database error....

H

hariprasad

New Member
When i go to my forum i get database error page...admincp is working perfectly...then i disabled hook system from admincp then forum worked but i cant run like tat forever so decided to disable the products one by one and check whether forum is working..but even after disabling all products i have installed the database error is coming but when i disable hook system no error is coming...what would be the reason...
pls help...
below is the database error i get...

Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT c.*, g.gcat, g.gid, g.gname, cat.password
FROM games_champs AS c, games_list AS g, games_cats AS cat
WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND cat.password=''
ORDER BY champ_date DESC LIMIT 0,7;

MySQL Error : Table 'xxxxxxxx_xx.games_champs' doesn't exist
Error Number : 1146
Request Date : Sunday, January 18th 2009 @ 05:15:51 AM
Error Date : Sunday, January 18th 2009 @ 05:15:51 AM
Script : http://xxxxxx.com/forum1/index.php
Referrer :
IP Address : xxxxxxxxx
Username : admin
Classname : vB_Database
MySQL Version : 5.0.27-Debian_0.dotdeb.1


Note : today i uninstalled many products (like ibproarcade,vbplaza,casino and many more) which i thought was unnecessary which was installed months back when it was vb 3.6 .after uninstalling when i opened the forum i got the database error.....
 
You have residue calls from ibproarcade that are being called in the code. Unfortunately, you deleted the database tables for it. See if you can find that query in your index.php file and comment it out or delete it. You probably has a shitload more that you need to resolve if you just deleted stuff.
 
- Check your plugin list and make sure none are there that are not suppost to be.
- Make sure all files relevent to uninstalled mods are not still in your directory.
 
i cant find anything related to ibproarcade in index.php ,
i did 1 thing i uploaded ibproarcade product file again and now the problem is solved but if i remove ibproarcade database error is coming....
 
Well easy way = just leave arcade installed and just dont have any linking to it.
Medium way = read instructions exactly on ibproarcade for removing/uninstalling arcade.
Harder way = disect your phpmyadmin for the ipbarcade tables and delete them.
 
Hoxxy said:
- Check your plugin list and make sure none are there that are not suppost to be.
- Make sure all files relevent to uninstalled mods are not still in your directory.
Click to expand...

there is no plugin installed for ibProArcade... but there is one product 'vBCredits with ibProArcade' which when i tried to uninstall is showing database error....

I re-uploaded the ibProArcade product again then the database error is not showing...
so if there is no other way i will keep ibProArcade product installed which i think is better...
 
tropickz said:
Well easy way = just leave arcade installed and just dont have any linking to it.
Medium way = read instructions exactly on ibproarcade for removing/uninstalling arcade.
Harder way = disect your phpmyadmin for the ipbarcade tables and delete them.
Click to expand...

:) ...

1st method is better and i decided to adopt that...
 
You must log in or register to reply here.
Back
Top