[hossgher]

hey mate, receiving the following error after upgrading to 4.3.9 from 4.2.6, any idea what i can do?

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT cats.*, COUNT(DISTINCT tmnts.id) AS counttmnts, COUNT(DISTINCT ladders.id) AS countladders, COUNT(DISTINCT leagues.id) AS countleagues, pcat.title AS categorytitle2, pcat.title AS parenttitle
FROM tmnt_categories AS cats
LEFT JOIN tmnt_categories AS pcat
ON (cats.parentid = pcat.catid)
LEFT OUTER JOIN tmnt_tmnts AS tmnts
ON (cats.catid = tmnts.catid)
LEFT OUTER JOIN tmnt_ladders AS ladders
ON (cats.catid = ladders.catid AND ladders.league = 0)
LEFT OUTER JOIN tmnt_ladders AS leagues
ON (cats.catid = leagues.catid AND leagues.league > 0)
GROUP BY cats.catid
ORDER BY cats.parentid DESC, cats.displayorder ASC, cats.title ASC;

MySQL Error : Unknown column 'ladders.league' in 'on clause'
Error Number : 1054
Request Date : Sunday, April 24th 2011 @ 09:27:58 AM
Error Date : Sunday, April 24th 2011 @ 09:27:58 AM
Script : http://www.teamichor.net/tournaments.php

i read earlier that this was fixed in 4.3.8, is there a hotfix that i can apply to 4.3.9? thanks in advance!