nodeblock PostgreSQL compatibility: wrong quotes
roychri - September 14, 2009 - 18:48
| Project: | Node Blocks |
| Version: | 6.x-1.2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | tom_o_t |
| Status: | reviewed & tested by the community |
Description
When I am using the nodeblock module with postgresql, I get the following error when going to admin/build/block :
* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "block" does not exist LINE 1: SELECT nid, title FROM node WHERE type = "block" AND status ... ^ in /var/html/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT nid, title FROM node WHERE type = "block" AND status = 1 AND (nid = tnid OR tnid = 0) in /home/var/sites/all/modules/contrib/nodeblock/nodeblock.module on line 96.According to this document:
http://drupal.org/node/555548
PostgreSQL does not allow double-quotes. You must use single quotes.
#1
Here is my proposed patch.
#2
Thanks for the patch. Will roll this next time I'm working on the module.