Privatemsg isn't working, throws error

I second that - when I try to view a message, I get to following error:

user warning: Unknown column 'p.variables' in 'field list' query: SELECT p.id, u.uid, u.name, p.author, p.timestamp, p.subject, p.message, p.newmsg, p.recipient, p.folder, p.format, p.thread, p.type, p.variables FROM privatemsg p INNER JOIN users u ON p.author = u.uid WHERE p.id = 7 AND (recipient = 2 OR author = 2) in /site.com/includes/database.mysql.inc on line 172.

I have the same problem.
I'm using the 11 of Oct. dev. version of subscriptions and the 2nd of Oct. version dev. of privatemsg for drupal 5.2

Andreas

It looks like the privatemsg table needs the field "variables" added to it. I looked through the .install file and didn't find it. I added it as longtext and it works. It has another error, though, relating to the autocomplete, but it doesn't prevent the message from sending.

Michelle

I did the same as MIchelle; I added the variables field as type text and the error message went away.

I confirm this too - extra field "variables" of type "text" added at the end of the "privatemsg" table makes the error messages go away and the module seems to work fine.

Andrey.

I tried to upgrade the module today and got the following error

    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER user_name_length_insert BEFORE INSERT ON users FOR EACH ROW SET NEW.name' at line 1 query: CREATE TRIGGER user_name_length_insert BEFORE INSERT ON users FOR EACH ROW SET NEW.name_length = LENGTH(NEW.name) in /home/delhiliv/public_html/scratch/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER user_name_length_update BEFORE UPDATE ON users FOR EACH ROW SET NEW.name' at line 1 query: CREATE TRIGGER user_name_length_update BEFORE UPDATE ON users FOR EACH ROW SET NEW.name_length = LENGTH(NEW.name) in /home/delhiliv/public_html/scratch/includes/database.mysql.inc on line 172.

Any help will be greatly appreciated

Sorry for posting it here. I had to post it in http://drupal.org/node/180549 but made a mistake.

My site has the same behavior .. the following "fixes" the problem. Clearly something equivalent should be in privatemsg.install

mysql> alter table privatemsg add column variables longtext;
Query OK, 930 rows affected (0.28 sec)
Records: 930  Duplicates: 0  Warnings: 0

The variables field and the update function have now been added to the .install file. There is no update path as this is a development branch. However, as reikiman has stated, the following query should do the trick:
ALTER TABLE privatemsg ADD variables longtext

-K

Actually, it might be best to follow these instructions instead.