Upond reindexing the site using postgresql as underlying drupal db I get
* warning: pg_query() [function.pg-query]: Query failed: ERROR: function unix_timestamp() does not exist LINE 1: ... INTO xapian_index_queue (nid, added) SELECT nid, UNIX_TIMES... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. in /var/www/apeoe/includes/database.pgsql.inc on line 139.
* user warning: query: INSERT INTO xapian_index_queue (nid, added) SELECT nid, UNIX_TIMESTAMP() FROM node in /var/www/apeoe/modules/xapian/xapian.module on line 863.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | 0001-bug-690322-by-marvil07-avoid-non-standard-sql-functi.patch | 1.19 KB | marvil07 |
| #1 | 0001-690322-avoid-non-standard-sql-function-UNIX_TIMESTAM.patch | 861 bytes | marvil07 |
Comments
Comment #1
marvil07 commentedThanks for reporting it!
This patch should solve the problem, please test it.
Comment #2
marvil07 commentedI setup an own pg environment :-), so I test it, change it and finally commit it ;-)
Comment #3
marvil07 commentedfor the record: commited to HEAD and DRUPAL-6--1