Phoca Forum

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?

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 TO: And let me know if this helps.

Thank you, Jan

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

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

Thank you, Jan

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

Jan