View=filelist Error 1054
Posted: 02 Nov 2016, 15:33
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.
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.
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, 5I cant find right answer for my problem, i tried reinstalling and downgrading phoca but that didnt work.