Hey guys, I had a quick question, so when doing the said updates using Navicat, the current DB that's out (As of... 10:25 PST January, 08 -2012) is, peqdb_rev2092... So, when opening the command prompt, and type 'source peqdb_rev2092.sql - it goes through all of it's files (Records, Query's etc) all of it's okay, gives me NO errors, at all... same with source load_player.sql (No errors) as well as the bots....
But then I get to the next part, where I have to update them through Navi, Since the PEQ DB is 2092... Wouldn't I need a higher one then 1711? At least, I thought that, but since the highest one there is 2087, I just clicked 1711 anyway... It gave me this,
[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`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
I followed the guide to a T, went over it 30 times + to make sure everything was right... and I got nothing... Help?
|