The module does not work properly on a Drupal installation that uses PostgreSQL.
I think the attached patch corrects this.

Greetings

CommentFileSizeAuthor
webformblock_postgresql.patch666 byteseltrufa

Comments

eltrufa’s picture

eltrufa commented
Title: Postgresql database suport » Postgresql database support
akanouras’s picture

akanouras commented

Hello,

I had the same problem and this patch did indeed fix it!

Thanks,
Antonis Kanouras

rdryfoos’s picture

rdryfoos commented

Plus one.
Thank you lportela.

-Rik Dryfoos

davidwhthomas’s picture

davidwhthomas commented
Status: Active » Reviewed & tested by the community

Duplicate of http://drupal.org/node/685684 and yes, it fixes the issue. thanks!

psynaptic’s picture

psynaptic commented
Status: Reviewed & tested by the community » Fixed

This has been committed to DRUPAL-6--1.

psynaptic’s picture

psynaptic commented

Could you guys tell me if this is PostgreSQL compatible?

db_query('UPDATE {blocks} set title = "%s" WHERE delta = %d', $form_values['title'], $form_values['delta']);
davidwhthomas’s picture

davidwhthomas commented

@psynaptic

Yes, nearly, the only change would be to switch your single/double quoting to:

<?php
db_query("UPDATE {blocks} set title = '%s' WHERE delta = %d", $form_values['title'], $form_values['delta']);
?>

Otherwise pgsql might interpret the title value as a database field/column.

I always use double quotes around db_query SQL and single quotes on the '%s'

thanks for the useful module!

DT

psynaptic’s picture

psynaptic commented

Excellent, thanks for the tips :)

In the end I removed that query but I'll remember your advice.

Status: Fixed » Closed (fixed)
Issue tags: -PostgreSQL

Automatically closed -- issue fixed for 2 weeks with no activity.

Issue tags: +PostgreSQL

Restoring issue tags, see #2125755: System messages removed all issue tags during D7 upgrade.