Problems with back-end after update
Posted: 11 Jul 2014, 16:56
Hi,
After updating Joomla from 3.1.1 to 3.3.0 in the site everything it's OK but in the administrator side I have :
1 While categories are correctly listed, files not. No files appears.
2 The layout seems not correct. I'm using Hathor as template.
3 When going to Statistics i have this error:
"Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SQL=SELECT MAX(a.hits) AS maxhit, SUM(a.hits) AS sumhit,uc.name AS editor FROM `jos_phocadownload` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.hits desc LIMIT 0, 1"
The update was made two mounts ago but unfortunately only today I discover the problem.
Now the release is 3.1.1 for Joomla and 3.0.5 for Phocadownload. I have installed also the italian language extension ( manualy )
After updating Joomla from 3.1.1 to 3.3.0 in the site everything it's OK but in the administrator side I have :
1 While categories are correctly listed, files not. No files appears.
2 The layout seems not correct. I'm using Hathor as template.
3 When going to Statistics i have this error:
"Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SQL=SELECT MAX(a.hits) AS maxhit, SUM(a.hits) AS sumhit,uc.name AS editor FROM `jos_phocadownload` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.hits desc LIMIT 0, 1"
The update was made two mounts ago but unfortunately only today I discover the problem.
Now the release is 3.1.1 for Joomla and 3.0.5 for Phocadownload. I have installed also the italian language extension ( manualy )