[PcGamer]

Getting this error after upgrade to 4.3.7

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT cats.*, COUNT(DISTINCT tmnts.id) AS counttmnts, COUNT(DISTINCT ladders.id) AS countladders, pcat.title AS categorytitle2, pcat.title AS parenttitle
FROM tmnt_categories AS cats
LEFT JOIN tmnt_categories AS pcat
ON (cats.parentid = cats2.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)
GROUP BY cats.catid
ORDER BY cats.parentid DESC, cats.displayorder ASC, cats.title ASC;

MySQL Error : Unknown column 'cats2.catid' in 'on clause'
Error Number : 1054