Migration from Joomla 1.5 and CP 1.98

  • webfeuerflo
  • Autore della discussione
  • Offline
  • Nuovo Utente
  • Nuovo Utente
Di più
9 Anni 9 Mesi fa - 9 Anni 9 Mesi fa #1941 da webfeuerflo
Migration from Joomla 1.5 and CP 1.98 è stato creato da 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!
Ultima Modifica 9 Anni 9 Mesi fa da webfeuerflo.

Si prega Accesso o Crea un account a partecipare alla conversazione.

Di più
9 Anni 9 Mesi fa #1943 da andrea_4g
Risposta da andrea_4g al 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:
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.

Si prega Accesso o Crea un account a partecipare alla conversazione.

  • webfeuerflo
  • Autore della discussione
  • Offline
  • Nuovo Utente
  • Nuovo Utente
Di più
9 Anni 9 Mesi fa #1944 da webfeuerflo
Risposta da webfeuerflo al 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!

Si prega Accesso o Crea un account a partecipare alla conversazione.

Di più
9 Anni 9 Mesi fa #1945 da andrea_4g
Risposta da andrea_4g al topic Migration from Joomla 1.5 and CP 1.98
That worked in the past, in similar circumstances.

Si prega Accesso o Crea un account a partecipare alla conversazione.

  • webfeuerflo
  • Autore della discussione
  • Offline
  • Nuovo Utente
  • Nuovo Utente
Di più
9 Anni 9 Mesi fa #1946 da webfeuerflo
Risposta da webfeuerflo al 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

Si prega Accesso o Crea un account a partecipare alla conversazione.

  • webfeuerflo
  • Autore della discussione
  • Offline
  • Nuovo Utente
  • Nuovo Utente
Di più
9 Anni 9 Mesi fa #1947 da webfeuerflo
Risposta da webfeuerflo al 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...

Si prega Accesso o Crea un account a partecipare alla conversazione.

Tempo creazione pagina: 0.177 secondi