warning options not saving after install? DB problem?

Hi I just installed this hack, everything seemed to go fine, except the first time I ran the installation when it was modifying the DB, it took several minutes (I'm not sure if that is normal) But it did finally give me a succussful message.

After was done installing, I went to set my warning options etc... I set them, clicked save, then I got a screen saying that it was all saved, but it didn't save any of my options?? I go back into the options, and they are all the default settings and none of the choices I made were saved?

I think that somehow, the database tables were not installed properly??

Also in the install instructions, it said:

Follow the steps in that script. This will create the necessary setting entries, used in the hack.
At this point, you might want to verify that everything was done as scheduled. To check this, run the following queries (remember to change them accordingly, if you are using a table prefix):
SELECT * FROM `" . TABLE_PREFIX . "setting` WHERE varname like 'warn_%'
This should show you a couple of pages of settings, their names should all start with the words "warn_".
DESCRIBE `" . TABLE_PREFIX . "warnings`
You should see the contents of the table warnings.
If those two queries show you the proper results, it should be OK to proceed to the next steps.

I don't have any table prefix, so what kind of query should I run? (sorry, I'm not that familiar with SQL queries )
Or if anyone has suggestions of what I could do to get this up and running, that would be great as well.

This looks like a wonderful hack, and I'm excited to get it up and running

Thanks!

[Marco van Herwaarden]

[sql]SELECT * FROM setting WHERE varname like 'warn_%';
DESCRIBE warnings;[/sql]
These 2.

[heynurse]

Thanks for the query, I ran that and the results said:

Your SQL-query has been executed successfully
SELECT *
FROM setting
WHERE varname
LIKE 'warn_%';# MySQL returned an empty result set (i.e. zero rows).
DESCRIBE warnings;# Rows: 11

I'm not really sure what that means? But my best guess is that the database settings did not get set up correctly with the script.

What would be my next step to get this up and running properly? Thanks

[sv1cec]

Try running the warn_install_setting.php again. Point your browser to it, select add settings and go.

Let me know if it worked for you.

[heynurse]

Hi John,

Thanks for your help, I belive that took care of it, I'll let you know if I have any problems.

[sv1cec]

Just let me know.

Rgds