Corruption in the database - Bugs - General - Forums - EQ

Forums > General > Bugs > Corruption in the database

Messages in topic: Corruption in the database

Oxgoad

Registered User

Nbr post: 97
Register: 4/20/11

Posted: 1/25/19, 2:27 PM

I'm noticing some corruption in the database. It seems to be located in the NPC table. Looking up NPCs in a zone or NPCs who drop an object, I sometimes will see the leading results filled with long strings of garbage characters. Some examples: Acidized Oil Dragonscale Hills Thank you.

MWunsch

Premium User

Nbr post: 108
Register: 7/15/03

Posted: 2/3/19, 7:40 AM

Have the same for Taaffaeite droppers, e.g. https://eq.magelo.com/npc/482575 (entry from 11/11/2018). Is there a fast way to report such errors as problem?

Jelan

Admin

Nbr post: 11387
Register: 5/4/01

Posted: 2/24/19, 8:03 PM

Thanks for the report guys, I am planning to do some cleanup fairly soon.

Oxgoad

Registered User

Nbr post: 97
Register: 4/20/11

Jelan

Admin

Nbr post: 11387
Register: 5/4/01

Posted: 4/19/19, 8:31 PM

I have fixed the issue. I just need to reindex the quick search so that those bogus entries do not appear there anymore.

Oxgoad

Registered User

Nbr post: 97
Register: 4/20/11

Oxgoad

Registered User

Nbr post: 97
Register: 4/20/11

Posted: 4/19/19, 11:51 PM

I still see some weirdness when I type "crescent r" into the quick search, but perhaps it's not finished indexing? Otherwise, it's so much better than it was.

Jelan

Admin

Nbr post: 11387
Register: 5/4/01

Posted: 4/20/19, 6:36 AM

Ya I need to wipe the index and reindex from scratch, will do that fairly soon

Jelan

Admin

Nbr post: 11387
Register: 5/4/01

Posted: 4/20/19, 8:40 PM

And that should be done as well now.