MyBB Community Forums

Full Version: SQL error 1054
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi anybody,
I have a very strange problem with mybb.
I install new theme and every thing works fine but when I want to go to moderators control panel show this error.


SQL Error:
1054 - Unknown column 'Array' in 'where clause'
Query:
SELECT t.subject,t.username,t.uid,t.tid,t.fid,t.lastpost,t.lastposter,t.lastposteruid,t.replies,tr.uid AS truid,tr.dateline,f.name FROM mk123_threads t LEFT JOIN mk123_threadsread tr ON (tr.tid=t.tid AND tr.uid='78') LEFT JOIN mk123_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.fid NOT IN (Array,'242') AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost DESC LIMIT 0,29


please help me
thanks so much
with king regards
M.K
Please list all the plugins/modifications you have installed.
I installed these plugins :

MyBB WYSIWYG Editor (1.0.4)
welcome pm
undo delete
topic stats
thanks
Simple TagCloud (beta) (0.9)
site map generator
seo titles
Round Avatar (1.0)
Last Posts (1.1.0)
reg secure question
quick reply pm
pro stats
pm admin
Show the users that has been online today (2.0)
Miss You Email (1.0.0)
Hijri Shamsi (Jalali) Date! (1.2.2)
image re sizer GD
Hello EditCore! (hello_pl.php)
Google SEO (1.6.3)
contact form
Autoset cookie paths (2.0)
Akismet (1.2.2)
Ajax notice pm
Advanced quick reply form
User CP Dropdown Menu

these are installed and enabled ...
tnx for your reply
Nobody can help me !
any idea ?
I'm pretty sure it's one of those modifications/plugins. What's the last one you installed?
@op, disable (/ uninstall) prostats plugin and check if error goes away !
btw, is your forum updated to latest version of MyBB
thanks so much for your reply..

I disable the prostats plugin and the problem was disappear..

the last plugin is a drop menu for users that can access to their control panel and some shortlinks .
you can see

http://www.sistaniha.info