Problems after upgrading from June to current release

gnode · #1 02-13-2009, 01:19 AM

Quote:

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 · #2 02-13-2009, 01:28 AM

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 · #3 02-13-2009, 01:30 AM

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.

**cavedude** · #4 02-13-2009, 03:12 AM

Easily done. First, get yourself the Rev 233 update: http://www.projecteq.net/phpBB2/viewtopic.php?t=4612 You're only using this to update your db, don't worry about quests or anything. The 1110a DB is very old, so that might be why you are having trouble. This assume you have not changed your db name, user, or password. If you have, then the update will fail as it depends on the settings the original installer provided. You will know if it failed if the DOS window that sources the DB doesn't stay up for at least a minute or so.

From there, grab the newest PEQ CVS. Source drop_system.sql, then source in the gz file after you unpack it. Go into the updates folder and run EVERY update from 233 up. So, start at Rev247 and go through Rev294. DO NOT skip right to the end, or run any other updates before 247. Also, don't source any sql from the EQEmu SVN, including from the changelog. Everything you need is handled by PEQ CVS.

Then, grab the newest quests from PEQ Quests CVS, and the newest server build from the EQEmu SVN and you should be set.

While all of your character data will be safe, your content will be lost. There is no way to preserve that other than keeping a sql record of every change you make and source it after you resource the content. PEQ makes so many changes to its database daily that there is no way we can offer individual table changes.

gnode · #5 02-13-2009, 11:04 AM

Quote:

Originally Posted by cavedude

Easily done. First, get yourself the Rev 233 update: http://www.projecteq.net/phpBB2/viewtopic.php?t=4612 You're only using this to update your db, don't worry about quests or anything. The 1110a DB is very old, so that might be why you are having trouble. This assume you have not changed your db name, user, or password. If you have, then the update will fail as it depends on the settings the original installer provided. You will know if it failed if the DOS window that sources the DB doesn't stay up for at least a minute or so.

From there, grab the newest PEQ CVS. Source drop_system.sql, then source in the gz file after you unpack it. Go into the updates folder and run EVERY update from 233 up. So, start at Rev247 and go through Rev294. DO NOT skip right to the end, or run any other updates before 247. Also, don't source any sql from the EQEmu SVN, including from the changelog. Everything you need is handled by PEQ CVS.

Then, grab the newest quests from PEQ Quests CVS, and the newest server build from the EQEmu SVN and you should be set.

While all of your character data will be safe, your content will be lost. There is no way to preserve that other than keeping a sql record of every change you make and source it after you resource the content. PEQ makes so many changes to its database daily that there is no way we can offer individual table changes.

Thanks I will give it a try. I am going to try it exactly that way first to see if I can get it running. If so, I am going to alter my original tables mentioned above up to the current schema and bring them in to try to skip on content changes. We aren't going beyond PoP and I did a lot of work to restore PoM back to original. Unless, do you know if PoM has a separate spawn table now? I wonder how many of my customizations might be standard by now..

**cavedude** · #6 02-13-2009, 11:50 AM

PoM is by the default the original version as best as I could get it. It's a spawn_condition now, so the default setting of 1 is for PoM 1.0, and changing it to 2 switches the spawns to version 2.0.

gnode · #7 02-13-2009, 12:31 PM

Quote:

Originally Posted by cavedude

PoM is by the default the original version as best as I could get it. It's a spawn_condition now, so the default setting of 1 is for PoM 1.0, and changing it to 2 switches the spawns to version 2.0.

Hmm... awesome. The only other really involved change I made was cleaning up airplane's spawn times and loot tables. Perhaps I should redo that on the new version and submit it back to you guys if needed.

I also made a quest that upgrades people's kunark and old planar armor up to low-tier velious specs. I can live without that given the stage we are in. But my only concern with that is all the old item ids floating around. Many of those items are in the 1400-1500 range and used by some people still...

What guidelines do you have regarding item ids? If I were to change all of these IDs to something that won't interfere with the peq db, what number range should I use?

It sounds like a lot of the big "fixes" I put in are standard now. I may just have to re-import a minority of my changes and clean up inventory.

**cavedude** · #8 02-13-2009, 01:09 PM

Sure, any work you do on airplane or any other zone submit to me on the PEQ forums. If it's good, I'll merge it

I never turn good work away.

The item IDs are Sony's so I don't handle the ranges at all. Because of that, I can't give you IDs that I can say with certainty won't be taken when I do the 13th floor dump again.

gnode · #9 02-15-2009, 01:07 AM

Quote:

Originally Posted by cavedude

Easily done. First, get yourself the Rev 233 update: http://www.projecteq.net/phpBB2/viewtopic.php?t=4612 You're only using this to update your db, don't worry about quests or anything. The 1110a DB is very old, so that might be why you are having trouble. This assume you have not changed your db name, user, or password. If you have, then the update will fail as it depends on the settings the original installer provided. You will know if it failed if the DOS window that sources the DB doesn't stay up for at least a minute or so.

