Hello There, Guest! › Register

MySubscriptions 2.2 released.
Looking for a custom plugin for your site? Ask here for a quote.

Solved Mod Panel SQL Error
#1

I recently put boxes around my postbit information:
[Image: postbitboxes.PNG]

I think it may something to do with this error. I do not get this error, however my administrator and mods do when the click the mod panel link, or upon clicking a reported post banner. If someone could point me in the right direction I would appreciate it. Thanks!

Quote:MyBB SQL Error




MyBB has experienced an internal SQL error and cannot continue.
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='115')
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 '1'='1' )
AND t.fid NOT IN
(Array,'574','433','458','503','308','357','554','560','575','576')
AND t.closed NOT LIKE 'moved|%'
AND t.visible != '-2'
AND f.active = '1'
ORDER BY t.lastpost DESC
LIMIT 0,19

This error message does not point me to any php page or line to edit so thats why I am posting it here. I cant figure it out.
Reply

Unfortunately you do not have sufficient rights to view replies in this thread. For full access, consider upgrading.





Users browsing this thread: 1 Guest(s)