Bot creation issue
 

Quick question if I may - couldnt find this after about 20 minutes of searching. I'm getting an error when I try to create a bot in-game. I was going to create and spawn a bot to test out LDoNs by doing this:

#bot create Vexxie 2 1 female (just an one of the many examples I tried)

And the error I receive in game:

#1054: Unknown colum 'Corrup' in 'field list'
Unable to save Vexxie as a bot.

I did the ReleaseBots build when I put the server together last night. I also made sure that I loaded all the DB updates after 1900. I'm not sure what I could be missing. I also combed through my logs and couldn't find any clues to get more information on what's missing or wrong.

Anyone seen this or have a clue?

Many thanks.

Baruuk

You need update 1723.

Hmm well I just tried sourcing that in these 2 updates:

1723_optional_sql_new_stats_window_rule.sql
1723_required_sql_corruption.sql

The first one succeeded.
The second one (the one I'm guessing you're suggesting), error'ed out with this error:

[Err] 1146 - Table 'peq.botbuffs' doesn't exist
[Err] ALTER TABLE `botbuffs` ADD COLUMN `CorruptionCounters` INT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER `CurseCounters`;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Am I supposed to source in updates prior to 1900? Does it appear I'm missing something?

Thanks again :)

Nevermind - figured it out by searching the error and found this post:

http://www.eqemulator.org/forums/sho...eq.botbuffs%27

Thanks for your help - it does still make me wonder what else I'm missing that I should source in :) I just assumed since the DB is ver. 1900 that I'd just go forward.

Thanks again.

The main db dump is 1900, however the tables created by load_players.sql and load_bots.sql were not updated.

Assuming you just sourced db_dump.sql and load_bots.sql then the 1723 that's required should be the only one you need to go back and do other than the 1900+ ones.

The botbuffs table is created when you source load_bots.sql, so you should have had it.

Thanks much Lex.