The module uses double quotes (“) for strings on its queries witch is not compatible with postgress. The solution is quite simple, replace the double quotes with single quotes scaped (\') on that queries.. the patch for the file block_class.module is attached.

CommentFileSizeAuthor
block_class_double_quotes_on_queries.patch1.26 KBmscalone

Comments

steven jones’s picture

steven jones commented
Status: Active » Needs work

Thanks for the patch, quick review:

+++ block_class.module.modificado	2010-04-08 10:15:10.000000000 -0300
@@ -2,7 +2,7 @@
-  $ret = db_fetch_object(db_query('SELECT css_class FROM {block_class} WHERE module = "%s" AND delta = "%s"', $block->module, $block->delta));
+  $ret = db_fetch_object(db_query('SELECT css_class FROM {block_class} WHERE module = \'%s\' AND delta = \'%s\'', $block->module, $block->delta));

Ugly! Just change the entire string to be in double quotes, and then you can use the single quotes without escaping in the string. Same for all the other bits in the patch.

Powered by Dreditor.

-Mania-’s picture

-Mania- commented

Why isn't this already sorted in a new release? Can't use the module in Postgres. :/

berenddeboer’s picture

berenddeboer commented
Status: Needs work » Closed (fixed)

As far as I can see, this has been applied to the dev version.