Hi!
When trying to register on my site (Drupal 5.1), I get a succesful registration, but with these warning messages:
1. warning: pg_query() [function.pg-query]: Query failed: ERROR: argument of OR must be type boolean, not type integer in /site/includes/database.pgsql.inc on line 125. 2. user warning: query: SELECT u.mail, u.name FROM users u LEFT JOIN users_roles ur on u.uid = ur.uid WHERE 0 OR ur.rid = 3 in /site/includes/database.pgsql.inc on line 144.
I'm using postgresql-8.1.8.
Any help would be appreciated,
Thank!
Daniel
2007. April 23. 11:55, Daniel:
Hi!
When trying to register on my site (Drupal 5.1), I get a succesful registration, but with these warning messages:
- warning: pg_query() [function.pg-query]: Query failed: ERROR:
argument of OR must be type boolean, not type integer in /site/includes/database.pgsql.inc on line 125. 2. user warning: query: SELECT u.mail, u.name FROM users u LEFT JOIN users_roles ur on u.uid = ur.uid WHERE 0 OR ur.rid = 3 in /site/includes/database.pgsql.inc on line 144.
So this happens after filling in the registration form on my site, and clicking the "Create new account" button. But I think that query supposed to look like this:
SELECT u.mail, u.name FROM users u LEFT JOIN users_roles ur on u.uid = ur.uid WHERE ur.rid = 0 OR ur.rid = 3 ^^^^^^ not
users_roles ur on u.uid = ur.uid WHERE 0 OR ur.rid = 3
Is that correct?
Thanks!
Daniel