MyBB Community Forums
[Error Message] MyBB SQL Error when access ModCP - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: [Error Message] MyBB SQL Error when access ModCP (/thread-124385.html)

Pages: 1 2 3


MyBB SQL Error when access ModCP - NNT_ - 2012-08-14

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.


RE: MyBB SQL Error when access ModCP - Omar G. - 2012-08-14

What MyBB version are you using?


RE: MyBB SQL Error when access ModCP - NNT_ - 2012-08-14

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

1.6.8


RE: MyBB SQL Error when access ModCP - Omar G. - 2012-08-14

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.


RE: MyBB SQL Error when access ModCP - NNT_ - 2012-08-14

(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


RE: MyBB SQL Error when access ModCP - StefanT - 2012-08-14

http://dev.mybb.com/issues/2082


RE: MyBB SQL Error when access ModCP - NNT_ - 2012-08-14

(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


RE: MyBB SQL Error when access ModCP - melchor - 2012-08-14

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


RE: MyBB SQL Error when access ModCP - NNT_ - 2012-08-14

(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.


RE: MyBB SQL Error when access ModCP - StefanT - 2012-08-14

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