Phoca Forum

Hi all!
Sorry for my English not good...
After update Phocadownload from 3.0.6 to 3.1.0 on my site asl.varese.it, it shows this error message:
1054 - Unknown column 'a.c.title' in 'order clause' SQL=SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM web314_phocadownload AS a LEFT JOIN web314_phocadownload_categories AS c ON a.catid = c.id WHERE c.id = 3 ORDER BY a.c.title ASC LIMIT 0, 5

Can anyone help me?

Thanks a lot!

In this moment I've restored the last backup and now the site is online with the previous version 3.0.6.
If anyone find the solution to my question, please reply.

Thanks.

Hi, do you use some module or plugin (Phoca Download) there, this seems like some obsolete plugin.

If yes, try to disable it and if all will work OK, this seems like obsolete plugin (module).

This seems like old phoca download content plugin, try to update it (if you are using it) and let me know.

Jan

Hi,

I have a similar issue. After upgrading from 3.0.6 to 3.1.0 the site cannot be launched at all. Luckily it is a test server.

I have disabled the Phoca Download Tree module (because it is not used) and upgraded the Phoca Download Plugin to latest version without success.
I cannot find any download option for the last old plug-in I have installed - it is Phoca Download File Module. This is version 3.0.0. Can this cause this this fatal error?
And what can I then do?

Thanks,

Claus.

Hereby the error:

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 xeid9_phocadownload AS c LEFT JOIN xeid9_phocadownload_categories AS cc ON cc.id = c.catid WHERE c.catid IN ( 15 ) 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 <= '2015-11-30 18:28:06' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2015-11-30 18:28:06' ) ORDER BY c.c.date DESC LIMIT 0, 10

Best regards,

Claus Lücking.

Hi, yes, the Phoca Download File Module needs to be updated too. So please contact me per email for the newest version.

Thank you, Jan