Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Hello
I'm migrating mysql to postgresql-postgis because i need to use GEO features.
The migration it's ok to psotgresql, but when i add a new content (every content type) drupal give me a 'Fatal Error'.
When i do the drush command the list it's sucess for every module, but the add content doesn't work.
Well, thanks for the help ;)
Comments
Comment #1
GoldThis isn't sounding like an issue related to this module.
Can you post more detail about your error? The error.log or entries from Watchdog?
Also, steps to replicate this would be good. If we can't replicate it we can't fix it.
Comment #2
claudiu.cristeaI'm facing the same error. The migration MySQL > PostgreSQL went smooth but after changing the default DB to the new populated PG, on
node/add
page I'm getting:PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "add" LINE 5: WHERE (base.nid IN ('add')) ^: SELECT revision.vid AS vid, base.uid AS uid, revision.title AS title, revision.log AS log, revision.status AS status, revision.comment AS comment, revision.promote AS promote, revision.sticky AS sticky, base.nid AS nid, base.type AS type, base.language AS language, base.created AS created, base.changed AS changed, base.tnid AS tnid, base.translate AS translate, revision.timestamp AS revision_timestamp, revision.uid AS revision_uid FROM {node} base INNER JOIN {node_revision} revision ON revision.vid = base.vid WHERE (base.nid IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => add ) in EntityCacheControllerHelper::entityCacheLoad() (line 100 of sites/all/modules/entitycache/entitycache.module).
It seems to me that Drupal doesn't select the best route for
node/add
like he's trying to execute the callback corresponding to routenode/%node
.@pineiden, do you have some fresh feedback on that?
Comment #3
claudiu.cristeaThis duplicates #1851398: PDOException:Invalid text representation when attempting to load an entity with a string ID and the patch posted there is fixing the issue.