Fixing SQL Import Script Errors

From JFTSE Wiki
Jump to navigation Jump to search

Fixing SQL Import Script Errors

Overview

When running the `import_sql.sh` script to import SQL files into the database, you might encounter errors related to missing `Guardian` and `BossGuardian` entries.

This happens because certain event maps reference Guardian entries that do not exist in the default SQL files provided by JFTSE. These missing definitions are a result of JFTSE-specific configurations that differ from the original Fantasy Tennis setup.

How to Fix

There are two ways to resolve this issue:

1. Modifying SQL Files Before Import

If the import fails due to missing Guardian entries, you can manually edit the affected SQL files.

Steps:

  1. Open the SQL file that failed during the import.
  2. Locate and remove any `INSERT` statements that reference missing Guardian or BossGuardian entries.
  3. Save the file and delete any partial entries from the database that were created before the failure.
  4. Re-run the `import_sql.sh` script to import the cleaned SQL files.

This approach prevents invalid data from being inserted and ensures the script runs smoothly.

2. Adding Missing Entries Manually

If you prefer to retain all Guardian entries referenced in the event maps, you can manually add the missing records to the database. Below are the required `INSERT` statements for Guardian and BossGuardian entries: If you choose this method, make sure to restart the SQL import after executing these statements.

Missing Guardian and BossGuardian entries

-- Additional Guardian entries for event maps
INSERT INTO fantasytennis.Guardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(73, 1, 8, 1, 1, 165, 45, 110, 120, 26, 15000, 55, 50, 'No. 1', 200, 200, 6, 61, 0, 9, 0, 1, 0);
INSERT INTO fantasytennis.Guardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(74, 1, 8, 1, 1, 165, 45, 110, 120, 26, 15000, 55, 50, 'No. 2', 225, 225, 6, 62, 0, 9, 0, 1, 0);
INSERT INTO fantasytennis.Guardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(75, 1, 8, 1, 1, 165, 45, 110, 120, 26, 15000, 55, 50, 'No. 3', 250, 250, 6, 63, 0, 9, 0, 1, 0);
INSERT INTO fantasytennis.Guardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(76, 1, 8, 1, 1, 200, 75, 150, 105, 26, 24000, 500, 50, 'No. 4', 475, 600, 20, 64, 0, 9, 0, 1, 0);
INSERT INTO fantasytennis.Guardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(77, 1, 8, 1, 1, 200, 75, 150, 100, 26, 24000, 500, 50, 'No. 5', 500, 600, 20, 65, 0, 9, 0, 1, 0);
INSERT INTO fantasytennis.Guardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(78, 1, 8, 1, 1, 200, 75, 150, 100, 26, 24000, 500, 50, 'No. 6', 525, 600, 20, 66, 1, 9, 0, 1, 0);
INSERT INTO fantasytennis.Guardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(79, 1, 8, 1, 1, 165, 45, 110, 120, 10, 15000, 55, 46, 'Aquara', 275, 275, 6, 34, 0, 9, 0, 0, 1);
INSERT INTO fantasytennis.Guardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(80, 1, 8, 1, 1, 165, 45, 110, 120, 9, 15000, 55, 44, 'Moora', 325, 360, 6, 33, 0, 9, 0, 0, 1);

-- Additional BossGuardian entries for event maps
INSERT INTO fantasytennis.BossGuardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(8, 1, 15, 1, 1, 165, 60, 150, 120, 23, 20000, 200, 60, 'Hera', 500, 375, 34, 3, 0, 9, 1, 1, 1);
INSERT INTO fantasytennis.BossGuardian (id, addDex, addSta, addStr, addWill, baseDex, baseSta, baseStr, baseWill, btItemID, hpBase, hpPer, `level`, name, rewardExp, rewardGold, rewardRankingPoint, guardIndex, earth, elementGrade, fire, water, wind) VALUES(9, 1, 15, 1, 1, 220, 80, 160, 120, 27, 24000, 500, 60, 'TB-255', 2000, 1500, 60, 6, 1, 9, 1, 0, 1);

