Bug 3 Issues Since Updating to the 2.1.3 w/ Thanks/Like

[s3ponline]

A few issues since updating.

First Issue:

When I click “Manage Criteria”, “Manage Awards”, or “Awards Request/Nominations”

I get "Invalid Action.”

2nd Issue:

Database error in vBulletin 4.1.0:

Invalid SQL:

			SELECT * 
			FROM dbtech_thanks_entry AS dbtech_thanks_entry
			
			WHERE 1=1 
				 AND dbtech_thanks_entry.dateline >= 473407200 AND entrytype = 'thanks' AND userid = 1;

MySQL Error   : Unknown column 'entrytype' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, January 20th 2011 @ 03:52:35 AM
Error Date    : Thursday, January 20th 2011 @ 03:52:38 AM
Script        : http://www.personalitynation.com/admincp/vbactivity.php?do=maintenance
Referrer      : http://www.personalitynation.com/admincp/vbactivity.php?do=maintenance

Third Issue:
Referrals aren’t being calculated.


List of modifications that I have:
DragonByte Tech: vBActivity & Awards (Pro) 2.1.3
DragonByte Tech: Advanced Post Thanks / Like (Pro) 1.1.2
DragonByte Tech: Advanced User Tagging (Lite) 1.2.1
DragonByte Tech: Facebook Style Status 1.3.5
DragonByte Tech: Info Panels (Pro) 1.1.3
DragonByte Tech: Random Questions (Pro) 2.1.0
DragonByte Tech: Triple Triad Pro 1.1.1
DragonByte Tech: User Spotlight 1.0.1
DragonByte Tech: vBCredits II Deluxe (Pro) 2.0.0

 

[Fillip H.]

When I click “Manage Criteria”, “Manage Awards”, or “Awards Request/Nominations”

I get "Invalid Action.”

Please ensure you followed the upgrade steps in the "upgrade notes" file - you may have a conflict that's resulting from the 2 cpnav_ files being present.

Database error in vBulletin 4.1.0:

Invalid SQL:

			SELECT * 
			FROM dbtech_thanks_entry AS dbtech_thanks_entry
			
			WHERE 1=1 
				 AND dbtech_thanks_entry.dateline >= 473407200 AND entrytype = 'thanks' AND userid = 1;

MySQL Error   : Unknown column 'entrytype' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, January 20th 2011 @ 03:52:35 AM
Error Date    : Thursday, January 20th 2011 @ 03:52:38 AM
Script        : http://www.personalitynation.com/admincp/vbactivity.php?do=maintenance
Referrer      : http://www.personalitynation.com/admincp/vbactivity.php?do=maintenance

Confirmed, will have a hotfix available shortly.

Referrals aren’t being calculated./QUOTE]Could you be a bit more specific?

 

[Fillip H.]

When I click “Manage Criteria”, “Manage Awards”, or “Awards Request/Nominations”

I get "Invalid Action.”

Please ensure you followed the upgrade steps in the "upgrade notes" file - you may have a conflict that's resulting from the 2 cpnav_ files being present.

Database error in vBulletin 4.1.0:

Invalid SQL:

			SELECT * 
			FROM dbtech_thanks_entry AS dbtech_thanks_entry
			
			WHERE 1=1 
				 AND dbtech_thanks_entry.dateline >= 473407200 AND entrytype = 'thanks' AND userid = 1;

MySQL Error   : Unknown column 'entrytype' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, January 20th 2011 @ 03:52:35 AM
Error Date    : Thursday, January 20th 2011 @ 03:52:38 AM
Script        : http://www.personalitynation.com/admincp/vbactivity.php?do=maintenance
Referrer      : http://www.personalitynation.com/admincp/vbactivity.php?do=maintenance

Confirmed, will have a hotfix available shortly.

Referrals aren’t being calculated.

Could you be a bit more specific?

 

[s3ponline]

Please ensure you followed the upgrade steps in the "upgrade notes" file - you may have a conflict that's resulting from the 2 cpnav_ files being present.

Confirmed, will have a hotfix available shortly.

Referrals aren’t being calculated.

Could you be a bit more specific?

I’ll try to install it again and see if the issue fixes. Should I wait for the hotfix?

I’m stating that the referral achievements don’t work. I have users who have been referred several times, but don’t receive a single achievement.

 

[Fillip H.]

The achievements work for referrals, not for being referred

There's no need to reinstall, the hotfix is for APTL and will work with just a simple file upload. You can, in fact, go download APTL 1.1.2 again right now and re-upload the files (no need to re-import XML) and it should work fine

 

[s3ponline]

The achievements work for referrals, not for being referred

There's no need to reinstall, the hotfix is for APTL and will work with just a simple file upload. You can, in fact, go download APTL 1.1.2 again right now and re-upload the files (no need to re-import XML) and it should work fine

No. That’s what I mean. The referrals are not calculating....
Also, Now it recalculates everything w/o error, but the thanks/posts are still at 0. Nobody has gotten credit for it; furthermore, everyone’s activity points have dropped tremendously after the recalculation.
I checked for
* bitfield_activity.xml
* bitfield_activity_pro.xml
* cpnav_activity.xml
* cpnav_activity_pro.xml
* hooks_activity.xml
* hooks_activity_pro.xml

And have none of them.

I’ve uploaded it twice now and I still get the issue. I did not have this issue on the previous version of vbactivity.

 

[Fillip H.]

Please PM me with an ftp account and an admincp account, and Ill take care of this issue and the other APTL one