Hi Guys,
I keep getting the following error when i run Update Experience points
it goes to User 130 everytime and the give me this DB error
Code:
Database error in vBulletin 4.0.6:
Invalid SQL:
UPDATE xperience_stats
SET
points_xperience=-4744,points_threads=0,points_thread_votes=0,points_thread_replycount=0,points_thread_views=6,points_thread_stickies=0,points_posts=0,points_post_avg=0,points_post_attachment=0,points_misc_events=0,points_threads_sg=0,points_posts_sg=0,points_post_attachment_views=0,points_user_profile=0,points_post_den=56,points_user_law=0,points_user_infractions=0,points_user_reputation=0,points_user_reputation_use=0,points_user_online=160,points_user_referrals=0,points_misc_custom=0,points_user_socialgroup=0,points_thread_tags=0,points_thread_rate=0,points_user_friends=0,points_user_visitormessages=0,points_user_albumpictures=0,points_misc_ldm=0,points_misc_dl2=0,points_misc_vbblog=0,points_misc_vbcms=0,points_misc_ppd=0,points_misc=0,points_thread=6,points_post=0,points_user=160,points_xperience=-4744,points_shop=0,points_post_scp=-12,points_post_thanks_used=-3,points_post_thanks_got_post=-1,points_post_thanks_got_total=-1,points_misc_ibparcadechamps=-5,points_user_activity=0,points_user_activity30=0,points_user_activity7=0,points_level=1,promoted=0,
dateline=1282309080
WHERE userid=130;
MySQL Error : Unknown column 'points_post_scp' in 'field list'
Error Number : 1054
Request Date : Friday, August 20th 2010 @ 02:56:37 PM
Error Date : Friday, August 20th 2010 @ 02:58:25 PM
Script : http://www.xbox-360.co.za/forum/admi...min_recount_xp
Referrer : http://www.xbox-360.co.za/forum/admi...php?do=recount
IP Address : 198.54.202.174
Username : MiNeM
Classname : vB_Database
MySQL Version : 5.0.91-community
Thanks in advance...