Not updating Changes in AdminCp?

[slim cutty]

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

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]

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]

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

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

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

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]

Your first error is most probably due to the warnings column not being created in the user table. Add it manually, running this query:


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]

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

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]

Pls do! It should work fine.

[slim cutty]

I got this error in sql...

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

Run the query like this:


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

[slim cutty]

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]

That's wierd, the installer skipped some columns and added others?

[slim cutty]

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]

Thanks for the nice words. Glad you have it solved.