#28 Upgrading from 1.8 to 3.0 DB using Export / Import XML

[Tazzmeister]

when upgrading from an OLD database version { i.8 } to the latest version { upgraded to PHPRB 4.0b4 - create NEW DB with this install }
from my understanding - if I export the OLD databases to the XML format, i would be able to import them to the NEW DB thru the interface for the XML import option. I am receiving mysql errors and Missing Index in my apache error log.

==================================================================================================================
Starting import...
There was an error inserting the recipe
INSERT INTO recipe_recipes (recipe_name, recipe_ethnic, recipe_base, recipe_course, recipe_prep_time, recipe_difficulty, recipe_directions, recipe_comments, recipe_serving_size, recipe_source, recipe_source_desc, recipe_modified, recipe_system, recipe_private, recipe_user) VALUES ('3-Cheese Garden Pizza', 1, 7, 6, NULL, 1, 'Preheat oven to 400F. Roll out pizza crust into a 14-inch circle on 15; Baking Stone using lightly floured Dough and Pizza Roller. Bake crust 5-7 minutes or until lightly browned; remove from oven. Finely slice tomato, zucchini and onion using Vario-Slicer. Slice mushrooms using Egg Slicer Plus. Spread garlic over crust. Sprinkle crust with mozzarella and cheddar cheeses; top with tomatoes. Sprinkle with seasoning. Layer zucchini, onion and mushrooms over tomatoes. Grate Paresan cheese over top. Bake 15-18 minutes or until golden brown and bubbly. Cut with Pizza Cutter. ', '', 8, The Pampered Chef, '', '2013-02-17', 'usa', '0', '2')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Pampered Chef, '', '2013-02-17', 'usa', '0', ' at line 27
There was an error adding the ingredient
INSERT INTO recipe_ingredients (ingredient_core, ingredient_name, ingredient_desc, ingredient_unit, ingredient_location, ingredient_solid, ingredient_system, ingredient_user) VALUES ('NULL', '(10 ounces) refrigerated pizza crust', '', , 15, '1', 'usa', '2')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 15, '1', 'usa', '2')' at line 14
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 0, '', 1, , 'FALSE', 0)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'FALSE', 0)' at line 14
There was an error adding the ingredient
INSERT INTO recipe_ingredients (ingredient_core, ingredient_name, ingredient_desc, ingredient_unit, ingredient_location, ingredient_solid, ingredient_system, ingredient_user) VALUES ('NULL', 'medium tomato, sliced', '', , 36, '1', 'usa', '2')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 36, '1', 'usa', '2')' at line 14
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 0, '', 1, , 'FALSE', 1)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'FALSE', 1)' at line 14
There was an error adding the ingredient
INSERT INTO recipe_ingredients (ingredient_core, ingredient_name, ingredient_desc, ingredient_unit, ingredient_location, ingredient_solid, ingredient_system, ingredient_user) VALUES ('NULL', 'medium zucchin, sliced', '', , 36, '1', 'usa', '2')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 36, '1', 'usa', '2')' at line 14
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 0, '', 1, , 'FALSE', 2)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'FALSE', 2)' at line 14
There was an error adding the ingredient
INSERT INTO recipe_ingredients (ingredient_core, ingredient_name, ingredient_desc, ingredient_unit, ingredient_location, ingredient_solid, ingredient_system, ingredient_user) VALUES ('NULL', 'small onion, sliced', '', , 36, '1', 'usa', '2')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 36, '1', 'usa', '2')' at line 14
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 0, '', 1, , 'FALSE', 3)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'FALSE', 3)' at line 14
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 147, '', 1, 11, 'FALSE', 4)
Duplicate entry '147-0' for key 'PRIMARY'
There was an error adding the ingredient
INSERT INTO recipe_ingredients (ingredient_core, ingredient_name, ingredient_desc, ingredient_unit, ingredient_location, ingredient_solid, ingredient_system, ingredient_user) VALUES ('NULL', 'garlic cloves, pressed', '', , 36, '1', 'usa', '2')
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 36, '1', 'usa', '2')' at line 14
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 0, '', 2, , 'FALSE', 5)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'FALSE', 5)' at line 14
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 148, '', 1, 11, 'FALSE', 6)
Duplicate entry '148-0' for key 'PRIMARY'
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 149, '', 1, 11, 'FALSE', 7)
Duplicate entry '149-0' for key 'PRIMARY'
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 150, '', 1, 13, 'FALSE', 8)
Duplicate entry '150-0' for key 'PRIMARY'
There was an error adding the ingredient/recipe mapping
INSERT INTO recipe_ingredient_mapping (map_recipe, map_ingredient, map_qualifier, map_quantity, map_unit, map_optional, map_order) VALUES (0, 151, '', 0.25, 11, 'FALSE', 9)
Duplicate entry '151-0' for key 'PRIMARY'
Importing complete

====================================================================================================================
[Sun Feb 17 16:59:32 2013] [error] [client 192.168.1.6] PHP Notice: Undefined offset: 26 in /var/www/phpRB.old/modules/recipes/index.php on line 31, referer: http://sys76/pages/buttons3.html
[Sun Feb 17 16:59:47 2013] [error] [client 192.168.1.6] PHP Notice: Undefined index: 0-10 Minutes in /var/www/phprecipebook-4.0b4/classes/Import_XML.class.php on line 73, referer: http://sys76/phprecipebook-4.0b4/index.php?m=recipes&a=import
[Sun Feb 17 16:59:47 2013] [error] [client 192.168.1.6] PHP Notice: Undefined index: in /var/www/phprecipebook-4.0b4/classes/Import_XML.class.php on line 74, referer: http://sys76/phprecipebook-4.0b4/index.php?m=recipes&a=import
[Sun Feb 17 16:59:47 2013] [error] [client 192.168.1.6] PHP Notice: Undefined index: Pkg in /var/www/phprecipebook-4.0b4/classes/Import_XML.class.php on line 64, referer: http://sys76/phprecipebook-4.0b4/index.php?m=recipes&a=import
[Sun Feb 17 16:59:47 2013] [error] [client 192.168.1.6] PHP Notice: Undefined index: Each in /var/www/phprecipebook-4.0b4/classes/Import_XML.class.php on line 64, referer: http://sys76/phprecipebook-4.0b4/index.php?m=recipes&a=import
[Sun Feb 17 16:59:47 2013] [error] [client 192.168.1.6] PHP Notice: Undefined index: Each in /var/www/phprecipebook-4.0b4/classes/Import_XML.class.php on line 64, referer: http://sys76/phprecipebook-4.0b4/index.php?m=recipes&a=import
[Sun Feb 17 16:59:47 2013] [error] [client 192.168.1.6] PHP Notice: Undefined index: Each in /var/www/phprecipebook-4.0b4/classes/Import_XML.class.php on line 64, referer: http://sys76/phprecipebook-4.0b4/index.php?m=recipes&a=import
[Sun Feb 17 16:59:47 2013] [error] [client 192.168.1.6] PHP Notice: Undefined index: Each in /var/www/phprecipebook-4.0b4/classes/Import_XML.class.php on line 64, referer: http://sys76/phprecipebook-4.0b4/index.php?m=recipes&a=import
[Sun Feb 17 16:59:47 2013] [error] [client 192.168.1.6] PHP Notice: Undefined index: Dry Goods in /var/www/phprecipebook-4.0b4/classes/Import_XML.class.php on line 60, referer: http://sys76/phprecipebook-4.0b4/index.php?m=recipes&a=import
karl@system76:/var/log/apache2$

=======================================================================================================================
thank you

Karl

kbirkland at gmail dot com