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:
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...
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!)
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
Hi Guys,
many thanks i will check and fix it. ;)
Hm... seems that here exists a few more bugs. I need more time for it. Maybe until monday. :-\
QuoteIf 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. :-\