MyBB Community Forums

Full Version: Intermittent SQL Error Alert
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
G'day,

My forum keeps sending me intermittent warnings that there is a problem with my db:

Sent: Friday, 25 February 2011 5:57 AM
Subject: MyBB error on Parramatta Radio Control Aircraft Club

Your copy of MyBB running on Parramatta Radio Control Aircraft Club (http://www.parramatta.rcflyingclub.com/mybb) has experienced an error. Details of the error include:
---
Type: 20
File:  (Line no. 0)
Message
SQL Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
			ORDER BY p.dateline' at line 4
Query: 
			SELECT u.*, u.username AS userusername, p.*
			FROM mybb_posts p
			LEFT JOIN mybb_users u ON (u.uid=p.uid)
			WHERE p.pid IN ()
			ORDER BY p.dateline

I can't work out what is triggering it, any ideas?
Are you using any plugin on posts / showthread pages ?
Hmmm possibly:
[attachment=21737]
De-activate "Original Poster Image", its out dated.
This is a bug which will be fixed in the next maintenance release.
Thankyou for the advice/help guy's much appreciated