On the first "send", I get a warning that there are no default for 'author_del'... at line 121 of includes/mysql.database.inc. And the message, as a result, is not sent, although I get a "message is sent" message as well.

Comments

Chill35’s picture

Chill35 commented

Does the privatemsg module work for anyone at all in 4.7.5 ? It does not work for me. It get the UI but messages aren't sent (neither are they received of course).

svetlin’s picture

svetlin commented

It works for me on 4.7.5...

Chill35’s picture

Chill35 commented

What version are you using ? I use the latest version which was updated on the 11th of January. I am afraid this version was broken... and I don't know how to go retrieve the version that existed prior to that one.

Chill35’s picture

Chill35 commented

What version of mySQL are you using ?

Mine is 5.0.

The problem is with how the database tables are accessed, that's why I am asking.

Chill35’s picture

Chill35 commented

Here is the error I am getting upon sending a message :

user warning: Field 'author_del' doesn't have a default value query: INSERT INTO privatemsg (author, recipient, subject, message, timestamp, newmsg, hostname, format) VALUES ('2', '1', 'hi', 'hello', '1168990527', '1', '542.45.45.2', '1') in ...... \includes\database.mysql.inc on line 121.
Message sent.

Although the message is said to have been sent, it has not.

mindless’s picture

mindless commented
Assigned: Unassigned » mindless
Status: Active » Fixed

mysql usually automatically sets a default of zero for integer columns, don't know why your db didn't set the default. anyhow, in privatemsg.install most columns needing a default have it listed, but this was missing for author_del and recipient_del on mysql.. i've added DEFAULT '0' for these.
to fix your db, do this in phpmyadmin or mysql cmdline:
alter table privatemsg modify column author_del tinyint unsigned not null default '0', modify column recipient_del tinyint unsigned not null default '0';

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)