Thread: Bard Bot Bug
View Single Post
  #9  
Old 04-04-2017, 11:49 AM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

That last query was a mistake on my part..really should have been:
Code:
SELECT * FROM `bot_spells_entries` WHERE `npc_spells_id` = '3008';
..you don't need to re-run that or post new results.


Since you have 2508 entries, rather than the 132 I expected, I think we can start there.

Taking 2508 and dividing by 132 - which gives 19 - I'd say that you have at least an 18-fold duplication problem.


Try running this and see what you get:
Code:
SELECT COUNT(*) FROM `bot_spells_entries`;
I have 1347 entries..but, I expect you to have 3723 entries.

In that case you just have an over-applied bard bot spells update. If you have more, then the other spells may be (somehow) over-updated as well.


Let me know and we can go from there.
__________________
Uleat of Bertoxxulous

Compilin' Dirty

Last edited by Uleat; 04-04-2017 at 12:11 PM..
Reply With Quote