Phoca download front-end cant find file

[fcar27]

Hi,

I hope you can help.
I have about 50 files I use with phoca download. Everything also worked fine until yesterday (up- and downloading) and I am now getting this error message if I try to download any file:

Code: Select all

SQL=SELECT c.catid, c.filename, c.directlink, c.link_external, c.access, c.confirm_license, c.metakey, c.metadesc, cc.access as cataccess, cc.accessuserid as cataccessuserid, c.tokenhits FROM ctnoq_phocadownload AS c, ctnoq_phocadownload_categories AS cc WHERE c.id = 5 AND c.published = 1 AND c.approved = 1 AND c.catid = cc.id AND cc.access IN (1,1,2,3,6) AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2014-04-08 12:25:27' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2014-04-08 12:25:27' ) ORDER BY c.ordering LIMIT 0, 1

In the backend I can still see the file and find all files. I also tried uploading the file again, but to no avail - no change with the error message. The error remains.
Any idea what went wrong?
Regards

Phoca version 3.0.4
Joomla 3.2.3

[Jan]

Hi, do you get any error there, I see sql query but no error

Jan

[fcar27]

Hi Jan

I attach two png's with what I get when choosing to download a file (sorry it is in german):

[Jan]

Hi, you can attach the images per external service e.g. imageshack (see forum rules)

Jan