So Im a whiz on linux, prefer it, but there were to many issues with CentOS7 with plesk 12 and the dependencies for eqemu i couldnt resolve. So Im just using windows server 2012, and cant seem to figure out these issues, and since i dont use VS to much and hate windows i dont know much.
First, cant find DB_version, when the world server tries to create it it throws and error and is never created. this is thing 1.
Code:
[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver login.eqemulator.net:5998
[World Server] Connecting to MySQL...
[World Server] Starting HTTP world service...
[World Server] Checking Database Conversions..
[Upgrade Script] No script update necessary
Perl Version is 5.16.3
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
Table 'db_version' does not exists.... Creating...
The system cannot find the path specified.
============================================================
EQEmu: Automatic Upgrade Check
============================================================
(Windows) MySQL is in system path
Path = C:\Program Files\MariaDB 10.0\bin/mysql
============================================================
Binary Revision / Local: (9096 / )
You have missing database updates, type 1 or 2 to backup your database before running them as recommended...
============================================================
#::: 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
8) [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 overwrites existing data)
11) [Windows Server Build] :: Download Latest and Stable Server Build (Overwrites existing .exe's, includes .dll's
12) [Windows Server .dll's] :: Download Pre-Requisite Server .dll's
13) [Windows Server Loginserver Setup] :: Download and install Windows Loginserver
14) [Remove Duplicate Rule Values] :: Looks for redundant rule_values entries and removes them
19) [EQEmu DB Drop Bots Schema] :: Remove Bots schema and return database to normal state
20) [Update the updater] Force update this script (Redownload)
0) Exit
then when i hit option 3 to update the database it throws these errors.
Code:
[Saved] :: db_update/2015_05_23_PetBuffInstrumentMod.sql
The system cannot find the path specified.
DB up to date with: 9079 - '2015_05_23_BuffDurations.sql'
The system cannot find the path specified.
Missing DB Update 9078 '2015_05_20_BuffInstrumentMod.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_05_20_BuffInstrumentMod.sql
[Saved] :: db_update/2015_05_20_BuffInstrumentMod.sql
The system cannot find the path specified.
Missing DB Update 9077 '2015_02_12_zone_gravity.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_02_12_zone_gravity.sql
[Saved] :: db_update/2015_02_12_zone_gravity.sql
The system cannot find the path specified.
DB up to date with: 9076 - '2015_02_04_average_coin.sql'
The system cannot find the path specified.
Missing DB Update 9075 '2015_02_02_logsys_packet_logs_with_dump.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_02_02_logsys_packet_logs_wit
h_dump.sql
[Saved] :: db_update/2015_02_02_logsys_packet_logs_with_dump.sql
The system cannot find the path specified.
Missing DB Update 9074 '2015_02_01_logsys_packet_logs.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_02_01_logsys_packet_logs.sql
[Saved] :: db_update/2015_02_01_logsys_packet_logs.sql
The system cannot find the path specified.
Missing DB Update 9073 '2015_01_31_character_item_recast.sql'
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_01_31_character_item_recast.
sql
I could do it manually but hiedisql isnt letting me do direct load to sql and have to do 1 by 1 and its a pain, but i feel as if these 2 issues are connected.
originally compiled with bots, figured that was the problem so recompiled without bots, and the issue persists and when i try to drop the bots table using the script it gives the following.
Code:
Fetching drop_bots.sql...
[URL] :: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/bots/drop_bots.sql
[Saved] :: db_update/drop_bots.sql
The system cannot find the path specified.
Restoring normality...
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
when i try to start zone.exe i get the 0xc000007b error, but all dlls are in the directory used the updater to dl them to make sure i had the correct ones.
not sure if using the 64bit mysql libs have anything to do with it(only dependancy thats 64bit) because VS wouldnt compile using the 32bit ones threw over 150 errors
using the peqbeta_2015-08-12-02_01 database.
id use the auto installer, but ive already got mysql installed for the plesk thats on this box im using, plesk is just easier for the people that i give hosting to so i keep it (plus its free for these servers i lease)
DB_Version issue. Zone Fault, Update script etc
Linear Mode
