H E L P !

[semaXD]

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!!!

[Boofo]

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

[semaXD]

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

[Boofo]

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

[semaXD]

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

--------------- Added 1203116946 at 1203116946 ---------------

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

[Guest210212002]

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.

[semaXD]

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

[Boofo]

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.

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

[Guest210212002]

Boofo is wiser than I.

[semaXD]

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

[Boofo]

No, sir, just been there, done that, too many times, I'm afraid.

--------------- Added 15 Feb 2008 at 17:44 ---------------

Did you re-install the xml in the Product manager and allow overwrite?

[semaXD]

ok got it thanks guys for the help just had to walk away and switch a few things around in the tables back in action!!

[Boofo]

Glad to hear it. What did you have to do?

[cheesegrits]

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

I'm pretty sure re-installing with allow overwrite doesn't rerun the install code, so it won't recreate missing tables

-- hugh

[Boofo]

Are you sure? I thought it did.

[semaXD]

i did exactly what you and chris said reinstalled it the added the tables back empty, i had to add a second column and then it populated I did ther removal in the cp and bada bing bada boom we are back in action!!

thanks again for your quick help on this you guys rock!!:D

[Boofo]

Great! Now you know what to do if you ever run into the same kind of problem again. Ain't it fun to learn? ;)

Did re-installing the hack add back the table or did you have to do that manually?

[semaXD]

To be honest i didnt check it was up, so i got a bottle of wine and called it a week~~

--------------- Added 1203146168 at 1203146168 ---------------

oh wait do you mean b4 it came back up? yea we did it manually then got the wine

[Boofo]

Wine seems to help with a lot on vbulletin errors I have found out. Beer is another good error fixer. ;)

[cheesegrits]

Are you sure? I thought it did.

Nope. From the ACP plugin.php code:

// Run if: code version is * (meaning always run), no version
// previously installed, or if the code is for a newer version
// than is currently installed
if ($code['version'] == '*' OR $installed_version === null OR is_newer_version($code['version'], $installed_version))
{
eval($code['installcode']);
}

It only runs install code on first install, or if you are installing a newer version (and then it only runs the new version's code).

Re-running the current version code on an update would be a bit disasterous for all those install codes that start out with "drop table if exists".

-- hugh

[Boofo]

You're right, I'm wrong. I digress.

[Guest210212002]

Wine seems to help with a lot on vbulletin errors I have found out. Beer is another good error fixer. ;)

Beer is the BEST error fixer. And causer, coincidentally. :D

[Boofo]

That would be considered "cause and effect", I suppose. The only thing I know for sure is with beer, the errors don't mean a thing. The more errors the better as that means more beer.