PostgreSQL: use single quotes and not double-quotes
jmpoure - March 11, 2009 - 10:26
| Project: | False Account Detector |
| Version: | 6.x-2.4 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | reviewed & tested by the community |
Jump to:
Description
* warning: pg_query() [function.pg-query]: Query failed: ERREUR: la colonne « 5fdae69200b8deaf908dd3976c260fa0 » n'existe pas LINE 1: SELECT COUNT(*) FROM false_accounts WHERE cid = "5fdae69200b... ^ in /home/html/test/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT COUNT(*) FROM false_accounts WHERE cid = "5fdae69200b8deaf908dd3976c260fa0" in /home/html/test/sites/all/modules/false_account/false_account.module on line 101.
* warning: pg_query() [function.pg-query]: Query failed: ERREUR: la colonne « 5fdae69200b8deaf908dd3976c260fa0 » n'existe pas LINE 1: SELECT * FROM false_accounts WHERE cid = "5fdae69200b8deaf90... ^ in /home/html/test/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT * FROM false_accounts WHERE cid = "5fdae69200b8deaf908dd3976c260fa0" ORDER BY created DESC LIMIT 50 OFFSET 0 in /home/html/test/sites/all/modules/false_account/false_account.module on line 101.PostgreSQL does not allow double-quotes. Use single quotes.
Kind regards,
Jean-Michel Pouré
| Attachment | Size |
|---|---|
| patch.diff | 512 bytes |
#1
Could this patch be applied? It has no side effect under MySQL and is very straightforward. Thanks.