From there, grab the newest PEQ CVS. Source drop_system.sql, then source in the gz file after you unpack it. Go into the updates folder and run EVERY update from 233 up. So, start at Rev247 and go through Rev294. DO NOT skip right to the end, or run any other updates before 247. Also, don't source any sql from the EQEmu SVN, including from the changelog. Everything you need is handled by PEQ CVS.

Then, grab the newest quests from PEQ Quests CVS, and the newest server build from the EQEmu SVN and you should be set.

While all of your character data will be safe, your content will be lost. There is no way to preserve that other than keeping a sql record of every change you make and source it after you resource the content. PEQ makes so many changes to its database daily that there is no way we can offer individual table changes.

I did this exactly and it did not work. So then I backtracked to find exactly what point it did not work.

I installed peq fresh, straight from: http://prdownloads.sourceforge.net/p...a.exe?download

Then I loaded my DB, which is structurally identical to the one in the installer.

Then I applied the 233 patch to update db and server files.

For giggles, I loaded up eqemu right then and there. When I log in, I am blasted with this error and I am able to get my char in the game, but he has no gear. Almost all of these items are in fact in the db. So maybe there are other changes I need to make before the 233 patch?
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2500
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2501
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 19255 in inventory slot 2531
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 4301 in inventory slot 2532
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 19418 in inventory slot 2533
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 4555 in inventory slot 2534
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 19330 in inventory slot 2535
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 6678 in inventory slot 2536
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 11631 in inventory slot 2538
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 6675 in inventory slot 2541
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 19496 in inventory slot 2542
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 11611 in inventory slot 2543
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 4175 in inventory slot 2544
[02.14. - 22:55:01] Warning: acctid 1 has an invalid item_id 11668 in inventory slot 2545
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11584 in inventory slot 2546
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6692 in inventory slot 2547
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6300 in inventory slot 2548
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2500
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2501
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19255 in inventory slot 2531
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4301 in inventory slot 2532
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19418 in inventory slot 2533
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4555 in inventory slot 2534
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19330 in inventory slot 2535
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6678 in inventory slot 2536
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11631 in inventory slot 2538
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6675 in inventory slot 2541
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19496 in inventory slot 2542
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11611 in inventory slot 2543
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4175 in inventory slot 2544
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11668 in inventory slot 2545
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11584 in inventory slot 2546
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6692 in inventory slot 2547
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6300 in inventory slot 2548
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2500
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2501
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19255 in inventory slot 2531
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4301 in inventory slot 2532
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19418 in inventory slot 2533
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4555 in inventory slot 2534
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19330 in inventory slot 2535
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6678 in inventory slot 2536
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11631 in inventory slot 2538
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6675 in inventory slot 2541
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19496 in inventory slot 2542
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11611 in inventory slot 2543
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4175 in inventory slot 2544
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11668 in inventory slot 2545
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11584 in inventory slot 2546
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6692 in inventory slot 2547
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6300 in inventory slot 2548
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2500
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2501
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19255 in inventory slot 2531
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4301 in inventory slot 2532
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19418 in inventory slot 2533
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4555 in inventory slot 2534
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19330 in inventory slot 2535
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6678 in inventory slot 2536
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11631 in inventory slot 2538
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6675 in inventory slot 2541
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19496 in inventory slot 2542
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11611 in inventory slot 2543
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4175 in inventory slot 2544
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11668 in inventory slot 2545
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11584 in inventory slot 2546
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6692 in inventory slot 2547
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6300 in inventory slot 2548
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2500
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 17005 in inventory slot 2501
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19255 in inventory slot 2531
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4301 in inventory slot 2532
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19418 in inventory slot 2533
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4555 in inventory slot 2534
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19330 in inventory slot 2535
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6678 in inventory slot 2536
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11631 in inventory slot 2538
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6675 in inventory slot 2541
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 19496 in inventory slot 2542
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11611 in inventory slot 2543
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 4175 in inventory slot 2544
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11668 in inventory slot 2545
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 11584 in inventory slot 2546
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6692 in inventory slot 2547
[02.14. - 22:55:02] Warning: acctid 1 has an invalid item_id 6300 in inventory slot 2548

gnode · #10 02-15-2009, 02:01 AM

Also, #npcloot show on any npc shows no loot. It is as though items simply won't load right... but the table is fully populated.

**cavedude** · #11 02-15-2009, 04:48 AM

The items table has changed since 233... You need to update past that to work with the current server after you've restored your inventory table.

What part of the procedure didn't work? What were the errors you were getting?

**cavedude** · #12 02-15-2009, 05:02 AM

Could you do a describe items; at a MySQL prompt and post the output? I have a feeling that you are overwriting the stock table with an outdated or altered table and that is where your trouble is.