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

CommentFileSizeAuthor
installedmodules.txt3.02 KBAnonymous (not verified)
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Anonymous’s picture

Status: Fixed » Active
sharplesa’s picture

Very good error report. Following procedure, this problem does not occur on mysql. Suspect that vlalieu is correct and it's a problem with Postgresql

webflo’s picture

Title: Cliscking on User account crashes when User account tabs submodule is activated » Clicking on User account crashes when User account tabs submodule is activated
Status: Active » Fixed

Fixed this PostgreSQL compatibility issue. Commit d1fc1db on 7.x-1.x.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.