H E L P !

[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

[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]

Originally Posted by Boofo

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

[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 [DATE]1203146168[/DATE] at [TIME]1203146168[/TIME] ---------------

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]

Originally Posted by Boofo

Are you sure? I thought it did.

Nope. From the ACP plugin.php code:

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