Greight |
07-05-2010 02:36 PM |
Hi Phalynx. One problem that exists (however it seems does not affect the functionality) is every now and then I get this db error psted to my email box:
HTML Code:
Database error in vBulletin 4.0.4:
Invalid SQL:
UPDATE xperience_stats
SET
points_xperience=10,
points_thread=0,
points_threads=0,
points_threads_sg=0,
points_thread_votes=0,
points_thread_replycount=0,
points_thread_views=0,
points_thread_stickies=0,
points_thread_tags=0,
points_thread_rate=0,
points_post=0,
points_posts=0,
points_posts_sg=0,
points_post_attachment=0,
points_post_attachment_views=0,
points_post_avg=0,
points_user_activity=0,
points_user_activity30=0,
points_user_activity7=0,
points_user=10.0302083333,
points_user_profile=10,
points_user_infractions=0,
points_user_law=0,
points_user_reputation=0,
points_user_reputation_use=0,
points_user_online=0.0302083333333,
points_user_socialgroup=0,
points_user_friends=0,
points_user_visitormessages=0,
points_user_albumpictures=0,
points_user_referrals=0,
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, points_post_thanks_used=0,points_post_thanks_got_post=0,points_post_thanks_got_total=0,
promoted=0,
dateline=1278341700
WHERE userid=530;
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
User ID 530 is my last registered user not activated.
Any idea where's the problem?
|