TrinityCore 4.3.4 world DBError

07/02/2015 00:02 Zudoran#1
Hallo ich habe mir vor kurzen ein TrinityCore 4.3.4 erstellt und alle DB eingespielt.

Als ich den Server richtig eingestellt habe und denn worldserver gestartet habe bekamm ich das.

Code:
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.2c 12 Jun 2015 (library: OpenSSL 1.0.2a 19 Mar 2015)
Using ACE version: 6.1.4
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
   \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
    \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
     \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
      \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                                 C O R E  /\___/
http://TrinityCore.org                    \/__/

In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction_A = ?, faction_H = ? WHERE entry = ?"
Unknown column 'faction_A' in 'field list'
In mysql_stmt_prepare() id: 53, sql: "INSERT INTO creature_transport (guid, npc_entry, transport_entry,  TransOffsetX, TransOffsetY, TransOffsetZ, TransOffsetO) values (?, ?, ?, ?, ?, ?, ?)"
Table 'world.creature_transport' doesn't exist
In mysql_stmt_prepare() id: 54, sql: "UPDATE creature_transport SET emote = ? WHERE transport_entry = ? AND guid = ?"
Table 'world.creature_transport' doesn't exist
In mysql_stmt_prepare() id: 55, sql: "SELECT name, security, help FROM command"
Unknown column 'security' in 'field list'
In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, exp_unk, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, type_flags2, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'faction_A' in 'field list'
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;****;*******;world
wäre nett wenn ihr mir helfen könnt.

Mfg

Zudoran
07/02/2015 07:45 Kaev <3#2
Quote:
Originally Posted by Zudoran View Post
DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to world database 127.0.0.1;3306;****;*******;world
Hast du die World-DB unter dem Datenbanknamen world eingespielt?
Und wenn ja, was steht in der SQLDriverLogFile?
07/02/2015 08:11 Zudoran#3
Ich habe kein schimmer wo sich die log datei befindet ich habe in den mysql ordner nachgeschaut nix gefunden ich such mal über die suchfunktion.

Also ich habe etwas gefunden mysql_error.log mehr aber leider nicht.

Code:
2015-07-01 21:47:43 2776 [Note] Plugin 'FEDERATED' is disabled.
2015-07-01 21:47:43 6a0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-07-01 21:47:43 2776 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-01 21:47:43 2776 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-01 21:47:43 2776 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-07-01 21:47:43 2776 [Note] InnoDB: Memory barrier is not used
2015-07-01 21:47:43 2776 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-01 21:47:43 2776 [Note] InnoDB: Not using CPU crc32 instructions
2015-07-01 21:47:43 2776 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-07-01 21:47:43 2776 [Note] InnoDB: Completed initialization of buffer pool
2015-07-01 21:47:43 2776 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-01 21:47:43 2776 [Note] InnoDB: 128 rollback segment(s) are active.
2015-07-01 21:47:43 2776 [Note] InnoDB: Waiting for purge to start
2015-07-01 21:47:43 2776 [Note] InnoDB: 5.6.24 started; log sequence number 1665234
2015-07-01 21:47:43 2776 [Note] Server hostname (bind-address): '*'; port: 3306
2015-07-01 21:47:43 2776 [Note] IPv6 is available.
2015-07-01 21:47:43 2776 [Note]   - '::' resolves to '::';
2015-07-01 21:47:43 2776 [Note] Server socket created on IP: '::'.
2015-07-01 21:47:43 2776 [Note] Event Scheduler: Loaded 0 events
2015-07-01 21:47:43 2776 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.6.24'  socket: ''  port: 3306  MySQL Community Server (GPL)
2015-07-01 21:51:21 2776 [Warning] IP address 'XXX.XXX.XXX.XXX' could not be resolved: Der angegebene Host ist unbekannt. 
2015-07-02 01:57:07 2776 [Warning] IP address 'XXX.XXX.XXX.XXX' could not be resolved: Der angegebene Host ist unbekannt. 
2015-07-02 04:56:26 2776 [Warning] IP address 'XXX.XXX.XXX.XXX' could not be resolved: Dies ist normalerweise ein zeitweiliger Fehler bei der Auflösung von Hostnamen. Grund ist, dass der lokale Server keine Rückmeldung vom autorisierenden Server erhalten hat.
Die IP-Adressen habe ersetzt durch X also nicht wundern.
07/02/2015 16:38 Sunrisew0w#4
Hat dein User rechte um auf die worlddb zuzugreifen? Um es zutesten kanste ja den root user nehmen und gucken ob dann gestartet wird, aber Cannot connect to world database 127.0.0.1;3306;****;*******;world
bedeutet einfach das er nicht connecten kann sprich username pw oder rechte sind falsch!