Create an arbitrary menu item and try do delete it again.
The following SQL query will performed:
query: DELETE FROM localizertranslation WHERE (object_name='menu' || object_name='menu_item') AND object_key='137' in /var/www/html/drupal-5.7/includes/database.pgsql.inc on line 144.
Using PostgreSQL as database backend, you will get an error:
pg_query() [function.pg-query]: Query failed: FEHLER: Operator existiert nicht: character varying = boolean at character 52 HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen. in /var/www/html/drupal-5.7/includes/database.pgsql.inc on line 125.
Reason: The logical operator || is known to MySQL, but not to PostgreSQL
Fix: Use the logical operator OR instead of || which ist understood by both PostgreSQL and MySQL.
Patch attached.
Regards
Andreas
| Comment | File | Size | Author |
|---|---|---|---|
| localizer_menu_psql.patch | 691 bytes | deining |
Comments
Comment #1
deining commentedFixed by Roberto:
http://drupal.org/cvs?commit=107885
Comment #2
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.