| Re: RADICORE V 1.76 [message #4052 is a reply to message #4049] |
Mon, 20 January 2014 22:38   |
juanguilarte
Messages: 27
Registered: June 2012
|
Junior Member |
|
|
Thank you for your comments
I am moving to the versionb 1.81 but the module dml.sqlsrv.class give me some errors. The last one I am sending to you
This application has encountered an unrecoverable error
The following has been reported to the administrator:
2014-01-20 22:49:48
Fatal Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]La columna 'task_desc' se ha especificado varias veces para 'x'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]El cursor no se declaró. (# 8156)
SQL query: SELECT * FROM ( SELECT x.task_id, x.task_desc, x.script_id, x.pattern_id, mnu_nav_button.button_text, mnu_nav_button.context_preselect, CASE WHEN (SELECT count(ip_address) FROM mnu_task_ip_address WHERE mnu_task_ip_address.task_id=mnu_nav_button.task_id_jnr) = 0 THEN 1 WHEN (SELECT count(ip_address) FROM mnu_task_ip_address WHERE mnu_task_ip_address.task_id=mnu_nav_button.task_id_jnr AND ip_address='127.0.0.1') = 1 THEN 1 ELSE 0 END AS ip_address_valid, COALESCE((SELECT task_desc FROM mnu_task_alt WHERE mnu_task_alt.task_id=mnu_nav_button.task_id_jnr AND mnu_task_alt.language_id='es-ve'), x.task_desc) AS task_desc, mnu_nav_button.sort_seq FROM mnu_nav_button LEFT JOIN mnu_task ON (mnu_task.task_id = mnu_nav_button.task_id_snr) LEFT JOIN mnu_task AS x ON (x.task_id = mnu_nav_button.task_id_jnr) WHERE x.is_disabled='N' AND mnu_task.task_id='menu' ) AS x WHERE ip_address_valid=1 ORDER BY sort_seq asc
Error in line 816 of file 'C:\wamp\www\radicore_v181\includes\dml.sqlsrv.class.inc'.
Client Info: DriverDllName: sqlncli11.dll, DriverODBCVer: 03.80, DriverVer: 11.00.2100, ExtensionVer: 3.0.3421.0
Server Info: CurrentDatabase: audit, SQLServerVersion: 11.00.2100, SQLServerName: JUANGUILARTE-HP\SQLEXPRESS
PHP_SELF: /radicore_v181/menu/menu.php
CURRENT DIRECTORY: C:\wamp\www\radicore_v181\menu
SERVER_ADDR: 127.0.0.1
SERVER_NAME: localhost
HTTP_HOST: localhost
User Id: MGR
Role Id: GLOBAL
REMOTE_ADDR: 127.0.0.1
REQUEST_URI: /radicore_v181/menu/menu.php?selection=main_menu&session _name=menu0
I am using MS SQL Server 2012
Thank you an advance
Regards
Juan Guilarte
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
