Download & Extend
Advanced Poll » Issues

update_7 error: psql uses single quotes

Posted by maho on June 19, 2008 at 1:52pm
Project:Advanced Poll
Version:5.x-1.0-beta6
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

As in #272445: update_3 error : db_drop_column

Error:
# warning: pg_query() [function.pg-query]: Query failed: ERROR: column "advpoll_binary" does not exist LINE 1: UPDATE node SET type = "advpoll_binary" WHERE type = "advpol... ^ in /home/maho/workspace/longturn.org/includes/database.pgsql.inc on line 125.
# user warning: query: UPDATE node SET type = "advpoll_binary" WHERE type = "advpoll-binary" in /home/maho/workspace/longturn.org/includes/database.pgsql.inc on line 144.

Because postgresql treats "something" as object(table/key/whatever) called "something" , not as varchar with content "something".

Patch attached.

AttachmentSize
update_7.diff662 bytes
Login or register to post comments

Comments

#1

Posted by ChrisKennedy on July 20, 2008 at 11:18pm
Status:needs review» fixed

Good call, thanks. Fixed.

http://drupal.org/cvs?commit=128773

#2

Posted by Anonymous (not verified) on August 3, 2008 at 11:22pm
Status:fixed» closed (fixed)

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