Problems after upgrading from June to current release

[cavedude]

Which files exactly are you sourcing? What is the address you are getting them from?

[gnode]

Originally Posted by cavedude

Which files exactly are you sourcing? What is the address you are getting them from?

http://code.google.com/p/projecteqemu/


Featured download: Revision302.zip

That is the changelog I originally followed, also.

[Andrew80k]

I think cavedude means which database.

[gnode]

peqdb_1129Rev311.sql

Then all of the miscellaneous *.sql files that did not involve dropping tables.

Thanks for the help... going to bed tonight and will look at it later. I am about ready to zip my db up and send it to someone to make an update script for me for some $$ because this is getting kind of ridiculous.

[Andrew80k]

Just use the peqdb_1129Rev311.sql file. Don't use any other files unless you know you need to. Which you don't. I did this once before and it hosed me up too. Had to drop it all and re-import it.

[gnode]

Originally Posted by Andrew80k

Just use the peqdb_1129Rev311.sql file. Don't use any other files unless you know you need to. Which you don't. I did this once before and it hosed me up too. Had to drop it all and re-import it.

I know I need to because I am missing several tables such as group and raid related.

Also, I am somewhat convinced the problem has nothing to do with my db. The error I am getting is a mysql syntax error in world.exe.

[Andrew80k]

How do you know you need to? I dump my entire database and reimport it using just the peqdb file and I don't have any missing tables. If you are missing table then you have a database problem with the import. As you say you may have an issue with the code. What code rev are you using? 301? Or 311? Make sure your code matches your database. Database can be before the code but not the other way around. You shouldn't use a database that is numbered after your code rev.

[gnode]

Cavedude: You may be uniquely suited to help me. Disregard everything that has been done here already.

Here is the situation in the most simple of terms.


I originally installed peq from: http://www.projecteq.net/downloads.php

The 1110a version and your standard db.

I have since done the following:
Created a couple items
Add them to some loot tables
Modified some loot tables
Modified some factions
Modified some spawn tables


I need to be able to move to the current version of the software while preserving these changes. In other words, I need to get current and instead of replacing these tables, alter them to add the necessary columns while also not harming my characters and their inventories. I have a tool that will alter them for me, as long as I have a good schema to bring the columns in from.



How exactly would you go about doing this? This can't be a unique situation other than that it is coming from such an old version.