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