B-4B the projectbuilder

Error Message in K2: TableK2Item: :store failed Unknown column 'language' in 'field list' SQL=UPDATE `jos17_k2_items`

Well the problem is that K2 writes one more table in the K2_categorie and K2_items tables and its called language now this table is missing in your database. This can happend when you make a fresh install of a joomla and then a fresh install of your K2, probally you made a dump from your old K2 tables into your new one that can couse a problem becouse now the language fields are missing. Also this can happen when you make a Update from J 1.5 to j 1.6 or j1.7 usally the k2 dont get updatet. You will not be able to store your items becouse of the error.

Thats how you can fix it!

Go in to your PHP My Admin  and open your MySql Database look for them 2 tables they look like that:

jos17_k2_categories, and jos17_k2_items

Now for the first go into k2_categories:

Insert this table: FIELD:language TYPE:char(7) COLLATION:utf8_general_ci ATTRIBUTES:---blank--- NULL: No DEFAULT: None EXTRA: ---blank---

Then Insert this index:

Now go in k2_items and insert:

Insert a new Field: FIELD:language TYPE:char(7) COLLATION:utf8_general_ci ATTRIBUTES:---blank--- NULL: No DEFAULT: None EXTRA: ---blank---

now insert a index in k2_items:

You can also use a simple db SQL query that inserts this column into the K2 categories and item tables:

ALTER TABLE `jos17_k2_categories` ADD `language` CHAR( 7 ) NOT NULL DEFAULT 'None', ADD INDEX ( `language` );

We testet it couple times and works very fine, so we hope we could help you with that!

Thanks your team b-4b.com