Je n'arrive pas à exporter ma bdd de fsb1 à fsb2 avec le convertisseur.
Avec CV_OUTPUT_FILE quand j'importe le out.sql dans phpmyadmin j'ai une erreur arrivé ici :
Avec CV_OUTPUT_DB (les deux BDD étant sur le même serveur, chez free), arrivé à exportations des forums j'ai droit à la même erreur :
Je comprends pas trop...
Merci à vous si vous pouvez m'expliquer et m'aider à résoudre ce problème.
Edit : je pense qu'il y a des erreurs lors de la récupération des id des catégorie et des forums sur fsb1, ou lors de la création des requètes, mais je ne trouve pas où, j'ai pas l'habitude de chercher dans du code...
Citation
DELETE FROM fsb2_forums;
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('', 1, 20, '', '', '', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('3', 2, 3, '', '3', 'Présentation', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('3', 4, 5, '', '3', 'Tout et rien, Caté Blabla', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('3', 6, 7, '', '3', 'Soirées / Fêtes', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('3', 8, 9, '', '3', 'Informatique', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('3', 10, 11, '', '3', 'Jeux vidéos', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('3', 12, 13, '', '3', 'Deux roues', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('3', 14, 15, '', '3', 'Musique', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('3', 16, 17, '', '3', 'Idées, critiques.', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('3', 18, 19, '', '3', 'Poubelle', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('', 21, 28, '', '', '', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('4', 22, 23, '', '4', 'Règles générales', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('4', 24, 25, '', '4', 'Tutoriaux généraux', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
INSERT INTO fsb2_forums (f_id, f_left, f_right, f_rules, f_cat_id, f_name, f_text, f_parent, f_status, f_total_topic, f_total_post, f_last_p_id, f_level, f_prune_time, f_prune_topic_type, f_type, f_map_default, f_map_first_post, f_location, f_location_view, f_password, f_tpl, f_global_announce) VALUES ('4', 26, 27, '', '4', 'Nouveautés', '', 0, '', '', '', '', 0, '', '', 0, '', '', '', '', '', '', '');
Hors le premier chiffre qui correspond à l'id de la catégorie prend place à l'id du forum...
Si je le change et en met un différent pour chaque forum, en respectant ceux de l'ancien (pour retrouver les messages), ils sont pris comme des catégorie par fsb2 et mes anciennes catégorie ne sont pas là.