| KURTZ |
06-28-2010 09:32 AM |
found an issue when i tried to update the point by the ACP:)
PHP Code:
Database error in vBulletin 4.0.4:
Invalid SQL:
UPDATE xperience_stats
SET
points_xperience=13724,
points_thread=5466.16,
points_threads=778,
points_threads_sg=118,
points_thread_votes=780,
points_thread_replycount=605.1,
points_thread_views=3077.56,
points_thread_stickies=100,
points_thread_tags=7.5,
points_thread_rate=0,
points_post=5326.4,
points_posts=2700,
points_posts_sg=2100,
points_post_attachment=522.5,
points_post_attachment_views=3.9,
points_post_avg=1.66883887087,
points_user_activity=100,
points_user_activity30=100,
points_user_activity7=60,
points_user=2932.39136574,
points_user_profile=30,
points_user_infractions=0,
points_user_law=15,
points_user_reputation=0,
points_user_reputation_use=0,
points_user_online=1617.89136574,
points_user_socialgroup=35,
points_user_friends=18,
points_user_visitormessages=25.5,
points_user_albumpictures=816,
points_user_referrals=375,
points_misc=0,
points_shop=,
points_misc_ldm=0,
points_misc_dl2=0,
points_misc_ppd=0,
points_misc_vbblog=0,
points_misc_vbcms=0,
points_misc_custom=0,
points_misc_events=0,
promoted=0,
dateline=1277721060
WHERE userid=2;
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 @ 05:31:47 AM
Error Date : Monday, June 28th 2010 @ 05:31:47 AM
Script : http://www.xxxx.it/xxx/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer : http://www.xxxx.it/xxx/admincp/xperience_admin.php?do=recount
IP Address : xxxxx
Username : KURTZ
Classname : vB_Database
MySQL Version : 5.0.91
|
More Information