Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > Advanced Warning System (AWS)
Reload this Page Warn user - SQL Error.
FAQ Members List Calendar Search Today's Posts Mark Forums Read
Warn user - SQL Error. Details »»
Warn user - SQL Error.
Version: , by GoranTornqvist GoranTornqvist is offline
Developer Last Online: Feb 2005 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 02-03-2005 Last Update: Never Installs: 0
 
No support by the author.

Hello, when warning a member, this error came up.
Looks like warning_bans value is empty, any ideas what to check for?

.................................................. ...........................
Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 8,
displaygroupid = 8,
warnings=3,
warning_level=4,
warning_bans = ,
usertitle = 'Temporarily Banned'
WHERE userid = 162

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 '
usertitle = 'Temporarily Banned'
WHERE userid = 162'

mysql error number: 1064

Date: Thursday 03rd of February 2005 03:04:08 PM
Script: http://xxx/Warn.php
Referer: http://xxx/Warn.php?do=WarnUser&id=162&post=1234
Username: xxx
IP Address: xxx

Show Your Support

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

Comments
  #2  
Old 02-03-2005, 02:58 PM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by GoranTornqvist
Hello, when warning a member, this error came up.
Looks like warning_bans value is empty, any ideas what to check for?

.................................................. ...........................
Database error in vBulletin 3.0.6:

Invalid SQL:
UPDATE user SET
usergroupid = 8,
displaygroupid = 8,
warnings=3,
warning_level=4,
warning_bans = ,
usertitle = 'Temporarily Banned'
WHERE userid = 162

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 '
usertitle = 'Temporarily Banned'
WHERE userid = 162'

mysql error number: 1064

Date: Thursday 03rd of February 2005 03:04:08 PM
Script: http://xxx/Warn.php
Referer: http://xxx/Warn.php?do=WarnUser&id=162&post=1234
Username: xxx
IP Address: xxx
What version are you running? If different from the latest, please download the latest and upgrade.

Rgds
  #3  
Old 02-04-2005, 12:22 PM
GoranTornqvist GoranTornqvist is offline
 
Join Date: Jan 2005
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Running:
WarningSystem_V3_1_2

Ok...there's a 3.1.5 now...
Is it easy to upgrade, does it take a long time?
  #4  
Old 02-04-2005, 12:49 PM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by GoranTornqvist
Running:
WarningSystem_V3_1_2

Ok...there's a 3.1.5 now...
Is it easy to upgrade, does it take a long time?
Nope, try upgrading and see if the error persists.

Rgds
Closed Thread

« Previous Thread | Next Thread »
Thread Tools

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 09:17 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04245 seconds
  • Memory Usage 2,220KB
  • Queries Executed 17 (?)
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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (4)postbit_onlinestatus
  • (4)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_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