Huppy
01-06-2022, 05:25 PM
Run into this problem recently, after transferring a database from a windows OS to linux server. It wouldn't let new toons get into server, spitting out an error in world log file - #1054: unknown column 'suspendeduntil' in 'field list.
On the linux server, just run this query on the database:
ALTER TABLE `account` CHANGE `suspendeduntil` `suspendeduntil` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ;
This was buried in an old post on these forums, but didn't specify the cause I experienced.
On the linux server, just run this query on the database:
ALTER TABLE `account` CHANGE `suspendeduntil` `suspendeduntil` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ;
This was buried in an old post on these forums, but didn't specify the cause I experienced.