Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [Error Message] MyBB SQL Error when access ModCP
#1
Not Solved
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.
Software is like sex: it's better when it's free.
-Linus Torvalds
#2
Not Solved
What MyBB version are you using?
#3
Not Solved
(2012-08-14, 07:35 AM)Omar G. Wrote: What MyBB version are you using?

1.6.8
Software is like sex: it's better when it's free.
-Linus Torvalds
#4
Not Solved
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.
#5
Not Solved
(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). Confused
Software is like sex: it's better when it's free.
-Linus Torvalds
#6
Not Solved
http://dev.mybb.com/issues/2082
[Image: banner.png]
#7
Not Solved
(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 Undecided
Software is like sex: it's better when it's free.
-Linus Torvalds
#8
Not Solved
tested it pro stats plugin is the main cause of this error...try to uninstall the plugin..
#9
Not Solved
(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.
Software is like sex: it's better when it's free.
-Linus Torvalds
#10
Not Solved
I don't see any mistake in the code and I can't reproduce it under the circumstances you describe.
[Image: banner.png]
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)