Phoca Forum

Hi Jan

i just upgraded a site from 2.5.x to a 3.3.x version.
I also updated PhocaDownload to the current version.
All the files are showing in the backend and in the frontend, but when you click on one in the frontend, all I get is an error message and the link does not include the .pdf at the end.

The error message reads:
[quote]
1054 - Unknown column 'c.tokenhits' in 'field list' 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 cnays_phocadownload AS c, cnays_phocadownload_categories AS cc WHERE c.id = 140 AND c.published = 1 AND c.approved = 1 AND c.catid = cc.id AND cc.access IN (1,1) AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2014-08-14 11:35:33' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2014-08-14 11:35:33' ) ORDER BY c.ordering LIMIT 0, 1
[/quote]

I have no idea how to fix this. Can you help, please?

Regards
David

Hi, see:

How to solve problems which occur when upgrading Joomla! extensions
Jan

Hi Jan

Thanks a lot. That solved the problem. I wish I understood MySQL better...

Regards
David

Ok