Database update system

[Uleat]

You shouldn't be using load_bots.sql any longer.

The eqemu_update.pl script now has a bots versioning system built in and all required bots sqls (minus the drop_bots.sql) will be applied through the update script.


Any other script use will apply incorrect database schema and will not function with the newest server code.


'2015_09_30_bots.sql' is both an install and conversion script.

The newer bots table more closely reflect the naming schema used in the 'player profile' conversion and is an attempt to help standardize bots to the rest of the
system.


There is more incoming as soon as I get the bugs worked out of my fresh install..and worked out of the changes themselves

[Nightrider84]

I tried just using the update script but i get the same errors and it wont source the bots in.

[Nightrider84]

Here is the log for the Update.pl after I dropped all traces of bots from my db.

Perl Version is 5.12.3
================================================== ==========
EQEmu: Automatic Upgrade Check
================================================== ==========
(Windows) MySQL is in system path
Path = C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin/mysql
================================================== ==========
Binary Revision / Local: (9089 / 9089)

================================================== ==========
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
================================================== ==========
1) [Backup Database] :: (Saves to Backups folder)
2) [Backup Database Compressed] :: (Saves to Backups folder)
3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
4) [EQEmu DB Bots Schema] Check for Bot REQUIRED database updates... (Must have
bots enabled)
5) [OPCodes] :: Download latest opcodes for each EQ Client
6) [Maps] :: Download latest map and water files
7) [Plugins (Perl)] :: Download latest Perl plugins
[Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov
erwrites existing data)
20) [Update the updater] Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

> 4
Retrieving latest bots database manifest...
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/bots_db_update_manifest.txt
[Saved] :: db_update/db_update_manifest.txt
Reading manifest...

Missing DB Update 9000 '2015_09_30_bots.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2015_09_30_bots.sql
[Saved] :: db_update/2015_09_30_bots.sql

================================================== ==========
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
================================================== ==========
1) [Backup Database] :: (Saves to Backups folder)
2) [Backup Database Compressed] :: (Saves to Backups folder)
3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
4) [EQEmu DB Bots Schema] Run pending REQUIRED updates... (1)
5) [OPCodes] :: Download latest opcodes for each EQ Client
6) [Maps] :: Download latest map and water files
7) [Plugins (Perl)] :: Download latest Perl plugins
[Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov
erwrites existing data)
20) [Update the updater] Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

> 4
Running Update: 9000 - 2015_09_30_bots.sql
ERROR 1136 (21S01) at line 675: Column count doesn't match value count at row 1
ERROR 1146 (42S02) at line 735: Table 'peq.bot_data' doesn't exist
ERROR 1146 (42S02) at line 755: Table 'peq.bot_groups' doesn't exist
ERROR 1146 (42S02) at line 768: Table 'peq.bot_data' doesn't exist
ERROR 1146 (42S02) at line 779: Table 'peq.bot_guild_members' doesn't exist
Missing DB Update 9000 '2015_09_30_bots.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bo
ts/required/2015_09_30_bots.sql
[Saved] :: db_update/2015_09_30_bots.sql

================================================== ==========
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
================================================== ==========
1) [Backup Database] :: (Saves to Backups folder)
2) [Backup Database Compressed] :: (Saves to Backups folder)
3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates
4) [EQEmu DB Bots Schema] Run pending REQUIRED updates... (1)
5) [OPCodes] :: Download latest opcodes for each EQ Client
6) [Maps] :: Download latest map and water files
7) [Plugins (Perl)] :: Download latest Perl plugins
[Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov
erwrites existing data)
20) [Update the updater] Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

>

[Huppy]

Originally Posted by Uleat

You shouldn't be using load_bots.sql any longer.

I haven't used that myself in a long time. Usually the only thing I've done in the past,
before this update script come along, when I had to re-source my db back in, I had
to source botadventuring.sql so the bots would zone along with owner. But I didn't
get any errors when running update script.

[Huppy]

Is this of any use ?

http://www.eqemulator.org/forums/sho...d.php?p=244897

Referring to this post here:

Originally Posted by Uleat

There is a known issue being addressed with the 2015_09_30_bots.sql file.

The update script will report errors at these lines:
- #675
- #735
- #755
- #768
- #779

It was traced to the conditional check for `bot_inventories` regarding the 6th augment slot.

If you're having issues with this, please ask for a solution in this thread.

[Nightrider84]

I already removed the 7 lines and tried it but no go

[Uleat]

Nightrider84, what version of MySQL/MariaDB are you using? (x.x.x, 32/64 bit, win/linux )


EDIT: Ok..I back read and found all but the 'build' number for your installation (5.1.x)

[Nightrider84]

Yeah im using the same stuff ive used for awhile now. I would have updated my VS to a newer version instead of 11 but I need SP1 on my windows rig that uses the server and its being an asshole and locks up and boot loops everytime I try to update it so I said fuck it lol. This seems to be the only update ive had any issues with it sticking so Im sure mysql is fine.

[Uleat]

If you're using windows 7, there's a issue with the updater.

(You can watch the updater with Resource Monitor and see MB's tick away from in-use to free..then it will 'hang' for an hour or two..but, it will eventually update.)


You can try installing this kb: https://support.microsoft.com/en-us/kb/3102810

But, note that language pack installations require re-installing it.


EDIT: And watch out for the Windows 10 'pre-positioner' KB..I clicked on every update to see what they did...

[Nightrider84]

It wasn't the updater that was the issue as far as I can tell. Once it installed the update it went into a boot loop trying to enter recovery mode and restarting because it couldnt find a problem only to reboot back into recovery. Tried safe mode and everything else so I just gave up on it for the time being.

[Uleat]

Oh, wow..I did miss the boot part...

What a pita!

[Nightrider84]

yeah still haven't figured out the bot issue unfortunatly.

[Nightrider84]

Still can't figure out why the bot sql won't load correctly any thoughts?

[Uleat]

Did you try the updated one?


EDIT: I switched the criteria from count to null check.

[Nightrider84]

Totally didn't lol. Do I need to drop my current bots database or can I just "upgrade" them