| Fatal Error on Popup [message #703] |
Wed, 21 March 2007 17:02  |
jzjames
Messages: 2
Registered: March 2007
|
Junior Member |
|
|
I am running through the Radicore tutorial, version 1.22.0, on a Windows XP machine with a local Apache 2.2.4.0 server, PHP 5.2.1, and PostgreSQL 8.2.3. I get a fatal PostgreSQL error whenever I click the popup button in the Add Relationship form, the one that specifies the junior table. Here is the PostgreSQL error message:
Fatal Error: pg_query() [function.pg-query]: Query failed: ERROR: 42703: column "column_count" does not exist at character 272 LOCATION: transformColumnRef, parse_expr.c:403 (# 256).
SQL query: SELECT count(*) FROM dict_table LEFT JOIN dict_column ON (dict_table.database_id=dict_column.database_id AND dict_table.table_id=dict_column.table_id) WHERE dict_table.database_id='test' GROUP BY dict_table.database_id, dict_table.table_id, dict_table.table_desc HAVING column_count > 0
Error in line 295 of file 'C:\Apache2.2\includes\dml.pgsql.class.inc'.
Thinking that there might be an error in my "test" data structure, I tried the same form using the "xample" schema and got the same error.
I couldn't find any mention of this problem in the forum archive or in the "Creating a PostgreSQL Driver.." article.
|
|
|
|
| Re: Fatal Error on Popup [message #704 is a reply to message #703] |
Wed, 21 March 2007 20:20  |
AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK
|
Senior Member |
|
|
You've found one of those circumstances where MySQL is more forgiving than PostgreSQL and Oracle. MySQL will allow the statement:
SELECT ..., count(dict_column.table_id) AS column_count FROM ... HAVING column_count > 0
but both PostgreSQL and Oracle will only accept the following:
SELECT ..., count(dict_column.table_id) AS column_count FROM ... HAVING count(dict_column.table_id) > 0
Attached is an updated file containing this correction.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|
|
|
|
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
