Identifiez-vous
> > > Corruption in the database


Messages dans le sujet: Corruption in the database
Oxgoad
Membre

Nbr msg: 97
Enregistré: 20/04/2011
Ecrit le: 25/01/2019 20:27

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:



Thank you.
MWunsch
Membre Premium

Nbr msg: 108
Enregistré: 16/07/2003
Ecrit le: 03/02/2019 13:40

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 msg: 11573
Enregistré: 05/05/2001
Ecrit le: 25/02/2019 02:03

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

Nbr msg: 97
Enregistré: 20/04/2011
Ecrit le: 26/02/2019 00:18

Thanks for looking into it!
Jelan
Admin

Nbr msg: 11573
Enregistré: 05/05/2001
Ecrit le: 20/04/2019 02:31

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

Nbr msg: 97
Enregistré: 20/04/2011
Ecrit le: 20/04/2019 05:28

Ah, much better! Thank you!
Oxgoad
Membre

Nbr msg: 97
Enregistré: 20/04/2011
Ecrit le: 20/04/2019 05:51

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 msg: 11573
Enregistré: 05/05/2001
Ecrit le: 20/04/2019 12:36

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

Nbr msg: 11573
Enregistré: 05/05/2001
Ecrit le: 21/04/2019 02:40

And that should be done as well now.