215 Posts
iliil
8 years ago
Topic

Hello!

 I'm geting this error when editing article after  SEBLOD 3.10 update  (both backend, frontend).

It seems that seblod update didn't create some columns in seblod tables.  

Can you please help me to fix this.

	1054 - Unknown column 'a.admin_form' in 'field list' SQL=SELECT a.id, 
a.title, a.name, a.description, a.admin_form, a.location, a.parent, 
a.storage_location, b.app as folder_app, a.options_admin, 
a.options_site, a.options_content, a.options_intro, a.template_admin, 
a.template_site, a.template_content, a.template_intro, a.stylesheets 
FROM #__cck_core_types AS a LEFT JOIN #__cck_core_folders AS b ON b.id =
 a.folder WHERE a.name ="event" AND a.published = 1

Thanks 

Michal

Get a VIP membership
4229 Posts
Kadministrator
8 years ago
1
Level 1

HI,

try installing seblod 3.10 again, seems upgrade sql was not executed for some reason. If this does not work, go to editor like mysqladmin, that allows editing your datatabase and manually execute query from administrator\components\com_cck\install\upgrades\3.10.0.sql - you need to replace #_ with your database prefix.

215 Posts
iliil
8 years ago
0
Level 2

Thank You, Klas.

39 Posts
jjnxpct
8 years ago
0
Level 1

I had the same issue on one of our sites using Seblod. Installing again did not help. Executing the mentioned mySQL queries did help. Thanks!

Get a VIP membership