Using Drupal 7.19 with PostgreSQL 8.4.13 I often see following error messages:

ERROR:  invalid input syntax for integer: "login.php" at character 429
STATEMENT:  SELECT base.uid AS uid, base.name AS name, base.pass AS pass, base.mail AS mail, base.theme AS theme, base.signature AS signature, base.signature_format AS signature_format, base.created AS created, base.access AS access, base.login AS login, base.status AS status, base.timezone AS timezone, base.language AS language, base.picture AS picture, base.init AS init, base.data AS data
        FROM
        drupal_users base
        WHERE  (base.uid IN  ('login.php'))
ERROR:  invalid input syntax for integer: "viewonline.php" at character 429
STATEMENT:  SELECT base.uid AS uid, base.name AS name, base.pass AS pass, base.mail AS mail, base.theme AS theme, base.signature AS signature, base.signature_format AS signature_format, base.created AS created, base.access AS access, base.login AS login, base.status AS status, base.timezone AS timezone, base.language AS language, base.picture AS picture, base.init AS init, base.data AS data
        FROM
        drupal_users base
        WHERE  (base.uid IN  ('viewonline.php'))
ERROR:  invalid input syntax for integer: "ucp.php" at character 429
STATEMENT:  SELECT base.uid AS uid, base.name AS name, base.pass AS pass, base.mail AS mail, base.theme AS theme, base.signature AS signature, base.signature_format AS signature_format, base.created AS created, base.access AS access, base.login AS login, base.status AS status, base.timezone AS timezone, base.language AS language, base.picture AS picture, base.init AS init, base.data AS data
        FROM
        drupal_users base
        WHERE  (base.uid IN  ('ucp.php'))
ERROR:  invalid input syntax for integer: "index.php" at character 429
STATEMENT:  SELECT base.uid AS uid, base.name AS name, base.pass AS pass, base.mail AS mail, base.theme AS theme, base.signature AS signature, base.signature_format AS signature_format, base.created AS created, base.access AS access, base.login AS login, base.status AS status, base.timezone AS timezone, base.language AS language, base.picture AS picture, base.init AS init, base.data AS data
        FROM
        drupal_users base
        WHERE  (base.uid IN  ('index.php'))

This is probably easy to fix (in PHP code?) - looks like a string is used instead of numerical index for that string - when constructing an SQL query (for some report?)

Thanks

Comments

Version: 7.19 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.