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!!