Phoca Forum

Hello. I've got the following setup:

Menulink to Category View - say category's name is "Download"
It contains a subcategory, say "test".


Creation of the link in /components/com_phocadownload/views/category/tmpl/default.php:79
JRoute-output: This does not work, since:

#1054 Unknown column '666test' in 'where clause' SQL=SELECT parent_id FROM jos_categories WHERE id=666test

If I remove the JRoute-wrapper, I'll get: which doesn't work either.

However omitting the ":test" results in an accessible link: So the same goes for Why doesn't it work as expected?

Hi, everything is OK, but some SQL query asks something from Joomla! categories, but Phoca Download does not use Joomla! categories table, so maybe some system plugin, etc.

Jan

Hi,

thanks for your hint, I found the problems.
The sql was fired by misconfigured Flexheader module combined with missing access rights for the user accessing the subcategory!
(So no problem with phoca!)

Best regards and thanks again

Edit:
Just found this:
viewtopic.php?f=31&t=25390#p96720
Which absolutely helps!

simkea wrote: change in mod_flexheader3.php in line 141:
- if($fl_view=='category') {
+ if($fl_view=='category' AND $fl_option!='com_phocadownload' ) {

Hi, thank you for the info

Jan