MyBB Community Forums

Hello,

since the update, I receive this message all the time in my inbox.

Quote:Your copy of MyBB running on Delta Commanders ~ Forum (http://deltacommanders.com/forum) has experienced an error. Details of the error include:
---
Type: 20
File: (Line no. 0)
Message
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,t.visible,tr.uid AS truid,tr.dateline,tp.displaystyle AS styledprefix,f.name
FROM mybb_threads t
LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='26')
LEFT JOIN mybb_threadprefixes tp ON (tp.pid = t.prefix)
LEFT JOIN mybb_forums f ON (f.fid = t.fid)
WHERE (t.visible = '1' OR t.fid IN (63,67) )
AND t.fid NOT IN (Array,'24','25','26','27','106','112')
AND t.closed NOT LIKE 'moved|%'
AND t.visible != '-2'
AND f.active = '1'
ORDER BY t.lastpost DESC
LIMIT 0,11

Please help me asap, it's really bothering me:$

And I have no idea what is causing this..

Thanks..

---

This happends on the following pages

While being an Administrator and you're accessing the www.yoursite.com/forum/modcp.php file + when youre browsing through the user database on your admincp, and then click on options > show IP adresses > Information on this IP adress.

Those actions trigger the clause error.

Thanks

---

Bumped.

bumb.. inbox has 128 error messages because of this..

please help

What installed plugins you've ?

As Yaldaram said, it would be nice to see what plugins you are running as I've yet to encounter an error like this.

poeh, that are quite a lot plugins to be honest..


Admin IP Match Plugin (1.3)
Disable portal.php Plugin (1.1)
Admins can log into Users' accounts (1.2)
Ajax PM Notification (1.8.1)
Spider Bots (1.1)
Custom User Permissions (0.2.2)
Fassim Anti Spam (1.21)
Favicon in address bar (1.0.1)
MyBB GoMobile (1.0 Beta 3)
Google SEO (1.6.2)
Help Center (1.5)
Help Center Edits (0.1)
IP Manager (0.1)
User IP Log (1.1)
Javascript Bot Protection (1.1)
Last Visitors in Profile (1.1)
Multiple Registrations Detector (1.1)
MyShoutbox (1.7)
MySupport (0.4.2)
MyTheme (2.0)
Show the users that has been online today (2.0)
Page Manager (1.5.2)
PluginLibrary (4)
Profile Views (1.2)
ProStats /proʊˈstæts/ (1.9.4)
Registration Security Question (1.2)
Report Reputation (0.3.1)
Side Boxes plus! (2.1.3)
Stop forum spam (1.2)
Style Usernames (1.5)
Top Bar (1.2)
View Groups (1.5)
Welcome Guest (1.5)
Welcome PM/Email (1.1)

Sooo.. It are quite much plugins.. But I'm sure more of the half of those listed have nothing to do with those errors..

Thanks for your replies!

Bump..

As they've reopened my topic now, I am requesting help again.

I still receive the same error, without knowing what is causing this..

It works when I disable all plugins, ive disabled some but without luck..

Any help would be greatly appreciated!

It says

Quote:Please contact the MyBB Group for support.

Does no-one have a clue what is causing this?

Disable them all. Then try enabaling one by one. Refreshing to see which plugin is causing the error after every activation. There might be something quicker but that's all I can think of.

Try turning style usernames off first.