Phoca Forum

Hello,

I have this error in Frontend (phocadownload 3.11) :

1054 - Unknown column 'c.c.date' in 'order clause' SQL=SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid FROM #__phocadownload AS c LEFT JOIN #__phocadownload_categories AS cc ON cc.id = c.catid WHERE c.catid IN ( 1,2,17,20,22 ) AND c.catid= cc.id AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND c.access IN (1,1,2,3) ) ) AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND cc.access IN (1,1,2,3) ) ) AND c.published = 1 AND c.approved = 1 AND cc.published = 1 AND c.textonly = 0 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2016-04-14 11:50:54' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2016-04-14 11:50:54' ) ORDER BY c.c.date DESC LIMIT 0, 8

thanks for your help
Arnaud

System Information

PHP Built On Linux info 3.0 #1337 SMP Tue Jan 01 00:00:00 CEST 2000 all GNU/Linux
Database Version 5.1.73-1+deb6u1
Database Collation latin1_swedish_ci
Database Connection Collation utf8_general_ci
PHP Version 5.4.45
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.5.1 Stable [ Unicorn ] 05-April-2016 22:45 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0

Hi, do you use Phoca Download File module? If yes, such needs to be updated.

Jan

Where do we get the update for this? I have looked on this page https://www.phoca.cz/phoca-download-file-module but don't see a link to download. Having same issue...if I turn on module the whole site crashes with a 1054 error.

Hi,

as shown here: https://www.phoca.cz/phoca-download-file-module see here please:

This module is available for users who participated in the development of free Phoca extensions. Get mor infomration on: contact page or ask per email: info [at] phoca [dot] cz. Thank you.

Kind regards, Christine