I just migrated the site from sqlite to Postgres, using the drush portabledb-import module
I'm getting a error page only when no user is logged in to the site.
I can get logged in using the login-link generated running
and everything works great, all the content is there and accessible, views all work, etc... however log out and I get this message at the home page again
The website encountered an unexpected error. Please try again later.
and The watchdog-show reports this
ID : 8
Date : 12/Mar 13:07
Type : php
Severity : error
Message : PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "not yet assigned"
LINE 4: WHERE (base.uid IN ('not yet assigned'))
^: 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, base.uuid AS uuid
WHERE (base.uid IN (:db_condition_placeholder_0)) ; Array
[:db_condition_placeholder_0] => not yet assigned
in DrupalDefaultEntityController->load() (line 191 of/usr/local/www/main/includes/entity.inc).
I've checked the DB and the 0 uid looks fine but just in case I followed the "Restore the anonymous (user ID 0) user record docs located here https://drupal.org/node/1029506
any ideas or suggestions would be greatly appreciated.