登錄 / 註冊
> > > Corruption in the database


主題的留言: Corruption in the database
Oxgoad
會員

帖子總數: 97
註冊: 2011/4/20
已發表: 2019/1/25 下午2: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
白金會員

帖子總數: 108
註冊: 2003/7/15
已發表: 2019/2/3 上午7: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
管理員

帖子總數: 11461
註冊: 2001/5/4
已發表: 2019/2/24 下午8:03

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

帖子總數: 97
註冊: 2011/4/20
已發表: 2019/2/25 下午6:18

Thanks for looking into it!
Jelan
管理員

帖子總數: 11461
註冊: 2001/5/4
已發表: 2019/4/19 下午8: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
會員

帖子總數: 97
註冊: 2011/4/20
已發表: 2019/4/19 下午11:28

Ah, much better! Thank you!
Oxgoad
會員

帖子總數: 97
註冊: 2011/4/20
已發表: 2019/4/19 下午11: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
管理員

帖子總數: 11461
註冊: 2001/5/4
已發表: 2019/4/20 上午6:36

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

帖子總數: 11461
註冊: 2001/5/4
已發表: 2019/4/20 下午8:40

And that should be done as well now.