Errors with PostgreSQL
wa2nlinux - January 29, 2009 - 15:08
| Project: | Privatemsg |
| Version: | 6.x-1.0-rc2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Description
# warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "pmi" at character 17 in /home/forum/drupal-6.9/includes/database.pgsql.inc on line 139.
# user warning: query: UPDATE pm_index pmi SET is_new = 0 WHERE uid = 1 AND is_new = 1 AND mid
#1
Which PostgreSQL version are you using ?
I can't reproduce the error with PostgreSQL 8.3 but the pmi isn't needed anyway, so please test the attached patch
#2
Small and to the point, just how i like 'em ;)
Thanks!
#3
Automatically closed -- issue fixed for 2 weeks with no activity.