Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Database Error

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

  1. mail2sacp

    mail2sacp Well-Known Member

    Joined:
    Feb 25, 2007
    Messages:
    71
    Likes Received:
    0
    Trophy Points:
    156
    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:
    156


    You should ask this at vbulletin.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice