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

Home » RADICORE development » Bug Reports » PostgreSQL error
PostgreSQL error [message #4109] Tue, 18 March 2014 09:48 Go to next message
rlchin is currently offline  rlchin
Messages: 3
Registered: March 2014
Location: Suriname
Junior Member
It tried postgresql v9.3.3 with version 1.75 - 1.82
Only version 1.75 works. All other give the following errors.
I have applied the patch with no results.
I also execute the Select statement with addition of the table name before button_text which gave the correct result.

atal Error: PostgreSQL: ERROR: 42702: column reference "button_text" is ambiguous LINE 1: ...nu_task.task_desc) AS task_desc, COALESCE((SELECT button_tex... ^ LOCATION: scanRTEForColumn, parse_relation.c:563 (# 42702)

SQL query: SELECT mnu_task.task_id, mnu_task.task_type, mnu_task.script_id, mnu_task.is_disabled, mnu_task.pattern_id, mnu_task.subsys_id, mnu_task.initial_passthru, mnu_task.selection_fixed, mnu_task.selection_temp, mnu_task.settings, mnu_task.order_by, mnu_task.keep_data, mnu_task.log_sql_query, mnu_task.screen_refresh, mnu_task.use_https, mnu_task.max_execution_time, mnu_task.task_id_run_at_end, mnu_task.task_id_run_at_cancel, mnu_task.created_date, mnu_task.created_user, mnu_task.revised_date, mnu_task.revised_user, mnu_pattern.pattern_desc, mnu_subsystem.subsys_desc, COALESCE((SELECT task_desc FROM mnu_task_alt WHERE mnu_task_alt.task_id=mnu_task.task_id AND mnu_task_alt.language_id='en-us') , mnu_task.task_desc) AS task_desc, COALESCE((SELECT button_text FROM mnu_task_alt WHERE mnu_task_alt.task_id=mnu_task.task_id AND mnu_task_alt.language_id='en-us') , mnu_task.button_text) AS button_text, COALESCE((SELECT task_desc FROM mnu_task_alt WHERE mnu_task_alt.task_id=mnu_task_passthru.task_id AND mnu_task_alt.language_id='en-us') , mnu_task_passthru.task_desc) AS task_desc_passthru, COALESCE((SELECT task_desc FROM mnu_task_alt WHERE mnu_task_alt.task_id=mnu_task_run_at_end.task_id AND mnu_task_alt.language_id='en-us') , mnu_task_run_at_end.task_desc) AS task_desc_run_at_end, COALESCE((SELECT task_desc FROM mnu_task_alt WHERE mnu_task_alt.task_id=mnu_task_run_at_cancel.task_id AND mnu_task_alt.language_id='en-us') , mnu_task_run_at_cancel.task_desc) AS task_desc_run_at_cancel FROM mnu_task LEFT JOIN mnu_pattern ON (mnu_pattern.pattern_id=mnu_task.pattern_id) LEFT JOIN mnu_subsystem ON (mnu_subsystem.subsys_id=mnu_task.subsys_id) LEFT JOIN mnu_task AS mnu_task_passthru ON (mnu_task_passthru.task_id=mnu_task.initial_passthru) LEFT JOIN mnu_task AS mnu_task_run_at_end ON (mnu_task_run_at_end.task_id=mnu_task.task_id_run_at_end) LEFT JOIN mnu_task AS mnu_task_run_at_cancel ON (mnu_task_run_at_cancel.task_id=mnu_task.task_id_run_at_canc el) WHERE mnu_task.task_id='logon' ORDER BY mnu_task.task_id asc

Error in line 682 of file '/www/htdocs/fin82/includes/dml.pgsql.class.inc'.

Host Info: localhost, Server Version: 9.3.3
Re: PostgreSQL error [message #4110 is a reply to message #4109] Tue, 18 March 2014 10:27 Go to previous message
AJM is currently offline  AJM
Messages: 2277
Registered: April 2006
Location: Surrey, UK
Senior Member
Please start a new thread for a new bug. Do *NOT* append it to an existing thread.

I have found the bug - the column in table MNU_TASK_ALT was incorrectly named 'button_desc' insteadof 'button_text'. Please rename it by running the following query:

SET search_path = menu;
ALTER TABLE menu.mnu_task_alt RENAME button_text TO button_desc;

Previous Topic: Adding line breaks to text fields
Next Topic: Audit Trail returns no records
Goto Forum:

Current Time: Wed Jan 26 16:22:05 EST 2022

Total time taken to generate the page: 0.01065 seconds