kedra
01-12-2020, 11:27 AM
I'm trying to stand up a new server for testing and I'm experiencing a crash after scribing spells and zoning only when using the RoF2 client.
More info:
A fresh Titanium client works fine, I'm only having this problem with a RoF2 client I obtained. It was pre-configured for the EZ server but included files that could be extracted into the install directory for a PEQ server (which I've done).
This is a new linux install using Akkadius' linux install script. I've run the export script and placed the four resulting files on the client: spells_us.txt, dbstr_us.txt, SKillCaps.txt, BaseData.txt. The first two in the root install directory, the latter two in the 'Resources' directory (I think that's correct?)
Reproducing the problem is a little inconsistent but here's an example:
Level 50 shaman runs the command: #scribespells 50
The ROF2 client will crash when zoning and the player cannot log back in until wiping those spells (or maybe just an offending spell but I haven't figured out exactly which one) from character_spells.
Besides running the export script and installing those files into the client I also attempted to import the client files to repopulate spells and dbstr tables - same problem. I've reviewed spells_us.txt, counted columns and the client file and server table seem to be identical.
I've tested with other classes and confirmed it's not just a bogus shaman spell, most caster classes will crash after running #scribespell and scribing a (usually large) range of spells but it's not always after scribing the same range of spells.
I tried to identify exactly which spells were causing this behavior but it's inconsistent, for example, I executed the following series of commands and zoned between each:
Attempt 1
#scribespells 50 1 - crash (wipe character_spells table)
Attempt 2
#scribespells 50 50 - okay
#scribespells 50 49 - okay
#scribespells 50 40 - okay
#scribespells 20 1 - okay
#scribespells 30 20 - ok (thought I was in the clear here)
#scribespells 40 30 - crash (wipe character_spells table)
Attempt 3
#scribespells 40 30 - okay this time
I've enabled mysql logging but I didn't see anything obviously wrong, although maybe I'm just not sure what I'm looking for.
As I said, titanium client works fine and getting ROF2 working at this point is really just a curiosity about checking out the new client. I suspect the ROF2 client I obtained might be the problem but I'm just wondering if anyone has any troubleshooting tips. I've been out of eqemu for a *long* and I'm pretty rusty so I could be overlooking something obvious.
Thanks for any help,
More info:
A fresh Titanium client works fine, I'm only having this problem with a RoF2 client I obtained. It was pre-configured for the EZ server but included files that could be extracted into the install directory for a PEQ server (which I've done).
This is a new linux install using Akkadius' linux install script. I've run the export script and placed the four resulting files on the client: spells_us.txt, dbstr_us.txt, SKillCaps.txt, BaseData.txt. The first two in the root install directory, the latter two in the 'Resources' directory (I think that's correct?)
Reproducing the problem is a little inconsistent but here's an example:
Level 50 shaman runs the command: #scribespells 50
The ROF2 client will crash when zoning and the player cannot log back in until wiping those spells (or maybe just an offending spell but I haven't figured out exactly which one) from character_spells.
Besides running the export script and installing those files into the client I also attempted to import the client files to repopulate spells and dbstr tables - same problem. I've reviewed spells_us.txt, counted columns and the client file and server table seem to be identical.
I've tested with other classes and confirmed it's not just a bogus shaman spell, most caster classes will crash after running #scribespell and scribing a (usually large) range of spells but it's not always after scribing the same range of spells.
I tried to identify exactly which spells were causing this behavior but it's inconsistent, for example, I executed the following series of commands and zoned between each:
Attempt 1
#scribespells 50 1 - crash (wipe character_spells table)
Attempt 2
#scribespells 50 50 - okay
#scribespells 50 49 - okay
#scribespells 50 40 - okay
#scribespells 20 1 - okay
#scribespells 30 20 - ok (thought I was in the clear here)
#scribespells 40 30 - crash (wipe character_spells table)
Attempt 3
#scribespells 40 30 - okay this time
I've enabled mysql logging but I didn't see anything obviously wrong, although maybe I'm just not sure what I'm looking for.
As I said, titanium client works fine and getting ROF2 working at this point is really just a curiosity about checking out the new client. I suspect the ROF2 client I obtained might be the problem but I'm just wondering if anyone has any troubleshooting tips. I've been out of eqemu for a *long* and I'm pretty rusty so I could be overlooking something obvious.
Thanks for any help,