Download & Extend
Privatemsg » Issues

Errors with PostgreSQL

Posted by wa2nlinux on January 29, 2009 at 3:08pm
Project:Privatemsg
Version:6.x-1.0-rc2
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

# 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

Login or register to post comments

Comments

#1

Posted by Berdir on January 30, 2009 at 12:37am
Status:active» needs review

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

AttachmentSizeStatusTest resultOperations
privatemsg.pgsql_fix_set_new_status.patch864 bytesIgnored: Check issue status.NoneNone

#2

Posted by litwol on February 19, 2009 at 9:20pm
Status:needs review» fixed

Small and to the point, just how i like 'em ;)

Thanks!

#3

Posted by System Message on March 5, 2009 at 9:30pm
Status:fixed» closed (fixed)

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