View Single Post
  #1  
Old 12-01-2010, 01:06 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,332
Default Errors with new DB 1751 and server 1752 install

After grabbing the svn updates with the new DB (1751), I did a completely
clean install of both server (1752) and DB. No errors on compile or when
sourcing db, etc.

I got the following errors when trying to login with SoD client.

Error in CreateAccount query ' INSERT INTO account SET name='huppy' status=0, lsaccount_id=2, time_creation=UNIX_TIMESSTAMP();' #1054 Unkown column 'time_creation' in 'field list'

[Debug] [WORLD_CLIENTLIST_ERR] Error adding local account for LS login: 'huppy', duplicate name?

[Debug] [WORLD_CLIENT_ERR] NOCLE: Bad/Expired session key '2'


Then I tried to source in the 1711 fix and got this error;

[Err] 1060 - Duplicate column name 'account_time_required'
[Err] ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
[Msg] Finished - Unsuccessfully
Reply With Quote