Updating the DB to support the latest EQEmu?

[Ropethunder]

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 (http://www.projecteq.net/phpBB2/viewtopic.php?p=9521#9521) when trying to source the .sql files.


[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]

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]

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

[Ropethunder]

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]

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]

Refer to this sql file for all changes to current -


http://66.159.225.58/eqemu/sql_changelog_to0.7.0.985.txt

GeorgeS

[techguy84]

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

C:\peq_db>

then run mysql. Do the

create database peq; command. Next run

\u peq

to pick that database and then type in

source load_player.sql and
source load_system.sql

[Ropethunder]

My database is clean and my server setup is fine. I've also linked apache/php/phpmyadmin so that I can use either phpmyadmin to manage my databases in a UI or access it directly from the console.

Quoting from my post on the projecteq forum:

I'm having trouble sourcing in the database from the CVS. I tried to source load_player.sql in the mysql console and phpmyadmin, which failed with this error:

Error

SQL query:

source aa_timers.sql;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'source aa_timers.sql' at line 1


I don't think it understands the list of "source .. file.sql" inside of another .sql file.

This is what happens when I try to read in load_player.sql. "source aa_timers.sql;" is the first line of this file.