ERROR:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "1" does not exist in /company/users/daniel/public_html/cms/drupal-6.1/includes/database.pgsql.inc on line 138.
* user warning: query: SELECT * FROM drupal_supernav_user_settings WHERE uid="1" in /company/users/daniel/public_html/cms/drupal-6.1/sites/all/modules/supernav/supernav.module on line 218.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "1" does not exist in /company/users/daniel/public_html/cms/drupal-6.1/includes/database.pgsql.inc on line 138.
* user warning: query: SELECT * FROM drupal_supernav_user_settings WHERE uid="1" in /company/users/daniel/public_html/cms/drupal-6.1/sites/all/modules/supernav/supernav.module on line 218.
Example:
Line: 217
$sql = 'SELECT * FROM {supernav_user_settings} WHERE uid="%d" '; #bad SQL
double commas is taken as column!!
please change all double commas to single commas in all SQLs
$sql = "SELECT * FROM {supernav_user_settings} WHERE uid='%d' "; #SQL is OK
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | supernav6xPostgresql.zip | 105.36 KB | kanonier |
| #1 | supernav5xPostgresql.zip | 99.72 KB | kevinwal |
Comments
Comment #1
kevinwal commentedI've fixed the 5.x version for postgreSQL. It's functioning properly for me although I don't have time to do a real test. Please test this before using!
Comment #2
kanonier commentedAlso you need change your INSERT-queries from style:
INSERT INTO tablename SET columnname='columnvalue'
to style:
INSERT INTO tablename(columnname) VALUES('columnvalue')
first style don't working with postgresql. And another thing - not needed quotas near values for integer columns.
In attachement - my patched 6th version. Not good way - I'm replace double-quoting by str_replace :) For me it was more easy :)
Comment #3
chrisshattuck commentedPlease see http://drupal.org/node/285027#comment-1094346. I may need to do some work on the new module to work with Postgresql. Thank you for the patch work!
Comment #4
kevinwal commented