Phoca Download File - Error 1054 - Update from 3.0.6 to 3.1.

[Jack Kane]

Hey Folks,

I've recently updated Phoca Download and have found the following error message when accessing the downloads page.

Code: Select all

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 jos_phocadownload AS c LEFT JOIN jos_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 <= '2015-12-07 20:20:24' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2015-12-07 20:20:24' ) ORDER BY c.c.date DESC LIMIT 0, 10

I've read another topic on these forums with the same error and it mentions contacting Jan for an updated version of Phoca Download File. Jan, can you help please?

Many thanks

[woodyf4u]

Normally, it is better to start my own topic, but in this case I have the same issue.

This is the error at the frontpage when I have updated Phoca Download to 3.1.0:

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 j2014_phocadownload AS c LEFT JOIN j2014_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) ) ) AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND cc.access IN (1,1) ) ) 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-12-08 18:24:36' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2015-12-08 18:24:36' ) ORDER BY c.c.date DESC LIMIT 0, 5

I have read some other topics and that pointed m e to an obsolete module.
The module Phoca Download Files is not updated.
I have received that module from Jan in the beginning of 2014.
So I have send him an email and asked for the latest version.

[Jan]

Hi, yes, the file module needs to be updated to newest version.

Jan

[woodyf4u]

Thanks Jan.
The updated module you send me solved this issue.

[Jack Kane]

I've just noticed this topic has been marked as solved, but it hasn't been for me.

Jan, can you send me the file also please?

I can't private message you as I haven't posted enough on the forums yet, but I don't want to post for the sake of posting. I'd like to post more, but I have nothing of value to add at the moment.

I appreciate your help with this.

[woodyf4u]

I am sorry I was interupting your topic.
For as far as I now you have contacted Jan before to receive an earlier version of this module.
So use that contactmail to ask him for the new release or use the contactform at this site.
https://www.phoca.cz/contact

[Jack Kane]

No problem Woody, I realised this when I came back to the topic.

Thanks for the link, I've sent a message that way instead.