SEF Link to Subcategory does not work (JRoute?)

[weltio]

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:

Code: Select all

/download/category/666-test

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:

Code: Select all

index.php?option=com_phocadownload&view=category&id=666:test

which doesn't work either.

However omitting the ":test" results in an accessible link:

Code: Select all

index.php?option=com_phocadownload&view=category&id=666

So the same goes for

Code: Select all

/download/category/666

Why doesn't it work as expected?

[Jan]

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

[weltio]

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!

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

[Jan]

Hi, thank you for the info

Jan