[zero] Lots of DB errors on new install

Need to confirm the errors and possibly resolve some of them

At least hundreds of these for various guids:

2014-06-04 21:09:29 ERROR:Table creature_movement contain path for creature guid 590000, but this creature guid does not exist. Skipping.
2014-06-04 21:09:29 ERROR:Table creature_movement contain path for creature guid 590000, but this creature guid does not exist. Skipping.

Hundreds of these:

2014-06-04 21:09:29 ERROR:Table creature_movement_template references unknown creature template 412. Skipping.
2014-06-04 21:09:29 ERROR:Table creature_movement_template references unknown creature template 412. Skipping.

This is all of these:
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 1.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 41202.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 41203.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 143301.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 143302.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 143303.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 143304.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 143305.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 298301.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 406801.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 504301.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 590101.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 590102.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760401.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760402.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760409.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760501.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760502.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760509.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760601.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760602.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760609.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760701.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760702.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760706.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760707.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760713.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760801.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760802.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 760809.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 902201.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 967901.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 1258101.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 1435401.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 1435402.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 1763501.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 1763502.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_creature_movement` contain unused script, id 1799501.

Lots of these:

2014-06-04 21:09:29 ERROR:Table `dbscripts_on_quest_start` has invalid creature (Entry: 9461) in SCRIPT_COMMAND_TEMP_SUMMON_CREATURE for script id 4023
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_quest_start` has invalid creature (Entry: 9546) in SCRIPT_COMMAND_TEMP_SUMMON_CREATURE for script id 4265
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_quest_start` has buddyEntry = 9546 in command 0 for script id 4265, but this creature_template does not exist, skipping.
2014-06-04 21:09:29 ERROR:Table `dbscripts_on_quest_start` has buddyEntry = 9546 in command 1 for script id 4265, but this creature_template does not exist, skipping.

Lots of these:

2014-06-04 21:09:29 ERROR:Table `db_script_string` has unused string id 2000000054
2014-06-04 21:09:29 ERROR:Table `db_script_string` has unused string id 2000000057
2014-06-04 21:09:29 ERROR:Table `db_script_string` has unused string id 2000000058

These:

2014-06-04 21:09:24 Loading Waypoint scripts...
2014-06-04 21:09:24 dbscripts_on_creature_movement :
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 1427 in command 0 for script id 143303, but this creature_template does not exist, skipping.
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 1427 in command 0 for script id 143303, but this creature_template does not exist, skipping.
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 483 in command 0 for script id 143304, but this creature_template does not exist, skipping.
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 1533 in command 20 for script id 153301, but this creature_template does not exist, skipping.
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 1533 in command 20 for script id 153301, but this creature_template does not exist, skipping.
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 3419 in command 0 for script id 406801, but this creature_template does not exist, skipping.
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has invalid creature (Entry: 11256) in SCRIPT_COMMAND_TEMP_SUMMON_CREATURE for script id 590101
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 11256 in command 0 for script id 590101, but this creature_template does not exist, skipping.
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 11256 in command 0 for script id 590101, but this creature_template does not exist, skipping.
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 11256 in command 0 for script id 590101, but this creature_template does not exist, skipping.
2014-06-04 21:09:24 ERROR:Table `dbscripts_on_creature_movement` has buddyEntry = 7267 in command 0 for script id 760713, but this creature_template does not exist, skipping.
2014-06-04 21:09:24
2014-06-04 21:09:24 >> Loaded 52 script definitions


2014-06-04 21:09:21 >> Loaded `npc_trainer_template`, table is empty!
2014-06-04 21:09:21 ERROR:Table `npc_trainer` have entry for nonexistent creature template (Entry: 198), ignore
2014-06-04 21:09:21 ERROR:Table `npc_trainer` have entry for nonexistent creature template (Entry: 198), ignore
2014-06-04 21:09:21 ERROR:Table `npc_trainer` have entry for nonexistent creature template (Entry: 198), ignore
2014-06-04 21:09:21 ERROR:Table `npc_trainer` have entry for nonexistent creature template (Entry: 198), ignore


And a lot more. This is on Rel19 on FreeBSD (from my fork of the ZERO repo [url]https://github.com/rage311/M0-FreeBSD[/url]). What am I missing here?

I haven't seen a cohesive and up-to-date guide on the DB setup, so I might have just done something wrong. Basically:

From mangoszero/server repo:

mysql -uroot mysql -uroot mangos mysql -uroot realmd mysql -uroot characters cd ../src/bindings/scripts/sql
mysql -uroot mysql -uroot scriptdev2 mysql -uroot scriptdev2 mysql -uroot mangos

From mangoszero/database repo:

cd _tools
./make_full_db.sh
mysql -uroot mangos

Then when I run mangosd, it says I need all the updates between 2441 and 2514 (I think those are the numbers). So I apply all of those from the server repo's sql/updates folder from low to high. Then I run it and get all of these nice errors. I'm sure I'm doing something wrong, but I don't know how to do it right... help?

[QUOTE=Hikari;71868]It looks almost like you've empty [i]creature_template[/i] and [i]creature[/i] tables.

Little sidenote, which has nothing to do with your current problem:
You've to apply [i]mangos_scriptname_full.sql[/i] after you imported [i]full_db.sql[/i], because it affects the data and not the table structures. In your current workflow you apply it to the empty tables, which won't have any effects.[/QUOTE]

mysql> select count(*) from creature_template;
+----------+
| count(*) |
+----------+
| 9091 |
+----------+
1 row in set (0.00 sec)

I checked several other tables that reported issues too, and they all have at least SOME data... except for the npc_trainer_template which has 0 records. I'm not sure what's happening here. Are any of the sql scripts in the database repo's "_updates" folder relevant?

Thanks for the note on the mangos_scriptname_full.sql. It's difficult to tell what's doing what without inspecting every script.