What exactly do you want me to do Optimize Tables & Repair Tables?

What I said.

I don't see anything in there. :(
Any other suggestions so my site won't get that annoying 503 error once in a while?

I don't know enough about mysql, but if he *is* using table prefixes and the queries are not using a table prefix (like in the first post it doesn't look like there are any table prefixes used), could that be why they are showing as slow queries or problem queries - because there is not table called just shout?

If the problem is table prefixes, you need to go into the code for your shout box and replace "FROM shout" with "FROM ".$TABLE_PREFIX."shout"

Also, do you have access to phpMyAdmin to see your mySQL tables?

Yes I have access to phpMyAdmin to see my mySQL tables..

Also just a reminder I installed a NEW shoutbox guys.. I WAS running vbshout 2.0, now im on Inferno vBShout. So.. just a reminder so you don't have me doing work I don't need to..

For my new shoutbox? Cause if I uninstalled my old one wouldn't it be removed? Also how would I do this.

Go inside your administrators control panel. Click on the Maintenance navigation box and then click on "Repair / Optimize Tables". Once that is done it will give you a list of all your tables. Once you have that list click look at it and compare the first entry (should be the same) to the one below:

access

If it is something like "vb_access" you use a table prefix. Once you have determined that go back and alter the query Paul M gave you to look like this:

[sql]TRUNCATE PREFIXshout;[/sql]

Just replace PREFIX with the prefix you found before the "access" in the last step. This should solve your problem.

Are you sure that your new shoutbox is not also using a table called 'shout'? I know that from my work on trackers, many of them will have tables with the same names and same column names (cuz they all make sense to have these names), so it may be that many shoutbox hacks use a table called 'shout'. When you uninstalled the old hack, did you remove the tables it installed when you installed it?

[sql]TRUNCATE infernoshout[/sql]

They have inferno in front of the shout box.

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.


When you removed vb shout, the offending table (below) was deleted.