H E L P !
 

HELP!!
I installed sponsor it 2.0 it was not working so i removed the sponsorit components from my forum. I backed up the two tables 'sponsors, sponsor_settings' then i dropped the two tables. now my forum doesn?t work at all!! and I can not access the adminCP either.
i tried to upload the tables but apparently they are corrupt. is there some thing else I can do to get in!!

here is the error I get.
Database error
The Girlfriends Films Forums database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the girlfriendsfilms.com home page, then try to open another page.
Click the Back button to try another link.

The girlfriendsfilms.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologize for any inconvenience.
-------------------------------------------------------------------------------------------
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT set_value, varname
FROM sponsor_settings
WHERE varname IN ('sponsor_active', 'sponsor_title', 'sponsor_message', 'sponsor_position', 'sponsor_columns', 'sponsor_redirect', 'sponsor_file', 'sponsor_imgpath');

MySQL Error : Table 'lesbianforum.sponsor_settings' doesn't exist
Error Number : 1146
Date : Friday, February 15th 2008 @ 02:16:34 PM
Script : http://girlfriendsfilms.com/forum/index.php
Referrer :
IP Address : 75.3.224.70
Username : GFadmin
Classname : vb_database


um help!!!

Did you uninstall the xml file? The hack is still trying to run.

yea i took all the files out ,the includes, admin cp and xml

and now i get this
Warning: Unknown(/var/www/html/forum/includes/functions_sponsorit.php): failed to open stream: No such file or directory in /global.php(360) : eval()'d code on line 1

Fatal error: (null)(): Failed opening required '/var/www/html/forum/includes/functions_sponsorit.php' (include_path='.:/php/includes:/usr/share/php') in /var/www/html/forum/global.php(360) : eval()'d code on line 1

You also need to uninstall the xml in the Product Manager.

I had already got the 2 in the includes/xml/ folder is that what you mean

--------------- Added [DATE]1203116946[/DATE] at [TIME]1203116946[/TIME] ---------------

should i re- upload the global.php from the archive folder

In the product manager itself, you actually need to remove the product through the AdminCP, not just delete the files. When you uninstall it, it executes the uninstall code that does the appropriate DB modifications and stops your forum from looking for those tables.

First, put the files back.

Then, ACP -> Plugins and Products -> Product Manager. Find the product in the list, and pick Uninstall from the dropdown on the right.

Unfortunately, since you dropped the tables the product uninstaller might die on you since it will still be looking for them. You MIGHT be able to just create two new blank tables with the same names to get the uninstaller to cycle through, but get a second opinion on that.

thanks chris i will upload the files and try that. at this point i cnat get to the admin cp this forum gets busy on th eweekend so now im stressed l:erm:ol

She could also re-install the product and allow overwrite so the tables would be there. And then uninstall it properly.

Boofo is wiser than I.

install what the "sponsor it" stuff i uploaded it and it gave me

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT set_value, varname
FROM sponsor_settings
WHERE varname IN ('sponsor_active', 'sponsor_title', 'sponsor_message', 'sponsor_position', 'sponsor_columns', 'sponsor_redirect', 'sponsor_file', 'sponsor_imgpath');

MySQL Error : Unknown column 'set_value' in 'field list'
Error Number : 1054
Date : Friday, February 15th 2008 @ 03:38:48 PM
Script : http://girlfriendsfilms.com/forum/login.php?do=login
Referrer : http://girlfriendsfilms.com/forum/admincp/index.php
IP Address : 71.156.44.190
Username : GFadmin
Classname : vb_database