I added a tab for users of my sports league and would like to know what "format" I guess I need to make the following happen.
Under a tab I have set up I simply want to make so that users have links to "my awards "My Teams Awards"....etc. I have YAAS installed.
Also id like a team name/logo to...
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.
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...
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"...
achievements
admincp
bug
comment
count
database
database error
display
double
download
error
feature
import
manual
number
only
options
performance
php
points
pro
question
server
settings
shouts
statistics
support
tags
test
trophy
updates
upload
vbactivity
vbulletin
version
xml
They upped it to twice the limit 150K, and it got about 40-50 users further then bombed out. Is there anything I can do to optimise this process just to get through the point calculation? I cant believe everyone who uses this mod has unlimited sql queries.
great. I was just told if vbactivity is doing this after only 20-30 users its using far too much database wise. I am unsure of what to do, this is the only time ive had this problem.
Users per page? I think that's what I was trying. Is the default set to 50?
Damn. What a pain.
So I'm assuming I would need unlimited? At 75k even a small forum such as mine would never be able to recalculate points unless it was unlimited. Heck mine only ever gets to like 30-35.
btw thats...
I just installed vbactivity pro and after entering achievements and setting point values I went to maintenance and to recalculate points.
Ive set the number to 1, 3, 5 even 10 all of which at somepoint errored out with the following:
Invalid SQL:
INSERT INTO dbtech_vbactivity_pointslog...