Setting up an old database

[samismallz]

Hi, I'm new to the forums and new to EQEmu server hosting in general. I was a player for a long time, but the server I played on went down and I was able to acquire the database files from the owner. I now want to host the server myself and put it back up.

I have followed the most recent method to setting up a server (http://www.eqemulator.net/wiki/wikka...verSetupGuide). The first part I am confused about is when using SVN Checkout to download the peq database from http://projecteqdb.googlecode.com/svn/trunk/peqdatabase. In my case, I already have a database, so instead of downloading the new one, I used mysql to source in my own database. First question is here - Was this the right thing to do? Should I still download the files from the site and source those?

Secondly, I set up the eqemu_config.xml file exactly as described in the wiki and made the start.bat file as instructed. I am able to get the server up in the EQEmu server list and when I log on to the server, my old characters appear, but they are naked and when I try to log on to play, it kicks me out. I checked in the logs and found that query cannot locate the items or characters. Can a kind soul please show me what I'm doing wrong? Thanks in advance for your time.

[rencro]

You will need to match the database up with the source....In the svn days, this was usually just a matter of matching the db rev with the source code rev. But now with git its a little trickier to track what version of db you have..

If you compiled the latest souce code then try to get your db updated with the "required" sql's from the svn and git folders, depending how old the db is..

As for using the svn db, you would want that in case you need to wipe the player tables..Just dont do it to your custom db without modifying the drop and load sqls, else it will wipe the rules and variables tables which usually contain much customization...

Your task is to find out what revision the database was last sourced as, then either update from there, or download source code that matches it...

[Uleat]

You could backtrack to an older revision, but you would lose any fixes or client additions since that time.

I'd recommend what rencro posted about db updates since you would be responsible for any issues that you run across..especially if they have since been fixed...

[samismallz]

Thank you for the replies. I did as you said and found out that the database I have is from rev2294 so I sourced in all the updates (required and optional) from the ...\source\utils\sql\svn and \git folders. Unfortunately, I am still getting the same error. Here is what I'm seeing in the error log:

---------------------------------------------
[09.04. - 08:44:34] Starting Log: logs/eqemu_error_world_1972.log
[09.04. - 08:44:34] Could not load EQTime file eqtime.cfg
[09.04. - 08:44:34] Error in AdventureManager:::LoadAdventures: SELECT id, zone, zone_version, is_hard, min_level, max_level, type, type_data, type_count, assa_x, assa_y, assa_z, assa_h, text, duration, zone_in_time, win_points, lose_points, theme, zone_in_zone_id, zone_in_x, zone_in_y, zone_in_object_id, dest_x, dest_y, dest_z, dest_h, graveyard_zone_id, graveyard_x, graveyard_y, graveyard_z, graveyard_radius FROM adventure_template (#1146: Table 'peq.adventure_template' doesn't exist)
[09.04. - 08:44:34] Error in AdventureManager:::LoadAdventureEntries: SELECT id, template_id FROM adventure_template_entry (#1146: Table 'peq.adventure_template_entry' doesn't exist)
[09.04. - 08:45:02] SetPlayerProfile query 'UPDATE character_ SET timelaston=unix_timestamp(now()),name='Bestbard', zonename='qrg', zoneid=3, instanceid=0, x = -71.038666, y = 6.882843, z = 2.126999, profile='_4¥Bestbard
class=8,level=75,xtargets=5 WHERE id=26880' #1054: Unknown column 'instanceid' in 'field list'
[09.04. - 08:45:02] SetPlayerProfile query 'UPDATE character_ SET timelaston=unix_timestamp(now()),name='Lylac', zonename='qrg', zoneid=3, instanceid=0, x = -61.249096, y = -23.651875, z = 2.126999, profile='Ï£ÁàLylac
class=2,level=75,xtargets=5 WHERE id=22' #1054: Unknown column 'instanceid' in 'field list'
[09.04. - 08:45:02] SetPlayerProfile query 'UPDATE character_ SET timelaston=unix_timestamp(now()),name='Mini', zonename='kael', zoneid=113, instanceid=0, x = 1194.003784, y = 637.639221, z = -75.903221, profile='º•nãMini
class=1,level=75,xtargets=5 WHERE id=25' #1054: Unknown column 'instanceid' in 'field list'
[09.04. - 08:45:02] SetPlayerProfile query 'UPDATE character_ SET timelaston=unix_timestamp(now()),name='Serine', zonename='vexthal', zoneid=158, instanceid=0, x = -863.115479, y = 68.591156, z = -40.872978, profile=')$\'ªSerine
class=8,level=60,xtargets=5 WHERE id=10' #1054: Unknown column 'instanceid' in 'field list'
[09.04. - 08:45:02] SetPlayerProfile query 'UPDATE character_ SET timelaston=unix_timestamp(now()),name='Stompem', zonename='crushbone', zoneid=58, instanceid=0, x = -66.125000, y = -106.625000, z = 5.502998, profile='È‘/ŽStompem
class=15,level=80,xtargets=5 WHERE id=6992' #1054: Unknown column 'instanceid' in 'field list'
[09.04. - 08:45:03] SetPlayerProfile query 'UPDATE character_ SET timelaston=unix_timestamp(now()),name='Woodelf', zonename='kael', zoneid=113, instanceid=0, x = 1691.713135, y = -1397.838989, z = -168.810455, profile='[Ç\0áWoodelf

Each entry is separated by a BUNCH of zeros, slashes, and other illegible characters.

Also, if it helps (or makes it more confusing), the characters that are showing up are not the characters on my login account, but they are characters the database owner used as GM characters. To clarify, I am logging in with MY username and password which should have the characters I used to use, but the characters showing up on the character selection screen are NOT the characters on my account, but characters I knew as GMs when I was playing on the server.

This whole thing is a mess and I'm really at a loss. Any help would be greatly appreciated.

[rencro]

Looks like you did but just in case, did you restart the server after sourcing everything in?..

As for the wrong accounts logging in, which login server are you using? Sounds like the login ids are not in order, which will happen if you moved from eqemu login server to local unless you line them all up.