[FIXED]PHP error on category with PHP 7.1

[Hache]

Hello,
I activated php 7.1.1 on my website, and since the category view doesn't work   

Here are the versions :
joomla 3.6.5
PHP 7.1.1
SQL 5.5.54-0+deb7u1-log
jDownloads Version 3.2.46


The main jdownloads page works fine : http://www.lgdj.org/telechargements
but as soon as you pick a category... http://www.lgdj.org/telechargements/category/5-aides-jeux

1146 - Table 'lgdjrufenew.#' doesn't exist SQL=SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(files.`file_id`) AS numitems,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid FROM #__jdownloads_categories as c LEFT JOIN #__jdownloads_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN `#` AS files ON files.`cat_id` = c.id AND files.published = 1 LEFT JOIN #__users AS u on u.id = files.created_id LEFT JOIN #__users AS u2 on u2.id = files.modified_id LEFT JOIN (SELECT id, link, access, published from #__menu GROUP BY link) AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',c.id) AND menu.published = 1 AND menu.access IN (1,1,2,3,8) WHERE c.access IN (1,1,2,3,8) AND c.published = 1 AND s.id=5 GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.description, c.pic, c.access, c.metakey, c.metadesc, c.robots, c.created_user_id, c.created_time, c.modified_user_id, c.modified_time, c.language, c.notes, c.views, c.params, c.password, c.password_md5, c.ordering, c.published, c.checked_out, c.checked_out_time, c.asset_id ORDER BY c.lft

[ColinM]

Hi
We have not yet tested with PHP 7.1.1  Clearly something must have changed
It was only released this year on 19th Jan.  We have not had a jD release since last year, also Joomla! itself has not had a release since December 2016.
Generally I would suggest not updating to new php that is after the latest release date.  I know all is OK with PHP 7.0.9 but I do not know about 7.1 series
Colin

[Hache]

Indeed, I switched back to 7.0.15 (I was on 5.6 previously...) and it's working back fine ! 

Thanks for your help !

[Arno]

I think that  we could fix this problem with PHP 7.1. So we will publish in the next days a new 3.2 version.