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

[PeterM]

Hi Jan,

Thanks for the help. I had to manually add the column 'archived_description'

At first it didn't work because I got an error

Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

I did a query run >>>>
ALTER TABLE {table_name] ROW_FORMAT=DYNAMIC;

Then it worked.

Can you tell me why at first this above error occured? Was that the reason why the add column didn't work in the update process?

Thanks!