I am having performance issues with my forum because of this query on the posts table..
Anyone can help me find out what is causing this?
What's the exact error your getting?
URL?
It's not an error.. it's an entry in the slow query logs..
What plugins do you have installed?
Anonymous Mode
Auto Media
BBCode Usertitle
Classic Author Column
Game Section
Google SEO
Image Resizer & Optimizer with GD
Last Threads, Posts and Popular Threads on UserCP Home
MyBlogs
MyIPN
Tagpad
Undo Delete
Deactivating them doesn't give improvement.. and some are optimized by me to use less hooks and or queries..
Most don't have a thing to do with the posts table either..
Anyone?