Announcement

Collapse
No announcement yet.

Database Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error

    I've received hundreds of emails since our upgrade to vBulletin 5.1.3 Patch Level 1 all pretty similar to these. Any idea what's going on?

    Database error in vBulletin 5.1.3:

    Invalid SQL:
    SELECT count(node.nodeid) AS qty
    FROM sentto AS s
    INNER JOIN node AS node ON node.nodeid = s.nodeid
    INNER JOIN privatemessage AS pm ON pm.nodeid = s.nodeid
    WHERE s.folderid = 1239 AND s.deleted = 0 AND pm.hidemsg = 0 AND pm.newmsg = 1
    /**getNewNotificationRequestCount**/;

    MySQL Error : Unknown column 'pm.hidemsg' in 'where clause'
    Error Number : 1054
    Request Date : Sunday, November 16th 2014 @ 10:20:40 PM
    Error Date : Sunday, November 16th 2014 @ 10:20:40 PM
    Script : http:///interact/forum/ajax/api/ln_ajax/getMessageAndAlertsCount
    Referrer : http://studentpilot.com/interact/forum/
    IP Address : 71.122.122.177
    Username : neil
    Classname : vB_Database_MySQL
    MySQL Version : 5.5.30-log

    ----------------------------------------------------

    Database error in vBulletin 5.1.3:


    Invalid SQL:
    SELECT count(node.nodeid) AS qty
    FROM sentto AS s
    INNER JOIN node AS node ON node.nodeid = s.nodeid
    INNER JOIN privatemessage AS pm ON pm.nodeid = s.nodeid
    WHERE s.folderid = 1239 AND s.deleted = 0 AND pm.hidemsg = 0 AND pm.newmsg = 1
    /**getNewNotificationRequestCount**/;

    MySQL Error : Unknown column 'pm.hidemsg' in 'where clause'
    Error Number : 1054
    Request Date : Sunday, November 16th 2014 @ 10:20:40 PM
    Error Date : Sunday, November 16th 2014 @ 10:20:40 PM
    Script : http:///interact/forum/ajax/api/ln_ajax/getMessageAndAlertsCount
    Referrer : http://studentpilot.com/interact/forum/
    IP Address : 71.122.122.177
    Username : neil
    Classname : vB_Database_MySQL
    MySQL Version : 5.5.30-log

  • #2
    Your errors are from a modification as there is no hidemsg field in the privatemessage table in a default 5.1.3 installation.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      I have no 3rd party mods installed.

      Comment


      • #4
        If I look at your website, it says 5.1.4. But your error message says 5.1.3. I'd suggest rerunning the upgrade.php script since something is off here.

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools <- awesome site for html/css help

        Comment

        Related Topics

        Collapse

        Working...
        X