rogerthorn

[TWO] Some DB errors i think here is the logs: ==================================== DBErrors.txt: --------------- 2014-08-05 23:45:24 DB table `creature_template_classlevelstats` is empty. 2014-08-05 23:45:25 Creature (Entry: 1840) does not have proper `UnitClass(0)` in creature_template 2014-08-05 23:45:25 Creature (Entry: 1860) does not have proper `UnitClass(0)` in creature_template ............ EventAIErrors.txt: ------------------ 2014-08-05 23:47:11 Event 258301 Action1 uses incorrect Target type 1 for event-type 1 (cannot be used OOC) 2014-08-05 23:47:11 Event 598201 Action1 uses incorrect Target type 6 for event-type 12 2014-08-05 23:47:11 Event 945111 Action1 uses incorrect Target type 6 for event-type 13 .................. SD2Errors.txt: ----------------- 2014-08-05 23:47:16 Script registering but ScriptName npc_nexus_drake_hatchling is not assigned in database. Script will not be used. Server.txt: (oh,the records in this log are pretty many i just paste a little of them) ---------------------------------------------------------------------- 2014-08-05 23:45:24 ERROR:DB table `creature_template_classlevelstats` is empty. ...... 2014-08-05 23:45:25 ERROR:Creature (Entry: 1840) does not have proper `UnitClass(0)` in creature_template ............. 2014-08-05 23:46:46 ERROR:Table `dbscripts_on_gossip` has out of range text_id1 (dataint = 2000000249 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 9508 .............. 2014-08-05 23:46:47 ERROR:Table gossip_menu entry 6543 are using non-existing text_id 7775 ...... 2014-08-05 23:46:52 dbscripts_on_creature_movement : 2014-08-05 23:46:52 ERROR:Table `dbscripts_on_creature_movement` has out of range text_id1 (dataint = 2000000141 expected 2001000000-2000010000) in SCRIPT_COMMAND_TALK for script id 143301 ......... 2014-08-05 23:46:54 ERROR:Table `creature_movement` Id 73908, point 1 has textid1 has value 2000005453 out of range. Must be in 2001000000-2000009999 END ======================================== my database: =========== where i download the database: --------------------------------- for MaNGOS Two (WoTLK) git clone [url]https://github.com/mangostwo/database[/url] here shows how I imported the database: ---------------------------------------- cd the folder "mangos" mysql -u root -p set names utf8; #create database: create database characters; create database mangos; create database realmd; create database scriptdev2; #import the structure of db: use characters; source Server/sql/characters.sql; use realmd; source Server/sql/realmd.sql; use mangos; source Server/sql/mangos.sql; #import MANGOS: use mangos; source database/_tools/full_db.sql; #import SCRIPT-DB: use mangos; source server/src/bindings/sql/mangos_scriptname_clear.sql; source server/src/bindings/sql/mangos_scriptname_full.sql; use scriptdev2; source server/src/bindings/sql/scriptdev2_create_structure_mysql.sql; source server/src/bindings/sql/scriptdev2_script_full.sql; some updates: |mangos folder\Server\sql\updates -+ | |archive | |characters -+ | | |01_characters_random_battleground.sql | | | |mangos -+ | | |01_mangos_creature_template.sql | | |02_mangos_creature_classlevels.sql | | | |realmd -+ | |void i updated the three *.sql above,i checked the "archive" folder,and i found that all of the stuffs in there were imported in my database already ,so i didnt use them. this is the version of my database(mangos.db_version): UDB 0.12.2 (406) for MaNGOS 12444 with SD2 SQL for rev. 2857 so,what's the fault? i guest it was the issue of database,but i dont know how to fix it . can you help?