update_7 error: psql uses single quotes
maho - June 19, 2008 - 13:52
| Project: | Advanced Poll |
| Version: | 5.x-1.0-beta6 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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.
| Attachment | Size |
|---|---|
| update_7.diff | 662 bytes |
#1
Good call, thanks. Fixed.
http://drupal.org/cvs?commit=128773
#2
Automatically closed -- issue fixed for two weeks with no activity.