View Single Post
  #1  
Old 01-06-2022, 05:25 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default unknown column 'suspendeduntil'

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:

Code:
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.
__________________
Hanging out at Antonica.World
Reply With Quote