Thread: Add-On Releases - gXboxLive - Xbox Live Leaderboard
View Single Post
  #129  
Old 03-30-2007, 03:15 PM
Ronin Storm Ronin Storm is offline
 
Join Date: Nov 2005
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looks like this class of error has been reported before. Just like to indicate that it's still turning up:

(some data cleaned up as it doesn't seem relevant... can provide entire error via PM on request)

Code:
Database error in vBulletin 3.6.5:

Invalid SQL:
REPLACE INTO gxboxlive SET 
				userid = '77',
				gamertag = '[...SNIP...]',
				avatar = 'http://tiles.xbox.com/tiles/fr/8+/1mdsb2JhbC9FCgUABh4AGANYL3RpbGUvMC8yODAwMQAAAAAAAAD5Eb9e.jpg" alt="Street Fighter II' HF',
				score = '5653',
				reputation = '20',
				zone = 'Recreation',
				[...SNIP...]

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 'HF',
				score = '5653',
				reputation = '20',
				zone = 'Recreation',
				las' at line 4
Error Number : 1064
[...SNIP...]
Classname    : vb_database
I suspect the issue is in the avatar line, and to do with the apostrophe after "Street Fighter II", exactly as the apostrophe after "Texas Hold" (i.e. "Street Fighter II' HF" and "Texas Hold'Em").

I'm using gXboxLive v1.34 on vB3.6.5.

Let me know if I can provide any more information.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01167 seconds
  • Memory Usage 1,764KB
  • 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)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