Front end Editor Button Bug on navigation to file

[polc1410]

I believe there is a bug on the front end editor (may be in the back end too but handled more gracefully!)  To reproduce this:
- Enable the button plugin for front end editor
- Open an article in front end
- Click the JDownloads Button
- Attempt to use the search box or any of the drop downs to locate a file
- 404 Parent Category Not Found is reported.

I am reproducing this in both the current 3.x build and the 2.x build - both originally upgrade from 1.9.

In the backend it behaves fine!  But I suspect it uses the same code so I suspect something more graceful happens ;-?

Enabling debugging in 3.x gives the following:

Code Select Expand

Error: 1054 - Unknown column 'a.file_title' in 'order clause' SQL=SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(files.`file_id`) AS numitems,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid FROM jos_jdownloads_categories as c LEFT JOIN `jos_jdownloads_files` AS files ON files.`cat_id` = c.id AND files.published = 1 LEFT JOIN jos_users AS u on u.id = files.created_id LEFT JOIN jos_users AS u2 on u2.id = files.modified_id LEFT JOIN jos_menu AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',c.id,'%') AND menu.published = 1 AND menu.access IN (1,1,2,3,6,7,8) WHERE c.access IN (1,1,2,3,6,7,8) AND c.published = 1 GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.description, c.pic, c.access, c.metakey, c.metadesc, c.robots, c.created_user_id, c.created_time, c.modified_user_id, c.modified_time, c.language, c.notes, c.views, c.params, c.password, c.password_md5, c.ordering, c.published, c.checked_out, c.checked_out_time, c.asset_id ORDER BY a.file_title asc

Unless I'm being thick there is no join creating a. in the sql so it is bound to fail...

[polc1410]

Actually the bug isn't there in the backend.

If you edit line 46 of plugins/editors-xtd/jdownloads/jdownloads.php to include administrator/ in-front of the index.php it handles fine from either side.  At least for a system admin ;-)
(Not saying thats secure or anything!)

[ColinM]

Hi
Apologies - had missed this one.  Confirm bug exists.  Tried before and after suggested fix as Registered user.  It was AOK after the fix.
Colin

[Arno]

Hi Guys,
many thanks i will check and fix it.

[Arno]

Hm... seems that here exists a few more bugs. I need more time for it. Maybe until monday. 

[Arno]

If you edit line 46 of plugins/editors-xtd/jdownloads/jdownloads.php to include administrator/ in-front of the index.php it handles fine from either side.  At least for a system admin ;-)
(Not saying thats secure or anything!)

Not really an option. In this case are all Downloads listed. Independently, from the view access level.
It seems that i must reworks this part.