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

mindless’s picture

Assigned: Unassigned » mindless
Status: Active » Fixed

Added 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)

Anonymous’s picture

Status: Fixed » Closed (fixed)