The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Database Error

Discussion in 'Database Discussions' started by mail2sacp, Jan 11, 2008.

  1. mail2sacp

    mail2sacp Well-Known Member

    Joined:
    Feb 25, 2007
    Messages:
    71
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    I have strange error which came suddenly without any changes in config or in mysql.

    Following is the error for VBulletin if anyone knows the soltuion than pleaase let us know.

    -------------------------------------------
    <!--
    Database error in vBulletin 3.6.8:

    Invalid SQL:

    SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
    thread.lastposter, thread.dateline, thread.postusername, thread.postuserid,
    IF(views&lt;=replycount, replycount+1, views) AS views, thread.visible, thread.open,
    user.username, user.userid, user.usergroupid,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM thread AS thread
    LEFT JOIN user AS user ON (user.username = thread.lastposter)
    WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open != '10'
    AND thread.forumid NOT IN (Array)
    ORDER BY lastpost DESC
    LIMIT 0, 25;

    MySQL Error : Unknown column 'Array' in 'where clause'
    Error Number : 1054
    Date : Friday, January 11th 2008 @ 09:58:50 AM
    Script : http://ourdomain.com/
    Referrer :
    IP Address : Our IP
    Username : Unregistered
    Classname : vB_Database
    ---------------------------------------------------------------
    If anyone know the solution please let us know it.

    Thank you
    Mail2Sacp.
     
  2. chopperb

    chopperb Active Member

    Joined:
    Jul 23, 2006
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6


    You should ask this at vbulletin.
     
Loading...

Share This Page