Thread: Edit Bug
View Single Post
  #4  
Old 05-01-2006, 01:17 AM
The Notorious's Avatar
The Notorious The Notorious is offline
 
Join Date: Jan 2006
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the reply.

I just checked and I don't think it's cuz of a ` in their username.
Error:

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

                       UPDATE user
                       SET
                               `vbbux` = `vbbux` + .abc, vbp_history = 'a:38:{i:0;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143696390;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:2:\"14\";s:12:\"fromusername\";s:12:\"Str8FromTheD\";s:6:\"reason\";s:79:\"Thief attempt was unsuccessful from <a href=\"member.php?u=14\">Str8FromTheD</a>.\";}i:1;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143697521;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:3:\"908\";s:12:\"fromusername\";s:7:\"kal_S23\";s:6:\"reason\";s:75:\"Thief attempt was unsuccessful from <a href=\"member.php?u=908\">kal_S23</a>.\";}i:2;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:1:\"5\";s:8:\"dateline\";i:1143734523;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:3:\"436\";s:10:\"tousername\";s:6:\"broham\";s:6:\"reason\";s:33:\"ill give u 5 for every soundscan \";}i:3;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:1:\"5\";s:8:\"dateline\";i:1143735122;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"2779\";s:10:\"tousername\";s:7:\"sure_wp\";s:6:\"reason\";s:76:\"Thief attempt was unsuccessful from <a href=\"member.php?u=2779\">sure_wp</a>.\";}i:4;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143736379;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:3:\"436\";s:10:\"tousername\";s:6:\"broham\";s:6:\"reason\";s:13:\"cuz ur awsome\";}i:5;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"50\";s:8:\"dateline\";i:1143743968;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7941\";s:12:\"fromusername\";s:4:\"mebe\";s:6:\"reason\";s:73:\"Thief attempt was unsuccessful from <a href=\"member.php?u=7941\">mebe</a>.\";}i:6;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:5:\"25.00\";s:8:\"dateline\";i:1143744106;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7941\";s:12:\"fromusername\";s:4:\"mebe\";s:6:\"reason\";s:73:\"Thief attempt was unsuccessful from <a href=\"member.php?u=7941\">mebe</a>.\";}i:7;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143746063;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"5371\";s:10:\"tousername\";s:3:\"MSC\";s:6:\"reason\";s:72:\"Thief attempt was unsuccessful from <a href=\"member.php?u=5371\">MSC</a>.\";}i:8;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1143839050;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"4892\";s:12:\"fromusername\";s:5:\"Quike\";s:6:\"reason\";s:17:\"keep it up mayne!\";}i:9;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:2:\"20\";s:8:\"dateline\";i:1143859603;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"2415\";s:12:\"fromusername\";s:8:\"DJ Spyda\";s:6:\"reason\";s:16:\"Cause You Got 1k\";}i:10;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:1:\"5\";s:8:\"dateline\";i:1143918153;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:3:\"182\";s:10:\"tousername\";s:5:\"Rayne\";s:6:\"reason\";s:4:\"News\";}i:11;a:4:{s:6:\"itemid\";s:2:\"14\";s:9:\"finalcost\";d:1063.47499999999990905052982270717620849609375;s:8:\"dateline\";i:1143919792;s:7:\"expires\";s:1:\"0\";}i:14;a:4:{s:6:\"itemid\";s:1:\"2\";s:9:\"finalcost\";d:209.604999999999989768184605054557323455810546875;s:8:\"dateline\";i:1143920206;s:7:\"expires\";s:1:\"0\";}i:15;a:4:{s:6:\"itemid\";s:1:\"4\";s:9:\"finalcost\";d:209.604999999999989768184605054557323455810546875;s:8:\"dateline\";i:1143920249;s:7:\"expires\";s:1:\"0\";}i:16;a:4:{s:6:\"itemid\";s:1:\"8\";s:9:\"finalcost\";d:209.604999999999989768184605054557323455810546875;s:8:\"dateline\";i:1143920311;s:7:\"expires\";s:1:\"0\";}i:17;a:4:{s:6:\"itemid\";s:2:\"10\";s:9:\"finalcost\";d:209.604999999999989768184605054557323455810546875;s:8:\"dateline\";i:1143920318;s:7:\"expires\";s:1:\"0\";}i:18;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:2:\"10\";s:8:\"dateline\";i:1143997231;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"4322\";s:12:\"fromusername\";s:5:\"joe86\";s:6:\"reason\";s:74:\"Thief attempt was unsuccessful from <a href=\"member.php?u=4322\">joe86</a>.\";}i:19;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1144110854;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6725\";s:12:\"fromusername\";s:10:\"Trackfresh\";s:6:\"reason\";s:79:\"Thief attempt was unsuccessful from <a href=\"member.php?u=6725\">Trackfresh</a>.\";}i:20;a:4:{s:6:\"itemid\";s:2:\"30\";s:9:\"finalcost\";d:5497.625;s:8:\"dateline\";i:1144338970;s:7:\"expires\";s:1:\"0\";}i:21;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:5:\"30.55\";s:8:\"dateline\";i:1144525593;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7598\";s:12:\"fromusername\";s:5:\"dirty\";s:6:\"reason\";s:5:\"propz\";}i:22;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1144711578;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"1403\";s:12:\"fromusername\";s:8:\"creepsor\";}i:23;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"250\";s:8:\"dateline\";i:1144711682;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"1403\";s:10:\"tousername\";s:8:\"creepsor\";s:6:\"reason\";s:47:\"4 bein so kind as to give me 200 u get rewarded\";}i:24;a:6:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1144712210;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"1689\";s:12:\"fromusername\";s:7:\"rehmann\";}i:25;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1144712633;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6169\";s:12:\"fromusername\";s:6:\"Krazye\";s:6:\"reason\";s:20:\"congratz on 5th logo\";}i:26;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1144946621;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"8614\";s:12:\"fromusername\";s:6:\"VBMisc\";s:6:\"reason\";s:10:\"Props mann\";}i:27;a:4:{s:6:\"itemid\";s:2:\"14\";s:9:\"finalcost\";d:1063.47499999999990905052982270717620849609375;s:8:\"dateline\";i:1144951587;s:7:\"expires\";s:1:\"0\";}i:28;a:4:{s:6:\"itemid\";s:1:\"5\";s:9:\"finalcost\";d:419.20999999999997953636921010911464691162109375;s:8:\"dateline\";i:1144951654;s:7:\"expires\";s:1:\"0\";}i:29;a:4:{s:6:\"itemid\";s:2:\"11\";s:9:\"finalcost\";d:419.20999999999997953636921010911464691162109375;s:8:\"dateline\";i:1144951699;s:7:\"expires\";s:1:\"0\";}i:30;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"500\";s:8:\"dateline\";i:1144982122;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"1403\";s:12:\"fromusername\";s:8:\"creepsor\";s:6:\"reason\";s:8:\"congratz\";}i:31;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1144982589;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"7676\";s:12:\"fromusername\";s:8:\"lildevil\";s:6:\"reason\";s:13:\"logo props!!!\";}i:32;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"400\";s:8:\"dateline\";i:1144983005;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:3:\"932\";s:12:\"fromusername\";s:16:\"Bi$hoP.of.MurdaH\";s:6:\"reason\";s:8:\"congratz\";}i:33;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"300\";s:8:\"dateline\";i:1144983161;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"4830\";s:12:\"fromusername\";s:17:\"OuttaMyFuccinMind\";s:6:\"reason\";s:8:\"congratz\";}i:34;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"200\";s:8:\"dateline\";i:1145040282;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6169\";s:12:\"fromusername\";s:6:\"Krazye\";s:6:\"reason\";s:8:\"congratz\";}i:35;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:3:\"100\";s:8:\"dateline\";i:1145043686;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"3156\";s:12:\"fromusername\";s:11:\"nevertakeaL\";s:6:\"reason\";s:35:\"Props on the sixth gfather logo man\";}i:36;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";d:150;s:8:\"dateline\";i:1145044376;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"1403\";s:10:\"tousername\";s:8:\"creepsor\";s:6:\"reason\";s:8:\"1k Posts\";}i:37;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";d:100;s:8:\"dateline\";i:1145461841;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:3:\"436\";s:10:\"tousername\";s:6:\"broham\";s:6:\"reason\";s:9:\"Soundscan\";}i:38;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";d:0;s:8:\"dateline\";i:1145733038;s:7:\"expires\";s:1:\"0\";s:8:\"touserid\";s:4:\"6560\";s:10:\"tousername\";s:5:\"Jakkc\";s:6:\"reason\";s:8:\"I <3 You\";}i:39;a:7:{s:6:\"itemid\";s:1:\"7\";s:9:\"finalcost\";s:4:\".abc\";s:8:\"dateline\";i:1145740275;s:7:\"expires\";s:1:\"0\";s:10:\"fromuserid\";s:4:\"6560\";s:12:\"fromusername\";s:5:\"Jakkc\";s:6:\"reason\";s:2:\":D\";}}'
                       WHERE userid = '3316';

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 ' vbp_history = 'a:38:{i:0;a:7:{s:6:\"itemid\";s:2:\"16\";s:9:\"
Error Number : 1064
Date         : Saturday, April 22nd 2006 @ 04:11:15 PM
Username     : Jakkc
Classname    : vb_database
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01166 seconds
  • Memory Usage 1,839KB
  • 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