Fix existing Guardian and BossGuardian entries

Some existing Guardian and BossGuardian records might be missing important attributes like `rewardExp`, `rewardGold`, or `guardIndex`. These entries can be corrected with the following `UPDATE` statements: 

-- Fix Guardian entries for rest since they miss rewardExp,rewardGold and guardIndex
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=10, baseSta=1, baseStr=10, baseWill=30, btItemID=1, hpBase=500, hpPer=1, `level`=10, name='Dokaro', rewardExp=11, rewardGold=16, rewardRankingPoint=0, guardIndex=1, earth=0, elementGrade=2, fire=0, water=0, wind=0 WHERE id=1;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=12, baseSta=1, baseStr=13, baseWill=32, btItemID=1, hpBase=550, hpPer=1, `level`=15, name='Penkaro', rewardExp=11, rewardGold=16, rewardRankingPoint=0, guardIndex=2, earth=0, elementGrade=2, fire=0, water=0, wind=0 WHERE id=2;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=14, baseSta=1, baseStr=16, baseWill=34, btItemID=1, hpBase=600, hpPer=1, `level`=20, name='Bekaro', rewardExp=12, rewardGold=17, rewardRankingPoint=0, guardIndex=3, earth=0, elementGrade=2, fire=0, water=0, wind=0 WHERE id=3;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=16, baseSta=1, baseStr=19, baseWill=36, btItemID=1, hpBase=650, hpPer=1, `level`=25, name='Hokaro', rewardExp=12, rewardGold=17, rewardRankingPoint=0, guardIndex=4, earth=0, elementGrade=2, fire=0, water=0, wind=0 WHERE id=4;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=18, baseSta=1, baseStr=22, baseWill=38, btItemID=1, hpBase=700, hpPer=1, `level`=30, name='Sikaro', rewardExp=12, rewardGold=18, rewardRankingPoint=0, guardIndex=5, earth=0, elementGrade=2, fire=0, water=0, wind=0 WHERE id=5;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=20, baseSta=1, baseStr=25, baseWill=40, btItemID=1, hpBase=750, hpPer=1, `level`=40, name='Ikaro', rewardExp=13, rewardGold=18, rewardRankingPoint=0, guardIndex=6, earth=1, elementGrade=2, fire=1, water=0, wind=0 WHERE id=6;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=5, addStr=1, addWill=1, baseDex=10, baseSta=1, baseStr=14, baseWill=35, btItemID=2, hpBase=650, hpPer=6, `level`=20, name='Doteko', rewardExp=14, rewardGold=19, rewardRankingPoint=0, guardIndex=7, earth=0, elementGrade=3, fire=0, water=0, wind=0 WHERE id=7;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=5, addStr=1, addWill=1, baseDex=12, baseSta=1, baseStr=17, baseWill=37, btItemID=2, hpBase=700, hpPer=6, `level`=25, name='Penteko', rewardExp=16, rewardGold=19, rewardRankingPoint=0, guardIndex=8, earth=0, elementGrade=3, fire=0, water=0, wind=0 WHERE id=8;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=5, addStr=1, addWill=1, baseDex=14, baseSta=1, baseStr=20, baseWill=39, btItemID=2, hpBase=750, hpPer=6, `level`=30, name='Beteko', rewardExp=16, rewardGold=21, rewardRankingPoint=0, guardIndex=9, earth=0, elementGrade=3, fire=0, water=0, wind=0 WHERE id=9;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=5, addStr=1, addWill=1, baseDex=16, baseSta=1, baseStr=23, baseWill=41, btItemID=2, hpBase=800, hpPer=6, `level`=35, name='Hoteko', rewardExp=16, rewardGold=21, rewardRankingPoint=0, guardIndex=10, earth=0, elementGrade=3, fire=0, water=0, wind=0 WHERE id=10;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=6, addStr=1, addWill=1, baseDex=18, baseSta=1, baseStr=26, baseWill=43, btItemID=2, hpBase=850, hpPer=6, `level`=40, name='Siteko', rewardExp=18, rewardGold=22, rewardRankingPoint=0, guardIndex=11, earth=0, elementGrade=3, fire=0, water=0, wind=0 WHERE id=11;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=6, addStr=1, addWill=1, baseDex=20, baseSta=1, baseStr=29, baseWill=45, btItemID=2, hpBase=900, hpPer=6, `level`=45, name='Eteko', rewardExp=19, rewardGold=22, rewardRankingPoint=0, guardIndex=12, earth=0, elementGrade=3, fire=1, water=0, wind=1 WHERE id=12;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=6, addStr=1, addWill=1, baseDex=15, baseSta=1, baseStr=25, baseWill=40, btItemID=3, hpBase=800, hpPer=7, `level`=25, name='Doga', rewardExp=27, rewardGold=37, rewardRankingPoint=2, guardIndex=13, earth=0, elementGrade=4, fire=0, water=1, wind=0 WHERE id=13;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=6, addStr=1, addWill=1, baseDex=17, baseSta=1, baseStr=30, baseWill=42, btItemID=3, hpBase=850, hpPer=7, `level`=30, name='Penga', rewardExp=27, rewardGold=39, rewardRankingPoint=2, guardIndex=14, earth=0, elementGrade=4, fire=0, water=1, wind=0 WHERE id=14;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=6, addStr=1, addWill=1, baseDex=19, baseSta=1, baseStr=35, baseWill=44, btItemID=3, hpBase=900, hpPer=7, `level`=35, name='Bega', rewardExp=28, rewardGold=39, rewardRankingPoint=2, guardIndex=15, earth=0, elementGrade=4, fire=0, water=1, wind=0 WHERE id=15;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=6, addStr=1, addWill=1, baseDex=21, baseSta=1, baseStr=40, baseWill=46, btItemID=3, hpBase=950, hpPer=7, `level`=40, name='Hoga', rewardExp=29, rewardGold=43, rewardRankingPoint=2, guardIndex=16, earth=0, elementGrade=4, fire=0, water=1, wind=0 WHERE id=16;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=6, addStr=1, addWill=1, baseDex=23, baseSta=1, baseStr=45, baseWill=48, btItemID=3, hpBase=1000, hpPer=7, `level`=45, name='Siga', rewardExp=30, rewardGold=43, rewardRankingPoint=2, guardIndex=17, earth=0, elementGrade=4, fire=0, water=1, wind=0 WHERE id=17;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=6, addStr=1, addWill=1, baseDex=25, baseSta=1, baseStr=50, baseWill=50, btItemID=3, hpBase=1050, hpPer=7, `level`=50, name='Ega', rewardExp=31, rewardGold=45, rewardRankingPoint=2, guardIndex=18, earth=1, elementGrade=4, fire=0, water=1, wind=0 WHERE id=18;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=50, baseSta=5, baseStr=30, baseWill=45, btItemID=4, hpBase=1200, hpPer=30, `level`=40, name='Dogoliath', rewardExp=55, rewardGold=70, rewardRankingPoint=4, guardIndex=19, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=19;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=55, baseSta=5, baseStr=35, baseWill=48, btItemID=4, hpBase=1350, hpPer=30, `level`=42, name='Pengoliath', rewardExp=60, rewardGold=75, rewardRankingPoint=4, guardIndex=20, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=20;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=60, baseSta=5, baseStr=40, baseWill=51, btItemID=4, hpBase=1500, hpPer=30, `level`=44, name='Begoliath', rewardExp=65, rewardGold=80, rewardRankingPoint=4, guardIndex=21, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=21;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=65, baseSta=5, baseStr=45, baseWill=54, btItemID=4, hpBase=1650, hpPer=30, `level`=46, name='Hogoliath', rewardExp=70, rewardGold=85, rewardRankingPoint=4, guardIndex=22, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=22;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=70, baseSta=5, baseStr=50, baseWill=57, btItemID=19, hpBase=1800, hpPer=30, `level`=48, name='Sigoliath', rewardExp=75, rewardGold=90, rewardRankingPoint=4, guardIndex=23, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=23;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=75, baseSta=5, baseStr=55, baseWill=60, btItemID=19, hpBase=1950, hpPer=30, `level`=50, name='Egoliath', rewardExp=85, rewardGold=92, rewardRankingPoint=4, guardIndex=24, earth=1, elementGrade=5, fire=0, water=0, wind=1 WHERE id=24;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=55, baseSta=10, baseStr=30, baseWill=45, btItemID=5, hpBase=2150, hpPer=50, `level`=40, name='Doblood', rewardExp=60, rewardGold=70, rewardRankingPoint=5, guardIndex=25, earth=0, elementGrade=6, fire=1, water=0, wind=0 WHERE id=25;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=60, baseSta=10, baseStr=35, baseWill=48, btItemID=5, hpBase=2300, hpPer=50, `level`=42, name='Penblood', rewardExp=65, rewardGold=75, rewardRankingPoint=5, guardIndex=26, earth=0, elementGrade=6, fire=1, water=0, wind=0 WHERE id=26;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=65, baseSta=10, baseStr=40, baseWill=51, btItemID=5, hpBase=2450, hpPer=50, `level`=44, name='Beblood', rewardExp=70, rewardGold=80, rewardRankingPoint=5, guardIndex=27, earth=0, elementGrade=6, fire=1, water=0, wind=0 WHERE id=27;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=70, baseSta=10, baseStr=45, baseWill=54, btItemID=5, hpBase=2600, hpPer=50, `level`=46, name='Hoblood', rewardExp=75, rewardGold=85, rewardRankingPoint=5, guardIndex=28, earth=0, elementGrade=6, fire=1, water=0, wind=0 WHERE id=28;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=75, baseSta=10, baseStr=50, baseWill=57, btItemID=5, hpBase=2750, hpPer=50, `level`=48, name='Siblood', rewardExp=80, rewardGold=90, rewardRankingPoint=5, guardIndex=29, earth=0, elementGrade=6, fire=1, water=0, wind=0 WHERE id=29;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=80, baseSta=10, baseStr=55, baseWill=60, btItemID=5, hpBase=2900, hpPer=50, `level`=50, name='Iblood', rewardExp=85, rewardGold=95, rewardRankingPoint=5, guardIndex=30, earth=0, elementGrade=6, fire=1, water=0, wind=1 WHERE id=30;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=55, baseSta=10, baseStr=30, baseWill=45, btItemID=7, hpBase=2650, hpPer=55, `level`=40, name='Windra', rewardExp=60, rewardGold=75, rewardRankingPoint=6, guardIndex=31, earth=0, elementGrade=7, fire=0, water=0, wind=1 WHERE id=31;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=60, baseSta=10, baseStr=35, baseWill=48, btItemID=8, hpBase=2800, hpPer=55, `level`=42, name='Earthra', rewardExp=65, rewardGold=80, rewardRankingPoint=6, guardIndex=32, earth=0, elementGrade=7, fire=0, water=0, wind=1 WHERE id=32;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=65, baseSta=10, baseStr=40, baseWill=51, btItemID=9, hpBase=2950, hpPer=55, `level`=44, name='Moora', rewardExp=70, rewardGold=85, rewardRankingPoint=6, guardIndex=33, earth=0, elementGrade=7, fire=0, water=0, wind=1 WHERE id=33;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=70, baseSta=10, baseStr=45, baseWill=54, btItemID=10, hpBase=3100, hpPer=55, `level`=46, name='Aquara', rewardExp=75, rewardGold=90, rewardRankingPoint=6, guardIndex=34, earth=0, elementGrade=7, fire=0, water=0, wind=1 WHERE id=34;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=75, baseSta=10, baseStr=50, baseWill=57, btItemID=11, hpBase=3250, hpPer=55, `level`=48, name='Fyra', rewardExp=80, rewardGold=95, rewardRankingPoint=6, guardIndex=35, earth=0, elementGrade=7, fire=0, water=0, wind=1 WHERE id=35;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=80, baseSta=10, baseStr=55, baseWill=60, btItemID=12, hpBase=3400, hpPer=55, `level`=50, name='Thundera', rewardExp=85, rewardGold=100, rewardRankingPoint=6, guardIndex=36, earth=0, elementGrade=7, fire=1, water=0, wind=1 WHERE id=36;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=10, addStr=1, addWill=1, baseDex=55, baseSta=10, baseStr=30, baseWill=45, btItemID=5, hpBase=4150, hpPer=60, `level`=45, name='DevilDokaro', rewardExp=80, rewardGold=85, rewardRankingPoint=3, guardIndex=37, earth=0, elementGrade=8, fire=1, water=0, wind=1 WHERE id=37;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=10, addStr=1, addWill=1, baseDex=60, baseSta=10, baseStr=35, baseWill=48, btItemID=5, hpBase=4300, hpPer=60, `level`=46, name='DevilPenkaro', rewardExp=85, rewardGold=90, rewardRankingPoint=3, guardIndex=38, earth=0, elementGrade=8, fire=1, water=0, wind=1 WHERE id=38;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=10, addStr=1, addWill=1, baseDex=65, baseSta=10, baseStr=40, baseWill=51, btItemID=5, hpBase=4450, hpPer=60, `level`=47, name='DevilBekaro', rewardExp=90, rewardGold=95, rewardRankingPoint=3, guardIndex=39, earth=0, elementGrade=8, fire=1, water=0, wind=1 WHERE id=39;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=10, addStr=1, addWill=1, baseDex=70, baseSta=10, baseStr=45, baseWill=54, btItemID=5, hpBase=4600, hpPer=60, `level`=48, name='DevilHokaro', rewardExp=95, rewardGold=100, rewardRankingPoint=3, guardIndex=40, earth=0, elementGrade=8, fire=1, water=0, wind=1 WHERE id=40;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=10, addStr=1, addWill=1, baseDex=75, baseSta=10, baseStr=50, baseWill=57, btItemID=5, hpBase=4750, hpPer=60, `level`=49, name='DevilSikaro', rewardExp=100, rewardGold=105, rewardRankingPoint=3, guardIndex=41, earth=0, elementGrade=8, fire=1, water=0, wind=1 WHERE id=41;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=10, addStr=1, addWill=1, baseDex=80, baseSta=10, baseStr=55, baseWill=60, btItemID=5, hpBase=4900, hpPer=60, `level`=50, name='DevilIkaro', rewardExp=105, rewardGold=110, rewardRankingPoint=3, guardIndex=42, earth=0, elementGrade=8, fire=1, water=0, wind=1 WHERE id=42;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=55, baseSta=10, baseStr=30, baseWill=45, btItemID=13, hpBase=2650, hpPer=55, `level`=50, name='Dolizard', rewardExp=65, rewardGold=90, rewardRankingPoint=8, guardIndex=43, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=43;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=60, baseSta=10, baseStr=35, baseWill=48, btItemID=14, hpBase=2800, hpPer=55, `level`=50, name='Penlizard', rewardExp=65, rewardGold=95, rewardRankingPoint=8, guardIndex=44, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=44;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=65, baseSta=10, baseStr=40, baseWill=51, btItemID=15, hpBase=2950, hpPer=55, `level`=50, name='Belizard', rewardExp=70, rewardGold=100, rewardRankingPoint=8, guardIndex=45, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=45;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=70, baseSta=10, baseStr=45, baseWill=54, btItemID=16, hpBase=3100, hpPer=55, `level`=50, name='Holizard', rewardExp=70, rewardGold=105, rewardRankingPoint=8, guardIndex=46, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=46;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=75, baseSta=10, baseStr=50, baseWill=57, btItemID=17, hpBase=3250, hpPer=55, `level`=50, name='Silizard', rewardExp=80, rewardGold=110, rewardRankingPoint=8, guardIndex=47, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=47;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=80, baseSta=10, baseStr=55, baseWill=60, btItemID=18, hpBase=3400, hpPer=55, `level`=50, name='Elizard', rewardExp=90, rewardGold=120, rewardRankingPoint=8, guardIndex=48, earth=1, elementGrade=9, fire=0, water=1, wind=0 WHERE id=48;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=50, baseSta=5, baseStr=30, baseWill=45, btItemID=21, hpBase=1200, hpPer=30, `level`=40, name='Dotossakan', rewardExp=55, rewardGold=65, rewardRankingPoint=4, guardIndex=49, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=49;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=55, baseSta=5, baseStr=35, baseWill=48, btItemID=21, hpBase=1350, hpPer=30, `level`=42, name='Pantossakan', rewardExp=60, rewardGold=65, rewardRankingPoint=4, guardIndex=50, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=50;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=60, baseSta=5, baseStr=40, baseWill=51, btItemID=21, hpBase=1500, hpPer=30, `level`=44, name='Betossakan', rewardExp=65, rewardGold=75, rewardRankingPoint=4, guardIndex=51, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=51;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=65, baseSta=5, baseStr=45, baseWill=54, btItemID=21, hpBase=1650, hpPer=30, `level`=46, name='Hotossakan', rewardExp=70, rewardGold=75, rewardRankingPoint=4, guardIndex=52, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=52;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=70, baseSta=5, baseStr=50, baseWill=57, btItemID=22, hpBase=1800, hpPer=30, `level`=48, name='Sitossakan', rewardExp=75, rewardGold=75, rewardRankingPoint=4, guardIndex=53, earth=1, elementGrade=5, fire=0, water=0, wind=0 WHERE id=53;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=7, addStr=1, addWill=1, baseDex=75, baseSta=5, baseStr=55, baseWill=60, btItemID=22, hpBase=1950, hpPer=30, `level`=50, name='Etoossakan', rewardExp=80, rewardGold=90, rewardRankingPoint=4, guardIndex=54, earth=1, elementGrade=5, fire=0, water=0, wind=1 WHERE id=54;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=14, baseSta=2, baseStr=16, baseWill=34, btItemID=1, hpBase=600, hpPer=1, `level`=20, name='Kuromaro', rewardExp=10, rewardGold=10, rewardRankingPoint=1, guardIndex=55, earth=1, elementGrade=2, fire=0, water=0, wind=0 WHERE id=55;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=16, baseSta=2, baseStr=19, baseWill=36, btItemID=1, hpBase=650, hpPer=1, `level`=25, name='Akamaro', rewardExp=12, rewardGold=10, rewardRankingPoint=1, guardIndex=56, earth=0, elementGrade=2, fire=1, water=0, wind=0 WHERE id=56;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=18, baseSta=2, baseStr=22, baseWill=38, btItemID=1, hpBase=700, hpPer=1, `level`=30, name='Aomaro', rewardExp=15, rewardGold=12, rewardRankingPoint=1, guardIndex=57, earth=0, elementGrade=2, fire=0, water=1, wind=0 WHERE id=57;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=20, baseSta=2, baseStr=25, baseWill=40, btItemID=1, hpBase=750, hpPer=1, `level`=35, name='Kokechamaro', rewardExp=18, rewardGold=15, rewardRankingPoint=1, guardIndex=58, earth=0, elementGrade=2, fire=0, water=0, wind=1 WHERE id=58;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=22, baseSta=2, baseStr=28, baseWill=42, btItemID=1, hpBase=800, hpPer=1, `level`=40, name='Chachamaro', rewardExp=20, rewardGold=18, rewardRankingPoint=1, guardIndex=59, earth=1, elementGrade=2, fire=1, water=0, wind=0 WHERE id=59;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=4, addStr=1, addWill=1, baseDex=24, baseSta=2, baseStr=31, baseWill=44, btItemID=1, hpBase=850, hpPer=1, `level`=50, name='Siromaro', rewardExp=35, rewardGold=20, rewardRankingPoint=1, guardIndex=60, earth=0, elementGrade=2, fire=0, water=1, wind=1 WHERE id=60;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=55, baseSta=10, baseStr=30, baseWill=45, btItemID=26, hpBase=2650, hpPer=55, `level`=50, name='No. 1', rewardExp=45, rewardGold=45, rewardRankingPoint=6, guardIndex=61, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=61;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=60, baseSta=10, baseStr=35, baseWill=48, btItemID=26, hpBase=2800, hpPer=55, `level`=50, name='No. 2', rewardExp=55, rewardGold=50, rewardRankingPoint=6, guardIndex=62, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=62;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=65, baseSta=10, baseStr=40, baseWill=51, btItemID=26, hpBase=2950, hpPer=55, `level`=50, name='No. 3', rewardExp=60, rewardGold=55, rewardRankingPoint=6, guardIndex=63, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=63;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=70, baseSta=10, baseStr=45, baseWill=54, btItemID=26, hpBase=3100, hpPer=55, `level`=50, name='No. 4', rewardExp=65, rewardGold=60, rewardRankingPoint=6, guardIndex=64, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=64;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=75, baseSta=10, baseStr=50, baseWill=57, btItemID=26, hpBase=3250, hpPer=55, `level`=50, name='No. 5', rewardExp=70, rewardGold=70, rewardRankingPoint=6, guardIndex=65, earth=0, elementGrade=9, fire=0, water=1, wind=0 WHERE id=65;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=8, addStr=1, addWill=1, baseDex=80, baseSta=10, baseStr=55, baseWill=60, btItemID=26, hpBase=3400, hpPer=55, `level`=50, name='No. 6', rewardExp=75, rewardGold=75, rewardRankingPoint=6, guardIndex=66, earth=1, elementGrade=9, fire=0, water=1, wind=0 WHERE id=66;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=11, addStr=1, addWill=1, baseDex=110, baseSta=25, baseStr=70, baseWill=88, btItemID=28, hpBase=4000, hpPer=850, `level`=50, name='Yeppeuni', rewardExp=150, rewardGold=120, rewardRankingPoint=7, guardIndex=67, earth=1, elementGrade=9, fire=0, water=1, wind=0 WHERE id=67;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=11, addStr=1, addWill=1, baseDex=115, baseSta=25, baseStr=72, baseWill=91, btItemID=28, hpBase=4100, hpPer=850, `level`=52, name='Gwiyeomi', rewardExp=155, rewardGold=125, rewardRankingPoint=7, guardIndex=68, earth=1, elementGrade=9, fire=0, water=1, wind=0 WHERE id=68;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=11, addStr=1, addWill=1, baseDex=120, baseSta=25, baseStr=74, baseWill=94, btItemID=28, hpBase=4200, hpPer=850, `level`=54, name='Ballari', rewardExp=160, rewardGold=130, rewardRankingPoint=7, guardIndex=69, earth=1, elementGrade=9, fire=0, water=1, wind=0 WHERE id=69;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=11, addStr=1, addWill=1, baseDex=125, baseSta=25, baseStr=76, baseWill=97, btItemID=28, hpBase=4300, hpPer=850, `level`=56, name='Sangkeumi', rewardExp=165, rewardGold=135, rewardRankingPoint=7, guardIndex=70, earth=1, elementGrade=9, fire=0, water=1, wind=0 WHERE id=70;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=11, addStr=1, addWill=1, baseDex=130, baseSta=25, baseStr=78, baseWill=100, btItemID=28, hpBase=4400, hpPer=850, `level`=58, name='Hwaljjagi', rewardExp=170, rewardGold=140, rewardRankingPoint=7, guardIndex=71, earth=1, elementGrade=9, fire=0, water=1, wind=0 WHERE id=71;
UPDATE fantasytennis.Guardian SET addDex=1, addSta=11, addStr=1, addWill=1, baseDex=135, baseSta=25, baseStr=80, baseWill=103, btItemID=28, hpBase=4500, hpPer=850, `level`=60, name='Saechimi', rewardExp=175, rewardGold=145, rewardRankingPoint=7, guardIndex=72, earth=1, elementGrade=9, fire=0, water=1, wind=0 WHERE id=72;

