登录 / 注册
> > > 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
管理员

帖子总数: 11573
注册: 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
管理员

帖子总数: 11573
注册: 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
管理员

帖子总数: 11573
注册: 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
管理员

帖子总数: 11573
注册: 2001/5/4
已发表: 2019/4/20 下午8:40

And that should be done as well now.