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.
Recommended Comments
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now