Page 1 of 1

Item Stats not showing (solved!)

Posted: Sat Dec 13, 2008 3:11 pm
by John Adams
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.