Phoca Forum

Upgrading to the latest version causes the website not to work - get this message on the homepage

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 waib7_phocadownload AS c LEFT JOIN waib7_phocadownload_categories AS cc ON cc.id = c.catid WHERE c.catid= cc.id AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND c.access IN (1,1,5) ) ) AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND cc.access IN (1,1,5) ) ) 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-02-05 09:14:40' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2016-02-05 09:14:40' ) ORDER BY c.c.date DESC LIMIT 0, 5

Reinstalling an older version over the top removes the issue - is there something I can do, please?

Mike

Hi, which version you are running now? And do you use some module on the site, this can be caused by obsolete module.

Jan

I have the same problem.

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 j2013_phocadownload AS c LEFT JOIN j2013_phocadownload_categories AS cc ON cc.id = c.catid WHERE c.catid IN ( 8 ) AND c.catid= cc.id AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND c.access IN (1,1,5) ) ) AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND cc.access IN (1,1,5) ) ) 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-02-12 17:58:36' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2016-02-12 17:58:36' ) ORDER BY c.c.date DESC LIMIT 0, 7


Upgraded to 3.1.0 from 3.0.6 and the site was down. I have found out that it is caused by the Phoca Download File module.
What to do? How to get an upgraded version ov the module as well?

Thanks

@framilos
try to contact Jan via email: info[at]phoca[dot]cz
and link this thread: viewtopic.php?f=31&t=39057
Kind regards,
Benno

Jan sent me an updated version of the Phoca Download File module by return of email and this has solved the issue - thanks go to Jan!

Ok, great to hear it.

Jan