Unknown column 'c.title'

[apweb]

Hi,

Since an update there is an error message when did a search (module search Joomla) in page List of Files (Category View) :

Unknown column 'c.title' in 'order clause' SQL=SELECT a.id, a.title AS title, a.alias, a.date AS created, a.access, a.accessuserid, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, a.description AS text, CONCAT_WS( " / ", 'Phoca Download', a.title ) AS section, "2" AS browsernav FROM #__phocadownload_categories AS a WHERE ((a.title LIKE '%p8806085%' OR a.alias LIKE '%p8806085%' OR a.metakey LIKE '%p8806085%' OR a.metadesc LIKE '%p8806085%' OR a.description LIKE '%p8806085%')) AND a.published = 1 AND a.access IN (1,1,5) AND a.language in ('fr-FR','*') GROUP BY a.id ORDER BY c.title ASC, a.title ASC LIMIT 0, 2000

Update :

Joomla 3.1.6 > 3.5.1

Phoca Download Search Plugin 3.0.1 >  3.1.0
Phoca Download Finder Plugin catégories 3.0.1 > 3.1.0
Phoca Download Finder plugin Files 3.0.1 > 3.1.0
Phoca Download Tree 3.0.2 > 3.1.0
Phoca Download 3.0.2 > 3.1.2

I extensively searched but can not find the solution?

[Jan]

Hi, when you enable debug mode in Joomla! are you able to copy the information from which file this error comes?

Try to open this file:
plugins/search/phocadownload/phocadownload.php
and edit it on row cca 84
FROM

Code: Select all

case 'category':
                $order = 'c.title ASC, a.title ASC';
                break;

TO:

Code: Select all

case 'category':
                $order = 'a.title ASC';
                break;

And let me know if this helps.

Thank you, Jan

[apweb]

Hi,
Well, that's it. By changing this line it works now.
Thank you Jan

[Jan]

Ok, thank you for the info, I will fix it for the next version.

Thank you, Jan

[Jan]

Hi, should be OK in version 3.1.3
https://www.phoca.cz/news/952-phoca-dow ... 3-released

Jan