IP TSL 1.1 (Top Site List) error: Unknown column 's.id' in 'on clause'

[RTM]

We recently moved to MySQL 5 and PHP 5... after that, our IPB 2.3.6 forum works fine, but trying to access the links area (powered by the legacy Invision TSL product) top site list results in this error:

Unknown column 's.id' in 'on clause'


Error: Error executing query


The software returned the following error:


Unknown column 's.id' in 'on clause'


Query Executed: SELECT s.*,COUNT(DISTINCT c.id) as comment_count, AVG(v.value) as rating,COUNT(DISTINCT v.id) as num_votes, IF( COUNT(DISTINCT v.id) , 2 * COUNT(DISTINCT v.id) * (AVG(v.value)-3),0) + (1 * in_count) + (1 * out_count) + (1 * hit_count) as combined_rating, COUNT(DISTINCT me.id) as already_voted FROM tsl_sites AS s, tsl_users AS u, tsl_emails AS e LEFT JOIN tsl_votes AS me ON me.active = 1 && me.site = s.id && me.ip_record = 1 LEFT JOIN tsl_comments AS c ON c.site = s.id && c.admin_validate = 1 LEFT JOIN tsl_votes AS v ON v.active = 1 && v.site = s.id WHERE s.user = u.id && s.email = e.id && u.blocked = 0 && s.active = 1 && s.admin_validate = 1 && e.validated = 1 && s.category IN ( "0","0","1","2","3","4","5","6") && s.category_validated = 1 GROUP BY s.id ORDER BY combined_rating DESC, name DESC LIMIT 0,10

Anyone else still running TSL and resolve this?

Cheers,
Rob

[RTM]

Anyone? No one is still using TSL ?