Updating the DB to support the latest EQEmu?

Ropethunder · #1 05-20-2007, 04:27 PM

My server runs fine with Angelox's database but always errors when trying to use the official ProjectEQ database from the main website.

If I understand correctly the errors I'm receiving when trying to run my server are due to changes in EQEmu since the last official release of this database?

Where can I get a list of the changes that need to be made to this database to make it function correctly?

I tried to use the database from the ProjectEQ CVS but I received an error when trying to source the .sql files.

Quote:

[Debug] [ZONE__INIT] Loading commands
[Debug] [ZONE__INIT] 193 commands loaded
[Error] Starting Log: logs/eqemu_error_zone_3608.log
[Error] Error in LoadRules query SELECT ruleset_id FROM rule_sets WHERE name='default': #1146: Table 'eqemu_projecteq.rule_sets' doesn't exist
[Debug] [RULES__ERROR] Failed to find ruleset 'default' for load operation. Canceling.
[Debug] [ZONE__INIT] No rule set configured, using default rules

..

[Status] Booting gfaydark
Map header: 74949 faces, 4817 nodes, 124159 facelists
Loaded map: 224847 vertices, 74949 faces
Map BB: (-2693.16 -> 2766.28, -2803.81 -> 2717.22, -98.53 -> 801.81)
Map ./Maps/gfaydark.map loaded.
Path File ./Maps/gfaydark.path not found.
[Debug] The next weather check for zone: gfaydark will be in 9002 seconds.
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.trackable' in 'field list'
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Status] Loading ground spawns...
[Status] Loading Ground Spawns from DB...
[Status] Loading World Objects from DB...
[Status] Loading Objects from DB...
[Status] Loading doors for gfaydark ...
[Status] Loading Doors from database...
[Status] Loading AA information...
[Error] Error in GetAASkillVars 'SELECT cost, max_level, hotkey_sid, hotkey_sid2, title_sid, desc_sid, type, prereq_skill, prereq_minpoints, spell_type, spell_r
efresh, classes, berserker,spellid,class_type,name,cost_inc FROM altadv_vars WHE
RE skill_id=2': #1054: Unknown column 'cost_inc' in 'field list'

techguy84 · #2 05-21-2007, 02:55 AM

Use the change logs in the emulator itself to see all the needed sql changes.

Or better yet, just get the CVS version of PEQ

Angelox · #3 05-21-2007, 07:39 AM

GeorgeS has a nice list of updates posted at his site;
http://66.159.225.58/eqemu/eq.html

Ropethunder · #4 05-23-2007, 03:39 PM

Quote:

Originally Posted by techguy84

Use the change logs in the emulator itself to see all the needed sql changes.

Or better yet, just get the CVS version of PEQ

Please read the last comment I made at the end of my post.

jimbabwe · #5 05-23-2007, 08:42 PM

Quote:

Originally Posted by Ropethunder

Please read the last comment I made at the end of my post.

well did you open the sql file and look at the code? maybe something is wrong with the file? Says there was a problem at line 1. So possibly post at least line 1 here.

**GeorgeS** · #6 05-24-2007, 01:20 AM

Refer to this sql file for all changes to current -

http://66.159.225.58/eqemu/sql_chang...o0.7.0.985.txt

GeorgeS

techguy84 · #7 05-24-2007, 01:49 PM

Sorry about that rope, I missed it. What is the error with the CVS. Possible something about the file not being found or something like that. Heres the differences

Angelox's = Fully updated, single file
PEQ Final = Non Updated Single File
PEQ CVS = Fully Updated Multi-file

The load_system and player files in the peq final are the complete dump from the database, while the cvs file are actually sql querys that link to sql files that are dumped for each db table.

The most common error is starting the mysql commnad line browers from a directory other than the one the files are located. If you start MCL and type in the source C:\peqdb\load_systems.sql; then it will errror out because the queries inside load system will try to source the other files from the directory your in.

When downloading from CVS, for the target folder, just put C:\ and download. Then start up command prompt, and type in cd\peq_db

You will end up being at

Code:

C:\peq_db>

then run mysql. Do the

create database peq; command. Next run

Code:

\u peq

to pick that database and then type in

Code:

source load_player.sql

and

Code:

source load_system.sql