1054 error on file lists view
Posted: 18 Nov 2015, 17:48
Hi,
i have migrated my site to Joomla 3 and i have reinstall the last phoca download component. I have also saved directory and export db from Joomla 2.5 a copy the directory and import the db data into the new db. All works fine, but when i try to select the file list view inserted into a Article {phocadownload view=filelist|id=15} i have an 1054 error
Errore: 1054
Unknown column 'a.c.ordering' 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, 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 cv8s3_phocadownload AS a LEFT JOIN cv8s3_phocadownload_categories AS c ON a.catid = c.id WHERE c.id = 15 ORDER BY a.c.ordering ASC LIMIT 0, 5
Can you help me?
Thank you
i have migrated my site to Joomla 3 and i have reinstall the last phoca download component. I have also saved directory and export db from Joomla 2.5 a copy the directory and import the db data into the new db. All works fine, but when i try to select the file list view inserted into a Article {phocadownload view=filelist|id=15} i have an 1054 error
Errore: 1054
Unknown column 'a.c.ordering' 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, 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 cv8s3_phocadownload AS a LEFT JOIN cv8s3_phocadownload_categories AS c ON a.catid = c.id WHERE c.id = 15 ORDER BY a.c.ordering ASC LIMIT 0, 5
Can you help me?
Thank you
