Arcade problem

Started by RobbieB, June 16, 2006, 05:15:42 PM

Previous topic - Next topic

RobbieB

When i upgrade from mysql 4 to 5 I seem to have lost tables or something

When I try to use the arcade I get this error
Table 'wowcmambo.smf_games_menus' doesn't exist

I use a program called mysql_yog to manage dbs... I also use a program called mysqlfront, mysql yog can expand the database and list the table, however a number of them are in red text and when I try to view data it says they dont exist.

When I use ph pmyadmin all the tables in question say "In Use" where it normally shows the
Records    Type   Collation   Size   Overhead   etc.

Luckily on this database the only tables that seem to have been corrupted or whatever were smf_game_*

However the only other db that was affected by this same problem has nearly half of its tables broken... and fortunately this is just a backup of another database so no biggie there I guess. Although, when I view this db in php myadmin only a few of the tables show inuse where as SMF has all of the ones that are affected "in use"

Not sure what I should do.

Ideally I'd want to recover the data but my guess is that I'll have to uninstall/reinstall the arcade module and then reinstall the games again. Installing games is kind of a hassle imo.

Advertisement: