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
Quote1146 - 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
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
Indeed, I switched back to 7.0.15 (I was on 5.6 previously...) and it's working back fine ! :D
Thanks for your help !
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.