Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > Advanced Warning System (AWS)
FAQ Community Calendar Today's Posts Search

Closed Thread
 
Thread Tools
Uninstalled v3.20 and fresh installed v3.3.0 Details »»
Uninstalled v3.20 and fresh installed v3.3.0
Version: , by Blam Forumz Blam Forumz is offline
Developer Last Online: May 2016 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 03-19-2005 Last Update: Never Installs: 0
 
No support by the author.

And now for some reason everything I change in my warning options doesnt change, it says "Your AWS Options have been updated." but then nothing else happens, also when I Try to warn someone I get this error:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: 
				UPDATE user SET
				usergroupid = ,
				displaygroupid = ,
				warnings=2,
				warning_bans = 1,
				usertitle = 'Temporarily Banned'
				WHERE userid = 283
			
mysql error: 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 '
				displaygroupid = ,
				warnings=2,
				warning_bans = 1,
	

mysql error number: 1064

Please help =-/

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 03-19-2005, 06:08 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Blam Forumz
And now for some reason everything I change in my warning options doesnt change, it says "Your AWS Options have been updated." but then nothing else happens, also when I Try to warn someone I get this error:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: 
				UPDATE user SET
				usergroupid = ,
				displaygroupid = ,
				warnings=2,
				warning_bans = 1,
				usertitle = 'Temporarily Banned'
				WHERE userid = 283
			
mysql error: 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 '
				displaygroupid = ,
				warnings=2,
				warning_bans = 1,
	

mysql error number: 1064

Please help =-/
Try downloading the zip file again, and upload the file warn_install_setting.php and admin_warn.php to your admincp directory.

As for your database error, that shouldn't appear when you try to warn someone, is it possible that it appears when you try to warn someone and with this warning the user is banned?

In any case, please make sure you have uploaded the file includes/functions_warning.php to your server.

Rgds


Rgds
  #3  
Old 03-19-2005, 06:15 AM
Blam Forumz Blam Forumz is offline
 
Join Date: Jun 2004
Posts: 554
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks alot All my errors have been solved ^_^
  #4  
Old 03-19-2005, 06:34 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Blam Forumz
Thanks alot All my errors have been solved ^_^
Glad if I could help.

Rgds
  #5  
Old 03-19-2005, 12:07 PM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Blam Forumz
And now for some reason everything I change in my warning options doesnt change, it says "Your AWS Options have been updated." but then nothing else happens, also when I Try to warn someone I get this error:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: 
				UPDATE user SET
				usergroupid = ,
				displaygroupid = ,
				warnings=2,
				warning_bans = 1,
				usertitle = 'Temporarily Banned'
				WHERE userid = 283
			
mysql error: 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 '
				displaygroupid = ,
				warnings=2,
				warning_bans = 1,
	

mysql error number: 1064

Please help =-/

also you are terribly out of date vbulletin 3.0.3 is full of security holes ....
  #6  
Old 03-19-2005, 12:38 PM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Delphiprogrammi
also you are terribly out of date vbulletin 3.0.3 is full of security holes ....
He might have used the patches Delphi, not everyone is willing to go through the upgrade hassle every time a new version is out.

Rgds
Closed Thread


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:25 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.03815 seconds
  • Memory Usage 2,249KB
  • Queries Executed 21 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (5)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete