Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Bug Reports » Radicore v1.95 - Postgresal 9.5.3 - System crash after pressing submit button (System crashes after clicking on the logon screen submit button.)
Radicore v1.95 - Postgresal 9.5.3 - System crash after pressing submit button [message #5625] Mon, 13 June 2016 13:12 Go to next message
kishen is currently offline  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?

Re: Radicore v1.95 - Postgresal 9.5.3 - System crash after pressing submit button [message #5628 is a reply to message #5625] Tue, 14 June 2016 04:45 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK
Senior Member
This never happened before! After a bit of investigation I have changed "FOR UPDATE" to "FOR UPDATE ON <tablename>" and this has fixed the problem. See the attached file.

Re: Radicore v1.95 - Postgresal 9.5.3 - System crash after pressing submit button [message #5630 is a reply to message #5628] Tue, 14 June 2016 06:43 Go to previous message
kishen is currently offline  kishen
Messages: 5
Registered: July 2013
Junior Member
Thank you! This fixed the problem.
Previous Topic: Delete 1 displays incomplete data upon error
Next Topic: getCount function throws error when sql statement starts with whitespace
Goto Forum:
  


Current Time: Fri Mar 29 05:50:02 EDT 2024

Total time taken to generate the page: 0.01178 seconds