Trophies

[ChatterScene]

I just set up images to go with each trophy name. Is there something I am supposed to do to make all of these show up now?
I rebuilt cache and recalc achievemnts and they are still not showing up. I am still getting user n/a in the who has trophy spot under manage trophies.

 

[ChatterScene]

There isnt even a tab for trophies showing on my activity page at top in navbar

 

[ChatterScene]

I even tried to go to scheduled tasks to run where it does the trophies I get a database error

 

[Neo_Angelo]

you have to assign the trophy to each trophie you have made, for example if you have say a trophie criteria set up for lets say "most posts" as an example you'd need to go into edit that trophie and add the image via the drop down, if you don't do this for existing trophies then they won't show.

i hope that was what you meant.

 

[ChatterScene]

Nope I did that already. i assigned images already. But they dont show and there is no trophy tab

 

[ChatterScene]

Wait i need to set up trophy criteria in criteria manager too? I am confused. I set up under trophy management each trophy image. Now I go to manage criteria and do that too?

Could I get an example of criteria for most posts? To earn a trophy?

 

[Neo_Angelo]

let me set up a few screenshots i think i may have confused things. i'll edit this post with what i mean.

ok firstly you set up your images using the info in Screenshot Trophy2.gif. when you've done that you'll be able to see the image next to the trophie you've made it for. (see trophy1.gif).

If any of the things show N/A as the trophy holder it means that no one has yet gained the right criteria for that trophy in our trophies bit you can see theres one for "points for posting" which whoever has the highest post count will have that trophy, if someone is supposed to have a trophy and doesn't i'm sure myself,Cosmic or fillip would be happy to hop over to your forums and check it out further (fillip would be your best bet).

 

[ChatterScene]

Ty
Okay this is how I have it set up.
And they all show NA.
Not even the one with most posts shows up. Someone hs to have that one. And the trophy tab in activity menu is missing. I tried schedule task for it and it caused a database area.

 

[Neo_Angelo]

you probably have a file missing or corrupt on your server, try uploading all the files for vba again, overwrite the previous files and see if that solves the problem. by the sounds of it your missing a file. if it doesn't solve it import the vba product again and overwrite the existing one you have installed. if this still doesn't fix the problem i'll mention it to Fillip H. to check it out for ya as hes the inventor and will probably know exactly what he's looking for.

 

[ChatterScene]

Thanks So much for trying to help. I did this and it still did not work
Still No near trophies and still no activity tab for trophies.
Amd still a database error when try to run trophy task in sceduled task manager.

 

[Deceptor]

Could you provide the SQL error occuring when you run the scheduled task manually?

 

[ChatterScene]

Yup here it is


Database error in vBulletin 4.0.2:

Invalid SQL:

(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 1) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 1
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 2) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 2
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 3) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 3
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 4) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 4
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 5) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 5
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 7) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 7
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 8) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 8
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 9) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 9
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 10) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 10
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 11) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 11
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 12) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 12
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 13) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 13
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 14) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 14
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 15) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 15
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 16) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 16
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 17) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 17
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 18) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 18
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 19) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 19
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
)
UNION ALL
(
SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 20) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
WHERE typeid = 20
GROUP BY userid
ORDER BY points DESC
) AS maxpoints
);

MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Monday, March 29th 2010 @ 12:53:04 PM
Error Date : Monday, March 29th 2010 @ 12:53:05 PM

Classname : vB_Database
MySQL Version : 5.0.45

 

[Deceptor]

Ah Fillip H. and his crazy union queries

For Fillip H., use this query to rebuild the counters for all trophies without union:

SELECT IFNULL(userid, 0) AS userid, IFNULL(typeid, 1) AS typeid, IFNULL(MAX(points), 0) AS points
FROM (
SELECT userid, typeid, SUM(points) AS points
FROM dbtech_vbactivity_pointslog
GROUP BY typeid, userid
ORDER BY points DESC
) AS maxpoints

GROUP BY typeid

For ChatterScene:

Can you run the above query I've offered to Fillip H. in your ACP to test it yields no errors?

 

[ChatterScene]

how do I do that? lol I am learning as I go


ETA:

i think I figured it out. Brings me to a page with user ids type ids and points I believe with no error

But Going back to trohies afterwards everything still N/A

 

[Deceptor]

Yeah the query won't actually update anything, I just wanted to confirm no errors occured. Once Bel is online I'll notify him of the hotfix so he can make the patch. Sorry for the trouble so far

 

[ChatterScene]

Okay Ty. Dont be sorry. I think this is an awesome mod and loving it so far

 

[Neo_Angelo]

it is strange that it hasn't worked for you. i don't think anyone else has had any problems like this, however fillip will sort you out for sure, he'll know whats gone wrong :3

 

[ChatterScene]

lol It is just my luck

 

[ChatterScene]

If I chose not to upload a trophy for a few of the things would that have caused this error? Cause I left about 6 with no pic.

 

[Neo_Angelo]

no we haven't added a picture for quite a few trophies yet so this wouldn't of caused any problems.