Hello dear developers,
My configuration is Ubuntu server 11.04, Drupal 7,7, with Postgresql databse, with modules set as in attached file (installedmodules.txt)
Steps to reproduce the bug:
1) Deactivate the sub-module "User account tabs"
2) Click on "My Account" link
3) The user account interface is displayed without mistake.
4) Activate the sub-module "User account tabs"
5) 2) Click on "My Account" link
6) Error message:
"PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "" LINE 4: WHERE (base.sid IN ('')) ^: SELECT base.sid AS sid, base.uid AS uid, base.mdid AS mdid, base.type AS type, base.event_type AS event_type, base.conditions AS conditions, base.send_interval AS send_interval, base.language AS language, base.send_method AS send_method, base.cron AS cron, base.module AS module, base.status AS status, base.destination AS destination, base.created AS created, base.updated AS updated FROM {notifications_subscription} base WHERE (base.sid IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => ) in DrupalDefaultEntityController->load() (line 196 of /var/www/tax/includes/entity.inc)."
Looks like if it is related to compatibiloity with postgreql.
Please advise.
Best regards,
Vincent Lalieu
Almaty - Kazakhstan
Comment | File | Size | Author |
---|---|---|---|
installedmodules.txt | 3.02 KB | Anonymous (not verified) |
Comments
Comment #1
Anonymous (not verified) CreditAttribution: Anonymous commentedComment #2
sharplesa CreditAttribution: sharplesa commentedVery good error report. Following procedure, this problem does not occur on mysql. Suspect that vlalieu is correct and it's a problem with Postgresql
Comment #3
webflo CreditAttribution: webflo commentedFixed this PostgreSQL compatibility issue. Commit d1fc1db on 7.x-1.x.