
10-06-2011, 02:55 PM
|
|
|
Join Date: Oct 2007
Location: UK
Posts: 2,802
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by Angle4cor
I tried to install this mod, but after trying to get into the "Competition" I've got this massage:
Database error in vBulletin 4.1.6:
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 vb_tmnt_categories AS cats
LEFT JOIN vb_tmnt_categories AS pcat
ON (cats.parentid = pcat.catid)
LEFT OUTER JOIN vb_tmnt_tmnts AS tmnts
ON (cats.catid = tmnts.catid)
LEFT OUTER JOIN vb_tmnt_ladders AS ladders
ON (cats.catid = ladders.catid AND ladders.league = 0)
LEFT OUTER JOIN vb_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 'wrestlin_forum.vb_tmnt_categories' doesn't exist
Error Number : 1146
Classname : vB_Database
MySQL Version : 5.5.11
Does anyone of you know how to resolve this problem ?
Thanks in advance.
|
This error refers to a lack of a mysql database table used in this modification. Did you import the product file?
|