MyBB Community Forums

Hi,

I've met a trouble in my forum.

SQL Error:
1054 - Unknown column 'Array' in 'where clause'
Query:
SELECT COUNT(aid) AS unapprovedattachments FROM forum_attachments a LEFT JOIN forum_posts p ON (p.pid=a.pid) LEFT JOIN forum_threads t ON (t.tid=p.tid) WHERE a.visible='0' AND t.fid IN (0,'13','14') AND t.fid NOT IN (Array)

I've searched about this problem, at http://dev.mybb.com/issues/476

I tried to fix, but return nothing.

This problem didn't appear when I search on mybb like that issues. It's appeared only when other moderators except me (uid=1) access to modcp.

What MyBB version are you using?

(2012-08-14, 07:35 AM)Omar G. Wrote: [ -> ]What MyBB version are you using?

1.6.8

Are you sure you are using clean MyBB 1.6.8 files (especially the functions_search.php one)? It seems to be fixed in 1.6.8.

(2012-08-14, 07:59 AM)Omar G. Wrote: [ -> ]Are you sure you are using clean MyBB 1.6.8 files (especially the functions_search.php one)? It seems to be fixed in 1.6.8.

My forum use fresh installation of MyBB 1.6.8, I've tried to disbled all plugin but that error still happening.

I've fixed my function_search.php but that trouble still be there.

Note: This trouble is shown to all users except user 1 (uid=1).

(2012-08-14, 09:12 AM)StefanT Wrote: [ -> ]http://dev.mybb.com/issues/2082

Yes, I've created new issue for this really strange trouble

tested it pro stats plugin is the main cause of this error...try to uninstall the plugin..

(2012-08-14, 09:43 AM)melchor Wrote: [ -> ]tested it pro stats plugin is the main cause of this error...try to uninstall the plugin..

I never use prostats plugin on my forum before.

I don't see any mistake in the code and I can't reproduce it under the circumstances you describe.