Column count doesn't match value count at row 1

More
11 years 9 months ago #842 by tfab
Hello,

try to migrate the properties from joomla 1.5.26 to joomla 2.5.4. I get this error:

"Column count doesn't match value count at row 1"

There is a new field "required" in the 2.0 version. How can i do the trick?

Greets
Thorsten

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago - 11 years 9 months ago #843 by andrea_4g
The most reliable procedure is this one:
solidsystem.it/how-to-and-tutorials/149-...es-to-joomla-17.html

Alternately you could add the missing rows manually with a SQL statement; it depends by the CP version you are migrating from:
Code:
// upgrade custom properties to 1.98 ALTER TABLE #__custom_properties DROP KEY `c_f_v`; ALTER TABLE #__custom_properties ADD `ref_table` VARCHAR(100) NOT NULL DEFAULT 'content' AFTER `id`; ALTER TABLE #__custom_properties ADD UNIQUE KEY `t_c_f_v` (`ref_table`,`content_id`,`field_id`,`value_id`); ALTER TABLE #__custom_properties ADD KEY `ref_table` (`ref_table`); // upgrade custom properties fields to 1.98 ALTER TABLE #__custom_properties_values ADD `priority` tinyint(4) NOT NULL DEFAULT '0' AFTER `label`; ALTER TABLE #__custom_properties_values ADD KEY `name` (`name`)"; ALTER TABLE #__custom_properties_values ADD KEY `priority` (`priority`); // upgrade custom properties fields to 1.99 ALTER TABLE #__custom_properties_values ADD `article_id` int(11) DEFAULT NULL; ALTER TABLE #__custom_properties_values ADD KEY `article_id` (`article_id`); // upgrade custom properties fields to 2.00 ALTER TABLE #__custom_properties_fields ADD `required` tinyint(1) NOT NULL default '0' AFTER `published`;

Note: replace '#_' with the correct table prefix.
Last edit: 11 years 9 months ago by andrea_4g.

Please Log in or Create an account to join the conversation.

More
11 years 9 months ago #845 by tfab
Thanks a lot!

Please Log in or Create an account to join the conversation.

Time to create page: 0.162 seconds