| Radicore v1.95 - Postgresal 9.5.3 - System crash after pressing submit button [message #5625] |
Mon, 13 June 2016 13:12  |
kishen
Messages: 5
Registered: July 2013
|
Junior Member |
|
|
Dear Tony,
I get the following error when trying to login:
Fatal Error: PostgreSQL: ERROR: 0A000: FOR UPDATE cannot be applied to the nullable side of an outer join LOCATION: make_outerjoininfo, initsplan.c:1105
SQL query: SELECT mnu_user.user_name, mnu_user.user_password, mnu_user.rdcaccount_id, mnu_user.pswd_chg_date, mnu_user.pswd_chg_time, mnu_user.pswd_count, mnu_user.in_use, mnu_user.is_disabled, mnu_user.logon_date, mnu_user.logon_time, mnu_user.start_date, mnu_user.end_date, mnu_user.ip_address, mnu_user.email_addr, mnu_user.external_id, mnu_user.is_external_auth_off, mnu_user.party_id, mnu_user.user_timezone, mnu_user.created_date, mnu_user.created_user, mnu_user.revised_date, mnu_user.revised_user, mnu_user.user_id, mnu_user.language_id, mnu_user_role.role_id, mnu_role.start_task_id, CASE WHEN (SELECT count(ip_address) FROM mnu_user_ip_address WHERE user_id='MGR') = 0 THEN true WHEN (SELECT count(ip_address) FROM mnu_user_ip_address WHERE user_id='MGR' AND ip_address='10.2.2.188') = 1 THEN true ELSE false END AS ip_address_valid, (SELECT STRING_AGG(role_id,',' ORDER BY role_id) FROM mnu_user_role WHERE user_id=mnu_user.user_id) AS role_list, mnu_language.input_date_format, mnu_language.output_date_format FROM mnu_user LEFT JOIN mnu_user_role ON (mnu_user_role.user_id=mnu_user.user_id AND mnu_user_role.is_primary='Y') LEFT JOIN mnu_role ON (mnu_role.role_id=mnu_user_role.role_id) LEFT JOIN mnu_language ON ( mnu_language.language_id=COALESCE(mnu_user.language_id, 'en')) WHERE mnu_user.user_id='MGR' ORDER BY mnu_user.user_name asc FOR UPDATE
Error in line 722 of file '/www/radicore/includes/dml.pgsql.class.inc'.
Host Info: 127.0.0.1, Server Version: 9.5.3
I have the following installed on my computer:
- Apache 2.4.9
- php 5.5.29
- Postgresal 9.5.3
Any suggestions why I get this error?
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
