[support] SQL warnings after registration
    Daniel 
    leva at az.isten.hu
       
    Fri Apr 27 07:55:33 UTC 2007
    
    
  
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:
>
> 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.
>
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
    
    
More information about the support
mailing list