[ozione]

Originally Posted by ozione

hello!

i just upgraded to 4.1.0 RC and I get the following error when trying to recount experience points:

SELECT
					COUNT(*) AS count_threads,
					SUM(votetotal/votenum) AS count_votes,
					SUM(replycount) AS count_replycount,
					SUM(views) AS count_views,
					SUM(sticky) AS count_stickies
					FROM vb4_thread 
					WHERE visible=1 AND forumid = 54
					AND postuserid=2
					AND thread.dateline > 315532800;

MySQL Error   : Unknown column 'thread.dateline' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, December 8th 2011 @ 10:27:48 AM
Error Date    : Thursday, December 8th 2011 @ 10:27:49 AM
Script        : http://www.xxx.xxx/vb4/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : http://www.xxx.xxx/vb4/admincp/xperience_admin.php?do=recount
IP Address    : xxx.xxx.xxx.xxx
Username      : xxx
Classname     : vB_xxx
MySQL Version : 5.1.54-log

any help would be appriciated.

still busting my head with this one.
HALP!