- Posts: 12
- Thank you received: 0
Migration from Joomla 1.5 and CP 1.98
- webfeuerflo
- Topic Author
- Offline
- New Member
Less
More
10 years 3 months ago - 10 years 3 months ago #1941
by webfeuerflo
Migration from Joomla 1.5 and CP 1.98 was created by webfeuerflo
Hello,
I migrated a Joomla 1.5 Website with Custom Properties 1.98 to Joomla 3.3.3 an CP 3 with the help of the extension Migrate me. Now in Joomla 3 I see my old properties in the component and also in the articles. But when I try to create a menu item to the custom properties component I get the following error:
"1054 Unknown column 'f.required' in 'field list' SQL=SELECT f.id AS f_id, f.name AS f_name, f.label AS f_label, f.field_type, f.required, v.id AS v_id, v.name AS v_name, v.label AS v_label, v.`default`, CASE WHEN v.name = "" THEN 1 ELSE 0 END AS is_separator FROM jos_custom_properties_fields AS f INNER JOIN jos_custom_properties_values AS v ON (f.id = v.field_id ) WHERE v.id = 15 LIMIT 1"
and in the Search module "Component not configured: missing fields." and in the tag cloud module "Tags not found"
The migration component imported everything from the old db But it seems to have changed the prefix as I don't have anything with the original prefix in my new db.
Can you please help me to sort this out?
thank you!
I migrated a Joomla 1.5 Website with Custom Properties 1.98 to Joomla 3.3.3 an CP 3 with the help of the extension Migrate me. Now in Joomla 3 I see my old properties in the component and also in the articles. But when I try to create a menu item to the custom properties component I get the following error:
"1054 Unknown column 'f.required' in 'field list' SQL=SELECT f.id AS f_id, f.name AS f_name, f.label AS f_label, f.field_type, f.required, v.id AS v_id, v.name AS v_name, v.label AS v_label, v.`default`, CASE WHEN v.name = "" THEN 1 ELSE 0 END AS is_separator FROM jos_custom_properties_fields AS f INNER JOIN jos_custom_properties_values AS v ON (f.id = v.field_id ) WHERE v.id = 15 LIMIT 1"
and in the Search module "Component not configured: missing fields." and in the tag cloud module "Tags not found"
The migration component imported everything from the old db But it seems to have changed the prefix as I don't have anything with the original prefix in my new db.
Can you please help me to sort this out?
thank you!
Last edit: 10 years 3 months ago by webfeuerflo.
Please Log in or Create an account to join the conversation.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
10 years 3 months ago #1943
by andrea_4g
Replied by andrea_4g on topic Migration from Joomla 1.5 and CP 1.98
Foreword: I don't know how the 'Migrate me' extension works.
Apparently it copied the original table verbatim to the new database, which is not the totally right thing to do because newer versions of CP have a (slightly) different DB structure compared to older ones.
The following queries are meant to upgrade the existing table:
Please replace '#_' with the appropriate table prefix.
Apparently it copied the original table verbatim to the new database, which is not the totally right thing to do because newer versions of CP have a (slightly) different DB structure compared to older ones.
The following queries are meant to upgrade the existing table:
Code:
ALTER TABLE `#__custom_properties_fields` ADD COLUMN `modules` varchar(255) NOT NULL AFTER `field_type`;
/* 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`;
Please replace '#_' with the appropriate table prefix.
Please Log in or Create an account to join the conversation.
- webfeuerflo
- Topic Author
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
10 years 3 months ago #1944
by webfeuerflo
Replied by webfeuerflo on topic Migration from Joomla 1.5 and CP 1.98
you mean, if I make the following queries in my new joomla3 database, it should work with cp3? I will try that!
Please Log in or Create an account to join the conversation.
- andrea_4g
- Offline
- Administrator
Less
More
- Posts: 1122
- Thank you received: 163
10 years 3 months ago #1945
by andrea_4g
Replied by andrea_4g on topic Migration from Joomla 1.5 and CP 1.98
That worked in the past, in similar circumstances.
Please Log in or Create an account to join the conversation.
- webfeuerflo
- Topic Author
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
10 years 3 months ago #1946
by webfeuerflo
Replied by webfeuerflo on topic Migration from Joomla 1.5 and CP 1.98
ok, here are the errors to each query:
ALTER TABLE `#__custom_properties_fields` ADD COLUMN `modules` varchar(255) NOT NULL AFTER `field_type`;
--> #1060 - Duplicate column name 'modules'
ALTER TABLE #__custom_properties DROP KEY `c_f_v`; --> #1091 - Can't DROP 'c_f_v';
--> #1091 - Can't DROP 'c_f_v'; check that column/key exists
ALTER TABLE #__custom_properties ADD `ref_table` VARCHAR(100) NOT NULL DEFAULT 'content' AFTER `id`;
--> #1060 - Duplicate column name 'ref_table'
ALTER TABLE #__custom_properties ADD UNIQUE KEY `t_c_f_v` (`ref_table`,`content_id`,`field_id`,`value_id`);
--> #1061 - Duplicate key name 't_c_f_v'
ALTER TABLE #__custom_properties ADD KEY `ref_table` (`ref_table`);
--> #1061 - Duplicate key name 'ref_table'
/* upgrade custom properties fields to 1.98 */
ALTER TABLE #__custom_properties_values ADD `priority` tinyint(4) NOT NULL DEFAULT '0' AFTER `label`;
--> #1060 - Duplicate column name 'priority'
ALTER TABLE #__custom_properties_values ADD KEY `name` (`name`);
--> #1061 - Duplicate key name 'name'
ALTER TABLE #__custom_properties_values ADD KEY `priority` (`priority`);
--> #1061 - Duplicate key name 'priority'
/* upgrade custom properties fields to 1.99 */
ALTER TABLE #__custom_properties_values ADD `article_id` int(11) DEFAULT NULL ;
--> success
ALTER TABLE #__custom_properties_values ADD KEY `article_id` (`article_id`);
--> success
/* upgrade custom properties fields to 2.00 */
ALTER TABLE #__custom_properties_fields ADD `required` tinyint(1) NOT NULL default '0' AFTER `published`;
--> success
now the error on the menu item is gone, but the errors in the modules remain:
search module: Component not configured: missing fields.
tags cloud: Tags not found
ALTER TABLE `#__custom_properties_fields` ADD COLUMN `modules` varchar(255) NOT NULL AFTER `field_type`;
--> #1060 - Duplicate column name 'modules'
ALTER TABLE #__custom_properties DROP KEY `c_f_v`; --> #1091 - Can't DROP 'c_f_v';
--> #1091 - Can't DROP 'c_f_v'; check that column/key exists
ALTER TABLE #__custom_properties ADD `ref_table` VARCHAR(100) NOT NULL DEFAULT 'content' AFTER `id`;
--> #1060 - Duplicate column name 'ref_table'
ALTER TABLE #__custom_properties ADD UNIQUE KEY `t_c_f_v` (`ref_table`,`content_id`,`field_id`,`value_id`);
--> #1061 - Duplicate key name 't_c_f_v'
ALTER TABLE #__custom_properties ADD KEY `ref_table` (`ref_table`);
--> #1061 - Duplicate key name 'ref_table'
/* upgrade custom properties fields to 1.98 */
ALTER TABLE #__custom_properties_values ADD `priority` tinyint(4) NOT NULL DEFAULT '0' AFTER `label`;
--> #1060 - Duplicate column name 'priority'
ALTER TABLE #__custom_properties_values ADD KEY `name` (`name`);
--> #1061 - Duplicate key name 'name'
ALTER TABLE #__custom_properties_values ADD KEY `priority` (`priority`);
--> #1061 - Duplicate key name 'priority'
/* upgrade custom properties fields to 1.99 */
ALTER TABLE #__custom_properties_values ADD `article_id` int(11) DEFAULT NULL ;
--> success
ALTER TABLE #__custom_properties_values ADD KEY `article_id` (`article_id`);
--> success
/* upgrade custom properties fields to 2.00 */
ALTER TABLE #__custom_properties_fields ADD `required` tinyint(1) NOT NULL default '0' AFTER `published`;
--> success
now the error on the menu item is gone, but the errors in the modules remain:
search module: Component not configured: missing fields.
tags cloud: Tags not found
Please Log in or Create an account to join the conversation.
- webfeuerflo
- Topic Author
- Offline
- New Member
Less
More
- Posts: 12
- Thank you received: 0
10 years 3 months ago #1947
by webfeuerflo
Replied by webfeuerflo on topic Migration from Joomla 1.5 and CP 1.98
also the properties are not shown in the articles although the plugin is activated and I can see the properties when I edit an article...
Please Log in or Create an account to join the conversation.
Time to create page: 0.182 seconds