PostgreSQL error [message #4109] |
Tue, 18 March 2014 09:48 ![Go to next message Go to next message](/theme/default/images/down.png) |
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 Go to previous message](/theme/default/images/up.png) |
AJM
Messages: 2361 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;
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|