[GENERAL] warning: pg_query(): Query failed

2005-01-10 Thread Aaron Steele
hi bruno, yeah, the postgresql problem was fixed by changing IF statements to CASE statements in forum.module code: // remove: -- $topic = db_fetch_object(db_query_range('SELECT DISTINCT(n.nid), l.last_comment_timestamp, IF(l.last_comment_uid, cu.name, l.last_comment_name) as last_comment_name,

Re: [GENERAL] warning: pg_query(): Query failed

2005-01-06 Thread Bruno Wolff III
On Thu, Jan 06, 2005 at 17:32:30 -0800, Aaron Steele <[EMAIL PROTECTED]> wrote: > hi bruno, > > turns out that l.last_comment_uid and l.last_comment_name are integer > and char var respectively. since i'm using 7.4.1 with strict boolean > casting, is there a better alternative to instantiating

Re: [GENERAL] warning: pg_query(): Query failed

2005-01-06 Thread Aaron Steele
hi bruno, turns out that l.last_comment_uid and l.last_comment_name are integer and char var respectively. since i'm using 7.4.1 with strict boolean casting, is there a better alternative to instantiating a different version of pgsql on my server? In the php code you showed the following fragme

Re: [GENERAL] warning: pg_query(): Query failed

2005-01-06 Thread Bruno Wolff III
On Thu, Jan 06, 2005 at 14:38:53 -0800, Aaron Steele <[EMAIL PROTECTED]> wrote: > hi bruno, Please copy replies to the list so that other people can help and learn from your problem. > > here's the IF() from psql, although i'm not familiar enough to really > know what to look for. do you see

Re: [GENERAL] warning: pg_query(): Query failed

2005-01-06 Thread Bruno Wolff III
On Wed, Jan 05, 2005 at 11:16:29 -0800, Aaron Steele <[EMAIL PROTECTED]> wrote: > > would it be useful to see the IF PLSQL function, or would you recommend > a modification to the database.pgsql.inc file? You should probably try looking at the IF function first to see if you can spot it using

Re: [GENERAL] warning: pg_query(): Query failed

2005-01-05 Thread Aaron Steele
hi steven, here's another file where the actual SQL query (the one in the error message) is defined. it's in the forum_get_forums() function. bruno noticed that the IF (via pl/pgsql) might not like the boolean casting to "2" since 7.4 is more strict about casting? does this help? /** * @file

Re: [GENERAL] warning: pg_query(): Query failed

2005-01-05 Thread Aaron Steele
hi bruno, would it be useful to see the IF PLSQL function, or would you recommend a modification to the database.pgsql.inc file? On Jan 5, 2005, at 10:52 AM, Bruno Wolff III wrote: On Wed, Jan 05, 2005 at 10:17:39 -0800, Aaron Steele <[EMAIL PROTECTED]> wrote: hi, warning: pg_query(): Query fai

Re: [GENERAL] warning: pg_query(): Query failed

2005-01-05 Thread Bruno Wolff III
On Wed, Jan 05, 2005 at 10:17:39 -0800, Aaron Steele <[EMAIL PROTECTED]> wrote: > hi, > > warning: pg_query(): Query failed: ERROR: invalid input syntax for type > boolean: "2" > CONTEXT: PL/pgSQL function "if" line 2 at if in > /Library/WebServer/Documents/dmap/includes/database.pgsql.inc on

Re: [GENERAL] warning: pg_query(): Query failed

2005-01-05 Thread Steven Klassen
# i'm setting up a forum that's connected to postgresql 7.4.2 (via # drupal.org framework) and i'm getting some errors. here's the link, # followed by the errors verbatim: http://128.32.146.140/dmap/?q=forum We would have to see database.pgsql.inc to tell you what's wrong with it. -- Steven Klas

[GENERAL] warning: pg_query(): Query failed

2005-01-05 Thread Aaron Steele
hi, i'm setting up a forum that's connected to postgresql 7.4.2 (via drupal.org framework) and i'm getting some errors. here's the link, followed by the errors verbatim: http://128.32.146.140/dmap/?q=forum warning: pg_query(): Query failed: ERROR: invalid input syntax for type boolean: "2" CONT