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.
This useful module doesn't seem to work with PostgreSQL databases.
When i try the filter, i obtain this error:
PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "/example.org/test/page" LINE 1: SELECT * FROM gotwo WHERE src = gid+'/example.org/test/page'... ^: SELECT * FROM {gotwo} WHERE src = gid+:src AND dst = :dst; Array ( [:src] => /example.org/test/page [:dst] => http://example.org/test/page ) in _gotwo_get() (line 339 of /usr/local/drupal/sites/all/modules/gotwo/gotwo.module).
Comments
Comment #1
Jibus CreditAttribution: Jibus commentedI spend time to understand why this request is required but i can't figure out. Before triggering this request, there is a first wich verify if the alias already exist.
Still working on this ...
Comment #2
hass CreditAttribution: hass commentedDo you know the equivalent of this SQL statement for PG?
Comment #3
Jibus CreditAttribution: Jibus commentedAt this time no
Can you explain what this statement do ?
This part cause a problem for Postgre: WHERE src = gid+:src
gid+:src
Comment #4
Andre-Brelated: #2207685: Bugged link discovery in _gotwo_do_redir() once that get's commited one could probably switch the db_select to something compatible to postgresql
Comment #5
rmcom CreditAttribution: rmcom commentedGiving this a bump.
Still the same issue:
PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "/page" LINE 1: SELECT * FROM gotwo WHERE src = gid+'/page' AND dst =... ^: SELECT * FROM {gotwo} WHERE src = gid+:src AND dst = :dst; Array ( [:src] => /page [:dst] => http://pagesite.com ) in _gotwo_get() (line 339 of /var/www/html/sites/all/modules/gotwo/gotwo.module).