rage_311

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.