Creating a bot gives failed to query name availability

[AsmoTiC]

If you check your DB, with something like Heidi or another viewer. Do you see all the bot tables?

bot_data
bot_inspect_messages
bot_stances
bot_timers
bot_buffs
bot_inventories
bot_pets
etc. There are a bunch of them.

Your new bot would try to write into the bot_data table. If it doesn't exist, then we need to help you get that SQL to source in correctly. Should have come in with the eqemu_update.pl, using option 4. But there have been instances in the past where some people need to install the first batch manually.

[Allairus]

That is the problem then. I have none of those entries in my database. I've run the update with option 4 quiet a few times. It does give an error on that update at one point that on one of the links can not be found. It is a heal rotation related file it gives the error on.

[AsmoTiC]

Ok, then the eqemu_update.pl isn't patching the bots for you correctly. Like I said, it's happened to others. Once it's patched up, the updates should work from this point forward.

First thing to try is resetting the database version to 0. In your DB find the table bots_version. Change that number to 0, and try running the perl script again (option 4 twice). If that still doesn't work, we have to roll up our sleeves.

If you follow this link https://github.com/EQEmu/Server/tree.../bots/required there will be a list of SQL files (as of this post there are 7).

Grab those SQL files (copy/paste into a blank file with an SQL extension for example) and put them somewhere convenient.

Next, source each SQL into your DB, in order (based on date, newest file last). I usually do this from a mysql command prompt, but you should be able to source them from Heidi.

Once that's done, you may want to change that bots_version table to 9006 (again as of the time of this post). That should get you working.

Alternatively you could check out this link. Similar steps, probably easier to read. http://wiki.eqemulator.org/p?Manual_..._Bots&frm=Main

If neither of those steps work, we might need to wait for Uleat to take a look at the thread and offer some suggestions. Let us know!

[Allairus]

Ok thanks. I will check that out this evening. I did not even see the table for bots_version.

[AsmoTiC]

Originally Posted by Allairus

Ok thanks. I will check that out this evening. I did not even see the table for bots_version.

Bummer. If that's the case before you can try using the update script try manually creating those version tables. Again, I typically type this stuff into a mysql command line, but you can create a query in Heidi and run the query with the same effect. Just type these in when you are inside the db (peq for example).

ALTER TABLE `db_version` ADD `bots_version` int(11) DEFAULT '0' AFTER `version`;