Recalculate points

[Blue6995]

I have tried to recalculate points, starting from the date that the forums first opened.

It starts off ok, but after a few seconds I get the following error:

Database error in vBulletin 4.0.4:

Invalid SQL:

SELECT * , post.userid AS postuserid
FROM vb3_dbtech_thanks_entry AS dbtech_thanks_entry
LEFT JOIN vb3_post as post ON (post.postid = dbtech_thanks_entry.contentid)
WHERE 1=1
AND dateline >= 1128898800 AND entrytype = 'thanks' HAVING postuserid = 1;

MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Request Date : Friday, July 23rd 2010 @ 01:17:29 AM
Error Date : Friday, July 23rd 2010 @ 01:17:33 AM
Script : http://www.rwf-forum.co.uk/vBulletin/admincp/vbactivity.php?do=recalcpoints
Referrer : http://www.rwf-forum.co.uk/vBulletin/admincp/vbactivity.php?do=maintenance
IP Address : xx.xxx.xxx.xxx
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.0.91-community-log

 

[Fillip H.]

I guess some mysql versions are more finnicky than others... I'll have a fix shortly and post back

Sent from my X10i using Tapatalk

 

[Blue6995]

I know how busy you are, but any sign of that fix you were working on

 

[Fillip H.]

I've uploaded the fix now, you can re-download the Pro zip and re-upload all files

 

[Blue6995]

Thanks for that - this time it worked. Just one thing though, I was expecting it to calculate the points from Oct 9 2005, but the awards etc are being shown as the date I first ran the program, which was 21 Jul 2010.

 

[Fillip H.]

That's because it would take a lot of processing power to determine exactly when an achievement was earned, so it just sets them as earned on the day recalc was ran.

Sent from my X10i using Tapatalk

 

[Blue6995]

Ah, I see. Many thanks