Settings not saving.

Hello, I just installed this hack and after installation I did the settings and it saves everything ok, but when I go back into the settings, all settings disappear! it makes all the typed settings to empty field and all the yes/no to NO. I read previous thread on this page about not saving, and did the same thing but didn't work.
When i run the mysql query:

SELECT * FROM setting WHERE varname like 'warn_%';
DESCRIBE warnings

I get:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
DESCRIBE warnings' at line 1

FIXED! SORRY, I DIN'T KNOW AFTER RUNNING THE INSTALL_SETTINGS.PHP SCRIPT, YOU HAD TO RE-SETUP. I EXPECTED THE SETTINGS THAT I PREVIOUSLY DID TO MAGICALLY APPEAR! ><;

[sv1cec]

Glad you figured it out.

Rgds

[King Kovifor]

I'm having the same problem... So what do I have to get Myth to do?

Edit: He thinks he knows what he did wrong.

[Mythotical]

Ok I have reinstalled twice, double checked file edits, templates and all but we are having the same problem.

King Kovifor can't even figure it out.

Any help much appreciated.

[sv1cec]

Do the new settings exist? Try running this query:

PHP Code:

SELECT * FROM setting WHERE varname like 'warn_%' 


And let me know.

[King Kovifor]

I would do that but I have absolutely no idea how to do querys or what they are. I mostly do template work but went into simple PHP stuff.

[sv1cec]

Easy, open your admincp and scroll down until you find a section entitled "Import & Maintenance", then open that and you will see Execute SQL Query. Click on that, and in the "Manual Query" box, paste the query I told you to run.

Rgds

[DS MrSinister]

I am having the same problem..

I have tried the query above. Did not work. Unless i added prefix. Still not saving my settings.

any other ideas?

[sv1cec]

Run this query:

PHP Code:

 SELECT * FROM ". TABLE_PREFIX ."setting WHERE varname like 'warn_%' 


Replace ".TABLE_PREFIX ." in that line above with whatever table prefix you are using in your site. If the query returns nothing, point your browser to the following URL:

http://www.yourdomainname.com/adminc...ll_setting.php

and follow the instructions.

Rgds

[DS MrSinister]

I got it to work...

thanks

now i have to fix my postbit_legacy problem i will figure that out later..