It would have been more helpful if you'd specified which two shout mods you used from the start. Since you are now using Infernoshout (which does not use the same table as your previous shout) the first part of my reply was correct.
Quote:
Originally Posted by Paul M
Either you no longer have a shout table (in which case you no longer have a problem), or you use table prefixes. Check your list of table names in the next option (Repair / Optimise Tables)
|
When you removed vb shout, the offending table (below) was deleted.
Quote:
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 208191
use sfoshowd_Forum;
select s.*, count(s.sid) as `TS`, u.username, u.usergroupid from shout s
left join user u on (u.userid = s.s_by)
|