View=filelist Error 1054

[k.slotwinski]

Hey,
I need to display file list in article but my I try to do it Error 1054 appears on article page and in editor.

Code: Select all

1054 Unknown column 'a.c.date' in 'order clause' SQL=SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename,a.filesize, a.date, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM #__phocadownload AS a LEFT JOIN #__phocadownload_categories AS c ON a.catid = c.id WHERE c.id = 55 ORDER BY a.c.date DESC LIMIT 0, 5

I have newest Phoca Download ver. 3.1.2 and Phoca Download Plugin ver. 3.1.2 - (Joomla! 3.6.4).
I cant find right answer for my problem, i tried reinstalling and downgrading phoca but that didnt work.

[Jan]

Hi, which plugin code you exactly add to the article?

Jan

[k.slotwinski]

Code: Select all

 {phocadownload view=filelist|id=152}

[Jan]

Hi, testing now, the plugin does not have any such problem, do you run any other part on your site (e.g. some module for Phoca Download)?

Jan