Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 8 Years, 5 Months, 3 Weeks ago Mod CP SQL Errors
#1
Solved: 8 Years, 5 Months, 3 Weeks ago
Quote:MyBB has experienced an internal SQL error and cannot continue.

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

One of my staff gets that when trying to access modcp.php. He has a super moderator account. I have an admin account and I don't have the same issue. I then made his account an admin account and he still had it. He tried two browsers with no success.

I've repaired the tables in pma.

Any ideas?

Cheers.
#2
Solved: 8 Years, 5 Months, 3 Weeks ago
Are any other users experiencing the problem apart from him
#3
Solved: 8 Years, 5 Months, 3 Weeks ago
So I'm guessing nobody knows.
#4
Solved: 8 Years, 5 Months, 3 Weeks ago
If I'm not wrong, this has already been reported as an issue to be fixed., let me see if I can find the thread/post.
#5
Solved: 8 Years, 5 Months, 3 Weeks ago
(2012-09-04, 07:22 AM)Omar G. Wrote: If I'm not wrong, this has already been reported as an issue to be fixed., let me see if I can find the thread/post.

OK. I did search for the error but didn't find anything of any use.
#6
Solved: 8 Years, 5 Months, 3 Weeks ago
Please refer to the following threads to see if any of them are of use to you:
http://community.mybb.com/thread-68110.html
http://community.mybb.com/thread-89959.html
http://community.mybb.com/thread-124385.html
#7
Solved: 8 Years, 5 Months, 3 Weeks ago
They weren't helpful.
#8
Solved: 8 Years, 5 Months, 3 Weeks ago
Did you, somehow, used the merge system?
#9
Solved: 8 Years, 5 Months, 3 Weeks ago
(2012-09-06, 02:46 PM)Omar G. Wrote: Did you, somehow, used the merge system?

no.
#10
Solved: 8 Years, 5 Months, 3 Weeks ago
Open modscp.php, find:
if($unviewableforums && !is_super_admin($mybb->user['uid']))
{
	$flist .= " AND fid NOT IN ({$unviewableforums})";
	$tflist .= " AND t.fid NOT IN ({$unviewableforums})";

	$unviewableforums = str_replace("'", '', $unviewableforums);
	$unviewableforums = explode(',', $unviewableforums);
}

Repace:
if($unviewableforums && !is_super_admin($mybb->user['uid']))
{
	if(is_array($unviewableforums))
	{
		$unviewableforums = str_replace("'", '', implode(',', $unviewableforums));
	}

	$flist .= " AND fid NOT IN ({$unviewableforums})";
	$tflist .= " AND t.fid NOT IN ({$unviewableforums})";

	$unviewableforums = str_replace("'", '', $unviewableforums);
	$unviewableforums = explode(',', $unviewableforums);
}
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)