ERROR: operator does not exist (query: UPDATE users SET timezone_id = 308 WHERE timezone = -14400 AND timezone_id = 0)
stodge - June 30, 2009 - 00:19
| Project: | Event |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | postponed (maintainer needs more info) |
Jump to:
Description
I stumbled across an error:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: operator does not exist: character varying = integer LINE 1: UPDATE users SET timezone_id = 308 WHERE timezone = -14400 A... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /var/www/sites/project/includes/database.pgsql.inc on line 139.
* user warning: query: UPDATE users SET timezone_id = 308 WHERE timezone = -14400 AND timezone_id = 0 in /var/www/sites/project/sites/all/modules/event/event.module on line 275.
#1
does pgsql take exception on the negative value for the int?
#2