Item Stats not showing (solved!)

Old bugs stored here for reference.
Locked
User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Item Stats not showing (solved!)

Post by John Adams » Sat Dec 13, 2008 3:11 pm

I don't know how else to tell you (LE) that a bug submitted from Tess /bug command has been resolved. There was nothing wrong with the server code. The problem was every item_stats `text` field had a space character in it. I am not sure how that happened, but likely during an earlier migration of data.
It has been fixed, and all items with stats on Tess should now show their proper item stats. Moving onto the next problem!
Edit: The actual problem is in the rawdata table structures for the parser, where we have NOT NULL specified for certain text/varchar fields, but then default it with a ' '. Kinda unnecessary as NOT NULL + DEFAULT <anything> kinda cancels out the NOT NULL :), so I will remove those from the Parser_DB.sql for future parsings.

Locked

Who is online

Users browsing this forum: No registered users and 0 guests