Quote:
Originally Posted by Pirate123
now when a new account is being created its saying
Error in createaccount query 'insert into account set name ='purcell2009', status=0, lsaccounts_id=152328;' #1364: field 'suspendeduntil' doesnt have a default value.
|
I think this is because you have MySQL running in 'strict' mode. (Not sure if the install guide still tells you to uncheck the strict mode box when installing MySQL on Windows).
I've updated utils/sql/svn/1195_account_suspendeduntil.sql to include a DEFAULT value for the suspendeduntil column, or you could do:
Code:
ALTER TABLE `account` CHANGE `suspendeduntil` `suspendeduntil` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ;