
03-20-2012, 06:07 PM
|
|
|
Join Date: Oct 2007
Location: UK
Posts: 2,802
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by MARCUS1980
Hello friend Bananalive I need your help more now thank you for your attention!
I got the product mentioned in this post, the full version on your site, as did the instal??o correctly sends the instructions, but it adds the fields in the menu bar, but when I click paa access, error on page appears.
"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 : Tabela 'torbrasil.tmnt_tmnts' n?o existe
Error Number : 1146
Request Date : Tuesday, March 20th 2012 @ 09:35:04 AM
Error Date : Tuesday, March 20th 2012 @ 09:35:04 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 "
I installed and reinstalled several times, but always with the same error, I asked my friends WHAT could be, then I got the answer for some reason the file *. Xml installation is not creating the table in the database.
My site is www.torbrasil.com.br, my account on their site is marcusgja@hotmail.com, sorry English horrible because I'm from Brazil and used a translator lol, sorry!
I'm posting here because you can not send the other place, thank you and help me because I liked the mod, and you are parabens, goodbye!
|
How is your mysql database set-up, is the mysql type = MyISAM ?
|