vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/forumdisplay.php?f=105)
-   -   warning options not saving after install? DB problem? (https://vborg.vbsupport.ru/showthread.php?t=82065)

heynurse 05-26-2005 02:26 PM

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:
Quote:

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 :rolleyes: )
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 05-26-2005 06:56 PM

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

heynurse 05-26-2005 07:49 PM

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

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 05-27-2005 05:13 AM

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 05-27-2005 07:38 AM

Hi John,

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

sv1cec 05-27-2005 07:58 AM

Just let me know.

Rgds


All times are GMT. The time now is 01:04 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01039 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete