Phoca Download wont work on front end after Joomla 3 upgrade

Phoca Download - download manager
erickemde
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 08 Jan 2012, 22:46

Phoca Download wont work on front end after Joomla 3 upgrade

Post by erickemde »

Hi,
I just upgraded to Joomla 3 and now Phoca Downloads won't work on the front end. When I try a list of files category view menu item, I get this error message:
1146 - Table 'ccuccatl_joomla2010.j17_phocadownload_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM j17_phocadownload_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC
In the admin section everything in Phoca works except Styles and Logging.
When I try to look at styles, I get the same error message.
When I try to look at logging, I get this error message:
500 Table 'ccuccatl_joomla2010.j17_phocadownload_logging' doesn't exist SQL=SELECT COUNT(*) FROM j17_phocadownload_logging AS a LEFT JOIN j17_phocadownload AS f ON f.id = a.fileid LEFT JOIN j17_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN j17_users AS ua ON ua.id = a.userid WHERE (a.type IN (1, 2)) Table 'ccuccatl_joomla2010.j17_phocadownload_logging' doesn't exist SQL=SELECT a.*,f.id as file_id, f.title as file_title, f.filename as filename,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM j17_phocadownload_logging AS a LEFT JOIN j17_phocadownload AS f ON f.id = a.fileid LEFT JOIN j17_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN j17_users AS ua ON ua.id = a.userid WHERE (a.type IN (1, 2)) ORDER BY f.title asc LIMIT 0, 20 Table 'ccuccatl_joomla2010.j17_phocadownload_logging' doesn't exist SQL=SELECT COUNT(*) FROM j17_phocadownload_logging AS a LEFT JOIN j17_phocadownload AS f ON f.id = a.fileid LEFT JOIN j17_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN j17_users AS ua ON ua.id = a.userid WHERE (a.type IN (1, 2))
So, it's obvious that the styles and logging tables don't exist or at least aren't named correctly. How do I fix this?
I'm on
Joomla! Version: Joomla! 3.4.3 Stable [ Ember ] 2-July-2015 16:00 GMT
Joomla! Platform Version: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Phoca Download 3.0.6
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48566
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Phoca Download wont work on front end after Joomla 3 upg

Post by Jan »

Hi, the styles table is missing so it should be added manually. See e.g. here:
viewtopic.php?f=1&t=24676#p92382
viewtopic.php?f=1&t=34561#p113168
Jan
If you find Phoca extensions useful, please support the project
Post Reply