-- -- Fix BossGuardian entries for rest since they miss rewardExp,rewardGold and guardIndex
UPDATE fantasytennis.BossGuardian SET addDex=1, addSta=15, addStr=1, addWill=1, baseDex=100, baseSta=45, baseStr=40, baseWill=90, btItemID=20, hpBase=5000, hpPer=150, `level`=60, name='Hell Blood', rewardExp=90, rewardGold=165, rewardRankingPoint=14, guardIndex=1, earth=1, elementGrade=9, fire=1, water=0, wind=1 WHERE id=1;
UPDATE fantasytennis.BossGuardian SET addDex=1, addSta=15, addStr=1, addWill=1, baseDex=100, baseSta=45, baseStr=40, baseWill=90, btItemID=20, hpBase=10000, hpPer=150, `level`=60, name='Hell Blood', rewardExp=480, rewardGold=450, rewardRankingPoint=44, guardIndex=2, earth=1, elementGrade=9, fire=1, water=0, wind=1 WHERE id=2;
UPDATE fantasytennis.BossGuardian SET addDex=1, addSta=15, addStr=1, addWill=1, baseDex=120, baseSta=35, baseStr=85, baseWill=95, btItemID=23, hpBase=7000, hpPer=200, `level`=60, name='Hera', rewardExp=200, rewardGold=180, rewardRankingPoint=14, guardIndex=3, earth=0, elementGrade=9, fire=1, water=1, wind=1 WHERE id=3;
UPDATE fantasytennis.BossGuardian SET addDex=1, addSta=15, addStr=1, addWill=1, baseDex=130, baseSta=25, baseStr=90, baseWill=100, btItemID=24, hpBase=9000, hpPer=250, `level`=60, name='Royal Lizard', rewardExp=220, rewardGold=270, rewardRankingPoint=14, guardIndex=4, earth=1, elementGrade=9, fire=0, water=1, wind=1 WHERE id=4;
UPDATE fantasytennis.BossGuardian SET addDex=1, addSta=15, addStr=1, addWill=1, baseDex=140, baseSta=15, baseStr=95, baseWill=105, btItemID=25, hpBase=11000, hpPer=300, `level`=60, name='TossakanBoss', rewardExp=240, rewardGold=285, rewardRankingPoint=10, guardIndex=5, earth=1, elementGrade=9, fire=1, water=1, wind=0 WHERE id=5;
UPDATE fantasytennis.BossGuardian SET addDex=1, addSta=15, addStr=1, addWill=1, baseDex=140, baseSta=10, baseStr=95, baseWill=105, btItemID=27, hpBase=13000, hpPer=300, `level`=60, name='TB-255', rewardExp=240, rewardGold=300, rewardRankingPoint=18, guardIndex=6, earth=1, elementGrade=9, fire=1, water=0, wind=1 WHERE id=6;
UPDATE fantasytennis.BossGuardian SET addDex=1, addSta=15, addStr=1, addWill=1, baseDex=160, baseSta=30, baseStr=105, baseWill=115, btItemID=29, hpBase=15000, hpPer=400, `level`=60, name='Dance King', rewardExp=280, rewardGold=300, rewardRankingPoint=10, guardIndex=7, earth=1, elementGrade=9, fire=1, water=1, wind=0 WHERE id=7;

Cleaning Up the Database

Before re-running the script, it's important to delete any invalid or partially inserted data left behind by previous failed attempts. You can do this with the following commands: 

DELETE FROM Config;
DELETE FROM K_Status;
DELETE FROM S_Maps;
DELETE FROM M_Scenarios;
DELETE FROM Map_2_Scenarios;
DELETE FROM Guardian_2_Maps;
DELETE FROM Skill_2_Guardians;
DELETE FROM S_Guardian_Multiplier;
DELETE FROM S_Relationship_Roles;
DELETE FROM S_Relationship_Types;
DELETE FROM S_Relationships;

Running the Import Script

Once you’ve applied the necessary fixes, you can proceed with re-importing the SQL files: 

cd <path-to-local-JFTSE-repo>/scripts
./import_sql.sh

Related Issues

Retrieved from "http://wiki.jftse.com/index.php?title=Fixing_SQL_Import_Script_Errors&oldid=71"