[Crrrazzzy]

i am getting the same error

Originally Posted by adigaorg

i have error in new version

the Update Experience points is not working and i have this error

Database error in vBulletin 4.0.4:

Invalid SQL:
UPDATE xperience_stats 
		SET
		points_xperience=31429,
		points_thread=8117.893,
		points_threads=1144,
		points_threads_sg=32,
		points_thread_votes=1418.333,
		points_thread_replycount=2367.9,
		points_thread_views=3150.66,
		points_thread_stickies=0,
		points_thread_tags=0,
		points_thread_rate=5,
		points_post=18574,
		points_posts=14398,
		points_posts_sg=3150,
		points_post_attachment=81,
		points_post_attachment_views=0,
		points_post_avg=5.35093297961,
		points_user_activity=0,
		points_user_activity30=0,
		points_user_activity7=0,
		points_user=4476.74571759,
		points_user_profile=100,
		points_user_infractions=0,
		points_user_law=0,
		points_user_reputation=140,
		points_user_reputation_use=710,
		points_user_online=2690.74571759,
		points_user_socialgroup=360,
		points_user_friends=201,
		points_user_visitormessages=132,
		points_user_albumpictures=93,
		points_user_referrals=50,
		points_misc=260.62,
		points_shop=,
		points_misc_ldm=0,
		points_misc_dl2=0,
		points_misc_ppd=0,
		points_misc_vbblog=260.62,
		points_misc_vbcms=0,
		points_misc_custom=0,
		points_misc_events=0, points_post_thanks_used=712,points_post_thanks_got_post=112,points_post_thanks_got_total=121,
		promoted=0,
		dateline=1277696520	
		WHERE userid=317;

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 '
		points_misc_ldm=0,
		points_misc_dl2=0,
		points_misc_ppd=0,
		points_misc_vb' at line 35
Error Number  : 1064
Request Date  : Monday, June 28th 2010 @ 06:42:55 AM
Error Date    : Monday, June 28th 2010 @ 06:43:01 AM
Script        : http://xxxxxxxxxx/forum/x23s2/xperience_admin.php?do=xperience_admin_recount_xp&avgppd=1&startat=201&pp=200
Referrer      : http://xxxxxxxxxx/forum/admincp/xperience_admin.php?do=xperience_admin_recount_xp
IP Address    : cccccccccc
Username      : cccccccccc
Classname     : vB_Database
MySQL Version : 5.0.90-community