Radicore Forum: Bug Reports » Radicore v1.95 - Postgresal 9.5.3 - System crash after pressing submit button

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.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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?

Report message to a moderator

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

AJM
Messages: 2371
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.