Error 500 when display files of the a single category

[jdelvalle]

I receive the next error when I access to the files to download from a menu with the "Single category" active.

It appears a double "DESC" (DESC DESC) to final of the SQL sentence.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 10' at line 15 SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.date_added, a.file_date, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_id, a.created_mail, a.modified_id, a.modified_date, a.submitted_by, a.set_aup_points, a.downloads, a.cat_id, a.changelog, a.password, a.password_md5, a.views, a.metakey, a.metadesc, a.robots, a.update_active, a.custom_field_1, a.custom_field_2, a.custom_field_3, a.custom_field_4, a.custom_field_5, a.custom_field_6, a.custom_field_7, a.custom_field_8, a.custom_field_9, a.custom_field_10, a.custom_field_11, a.custom_field_12, a.custom_field_13, a.custom_field_14, a.access, a.language, a.ordering, a.published, a.checked_out, a.checked_out_time, a.modified_date as modified, a.modified_id,CASE WHEN a.publish_from = 0 THEN a.date_added ELSE a.publish_from END as publish_from,a.publish_to, a.images, a.metakey, a.metadesc, a.access, a.downloads, LENGTH(a.description_long) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS state,aa.url_download AS filename_from_other_download,c.title AS category_title, c.access AS category_access, c.alias AS category_alias, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent,u.name AS creator,u2.name AS modifier,u2.name AS modifier,l.title AS license_title, l.url AS license_url, l.description AS license_text,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias,menuf.id AS menuf_itemid,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM qsi4v_jdownloads_files AS a LEFT JOIN qsi4v_jdownloads_files AS aa on aa.file_id = a.other_file_id LEFT JOIN qsi4v_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN qsi4v_users AS ua ON ua.id = a.created_id LEFT JOIN qsi4v_users AS uam ON uam.id = a.modified_id LEFT JOIN qsi4v_users AS u on u.id = a.created_id LEFT JOIN qsi4v_users AS u2 on u2.id = a.modified_id LEFT JOIN qsi4v_jdownloads_licenses AS l on l.id = a.license LEFT JOIN qsi4v_jdownloads_ratings AS r on r.file_id = a.file_id LEFT JOIN qsi4v_jdownloads_categories as parent ON parent.id = c.parent_id LEFT JOIN qsi4v_menu AS menuf on menuf.link LIKE CONCAT('index.php?option=com_jdownloads&view=download&id=',a.file_id,'%') AND menuf.published = 1 AND menuf.access IN (1,1,5) LEFT OUTER JOIN (SELECT cat.id as id FROM qsi4v_jdownloads_categories AS cat JOIN qsi4v_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 AND a.cat_id = 6 AND (a.publish_from = '0000-00-00 00:00:00' OR a.publish_from <= '2015-03-07 19:37:24') AND (a.publish_to = '0000-00-00 00:00:00' OR a.publish_to >= '2015-03-07 19:37:24') ORDER BY c.lft, a.date_added DESC DESC LIMIT 0, 10

Call stack
#   Function   Location
1   JApplicationCms->execute()   JROOT/index.php:40
2   JApplicationSite->doExecute()   JROOT/libraries/cms/application/cms.php:251
3   JApplicationSite->dispatch()   JROOT/libraries/cms/application/site.php:230
4   JComponentHelper::renderComponent()   JROOT/libraries/cms/application/site.php:191
5   JComponentHelper::executeComponent()   JROOT/libraries/cms/component/helper.php:360
6   require_once()   JROOT/libraries/cms/component/helper.php:380
7   JControllerLegacy->execute()   JROOT/components/com_jdownloads/jdownloads.php:34
8   jdownloadsController->display()   JROOT/libraries/legacy/controller/legacy.php:728
9   JControllerLegacy->display()   JROOT/components/com_jdownloads/controller.php:72
10   JdownloadsViewCategory->display()   JROOT/libraries/legacy/controller/legacy.php:690
11   JError::raiseError()   JROOT/components/com_jdownloads/views/category/view.html.php:78
12   JError::raise()   JROOT/libraries/legacy/error/error.php:254

I think is an bug,

Greeting.

Julian del Valle

[ColinM]

Hi
I have tried but I cannot reproduce the problem.  Have you recently migrated from an earlier version of jDownloads or from Joomla! 2.5 to 3.x ?

Colin

[jdelvalle]

Hi Colin,

Yes, I have migrated from jDownloads 1.9.2.11 to 3.2.26 and the Joomla 3.1 to 3.4.

Greeting.

Julian del Valle

[Arno]

It appears a double "DESC" (DESC DESC) to final of the SQL sentence

This was a problem with an older version. But should be fixed in the meantime.
Have you maybe used some special sorting settings in the menu item for jDownloads?  

Login data (via PM) for your backend could be useful...

[jdelvalle]

Arno,

I have been doing different test and the bug occurs in the next situation:

When at the entrance "menu" at the slider "List Layouts" at the parameter "Downloads order" is put to "Most recent first".

With the value "Downloads Manger Order" works ok.

Greeting.

Julian del Valle