Unknown column 'cc.archived_description' in 'SELECT'

[PeterM]

Hi After updating to Version 6.1.2 I get this message 'Unknown column 'cc.archived_description' in 'SELECT'' in the frontend when I click on a category. Also when I check the maintenance of the database in the backend it shows one problem and it says that tabel 'bcr6k_phocadownload_categories' has no column 'archived_description'. (from file 6.1.2.sql.). I am running Joomla 5.4.7

[Jan]

Hi, check the files:
administrator/components/com_phocadownload/update/sql/mysql/6.1.2.sql
There should be this instruction:
ALTER TABLE `#__phocadownload_categories` ADD COLUMN `archived_description` TEXT AFTER `description`;

The same with:
administrator/components/com_phocadownload/install/sql/mysql/install.utf8.sql
`archived_description` text, should be included there.

If the update on your site didn't update this column, try to run it manually in your database:

ALTER TABLE `#__phocadownload_categories` ADD COLUMN `archived_description` TEXT AFTER `description`;

(change #__ to your prefix)

Jan