also when i tried to recount the PPD, the following error occurred:
Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
u.userid,
points_user_activity+points_user_albumpictures+points_misc_ibparcadechamps+points_user_law+points_post_attachment+points_post_attachment_views+points_misc_custom+points_misc_cdp+points_misc_dla+points_post_den+points_misc_ds_vbexp+points_misc_dl2+points_xperience+points_user_profile+points_user_friends+points_post_thanks_got_total+points_post_thanks_got_post+points_user_infractions+points_misc_ldm+points_misc_ppd+points_user_online+points_misc+points_post+points_user+points_thread+points_posts+points_user_referrals+points_thread_replycount+points_user_reputation+points_threads_sg+points_posts_sg+points_user_socialgroup+points_thread_stickies+points_thread_tags+points_thread_tnc+points_threads+points_user_reputation_use+points_post_thanks_use+points_post_thanks_used+points_thread_views+points_user_visitormessages+points_thread_votes+points_misc_ppg+points_post_group_discussion+points_thread_group_discussion+points_misc_vbblog+points_post_thanks
AS get_count
FROM xperience_stats as s
INNER JOIN user as u ON u.userid = s.userid
WHERE 1 = 1 AND NOT (1=2 )
ORDER BY get_count DESC, points_xperience DESC
LIMIT 0,1;
MySQL Error : Unknown column 'points_thread_tnc' in 'field list'
Error Number : 1054
Request Date : Friday, August 28th 2009 @ 10:13:03 AM
Error Date : Friday, August 28th 2009 @ 10:13:04 AM
Script : http://www.familybunker.com/forums/admincp/xperience_admin.php?do=xperience_admin_recount_ppd&avgppd=1&startat=1251&pp=250
Referrer : http://www.familybunker.com/forums/admincp/index.php?loc=plugin.php%3Fdo%3Dproduct
Classname : vB_Database_MySQLi
MySQL Version : 5.1.30