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

Comments

mscalone’s picture

mscalone commented
StatusFileSize
new postgresql-double-quote-error-on-select-1606354.patch1.05 KB

forgot the patch :)

gotheric’s picture

gotheric commented
Assigned: Unassigned » gotheric
apodran’s picture

apodran commented

The same issue for 6.x-2.1

gotheric’s picture

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.