bot spell effects not sticking on migrated characters?

[Madrigal]

Okay, I've been having a weird "bug" lately with bot spell effects not sticking on characters that I migrated from a PEQ-Rev1265 database to a fresh PEQ Rev1265 database.

I am running the latest EQEmu-Rev1316-Bots on a Windows 7 64-Bit operating system.

This is what happens:

I log on with a migrated character, spawn a cleric bot, then wait for it to buff me. Although the bot casts the appropriate buffs on me, nothing shows up in the "buff window" and my stats don't change. However, if I log off with the character and log back on, the buffs (as well as their effects) appear in the effects window.

But, if I create a *new* character and spawn a bot, all the buffs immediately "stick" and show up in the window. In short, newly-created characters have no problems whatsoever receiving buffs.

I've tried to debug the problem on my own by eliminating extraneous tables and sourcing only the account and character_ tables into the new database.

Here's what I've done:

1) Dropped the old database in MySQL and created a new database called "peq".

2) Sourced in peqdb_rev1265.sql, followed by load_player.sql.

3) I then go to my backup database tables and source in account.sql and character_.sql, just to provide the bare essentials (without inventory or faction lists at this point) of the older players.

4) Now I source in load_bots.sql (which has been slightly re-arranged to prevent some errors, discussed in another post somewhere on this board).

That's the procedure that I've used... I'm new here, so I may be missing something extremely stupid, but I haven't had any success searching the forums. As I said before, newly-created characters have no problem receiving buffs from bots, but the old characters must camp and re-login before being affected.

Thanks in advance for taking the time to read this (I know it turned into a kinda long post, heh), and hopefully somebody can offer me some ideas on what the problem may be.

Madrigal

p.s.: Since I upgraded to EQEmu-Rev1316-Bots, I've been getting another error (#1054: Unknown column 'charges' in 'field list') whenever I spawn a bot. However, this error doesn't *seem* to directly correlate to the spell effects not sticking, as both the bots of newly-created characters and the old characters receive this error message.

[Congdar]

You must be missing something from your backup or the backup process missed something. Not positive with that.
The 1054 error could be due to missing db updates. The current release you say you have is 1265. Your executables are 1316. You should always check for any updates between the db and the release, so updates from 1265 to 1316 are found in the svn under /utils/sql/svn/ and I see 3 with 1 being for bots and is probably the cause of the error. Check the changelog.txt file too cuz sometimes the sql updates are in there.

Backing up the database has a new requirement with the addition of some views/method. It now always requires the -R switch for mysqldump to pick those up. Not sure if that is causing your buff issue, but thought I would mention it.

EDIT:
I thought I would mention that you probably could avoid this by not going to a fresh db each time. The drop_system.sql file does not delete user tables, and once you've run that then you run the db update for 1265 plus any svn updates and all should work.

[Madrigal]

Thanks, Congdar ... everything you wrote was solid advice, and I think the problem with my backup database revolved around not using the -R switch when executing mysqldump.

The #1054 error I was receiving was fixed by sourcing in the 1280_bot_augs.sql (in the utils/sql/svn directory), like you recommended.

[Krran]

This thread help me resolve the same issue. It also made my bots items appear on them again! Thanks guys, easy fix.