Uninstalled Arcade but MySQL Error 1146

[BigJimTheLug]

My forum home page index.php does not load anymore. Every other part of my forum is working fine minus the forumhome.

I get this error on my forumhome page:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT champ_gid AS gid, champ_mid AS userid, champ_name AS name, COUNT(champ_mid) AS total
FROM games_champs
GROUP BY userid
ORDER BY total DESC LIMIT 3;

MySQL Error : Table 'puremark_vb.games_champs' doesn't exist
Error Number : 1146


I removed the files and this problem occurred. I tried to upgrade to the latest version and received another MySQL Error via the this link

http://www.puremarketprofits.com/arcade.php


mySQL query error: SELECT arcade_access, p_require FROM usergroup WHERE usergroupid = 1

mySQL error: Unknown column 'arcade_access' in 'field list'
mySQL error code:
Date: Thursday 08th 2009f January 2009 05:52:14 PM


How can I fix it so that my forum home page loads. I don't want the arcade any longer, but if i remove it, problems arise. Please help.
Thanks.

--------------- Added 1231459288 at 1231459288 ---------------

I also get this error from the admincp


mySQL query error: SELECT * FROM games_settings

mySQL error: Table 'games_settings' doesn't exist
mySQL error code: 1146
Date: Thursday 08th 2009f January 2009 05:59:56 PM



--------------- Added 1231461045 at 1231461045 ---------------

Problem solved.

[GreasySpoon]

Problem solved.

Please tell us how you have solved the problem. Maybe someone else have the same issue.

[BigJimTheLug]

I have to create all the tables related to games using phpmyadmin.

Fortunately, all the tables related to games, were listed in another one of our boards. So all I did was an export of those particular tables in mysql format from one database, and then I imported them using phpmyadmin to my current database with the arcade problem. As soon as I began the import into the database with the problem, phpmyadmin created the tables automatically and that did the problem.

I knew that I did not have the tables and would have to either stop calling them upon loading the forum home or create them even though I uninstalled the arcade. Since I'm not proficient in mysql, it was easire for me to do an export/import fix than a coding fix.

I can load the mysql file onto this website if it is okay with the owner of this arcade system.

The problem is that as soon as you try to uninstall the ibpro-arcade, it causes lots of problems and goes to show that it needs a lot of work because it does not do a clean uninstall, but only does a clean install.

Install the arcade at your own risk.

Update
Here are the game's tables that will need to be created when the ibpro-arcade is uinstalled.
games_cats
games_champs
games_league
games_list
games_savedGames
games_scores
games_session
games_settings

--------------- Added 1231518703 at 1231518703 ---------------

If my message appears incoherent, please excuse it. I typed the reply on how to fix it as soon as I woke up. I'll try to clear it up later if the need arises.
Thank you.

[gg2-hungama]

i had a same thing sir ..the very first error as you described ..and i followed as you said copied and some tables moved from my old board sql database to current one all the games table u said and my forum is now back on ..u rock ..problem is solved ..but the coder should do something luckyly i had old board which had installed ipbarcade..but ppl who doesnt have this kind stuff ..i feel bad for them... thanks worked u r solution for me thanks