Closed (fixed)
Project:
Privatemsg
Version:
4.7.x-1.x-dev
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Reporter:
Created:
2 Aug 2006 at 17:44 UTC
Updated:
25 Aug 2006 at 18:15 UTC
I'm using 4.7 on PHP5 and Mysql5.
user warning: Field 'folder' doesn't have a default value query: INSERT INTO privatemsg (author, recipient, subject, message, timestamp, newmsg, hostname, format) VALUES ('2', '1', 'test', 'test', '1149170625', '1', '127.0.0.1', '0') in C:\web\drupal\includes\database.mysql.inc on line 120.
Issue seems to be in Line 506 of privatemsg.module with version
// $Id: privatemsg.module,v 1.52.2.3 2006/06/20 03:47:27 mindless Exp $
privatemsg table has column folder with NOT NULL and no DEFAULTING
mysql:
folder int(10) unsigned NOT NULL,
Comments
Comment #1
mindless commentedAdded DEFAULT '0' for folder column in HEAD and DRUPAL-4-7 (though I haven't seen problems with this.. I guess some mysql versions automatically add a default of zero; good to now explicitly state this default)
Comment #2
(not verified) commented