vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/forumdisplay.php?f=105)
-   -   Not updating Changes in AdminCp? (https://vborg.vbsupport.ru/showthread.php?t=94710)

slim cutty 08-20-2005 05:09 PM
Not updating Changes in AdminCp?
 
I re-installed this hack after upgrading to 3.0.8, it worked fine on 3.0.7, I doubt that is the problem...

at anyrate, I have the latest version of the hack 3.4.15 I did all the file edits and ran install_warn.php as described in the instructions.

When I try to edit options in admincp and click update my changes aren't being updated. It Reads "Your AWS Options have been updated" however, The options remain to say no for everything and blank.

could this be a database issue?


EDITED*

Okay.. problem solved... lol
I didn't run the settings...sorry for this post.. this is the most tedious hack to install, but by far a great hack I love it.. thanks for all the support here to the creator.

Okay I fixed that issue.. but I am now getting this sql error when updating a user....

Code:
Database error in vBulletin 3.0.8:

Invalid SQL: UPDATE user SET

mysql error: Unknown column 'alerts' in 'field list'

mysql error number: 1054
I originally thought that the error was in user.php.. but it's not... shortly after I had the same error above for the 'warnings' table also
I uninstalled/re-installed twice but still the same error

For some odd reason the uninstaller is leaving behind remnants of the hack.. I still see templates in the template area that can't be reverted... when I uninstall warn_notes seems to still remain there? I need help majorly... thanks

sv1cec 08-21-2005 05:21 AM
OK, first calm down and give me proper details of your errors. The one you send me above, doesn't even contain the script that caused the error. The uninstaller may leave things behind, I do not pay too much attention to it, I do update it from time to time, but it is possible that some things slip by.

Give me details of your errors, the complete error messages.

slim cutty 08-21-2005 11:15 AM
lol ahahaahha I'm sorry man, I love this hack and never had problems with it before except the redirect which you helped me fix....

well, here's the deal, on "view warned users" in admincp... I get this error

HTML Code:
Database error in vBulletin 3.0.8:

Invalid SQL: SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0
mysql error: Unknown column 'warnings' in 'where clause'

mysql error number: 1054

Date: Sunday 21st of August 2005 08:09:21 AM
Script: http://66.49.132.220/sacred/admincp/admin_warn.php?act=viewwarnedusers
Referer: http://66.49.132.220/sacred/admincp/index.php?do=nav
On "warings per warner" I get this error

HTML Code:
Database error in vBulletin 3.0.8:

Invalid SQL: select wt.userid, wt.username, wt.usergroupid  from
        user wt WHERE usergroupid =  OR usergroupid =  OR usergroupid =  ORDER BY userid
mysql error: You have an error in your SQL syntax near 'OR usergroupid =  OR usergroupid =  ORDER BY userid' at line 2

mysql error number: 1064

Date: Sunday 21st of August 2005 08:10:57 AM
Script: http://66.49.132.220/sacred/admincp/admin_warn.php?act=viewstats2
Referer: http://66.49.132.220/sacred/admincp/index.php?do=nav
and on "warnings per user" I get this which is relatively the same issue

HTML Code:
Database error in vBulletin 3.0.8:

Invalid SQL: SELECT COUNT(*) AS users FROM user AS user where warnings>0 OR alerts>0
mysql error: Unknown column 'warnings' in 'where clause'

mysql error number: 1054

Date: Sunday 21st of August 2005 08:12:17 AM
Script: http://66.49.132.220/sacred/admincp/admin_warn.php?act=viewwarnedusers
Referer: http://66.49.132.220/sacred/admincp/index.php?do=nav
I guess the installer isn't putting some things in, I re-uped my board with my backups yet, the hack still will not install right for some reason....those are the errors... I don't know exactly what you mean as far as scripts? But I'll look at the uninstaller and see what it inserts into the database and try to drop them, I guess I'll wait for you to answer this an I'll come back to it.

sv1cec 08-21-2005 12:25 PM
Your first error is most probably due to the warnings column not being created in the user table. Add it manually, running this query:

Code:
ALTER TABLE `".TABLE_PREFIX."user` add `warnings` int(5) default '0'
As for your second issue, have you set up your Warning Options properly, as far as the admin/mod/smod user groups?

You must first define your options, before you can run the program.

slim cutty 08-21-2005 12:28 PM
wow... I just unistalled it completely lol, I'll try this... but there is still the first problem...

When I update the user, I get the error where it doesn't recognize the "alert column" in fieldset... that was the initial problem...

EDITED*

Okay looking at the installer, I guess that I add this...

HTML Code:
ALTER TABLE `".TABLE_PREFIX."user` add `alerts` int(5) default '0'
I'll come back to this if this works thanks a bunch man

sv1cec 08-21-2005 01:03 PM
Pls do! It should work fine.

slim cutty 08-21-2005 01:32 PM
I got this error in sql...

HTML Code:
#1103 - Incorrect table name '".TABLE_PREFIX."user'
I don't have table pre-fixes... is there a way to run this without getting this error? I think this is why it was causing so much trouble...lol I would try to do this myself but I don't want to add or delete the wrong thing

sv1cec 08-21-2005 01:55 PM
Run the query like this:

Code:
ALTER TABLE `user` add `alerts` int(5) default '0'

slim cutty 08-21-2005 02:26 PM
John! I Love You Man! lol ahahahahah

That did it

For some reason, the installer skipped? I just went through and manually added the rest of what was missing thanks man... you were a big help

sv1cec 08-21-2005 02:28 PM
That's wierd, the installer skipped some columns and added others?

slim cutty 08-21-2005 03:35 PM
Yep, I was trying to figure that out myself...

It could be on my end though... I need to upgrade my phpadmin, however, my hosts is not allowing a change anytime soon, even thought I doubt that was what effected this...

I did notice a few other posts here that had the same issue with a table or two but they never responded back... oh well, all is well finally I wish I had had this kind of support for another hack that destroyed my last bulletin board..lol

GREAT Hack!

sv1cec 08-24-2005 06:00 PM
Thanks for the nice words. Glad you have it solved.


All times are GMT. The time now is 10:50 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.01064 seconds
  • Memory Usage 1,742KB
  • 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
  • (3)bbcode_code_printable
  • (5)bbcode_html_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (12)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