Bug Question and an error

[DevinM]

Question:
Is it possible to not display leaderboards for things we dont use? We have about 10 leader boards for options I am not using (tags, shouts....etc). Was curious if I could set it to simply not appear on the leaderboards page.


Error:

I get this error when I click on "All Achievements"

Database error in vBulletin 4.1.0:

Invalid SQL:

				SELECT COUNT(*) AS blogcomment
				FROM blog_text
				WHERE blogtextid NOT IN(SELECT firstblogtextid FROM blog)
					AND userid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Error Number  : 1064
Request Date  : Monday, February 21st 2011 @ 07:47:27 PM
Error Date    : Monday, February 21st 2011 @ 07:47:28 PM
Script        : http://www.gridironjunkies.net/vbactivity.php?do=allachievements
Referrer      : http://www.gridironjunkies.net/vbactivity.php?do=leaderboards
Classname     : vB_Database
MySQL Version : 5.0.91-log

 

[Fillip H.]

Points Settings -> Display Settings

Were you a guest at the time of receiving the error?

 

[DevinM]

No. In fact I just double checked to make sure lol.

 

[DevinM]

I appear to get the same error when I hit "Recalculate Achievements" under maintenance in the admincp.

Database error in vBulletin 4.1.0:

Invalid SQL:

				SELECT COUNT(*) AS blogcomment
				FROM blog_text
				WHERE blogtextid NOT IN(SELECT firstblogtextid FROM blog)
					AND userid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Error Number  : 1064
Request Date  : Tuesday, February 22nd 2011 @ 08:01:19 AM
Error Date    : Tuesday, February 22nd 2011 @ 08:01:20 AM
Script        : http://www.gridironjunkies.net/admingjnet/vbactivity.php?do=maintenance
Referrer      : http://www.gridironjunkies.net/admingjnet/vbactivity.php?do=maintenance
Classname     : vB_Database
MySQL Version : 5.0.91-log

 

[Fillip H.]

What blog Achievements have you set up?

 

[DevinM]

Just blog postings and comments. Then varying numbers (25, 50...etc)

 

[Fillip H.]

Hum okay, I'll give this a test and have a fix posted ASAP

Out of curiosity, do the achievements still get awarded when actually posting a blog / comment?

 

[DevinM]

No one has reached the first achievement, it did award the trophy for most blogs however. The first achievement is for 10 blogs, I think we have a few who are at 7-8 blogs.

 

[DevinM]

Any luck with this? I know youre very busy just curious as I have to work on my site after work most days so was just checking in.

 

[Fillip H.]

Not yet, I'll get to it ASAP though

 

[Fillip H.]

Sorry for the delay, been a hectic couple of days around here

This has now been fixed, you can re-download the zip from the Customer Area and re-upload them (no need to re-import XML)

In addition, some performance updates for large boards on the Achievement Statistics page (Pro-only) has been added, and a bug preventing the Snapshots feature from functioning correctly has been fixed as well (also Pro-only).

 

[DevinM]

That did it! Fillip H. youre awesome, thanks as always for the top notch support here!