- Posts: 4
- Thank you received: 0
Column count doesn't match value count at row 1
- tfab
- Topic Author
- Offline
- New Member
Less
More
12 years 4 months ago #842
by tfab
Column count doesn't match value count at row 1 was created 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
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.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
12 years 4 months ago - 12 years 4 months ago #843
by andrea_4g
Replied by andrea_4g on topic Re: Column count doesn't match value count at row 1
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:
Note: replace '#_' with the correct table prefix.
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: 12 years 4 months ago by andrea_4g.
Please Log in or Create an account to join the conversation.
- tfab
- Topic Author
- Offline
- New Member
Less
More
- Posts: 4
- Thank you received: 0
12 years 4 months ago #845
by tfab
Replied by tfab on topic Re: Column count doesn't match value count at row 1
Thanks a lot!
Please Log in or Create an account to join the conversation.
Time to create page: 0.166 seconds