Bug Database error after recalculating points

[capecoddah]

Hi guys, I'm receiving this error after calculating my members' points for the first time.

Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT * , thread.forumid
FROM dbtech_usertag_mention AS dbtech_usertag_mention
LEFT JOIN post AS post USING(postid)
LEFT JOIN thread AS thread USING(threadid)

WHERE 1=1
AND dateline >= 1330401600 AND dbtech_usertag_mention.userid = 1;

MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052

Thank you for your assistance.

 

[Ozzy47]

Try upgrading to 3.0.1 and see if that fixes the issue.

 

[capecoddah]

Same error after upgrading to 3.0.1.

---------- Post added at 20:38 ---------- Previous post was at 20:32 ----------

It did calculate the total points for someone who had no dbtech tags/mentions, but when it got to the first account who had mentions/tags (my account) the error occurred.

 

[Ozzy47]

Ok then Fillip H. will have to look into it I know this was fixed once before but it was for vB4.x

 

[Fillip H.]

I believe it should be taken care of now, if you re-download and re-upload the files for v3.0.1

 

[capecoddah]

Thank you Fillip H., that did work.


However, I have another issue now (of course, ha). I didn't think I should start a new thread for it, though.

After recalculating points, repairing the cache, and making sure all points settings are set to "active," points for individual categories are still not recorded on the leaderboards or in profiles. Here's what I mean:

 

[Fillip H.]

Manually execute /admincp/vbactivity.php?do=finalise&version=2000

 

[capecoddah]

you're the man, thanks!


i'll be back when i install all of these awesome mods on my other vbulletin (4.x) forum

 

[Cosmic]

you're the man, thanks!


i'll be back when i install all of these awesome mods on my other vbulletin (4.x) forum

^.^ Bear in mind your pro licenses are only valid for a single forum/URL.

 

[capecoddah]

i'm aware. thanks.