Converting from 6.0 up to 7.0

Elkay · #1 07-27-2006, 03:03 PM

Hello,

Been out of the scene for a while. Looking to get my 6.0 server up to speed. I have all the executables, database, xml, etc up and running, but my database needs some work (expected). The first error I've encountered is that I need to source utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql. I can't find 6.1 anywhere to grab this file, and I believe the util dir was only on CVS anyway. Can someone post this file, and perhaps any other files I'm bound to run into to get my database up to 7.0 compatible? TIA.

rojadruid · #2 07-27-2006, 04:15 PM

Quote:

Originally Posted by Elkay

Hello,

Been out of the scene for a while. Looking to get my 6.0 server up to speed. I have all the executables, database, xml, etc up and running, but my database needs some work (expected). The first error I've encountered is that I need to source utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql. I can't find 6.1 anywhere to grab this file, and I believe the util dir was only on CVS anyway. Can someone post this file, and perhaps any other files I'm bound to run into to get my database up to 7.0 compatible? TIA.

everything you need should be in the wiki.

And welcome back.

Elkay · #3 07-30-2006, 03:42 AM

Hey, I scoured the Wiki pretty thoroughly, and haven't been able to locate anywhere that has the the file I'm looking for, from what I can see anyway. Am I missing something, or is something missing? I wasn't just looking for the schema, I was looking for the actual upgrade script files. Using the logs isn't really an option either because they don't go all the way back to 6.0. TIA.

Elkay · #4 07-30-2006, 05:38 AM

Disregard the last post. Found everything I need I think in the source zip file. For whatever reason it's not letting me re-edit my last post, so just posting again. Now I'm getting an error running items-0.6.0-DR2-0.6.1-DR1-convert.sql:

Unknown column 'unknown021' in 'items'

At what point was this column added? As far as I knew I was running 6.0 (not sure which DR it was). Just wondering what small step I'm missing here, and without logs going back that far I can't see what I'm missing.

Elkay · #5 08-01-2006, 11:41 AM

Ok, almost up to speed. My characters just aren't right (PP length error), and from what I've gathered I need to run ppconvert on my database. I got ppconvert from the util dir, but I can't get it to compile on VS2003. It's not the lack of include files (mysql, etc), it's just a bunch of actual errors and I don't know C very well. Just wondering if someone has a compiled version of ppconvert, or if there is something else I need to, or can, use.

Elkay · #6 08-01-2006, 03:48 PM

Ok, couple things..

First, why can I almost never see the option to edit my posts? It says edit enabled at the bottom, and I'm logged in as myself..

Second, in answer to my last question about ppconvert, I found it precompiled in the serverpack here:

http://eqemu.sesmar.net/sp/EQEmuSP-2.0-NoInstaller.rar

Ran it, worked great with no errors. Off to test my db!!

#7 08-01-2006, 04:56 PM

Quote:

Originally Posted by Elkay

First, why can I almost never see the option to edit my posts? It says edit enabled at the bottom, and I'm logged in as myself..

Because I have editing time limited, too many people would ask for help get a responce then edit there original post to say <<<FIXED NVM>> then people can get help from that thread.

Also some people were going back days / week later and editing there posts to say some rude things.

Elkay · #8 08-01-2006, 05:26 PM

Ah ok, makes perfect sense.

Anyway, still having some problems post-ppconvert. Now when I try to enter a zone from the char select, I see this in the zone window:

Path File ./Maps/freportw.path not found.
[Status] Weather should change in 6728 seconds
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.wa
lkspeed' in 'field list'
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
Error3 in PopulateZoneLists query 'SELECT spawnentry.spawngroupID, npcid, chance
, spawnentry.spawn_limit AS gsl, npc_types.spawn_limit AS sl FROM spawnentry, s
pawn2 LEFT JOIN npc_types ON spawnentry.npcID = npc_types.id WHERE spawnentry.sp
awngroupID=spawn2.spawngroupID AND zone='freportw' ORDER by chance' #1054: Unkno
wn column 'spawnentry.spawn_limit' in 'field list'
[Error] Loading spawn groups failed.
Zone->Init failed

Now.. I saw someone else had this exact error in another post, and never got an appropriate response back for the fix. My spawnentry table does exist, but it does not have this field. According the the current PEQ schema, that table doesn't have that column, but the spawngroup table does. Also, my npc_type table has walkspeed removed per the logs for the most current build (840). What gives, and what's right? I'm running the 'official' 840 binaries on windows.

EDIT: I got into the game fine with the 833 and 839 builds (just tried them on a hunch). I'm wondering if there's just something flat out wrong with the official 840 build. I get no SQL errors on 833 or 839 and all appears to be working now.

Belfedia · #9 08-01-2006, 09:03 PM

Quote:

Originally Posted by Elkay

EDIT: I got into the game fine with the 833 and 839 builds (just tried them on a hunch). I'm wondering if there's just something flat out wrong with the official 840 build. I get no SQL errors on 833 or 839 and all appears to be working now.

Have you make Slq DB change like changelog.txt say ?

Elkay · #10 08-02-2006, 02:38 AM

Quote:

Originally Posted by Belfedia

Have you make Slq DB change like changelog.txt say ?

The changelog from build 839 to 840 had no db changes, and I confirmed that 833 even works fine. I still think there's either something wrong with the 840 build or the changelog wasn't completely updated..