Zone.exe Crash - Page 2

**Uleat** · #16 09-11-2016, 10:32 PM

Try this...

Manually delete each table that is prefixed with 'bot' - skipping any table that gives an error, then go back through and try deleting those.

There is an order to do it in and it is applied in the drop_bots.sql file.

I'm not sure if the heal rotation tables are in the 'drop' file..so, that may be part of the problem.

Essentially, you do not want any 'bots' tables in your database - though, you can leave the views and functions since they are cleared out by the install script.

Finally, change the value of `bots_version` to '0' in the `db_version` table.

You shouldn't need to re-install everything to get a working server :/

EDIT: Once you manually remove all traces of bots, the installer should work properly.

DanCanDo · #17 09-11-2016, 10:40 PM

I just ran a non-bot windows server using the update script to install bots.
It went smoothly, but something else I did AFTER I installed the bots, I ran
check_bot_db_updates and it pulled a couple in. All works fine.

DanCanDo · #18 09-11-2016, 10:52 PM

This is the updates it grabbed afterwards:

Code:

Enter a command #> check_bot_db_updates
[Database] Running Update: 9003 - 2016_04_05_bots_pet_spell_id_field.sql
[Database] Running Update: 9008 - 2016_06_28_bots_inventory_charges_update.sql

whiteknight33 · #19 09-11-2016, 11:27 PM

I did everything you specified. I deleted all of the files and ran the installer. Bots are working on my server, but that error isn't going away and I can't use the guild window. (It won't update and show characters.)

Where does this table come from?

Code:

Table 'peq.vw_bot_character_mobs' doesn't exist

whiteknight33 · #20 09-11-2016, 11:32 PM

Quote:

Originally Posted by whiteknight33

I did everything you specified. I deleted all of the files and ran the installer. Bots are working on my server, but that error isn't going away and I can't use the guild window. (It won't update and show characters.)

Where does this table come from?

Code:

Table 'peq.vw_bot_character_mobs' doesn't exist

Edit: Also, the bots version was already set to 0.

It also won't let me create new bots because it says it can't check name availability... So I'm assuming that missing file had something to do with that.

DanCanDo · #21 09-12-2016, 08:47 AM

The 'vw_bot_character_mobs' is (supposed to be) in the Views part of your database.
That is seperate from 'Tables' You should have a total of 5 tables under Views.
If any of the vw's are missing, I am not sure why the installer didn't insert them for you.
I tested this whole bot installer from the script and it all worked fine for me on a win 7 box.
Did you try running any and all database updates in the update script ?

**Uleat** · #22 09-12-2016, 02:10 PM

You can manually run the queries found here: https://github.com/EQEmu/Server/tree.../bots/required
(You should have them locally in your source code folder..just match up the paths.)

They should be installed in the order listed in the manifest - starting with 9000: https://github.com/EQEmu/Server/blob...e_manifest.txt

There are a couple of other changes that need to be applied as well..but, until you get all of those in, without errors, we won't address that.