MyBB Community Forums

on my friend's board and We been using mybb candidate 4 for awhile.

just sudden, we are getting errors now on some of threads.

mySQL 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 ')' at line 1
Query: SELECT * FROM mybb_attachments WHERE pid IN()

ARG...

no one helping :/

Have you changed anything? Changed the database structure at all?

Chris

A member of the german community has the same problem.

Quote:mySQL 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 ')' at line 1
Query: SELECT * FROM mybb_attachments WHERE pid IN()

He said that he didn't change anything. The error only seems to appear when you open a post that's not older than a week. All old posts can be seen.

Here is an examle: http://www.krafdi.de/forum1/showthread.php?tid=74

Any idea?

Greets,
Michael

Nobody?

Can you get him to do me a favour and edit showthread.php.

Find:

		if($pids)

Replace With:

		if(!empty($pids))

And see if that fixes it?

Thanks

Hi Chris,

thanks a lot for your answer!

There's no

Quote:if($pids)

in the showthreads.php, there's two times

Quote:if($pid)

So he replaced it with

Quote:if(!empty($pid))

But nothing changed, the error still appears.