Hello,
I recently updated to VB5. I saw that search was returning only a few among hundreds of expected results. I rebuilt the search index from command line. That did not help.
I went to update the thread topic info. I did this with 2K threads, 40K threads and in the end I get the same message. Can someone please help?
I recently updated to VB5. I saw that search was returning only a few among hundreds of expected results. I rebuilt the search index from command line. That did not help.
I went to update the thread topic info. I did this with 2K threads, 40K threads and in the end I get the same message. Can someone please help?
Code:
Error Invalid SQL: UPDATE node AS node INNER JOIN ( SELECT node.starter, SUM(CASE WHEN node.parentid = node.starter AND (node.showpublished > 0 AND node.showapproved > 0) THEN 1 ELSE 0 END) AS textcount, SUM(CASE WHEN node.parentid = node.starter AND (node.showpublished = 0 OR node.showapproved = 0) THEN 1 ELSE 0 END) AS textunpubcount, SUM(CASE WHEN node.nodeid != node.starter AND (node.showpublished > 0 AND node.showapproved > 0) THEN 1 ELSE 0 END) AS totalcount, SUM(CASE WHEN node.nodeid != node.starter AND (node.showpublished = 0 OR node.showapproved = 0) THEN 1 ELSE 0 END) AS totalunpubcount, MAX(node.publishdate) AS lastcontent FROM node AS node WHERE node.starter between 15267583 and 15287582 AND node.contenttypeid NOT IN (30,34,35) GROUP BY node.starter ) AS counts ON node.nodeid = counts.starter SET node.textcount = counts.textcount, node.textunpubcount = counts.textunpubcount, node.totalcount = counts.totalcount, node.totalunpubcount = counts.totalunpubcount, node.lastcontent = counts.lastcontent /**updateThreadCounts**/; Exception trace: ## /data/core/vb/database.php(1189) Exception Thrown #0 /data/core/vb/database/mysqli.php(201): vB_Database->halt() #1 /data/core/vb/database.php(542): vB_Database_MySQLi->execute_query(true, Object(mysqli)) #2 /data/core/vb/db/query/stored.php(111): vB_Database->query_write('Invalid SQL:\r\n\n...') #3 /data/core/vb/db/assertor.php(304): vB_dB_Query_Stored->execSQL() #4 /data/core/admincp/misc.php(773): vB_dB_Assertor->assertQuery('vBAdmincp:updat...', Array) #5 /data/includes/api/interface/collapsed.php(142): require_once('/data/c...') #6 /data/includes/vb5/frontend/controller/relay.php(33): Api_Interface_Collapsed->relay('admincp/misc.ph...') #7 /data/index.php(74): vB5_Frontend_Controller_Relay->admincp('misc.php') #8 {main}
Comment