By imark on

The privatemsg module gives the error:

user warning: Unknown column 'newmsg' in 'where clause' query: SELECT COUNT(*) FROM privatemsg WHERE recipient = '1' AND newmsg = 1 AND recipient_del = 0 in /.../includes/database.mysql.inc on line 120.

How to repair the module and the error?

⋅ Categories: Drupal 4.7.x

Comments

pcwick’s picture

pcwick commented

I recall getting that error previously and am trying to remember what step resolved the issue. Are you sure your database tables are installed properly? You might try an updated version of this module that is working for me. It hasn't been posted to the downloads page yet, but is located in this thread: http://drupal.org/node/60903

Or you can download it directly here:
http://drupal.org/files/issues/privatemsg_4.module

Change the name of the file from privatemsg_4.module to privatemsg.module, and replace the privatemsg.module file that is already in the privatemsg directory in your modules directory.

I hope that works for you.

Ayman’s picture

Ayman commented

Looks like you are running an old version of the module, and your database scheme needs updating, check the mysql scheme file and decide what queries you need to run.

Judging from the error message, you need to run at least the last group of queries.

--
Ayman Hourieh
http://aymanh.com/