Database errors

[Doctor]

Database error in vBulletin 4.0.3:

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 : Saturday, May 22nd 2010 @ 02:13:45 AM
Error Date : Saturday, May 22nd 2010 @ 02:13:45 AM
Script : http://www.myanimeisland.com/cron.php?rand=1274490820
Referrer : http://www.myanimeisland.com/group.php?do=invitations
IP Address : 92.41.220.20
Username : Unregistered
Classname : vB_Database
MySQL Version :

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT award.*, award_cat.award_cat_title
FROM award AS award
LEFT JOIN award_cat AS award_cat USING (award_cat_id)

ORDER BY award_cat.award_cat_displayorder,award.award_displayorder;

MySQL Error : Table 'myanimeisland.award' doesn't exist
Error Number : 1146
Request Date : Saturday, May 22nd 2010 @ 04:27:46 AM
Error Date : Saturday, May 22nd 2010 @ 04:27:46 AM
Script : http://www.myanimeisland.com/awards.php
Referrer : 
IP Address : 95.108.157.252
Username : Unregistered
Classname : vB_Database
MySQL Version :

 

[Fillip H.]

I'm not sure if its the mobile browser, but I don't see the full error in the first quote posted. Could you please attach it as a txt or something? Thanks

The second error doesn't appear to be related to vbactivity, since it doesn't use any tables or columns by that name as described in the error
Do you use any other award mod, or recently uninstalled one?

 

[Utas]

I have the same trouble.
View attachment vBulletin Database Error.txt
I think the errors come from the Trophy because they do not work.

 

[Fillip H.]

What version of MySQL are you running? Because I don't get this error on that exact query on my test board.

 

[Utas]

MySQL client version: 5.0.32
Server version: 5.0.32-Debian_7etch11-log

 

[Fillip H.]

Uploaded a fix, try re-downloading and re-uploading the files.

Importing the XML file isn't needed

 

[Doctor]

Allright i updated it and i have not got a email about any errors "yet"
but i have a big problem now

The Achievements have gone nuts its says i have 50 friends and Referred over 100 people! etc... (wish that bit was true )
anyway i have not even got close to that also its give veryone else the same ones

http://www.myanimeisland.com/members/1-Vodkaholic

Mike

 

[Fillip H.]

Can you please screenshot the Manage Achievements interface? The one that lists all your created Achievements

 

[Doctor]

It is 100% just like yours on this site mate
but here you go

 

[Fillip H.]

Can you try running the Recalculate Achievements function and see if that fixes it?

 

[Doctor]

Yes indeed i have hehe
Nothing fixes it
Even uninstall and reinstall same problem

 

[Fillip H.]

I'm at a loss then, nobody else has reported this problem.
Would it be possible for me to get an Admin account on your forum as well as FTP access? I can look into it then

 

[Doctor]

Fillip H. Referrals Achievements dont seem to be working

 

[Fillip H.]

Did you try recalculate?

 

[Doctor]

indeed i did

 

[Fillip H.]

Can you check the affected profile in the User part of the admincp to see if he indeed has got the number of referrals needed?

 

[Doctor]

yes i have everything is right just not showing them

http://www.myanimeisland.com/members/1-Vodkaholic

 

[Fillip H.]

Can't really figure that one out until you can get FTP working then, sorry

 

[Doctor]

the only thing i can think of what uses referrals is this http://www.vbulletin.org/forum/showthread.php?t=236117 Think this could be the problem? shared Hooks or something?

 

[Fillip H.]

Dunno, but recalc should have worked anyway...