Double

The error occurs when running cron on drupal instalations over PostgreSQL and its due to an error on the ussage of double quites on sql query. In PostgreSQL double quotes are used for tables names.

Proposed resolution

The solution is quite simpe, change double " quotes for escaped simple quotes \'

Remaining tasks

Apply the patch

User interface changes

N/A

API changes

N/A

CommentFileSizeAuthor
#1 postgresql-double-quote-error-on-select-1606354.patch1.05 KBmscalone
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

mscalone’s picture

mscalone CreditAttribution: mscalone commented
FileSize
postgresql-double-quote-error-on-select-1606354.patch1.05 KB

forgot the patch :)

gotheric’s picture

gotheric CreditAttribution: gotheric commented
Assigned: Unassigned » gotheric
apodran’s picture

apodran CreditAttribution: apodran commented

The same issue for 6.x-2.1

gotheric’s picture

gotheric CreditAttribution: gotheric commented
Status: Reviewed & tested by the community » Fixed

I've just committed a new DEV version that fixed the quote problem.
I think it will be in next stable version in about a month.

Status: Fixed » Closed (fixed)

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