Announcement

Collapse
No announcement yet.

Error in Message Cente

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

  • Error in Message Cente

    Hello everyone,

    A problem when I open message center or notifications Ihave this message:

    Error Invalid SQL: (SELECT n.nodeid, n.routeid, n.publishdate, n.unpublishdate, n.userid , n.authorname, n.title, n.starter, n.lastcontent, n.lastcontentid, n.lastcontentauthor, n.lastauthorid, n.textcount, n.totalcount, n.ipaddress, text.rawtext, text.pagetext, text.previewtext, pm.msgtype, s.folderid, 'messages' AS titlephrase, u.username, starter.routeid, s.msgread, pm.about, pm.aboutid, n.routeid AS aboutrouteid, starter.title AS abouttitle, starter.userid AS starteruserid, starter.created AS startercreated, starter.lastcontent AS lastpublishdate, poll.votes, poll.lastvote, starter.starter AS starter_parent, NULL AS aboutstarterid, NULL as aboutstartertitle, NULL AS aboutstarterrouteid FROM privatemessage AS pm INNER JOIN text AS text ON text.nodeid = pm.nodeid INNER JOIN node AS n ON n.nodeid = pm.nodeid INNER JOIN node AS starter ON starter.nodeid = n.starter INNER JOIN sentto AS s ON s.nodeid = pm.nodeid INNER JOIN messagefolder AS f ON f.folderid = s.folderid INNER JOIN user AS u ON u.userid = n.userid LEFT JOIN poll AS poll ON poll.nodeid = pm.aboutid WHERE s.userid = 7095 AND s.msgread=0 AND s.deleted = 0 AND n.userid NOT IN (-1) AND s.folderid NOT IN (15892,15893) AND pm.msgtype = 'message' AND ifnull(f.title, '') = '' AND n.nodeid IN (-1) ORDER BY n.created DESC LIMIT 5) UNION (SELECT n.nodeid, n.routeid, n.publishdate, n.unpublishdate, n.userid , n.authorname, n.title, n.starter, n.lastcontent, n.lastcontentid, n.lastcontentauthor, n.lastauthorid, n.textcount, n.totalcount, n.ipaddress, text.rawtext, text.pagetext, text.previewtext, pm.msgtype, s.folderid,'requests' AS titlephrase, u.username, starter.routeid, s.msgread, pm.about, pm.aboutid, n.routeid AS aboutrouteid, starter.title AS abouttitle, starter.userid AS starteruserid, starter.created AS startercreated, starter.lastcontent AS lastpublishdate, poll.votes, poll.lastvote, starter.starter AS starter_parent, NULL AS aboutstarterid, NULL as aboutstartertitle, NULL AS aboutstarterrouteid FROM privatemessage AS pm INNER JOIN text AS text ON text.nodeid = pm.nodeid INNER JOIN node AS n ON n.nodeid = pm.nodeid INNER JOIN node AS starter ON starter.nodeid = n.starter INNER JOIN sentto AS s ON s.nodeid = pm.nodeid INNER JOIN user AS u ON u.userid = n.userid LEFT JOIN poll AS poll ON poll.nodeid = pm.aboutid WHERE s.userid = 7095 AND s.msgread=0 AND s.deleted = 0 AND n.userid NOT IN (-1) AND pm.msgtype = 'request' ORDER BY n.created DESC LIMIT 5) /**pmPreview**/;


  • #2
    What is the rest of the error message?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      :
      ## /home/****/public_html/vb/core/vb/database.php(1208) Exception Thrown #0 /home/****/public_html/vb/core/vb/database/mysqli.php(249): vB_Database->halt() #1 /home/****/public_html/vb/core/vb/database.php(576): vB_Database_MySQLi->execute_query(true, Object(mysqli)) #2 /home/****/public_html/vb/core/vb/db/result.php(144): vB_Database->query_read('Invalid SQL:\r\n(...', true) #3 /home/****/public_html/vb/core/vb/db/result.php(68): vB_dB_Result->rewind() #4 /home/****/public_html/vb/core/vb/db/query/stored.php(104): vB_dB_Result->__construct(Object(vB_Database_MySQLi), '(SELECT n.nodei...', false) #5 /home/****/public_html/vb/core/vb/db/assertor.php(301): vB_dB_Query_Stored->execSQL() #6 /home/****/public_html/vb/core/vb/api/content/privatemessage.php(1575): vB_dB_Assertor->assertQuery('vBForummPrevi...', Array) #7 /home/****/public_html/vb/core/vb/api/wrapper.php(197): vB_Api_Content_Privatemessage->previewMessages() #8 /home/****/public_html/vb/includes/api/interface/collapsed.php(101): vB_Api_Wrapper->__call('previewMessages', Array) #9 /home/****/public_html/vb/includes/vb5/template/runtime.php(1008): Api_Interface_Collapsed->callApi('content_private...', 'previewMessages', Array, false, true) #10 /home/****/public_html/vb/includes/vb5/template.php(399) : eval()'d code(2): vB5_Template_Runtime:arseData('content_private...', 'previewMessages') #11 /home/****/public_html/vb/includes/vb5/template.php(399): eval() #12 /home/****/public_html/vb/includes/vb5/template/cache.php(134): vB5_Template->render(false) #13 /home/****/public_html/vb/includes/vb5/template.php(421): vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\t\r\n\t\r\n...') #14 /home/****/public_html/vb/includes/vb5/template/cache.php(134): vB5_Template->render(false) #15 /home/****/public_html/vb/includes/vb5/template.php(421): vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- *** STA...') #16 /home/****/public_html/vb/includes/vb5/template/cache.php(134): vB5_Template->render(false) #17 /home/****/public_html/vb/includes/vb5/template.php(421): vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r\n\r\n\r\n...') #18 /home/****/public_html/vb/includes/vb5/template/cache.php(134): vB5_Template->render(false) #19 /home/****/public_html/vb/includes/vb5/template.php(421): vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r\n\t\r\n\r...') #20 /home/****/public_html/vb/includes/vb5/template/cache.php(134): vB5_Template->render(false) #21 /home/****/public_html/vb/includes/vb5/template.php(421): vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\t\r\n\t\t<me...') #22 /home/****/public_html/vb/includes/vb5/frontend/controller/page.php(259): vB5_Template->render() #23 /home/****/public_html/vb/index.php(74): vB5_Frontend_Controller_Page->index(13, '13', 'privatemessage_...', 'index', 'I'm a dummy val...') #24 {main

      Comment


      • #4
        Hmm.. the important part which is the MySQL Error Code and where the error occurs in the query isn't available?

        First I would suggest correcting this issue:
        Code:
        Warning: session_start(): open(/tmp/sess_0481359b0e105a94b58ee5973b44bb84, O_RDWR) failed: No space left on device (28) in /home/CCCCCCCC/public_html/vb/includes/vb5/frontend/controller/page.php on line 56
        Warning: session_start(): Failed to read session data: files (path: /tmp) in /home/CCCCCCCC/public_html/vb/includes/vb5/frontend/controller/page.php on line 56
        MySQL won't work properly without space on the drive. Your hosting provider can help you allocate more space to the system.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        Related Topics

        Collapse

        Working...
        X