Thread: Major Additions - Forum Tournaments & Ladders
View Single Post
  #1090  
Old 11-26-2008, 08:46 PM
dirtyfeast dirtyfeast is offline
 
Join Date: May 2008
Posts: 26
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by dirtyfeast View Post
Code:
Database error in vBulletin 3.7.4:

Invalid SQL:
UPDATE tmnt_ladder_games SET accepted = -1, finished = 1 WHERE id=3 AND agree_u = 0, agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1);

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 ' agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1)' at line 1
Error Number  : 1064
Request Date  : Monday, November 24th 2008 @ 09:04:15 PM
Error Date    : Monday, November 24th 2008 @ 09:04:16 PM
Script        : http://www.com/forum/competitions.php?do=ladderteamreject&id=3
Referrer      : http://www.com/forum/competitions.php?do=ladderteamchallenges
IP Address    : ************
Username      : **********
Classname     : vB_Database
MySQL Version : 5.0.51a-community
Just installed, went smooth. Made test ladder, made a challange, accepts challange great. I get this error when I reject challange. Anyone know what is causing this. Installed latest mod from first post. No other issues are known at this time.
I want to add that this is with the Teams for the ladders. It works fine with just members of the forum joing the Player ladders. Could this issue be caused because you create a team name rather using the username of the forums.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01096 seconds
  • Memory Usage 1,768KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete