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

        • aelalfey
          Database error in vBulletin 5.1.8
          by aelalfey
          I started getting this error about 6 days "about 10 emails everyday" ago with no certain reason.
          Code:
          [COLOR=#222222][FONT=arial]Database error in vBulletin 5.1.8:[/FONT][/COLOR]
          
          [COLOR=#222222][FONT=arial]                        Invalid SQL:[/FONT][/COLOR]
          [COLOR=#222222][FONT=arial]CREATE[/][/]
          ...
          Fri 25 Sep '15, 4:00am
        • marky
          Database error in vBulletin 5.1.0
          by marky
          Got an error today (everything is verbatim except the bolded part):

          Invalid SQL:
          /** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_10_lvl1data' AND event = 'nodeChg_10')...
          Tue 22 Apr '14, 1:29pm
        • Merenguista
          Database Error in my 5.0.5
          by Merenguista
          Hi

          I received over 200 Database Error messages :

          Code:
          [COLOR=#222222][FONT=arial]Database error in vBulletin :[/FONT][/COLOR]
          
          [COLOR=#222222][FONT=arial]                       Invalid SQL:[/FONT][/COLOR]
          [COLOR=#222222][FONT=arial]SELECT * FROM setting;[/FONT][/COLOR]
          ...
          Mon 11 Nov '13, 10:21am
        • vskylabv
          Error while upgrading vb5.0.2 to vb5.0.3
          by vskylabv
          Since the support tickets have gone on vacation, I figured I'd asked on here.

          Here's the error I'm receiving while upgrading.
          Code:
          [COLOR=#000000][FONT=arial][SIZE=12px]<?xml version="1.0" encoding="window[/][/][/]
          ...
          Sat 29 Jun '13, 4:57pm
        Working...
        X