
03-21-2012, 04:01 AM
|
|
|
Join Date: May 2011
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
As I said, I installed the version and nothing :-(
"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 tmnt_categories AS cats
LEFT JOIN tmnt_categories AS pcat
ON (cats.parentid = pcat.catid)
LEFT OUTER JOIN tmnt_tmnts AS tmnts
ON (cats.catid = tmnts.catid)
LEFT OUTER JOIN tmnt_ladders AS ladders
ON (cats.catid = ladders.catid AND ladders.league = 0)
LEFT OUTER JOIN 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 : Coluna 'cats.displayorder' desconhecida em 'order clause'
Error Number : 1054
Request Date : Wednesday, March 21st 2012 @ 01:08:52 AM
Error Date : Wednesday, March 21st 2012 @ 01:08:52 AM
Script : http://www.torbrasil.com.br/competitions.php
Referrer : http://www.torbrasil.com.br/forum.php
IP Address : 187.21.114.241
Username : MARCUS1980
Classname : vB_Database
MySQL Version : 5.5.15-log"
|