I just upgraded to vBulletin 4 a few days ago, and get the below mysql error periodically:
In the VB admin panel I've tried running the "fix mysql" tool and targeting that table, which works for a few hours, but then the same error returns. Any tips on fixing it permanently?
Code:
Database error in vBulletin 4.2.0: Invalid SQL: SELECT tagsearch.tagid, tag.tagtext, COUNT(*) AS searchcount FROM blog_tagsearch AS tagsearch INNER JOIN tag AS tag ON (tagsearch.tagid = tag.tagid) WHERE tagsearch.dateline > 1343200465 GROUP BY tagsearch.tagid, tag.tagtext ORDER BY searchcount DESC LIMIT 70; MySQL Error : Table 'gchiang_ddforums.blog_tagsearch' doesn't exist Error Number : 1146 Request Date : Friday, August 24th 2012 @ 02:14:25 AM Error Date : Friday, August 24th 2012 @ 02:14:25 AM Script : [URL]http://www.dynamicdrive.com/forums///blog_search.php?do=search[/URL] Referrer : IP Address : 66.249.73.148 Username : Unregistered Classname : vB_Database MySQL Version :