1054 error on file lists view

[sercio]

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

[Benno]

Hi,
do you completely followed this migration guide: https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3 ?
Which Phoca Download Plugin version do you use?

Kind regards,
Benno

[sercio]

Hi,
do you completely followed this migration guide: https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3 ?
Which Phoca Download Plugin version do you use?

Kind regards,
Benno

Hi,
yes, i have used the guide (very simple guide).
The plugin version is 3.0.6

[Benno]

Hi,

The plugin version is 3.0.6

you wrote in Post #1:

i have reinstall the last phoca download component.

The current Phoca Download version is v3.1.0
The current Phoca Download Plugin version also is v3.1.0,
So, install the right Plugin version and the problem will be hopefully solved.
https://github.com/PhocaCz/PhocaDownloa ... v3.1.0.zip

Kind regards,
Benno

[sercio]

Hi,
i have upgraded the plugin and now all work fine! Thank you very much.

[Benno]

You're welcome!

Kind regards,
Benno