[dkelsey]

Originally Posted by konixxx

I uploaded files, imported the product. I set up the permissions and when I try to enter tournament site i have MySQL Error : Table 'xxxxxxxxxxxx.tmnt_categories' doesn't exist
Do i have to add something manually to my database?

Error Number : 1146

I didn't see any response to this. I had the same problem. I'm using mysql5.5.8. 'turns out, none of the tables were created in the install process.

show tables like 'tmnt%'

returns nothing.
I looked and found the create statements in product-tournament2008.xml
they use the syntax create table blah () Type=MyISAM -- this failed--no longer supported by mysql. I changed all of these to Engine=MyISAM and the install created all the tables successfully.

from mysql: http://dev.mysql.com/doc/refman/5.1/...ate-table.html

The older TYPE option was synonymous with ENGINE. TYPE has been deprecated since MySQL 4.0 but is still supported for backward compatibility in MySQL 5.1 (excepting MySQL 5.1.7). Since MySQL 5.1.8, it produces a warning. It is removed in MySQL 5.5. You should not use TYPE in any new applications, and you should immediately begin conversion of existing applications to use ENGINE instead. (See Section D.1.62, ?Changes in MySQL 5.1.8 (Not released)?.)

show tables like 'tmnt%'
 Tables_in_forum (tmnt%)    
 -------------------------- 
 tmnt_activity              
 tmnt_announcements         
 tmnt_banners               
 tmnt_categories            
 tmnt_comments              
 tmnt_ladder_games          
 tmnt_ladder_mcs            
 tmnt_ladder_players        
 tmnt_ladders               
 tmnt_members               
 tmnt_players               
 tmnt_rules                 
 tmnt_teams                 
 tmnt_tmnts