db error when creating album

[Mazinger]

I get dberror when I try to create a new album:



Database error in vBulletin 3.7.0 Beta 2:
Invalid SQL:
INSERT INTO album
(userid, title, description, public, createdate)
VALUES
(1, 'name', 'description', 1, 1197918102);
MySQL Error : Field 'lastpicturedate' doesn't have a default value
Error Number : 1364
Date : Monday, December 17th 2007 @ 09:01:43 PM
Script : http://localhost/vb/album.php?do=updatealbum&u=1&albumid=0
Referrer : http://localhost/vb/album.php?do=addalbum
IP Address : 127.0.0.1
Username : admin
Classname : vB_Database

[Mez]

Please report this as a bug. Including details on whether this was a fresh install or an upgrade.

For now, the following query will solve this issue


ALTER TABLE album CHANGE lastpicturedate lastpicturedate INT UNSIGNED NOT NULL DEFAULT '0';