DB error when going to the tournaments and ladders mod
Code:
Database error in vBulletin 4.1.8:
Invalid SQL:
SELECT cats.*, COUNT(DISTINCT tmnts.id) AS counttmnts, COUNT(DISTINCT ladders.id) AS countladders, COUNT(DISTINCT leagues.id) AS countleagues, pcat.title AS categorytitle2, pcat.title AS parenttitle
FROM NCe_tmnt_categories AS cats
LEFT JOIN NCe_tmnt_categories AS pcat
ON (cats.parentid = pcat.catid)
LEFT OUTER JOIN NCe_tmnt_tmnts AS tmnts
ON (cats.catid = tmnts.catid)
LEFT OUTER JOIN NCe_tmnt_ladders AS ladders
ON (cats.catid = ladders.catid AND ladders.league = 0)
LEFT OUTER JOIN NCe_tmnt_ladders AS leagues
ON (cats.catid = leagues.catid AND leagues.league > 0)
GROUP BY cats.catid
ORDER BY cats.parentid DESC, cats.displayorder ASC, cats.title ASC;
MySQL Error : Table 'forum.nce_tmnt_categories' doesn't exist
Error Number : 1146
Request Date : Wednesday, November 30th 2011 @ 11:21:33 PM
Error Date : Wednesday, November 30th 2011 @ 11:21:33 PM
Script : http://localhost/vbulletin/competitions.php
Referrer : http://localhost/vbulletin/content.php
IP Address : 127.0.0.1
Username : owning
Classname : vB_Database
MySQL Version : 5.5.8
Stack Trace:
#0 vB_Database->halt() called in [path]\includes\class_core.php on line 423
#1 vB_Database->execute_query() called in [path]\includes\class_core.php on line 456
#2 vB_Database->query_read() called in [path]\includes\functions_tal.php on line 1442
#3 build_tll_catcache() called in [path]\includes\functions_tal.php on line 133
#4 require_once([path]\includes\functions_tal.php) called in [path]\competitions.php on line 107