Would like to post a few things on this as I've spent days banging my head.
First, regarding the readme.txt that tells you to delete your npc_spells_entries table. never ever do this. When working with databases it can be very easy to overlook something and can cause major headaches while you spend hours trying to figure out why something doesn't work. Always rename the table before making any changes (you wouldn't just overwrite a file without backing it up first would you?). Even if it's something as simple as adding one column. It's much easier to look at your tables and know what is what:
npc_spell_entries_bots
npc_spell_entries_prebots
npc_types_bots
npc_types_prebots
etc, etc
Now I have a working table of both versions. I work with databases on a regular basis, so I knew to do this before-hand.
With that said, ever since I installed BOTs on my server I've been experiencing random disconnects (doing GM commands brings my zones down) and cannot group with other players. So I decided to roll back to pre-bots days. Now if I wouldn't have done what I stated above, I would be resourcing my database to get my npc_spell_types back. To source in my DB the first time took over 4 hours (don't ask why). This would have sucked. At any rate, I just want those out there not to have to do this if it can be easily avoided
Though that's not what I banged my head over, the issue I started having (after copying my orginal world.exe, zone.exe, and that dll back over) was that the zone would launch and then close right back down. I tried a different combination of things and in the end all i needed to do was the
mysql > set password for 'root'@'localhost' = old_password('newpw');
command. just wanted to give everyone a heads up.
Last edited by aneriel; 08-28-2007 at 01:26 PM..
Reason: Fixed boldness
|
Hybrid Mode
