This is caused by a modification.

The main culprit is:

| 180105 | fvsports_Focker | localhost | fvsports_forum | Query | 24 | Copying to tmp table | SELECT item.item_id, item.item_title, item.threadid, grp.group_title, item.item_status, item.item_cr |

This does not look like a default vB query.

"Copying to tmp table" This indicates that MySQL need to copy all data to a temporary table in order to do a sort, filter or merge. This can be caused by missing indexes on the table. Please contact the author of this modification for a solution.

thanks. i did a search and that comes up as my vbookie mod. ill have to look into remedying that and seeing if that helps

Learn something new every day! :up:

Thanks for the help you two. I believe that may have been the issue since it hasn't acted up since I disabled that mod. I will keep an eye on it for the next few days to make sure, but I really appreciate the help.

I'm having similar problem. My webhost said that the query has become too complex, and that it was timing out before it finished. I tried rescheduling some of the RSS feeds, but that proved fruitless, as it got another error message today. Any suggestions on this one?

I've noticed another accompanying problem:
The RSS feeds won't write to the server until, or unless I sign on as admin. Like it needs that as authorization

You need to increase your mysql wait time.

Oh for gods sake open your own thread. I just wasted 5 minutes reading this one only to realize it's from 2008! And your error isn't even the same as his. Assuming you've uninstalled (or at least disabled) all your mods, and the problem still occurs, then take it to vb.com.