JDownloads front end editor button plugin sql error 1054 - [Fixed in 3.2.38]

[NickS]

Hi,

Thanks for the great component and for any support you can give.


System Information
JDownloads Version                     See attached -JDownload versions
Joomla! Version                            Joomla! 3.4.3 Stable
PHP Version                                 5.5.9-1ubuntu4.11
Database Version                         5.5.44-0ubuntu0.14.04.1
Web Server                                  Apache/2.4.7 (Ubuntu)
WebServer to PHP Interface        apache2handler


Issue Details
When a user tries to add a JDownload to an article using the extended editor (JCE) Download button from the front end (see step-1), the pop up opens and provides a shortened list of available downloads (see Step-2) but when the user applies a filter such as state or category to the list, the system returns an SQL 1054 error (see step-3 SQL error also posted below)


Attempted resolution
Updated to current-Joomla, updated to current JDownloads, turned off non JDownloads plugins to eliminate plugin conflicts, ran the SQL in PHPMyAdmin and confirmed that the field a.file_title does not exist despite the call to order by it, there is no mention of the column in the select part of the querry either.   (see step-3 or SQL error posted below)


SQL 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 rev3_jdownloads_categories as c LEFT JOIN `rev3_jdownloads_files` AS files ON files.`cat_id` = c.id AND files.published = 1 LEFT JOIN rev3_users AS u on u.id = files.created_id LEFT JOIN rev3_users AS u2 on u2.id = files.modified_id LEFT JOIN rev3_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,9) WHERE c.access IN (1,1,2,3,6,7,8,9) 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

[gelöscht durch Administrator]

[Arno]

Hi Nick,
sorry for the delay.
I will check this in the next hour.

[Arno]

Hi Nick,
i have it tested with the newest jD version but i can not reproduce your problem here.

So maybe can you send me login data for your backend via PM?

[NickS]

Thanks!

It's in your inbox.

[NickS]

Hi Arno,

Permissions are now set to SU and the login is hidden under the home button on the top menu.  Just hover over home and click portal.

Thanks again for your help with this.

Regards,

Nick 

[Arno]

Hi Nick,
thanks. I will try this tomorrow.

[NickS]

Hi,

I did a fresh install of the current Joomla in my test environment then used the extension manager to add just the current version of Jdownloads.  Out of the box with just the Jdownloads plugins turned on and no other components added,  I still get the 1054 eroror when using the filter in the front end from the download button. (Done with all permissions 777 & owner webserver-user)

Thanks again for your help Arno,


Regards,

Nick S

[Arno]

Very strange. I will test it here tonight again with a fresh installation.

Edit:

...used the extension manager to add just the current version of Jdownloads.

You have installed it from Joomla.org? Or downloaded from www.jdownloads.com?

[Arno]

Okay i have now also get the error. 
Seems to be for me a heavy bug and it is not easy to find the right part to fix it.
So i need maybe a day or two for it.

I know that this function has earlier worked properly. So it can be the result from changes for another jD part.
jDownloads is not really a small script.

Edit:
i have now found the reason. The issue exist only when SEO settings are activated in Joomla. So i think it is a bug in the router.php from jD. I will try to fix it tomorrow. 

[Arno]

Maybe is the solution more simple:
copy the unzipped file below to:
... /administrator/components/com_jdownloads/views/downloads/tmpl/

Please post then here your result. Thanks.

[gelöscht durch Administrator]

[NickS]

Hi Arno,

You are correct, I did have SEF URLs enabled.  My initial tests confirm the fix works. (Including my production environment.)  I will let you know if I find any issues but I think that will do it.

Thank you for your ongoing assistance.  You have developed a very effective and useful tool and support it well.


Regards,

Nick S

[Arno]

Hi Nick,
thanks for your result.