Error 1054 after joomla update from 3.6.5 to 3.7.4

[prke77]

Hi,
I have joomla 3.7.4 and Phoca download v 3.1.2. After update joomla from 3.6.5 to 3.7.4 in frontend when I want to access the files, I get the following error:
Error: 1054 - Unknown column 'c.tokenhits' in 'field list'


p.e. : http://www.zcvranje.com/javne-nabavke/j ... -vrednosti
Thanks a lot.
Regards,
Prke

[Jan]

Hi, see similar posts in this forum, seems like your Joomla! didn't upgrade Phoca Download correctly in the past. Just run thiese SQL queries in e.g. phpMyAdmin manually:
administrator\components\com_phocadownload\update\sql\mysql\3.0.2.sql

You need to change the prefix #__ to your database prefix before running the sql.

And you should check, if this query was updated too:
administrator\components\com_phocadownload\update\sql\mysql\3.1.1.sql

Jan

[prke77]

Jan, I have two files in this rout 3.0.2.sql and 3.1.1.sql. Can I delete the file 3.0.2?

[prke77]

I changed the prefix in the file 3.0.2.sql. Then I renamed name the file 3.0.2 to 3.1.1.sql. but it still reporting the same error.

[prke77]

Jan,
Thank you, resolved!

[Jan]

Ok