Phoca Download File Cannot Work

[mkpdroid]

Hi,

I have using Phoca Download File 3.0 and when the module published i got below error message:

Code: Select all

Unknown column 'c.c.id' 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 c2qxc_phocadownload AS c LEFT JOIN c2qxc_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-03-14 10:06:52' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2016-03-14 10:06:52' ) ORDER BY c.c.id DESC LIMIT 0, 11

But the strange thing, i have no problem with the previous website with the same version of Phoca Download File.

thank you

[mkpdroid]

Hi,

i have using the latest phoca download component 3.10, when i downgrade to phoca 3.0.6 the phoca download file 3.0.0 work fine. so i think, phoca download file 3.0.0 not compatible yet with phoca download component 3.1.0.

thank you

[Benno]

Hi,
yes, please contact Jan via email:
info[at]phoca[dot]cz
to get:
mod_phocadownload_file_v3.1.0.zip

Kind regards,
Benno