85 Posts
yuberlin
6 years ago
4
Topic

I'm trying to update seblod (Joomla 3.7.5 and Seblod 3.7.2) but whatever i do, i get this error message in frontend on a blank page:

Unknown column 'a.storage_cck' in 'field list'

Backend works fine. I already tried to update to seblod 3.8 and 3.9 first but no luck. 

Can somebody please help me how this database problem could be fixed? What table is it?

Get a Book for SEBLOD
4229 Posts
Kadministrator
6 years ago
0
Level 1

Hi,

before you upgrade try installing 3.7.2 over existing one again, then go in the small steps further - 3.8, 3.9 etc. And as always backup before so you can go back in case anything goes wrong.

85 Posts
yuberlin
6 years ago
1
Level 1

Its not working. I installed 3.7.2 again and then 3.8. After 3.8. installed i get the error message again in frontend. When Installation is finished ein get a error message in backend for plg_content_cck.zip.

4229 Posts
Kadministrator
6 years ago
0
Level 2

Than I'm afraid only way would be to install Seblod on some test installation, than compare your database structure with the one from new installation and add missing columns and indexes yourself.

6 years ago
0
Level 1

Hello yuberlin,

It seems that you already had an issue before 3.7.2.

You can try to run the following query (after changing the prefix):

ALTER TABLE `#__cck_core_fields` ADD `storage_cck` VARCHAR(50) NOT NULL AFTER `storage`;

It can be found in pkg_seblod_3.15.0.zip/extensions/com_cck.zip/admin/install/upgrades/3.6.5.sql

I would suggest to check the various queries from 3.6.5.sql to 3.7.2.sql and compare or run them manually via PhpMyAdmin.

Then you, you should try to update to SEBLOD 3.8.0 first.

Regards,
Saba

Get a Book for SEBLOD