Anmelden
> > > Corruption in the database


Nachrichten zum Thema: Corruption in the database
Oxgoad
Mitglied

Beiträge: 97
Registrieren: 20.04.11
Gesendet: 25.01.19, 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
Premium Mitglied

Beiträge: 108
Registrieren: 16.07.03
Gesendet: 03.02.19, 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

Beiträge: 11573
Registrieren: 05.05.01
Gesendet: 25.02.19, 02:03

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

Beiträge: 97
Registrieren: 20.04.11
Gesendet: 26.02.19, 00:18

Thanks for looking into it!
Jelan
Admin

Beiträge: 11573
Registrieren: 05.05.01
Gesendet: 20.04.19, 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
Mitglied

Beiträge: 97
Registrieren: 20.04.11
Gesendet: 20.04.19, 05:28

Ah, much better! Thank you!
Oxgoad
Mitglied

Beiträge: 97
Registrieren: 20.04.11
Gesendet: 20.04.19, 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

Beiträge: 11573
Registrieren: 05.05.01
Gesendet: 20.04.19, 12:36

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

Beiträge: 11573
Registrieren: 05.05.01
Gesendet: 21.04.19, 02:40

And that should be done as well now.