Announcement

Collapse
No announcement yet.

Database errors very frequent

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

  • Database errors very frequent

    I'm experimenting frequent mysql database erros:

    in admin script:

    Error Invalid SQL: UPDATE node AS channel INNER JOIN ( SELECT parentid, SUM(CASE WHEN showpublished AND showapproved AND contenttypeid <> 19 THEN 1 else 0 END) AS textcount, SUM(CASE WHEN showpublished AND showapproved OR contenttypeid = 19 THEN 0 else 1 END) AS textunpubcount, SUM(totalcount) AS childcount, SUM(totalunpubcount) AS childunpub, MAX(COALESCE(lastcontent, publishdate, 0)) AS lastcontent FROM node WHERE parentid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33 ,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63 ,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93 ,94,95,96,97,98,99,100) GROUP BY parentid ) AS starter ON starter.parentid = channel.nodeid SET channel.textcount = starter.textcount, channel.textunpubcount = starter.textunpubcount, channel.totalcount = starter.childcount + starter.textcount, channel.totalunpubcount = starter.childunpub, channel.lastcontent = starter.lastcontent /**updateChannelCounts**/;

    Traza excepción:

    ## /core/vb/database.php(1208) Exception Thrown
    #0 /core/vb/database/mysqli.php(249): vB_Database->halt()
    #1 /core/vb/database.php(561): vB_Database_MySQLi->execute_query(true, Object(mysqli))
    #2 /core/vb/db/query/stored.php(112): vB_Database->query_write('Invalid SQL:\r\n\n...')
    #3 /core/vb/db/assertor.php(301): vB_dB_Query_Stored->execSQL()
    #4 /core/admincp/misc.php(713): vB_dB_Assertor->assertQuery('vBAdmincp:updat...', Array)
    #5 /includes/api/interface/collapsed.php(142): require_once('/home/sonja/dom...')
    #6 /includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay('admincp/misc.ph...')
    #7 /index.php(74): vB5_Frontend_Controller_Relay->admincp('misc.php')
    #8 {main}


    in public forum:

    Error Invalid SQL: SELECT pm.nodeid FROM privatemessage AS pm INNER JOIN node AS msg ON msg.nodeid = pm.nodeid WHERE pm.aboutid IN (1115489) AND msg.userid IN (233507) AND pm.about IN ('subscriber','sg_subscriber') /**getNodePendingRequest**/;
    Traza excepción:

    ## /core/vb/database.php(1208) Exception Thrown
    #0 /core/vb/database/mysqli.php(249): vB_Database->halt()
    #1 /core/vb/database.php(576): vB_Database_MySQLi->execute_query(true, Object(mysqli))
    #2 /core/vb/db/result.php(144): vB_Database->query_read('Invalid SQL:\r\n\n...', true)
    #3 /core/vb/db/result.php(68): vB_dB_Result->rewind()
    #4 /core/vb/db/query/stored.php(104): vB_dB_Result->__construct(Object(vB_Database_MySQLi), '\n\t\t\tSELECT pm.n...', false)
    #5 /core/vb/db/assertor.php(301): vB_dB_Query_Stored->execSQL()
    #6 /core/vb/db/assertor.php(649): vB_dB_Assertor->assertQuery('vBForum:getNode...', Array, false)
    #7 /core/vb/api/follow.php(1959): vB_dB_Assertor->getRows('vBForum:getNode...', Array)
    #8 /core/vb/api/wrapper.php(201): vB_Api_Follow->isFollowingContent(1115489)
    #9 /includes/api/interface/collapsed.php(101): vB_Api_Wrapper->__call('isFollowingCont...', Array)
    #10 /includes/vb5/template/runtime.php(1028): Api_Interface_Collapsed->callApi('follow', 'isFollowingCont...', Array, false, true)
    #11 /includes/vb5/template.php(400) : eval()'d code(480): vB5_Template_Runtime:arseData('follow', 'isFollowingCont...', '1115489')
    #12 /includes/vb5/template.php(400): eval()
    #13 /includes/vb5/template/cache.php(134): vB5_Template->render(false)
    #14 /includes/vb5/template.php(422): vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- *** STA...')
    #15 /includes/vb5/template/cache.php(134): vB5_Template->render(false)
    #16 /includes/vb5/template.php(422): vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r\n\r\n\r\n...')
    #17 /includes/vb5/template/cache.php(134): vB5_Template->render(false)
    #18 /includes/vb5/template.php(422): vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r\n\t\r\n\r...')
    #19 /includes/vb5/template/cache.php(134): vB5_Template->render(false)
    #20 /includes/vb5/template.php(422): vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\t\r\n\t\t<me...')
    #21 /includes/vb5/frontend/controller/page.php(259): vB5_Template->render()
    #22 /index.php(74): vB5_Frontend_Controller_Page->index(224, '1115489', 1, 1, 100, 224, 0, '', 'Temas...', 'Buenas noches, ...', 'http://schema.o...')
    #23 {main}


  • #2
    Neither of those queries return an error when I run them directly against a test database. Did you get an email to your technical email address as specified in your /core/includes/config.php? What is the complete error including the MySQL Error ID given?

    What version of PHP and MySQL are you running? What version of vBulletin?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment

    Related Topics

    Collapse

    Working...
    X