Jump to content


NEW custom search, includes forums, wiki, github issues, TC sourcecode, irc logs, doxygen automated documentation; read more here
Photo

"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

database world world database mysql sql database world error install

  • Please log in to reply
1629 replies to this topic

#981 Bioaim

Bioaim

    Member

  • Plebs
  • PipPip
  • 11 posts

Posted 03 June 2013 - 12:29 PM

okay guys, i fixed the problem with the binaries now!

 

But now there is an error with autobroadcast or something:

 

TrinityCore rev. 9664c0ab5cc7+ 2013-05-30 13:18:29 +0200 (master branch) (Win32, Release) (authserver)
<Ctrl-C> to stop.

Using configuration file authserver.conf.
OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e 11 Feb 2013)
Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
MySQL client library: 5.5.9
MySQL server ver: 5.5.27
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.5.9
MySQL server ver: 5.5.27
Connected to MySQL database at 127.0.0.1
In mysql_stmt_prepare() id: 69, sql: "SELECT id, weight, text FROM autobroadcast WHERE realmid = ? OR realmid = -1"
Table 'auth.autobroadcast' doesn't exist
DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
Cannot connect to database

 



#982 Aokromes

Aokromes

    Advanced Member

  • Moderators
  • 3,064 posts

Posted 03 June 2013 - 12:31 PM

Since it's your 1st instalation, drop auth database update your TC sources, recompile and import base auth sql file again, it had a bug and it was fixed yesterday.

#983 Dhiana

Dhiana

    Advanced Member

  • Members
  • PipPipPip
  • 143 posts

Posted 03 June 2013 - 12:57 PM

Ich vermute du hast einfach nur die Full DB 4.3.4 und versucht alle Updates die im Repo der Core dabei sind einzuspielen

und hast das 4.3.4 Repo völlig außer acht gelassen.



#984 Bioaim

Bioaim

    Member

  • Plebs
  • PipPip
  • 11 posts

Posted 03 June 2013 - 04:18 PM

thank you very much, auth is working now...

 

but i have worldserver problems:

 

Realm running as realm ID 1
Using World DB: TDB 335.51
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ./
WORLD: MMap data directory is: ./mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: ./vmaps
Loading Trinity strings...
>> Loaded 1026 Trinity strings from table trinity_string in 3 ms
Initialize data stores...
>> Initialized 98 data stores in 202 ms
Using deDE DBC Locale as default. All available DBC locales: deDE
Loading spell dbc data corrections...
>> Loaded spell dbc data corrections in 3 ms
Loading SpellInfo store...
>> Loaded spell custom attributes in 28 ms
Loading SkillLineAbilityMultiMap Data...
>> Loaded 10219 SkillLineAbility MultiMap Data in 3 ms
Loading spell custom attributes...
>> Loaded spell custom attributes in 17 ms
Loading GameObject models...
Loading Script Names...
>> Loaded 2149 Script Names in 99 ms
Loading Instance Template...
>> Loaded 83 instance templates in 1 ms
Loading instances...
>> Loaded instances in 2 ms
Loading Localization strings...
>> Localization strings loaded in 4 ms
Loading Account Roles and Permissions...
>> Loaded 47 permission definitions, 39 role definitions and 4 group definitions in 1 ms
Loading Page Texts...
>> Loaded 1834 page texts in 8 ms
Loading Game Object Templates...
>> Loaded 19061 game object templates in 178 ms
Loading Spell Rank Data...
>> Loaded 5593 spell rank records in 8 ms
Loading Spell Required Data...
>> Loaded 41 spell required records in 1 ms
Loading Spell Group types...
>> Loaded 461 spell group definitions in 1 ms
Loading Spell Learn Skills...
>> Loaded 99 Spell Learn Skills from DBC in 3 ms
Loading Spell Learn Spells...
>> Loaded 8 spell learn spells + 572 found in DBC in 3 ms
Loading Spell Proc Event conditions...
>> Loaded 1085 extra and 59 custom spell proc event conditions in 4 ms
Loading Spell Proc conditions and data...
>> Loaded 0 spell proc conditions and data. DB table `spell_proc` is empty.
Loading Spell Bonus Data...
>> Loaded 332 extra spell bonus data in 1 ms
Loading Aggro Spells Definitions...
>> Loaded 106 SpellThreatEntries in 1 ms
Loading Spell Group Stack Rules...
>> Loaded 53 spell group stack rules in 1 ms
Loading NPC Texts...
>> Loaded 6044 npc texts in 161 ms
Loading Enchant Spells Proc datas...
>> Loaded 42 enchant proc data definitions in 1 ms
Loading Item Random Enchantments Table...
>> Loaded 28607 Item Enchantment definitions in 39 ms
Loading Disables
>> Loaded 802 disables in 3 ms
Loading Items...
>> Loaded 37294 item templates in 1123 ms
Loading Item set names...
>> Loaded 2481 item set names in 4 ms
Loading Creature Model Based Info Data...
>> Loaded 24142 creature model based info in 47 ms
Loading Creature templates...
>> Loaded 29923 creature definitions in 715 ms
Loading Equipment templates...
[1054] Unknown column 'id' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

 

 

Then worldserver.exe crashes and a window appears with " worldserver.exe doens't work anymore" ( i dont know the exaclty translation, im an austrian )



#985 Ascathor

Ascathor

    Advanced Member

  • Members
  • PipPipPip
  • 359 posts

Posted 03 June 2013 - 04:21 PM

Obviously did not apply world updates.

"I never said that." - Morgan Freeman


#986 Bioaim

Bioaim

    Member

  • Plebs
  • PipPip
  • 11 posts

Posted 03 June 2013 - 05:07 PM

oh, i didn't apply any updates, do i have to execute all of them ?



#987 Aokromes

Aokromes

    Advanced Member

  • Moderators
  • 3,064 posts

Posted 03 June 2013 - 05:08 PM   Best Answer

https://github.com/T...ster/README#L44

#988 Bioaim

Bioaim

    Member

  • Plebs
  • PipPip
  • 11 posts

Posted 03 June 2013 - 06:27 PM

Thank you guys for you support. Finally i started my server successfully. :)



#989 cava

cava

    Member

  • Plebs
  • PipPip
  • 10 posts

Posted 06 June 2013 - 02:42 PM

thats the answer 

https://github.com/T...lpha/issues/221

 

the wiki is wrong i think because worked for me



#990 slugshell

slugshell

    Newbie

  • Plebs
  • Pip
  • 5 posts

Posted 08 June 2013 - 01:38 AM

Hallo alle zusammen,

vorab sollte ich erwähnen, dass ich erst neulich ohne Probleme einen 3.3.5 Server aufgesetzt habe.

 

Zum 4.3.4 Branch...

1. Trinity Core Branch 4.3.4 via git gezogen und ohne Fehler kompiliert rev. 3f5276501d36 2013-06-07
2. World Datenbank via TDB_full_434.04_2013_02_14 Paket angelegt.
3. Via git TrinityCore_4.3.4_DB_Alpha gezogen und im ../update Ordner alle updates ohne Fehlermeldungen auf world Datenbank angewandt.

4. Die Updates aus dem Trinity Core/sql/updates/world Ordner NICHT angewandt.

 

Nun bekomme ich aber leider folgenden Fehler:

 

Using configuration file /srv/trinity/server2/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
Using ACE version: 6.0.3
TrinityCore rev. 3f5276501d36 2013-06-07 18:31:31 +0200 (4.3.4 branch) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.

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

Realm running as realm ID 1
Using World DB: TDB 434.04
Using enUS DBC Locale
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir /srv/trinity/server2/data/
WORLD: MMap data directory is: /srv/trinity/server2/data/mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: /srv/trinity/server2/data/vmaps
Loading Trinity strings...
>> Loaded 1035 Trinity strings from table trinity_string in 3 ms
Initialize data stores...
SQL and DBC format strings are not matching for table: 'spell_dbc'
[1146] Table 'world2.spelleffect_dbc' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Aborted

 

@maddy Muss ich evtl. doch alle neueren Updates aus dem sql Ordner der Trinity Core anwenden?

Update: Gerade versucht meine World 4.3.4 4 Datenbank nur via TrinityCore4.3.4/sql/update/world zu updaten, problem sind hier die Fehlermeldungen bzgl. creature_ai_sripts table

die ja unterdrückt/entfernt wurde und leider auch kein erfolgreicher start..

 

Anscheinend muss die 4.3.4 Datenbank synchronisiert werden siehe

https://github.com/T...lpha/issues/221

 

Gibt es evtl. ein workaround?

 

Bitte helft mir,

 

Danke,

mfG

Alex


Edited by slugshell, 08 June 2013 - 02:30 PM.


#991 slugshell

slugshell

    Newbie

  • Plebs
  • Pip
  • 5 posts

Posted 08 June 2013 - 02:19 PM

I am running into the exact same problems Toba is having with TrinityCore rev.3f5276501d36 and latest TrinityCore 4.3.4 4 DB + DB Updates.

 

Here is what i have tried sofar..

 

4.3.4 Branch...

1. Downloaded Trinity Core Branch 4.3.4  via git and compiled it with out any errors (Trinity Core rev. 3f5276501d36 2013-06-07)
2. Installed world database via TDB_full_434.04_2013_02_14 packet.
3. Downloaded git TrinityCore_4.3.4_DB_Alpha and applied all updates with out any errors.

4. I did not apply any Trinity Core/sql/updates/world database updates.

 

Getting following errors:

 

Using configuration file /srv/trinity/server2/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 2013)
Using ACE version: 6.0.3
TrinityCore rev. 3f5276501d36 2013-06-07 18:31:31 +0200 (4.3.4 branch) (Unix, Release) (worldserver-daemon)
<Ctrl-C> to stop.

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

Realm running as realm ID 1
Using World DB: TDB 434.04
Using enUS DBC Locale
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir /srv/trinity/server2/data/
WORLD: MMap data directory is: /srv/trinity/server2/data/mmaps
VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
VMap data directory is: /srv/trinity/server2/data/vmaps
Loading Trinity strings...
>> Loaded 1035 Trinity strings from table trinity_string in 3 ms
Initialize data stores...
SQL and DBC format strings are not matching for table: 'spell_dbc'
[1146] Table 'world2.spelleffect_dbc' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Aborted

 

I know TDB 4.3.4 needs resync, but is there a temporarily workaround?

 

Thanks,

 

Slugshell


Edited by slugshell, 08 June 2013 - 02:26 PM.


#992 Guybrush

Guybrush

    Advanced Member

  • Members
  • PipPipPip
  • 408 posts

Posted 08 June 2013 - 05:08 PM

I know TDB 4.3.4 needs resync, but is there a temporarily workaround?

 

Yes. Check the source/sql/updates/world for queries marked 4.3.4 and apply them in order.

 

Under normal circumstances this would not be appropriate, but given recent changes, this is the temporary solution.


How appropriate. You fight like a cow.


#993 Niebla

Niebla

    Newbie

  • Plebs
  • Pip
  • 2 posts

Posted 08 June 2013 - 06:21 PM

Yes. Check the source/sql/updates/world for queries marked 4.3.4 and apply them in order.

 

Under normal circumstances this would not be appropriate, but given recent changes, this is the temporary solution.

 

I have same problem. When must these updates be done, after the tdb updates?



#994 spleee101

spleee101

    Newbie

  • Plebs
  • Pip
  • 8 posts

Posted 09 June 2013 - 05:19 PM

Hello everyone recentely i decided to move to 4.3.4 after getting tired of 3.5.5 anyways ive followed the new guide to make sure i did everything right and while compiling the server and all went well, when

i got to updating the world database i ran into problems, i downloaded the latest updates for 4.3.4 and i used command prompt to merge them all together, then i downloaded the latest TDB full for 4.3.4 and imported it into the world database. Finally i went to import the merged updates and at the very end i get an error (  i know this is not pastebin so i attatched error logs to post)

 

and if it helps any this is whaty worldserver.exe is saying

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, 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_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, 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, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'trainer_spell' 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;root;spleee;world
 

 

 i appreciate any advice, ive updated trinity dbs numerous times without error and seeing as this is a fresh compile i dont see how i can be seeing this error. thanks in advance.

Attached Files



#995 spleee101

spleee101

    Newbie

  • Plebs
  • Pip
  • 8 posts

Posted 09 June 2013 - 09:07 PM

sorry to double post but after going through the errors over and over after manualling updating the db one sql at a time, i found anytime something attempts to modify the equipment id table it errors, i looked into this and equipment id is not even a table in the database?


Edited by spleee101, 09 June 2013 - 09:07 PM.


#996 Guybrush

Guybrush

    Advanced Member

  • Members
  • PipPipPip
  • 408 posts

Posted 10 June 2013 - 03:41 AM


I have same problem. When must these updates be done, after the tdb updates?

 

Yes


How appropriate. You fight like a cow.


#997 Dhiana

Dhiana

    Advanced Member

  • Members
  • PipPipPip
  • 143 posts

Posted 11 June 2013 - 01:44 PM

Du musst natürlich auch die updates aus dem Core Repo für 4.3.4 einfügen, die noch nicht im 4.3.4 DB Repo sind.

 



#998 marshalpinokio

marshalpinokio

    Newbie

  • Plebs
  • Pip
  • 3 posts

Posted 15 June 2013 - 05:44 PM

I Get This Problem every time I Run Worldserver

authserver Runs clean

i have used TDB_full_434.04_2013_02_14 And The latest Updates from [https://github.com/T...4.3.4_DB_Alpha]

[last Update name was 063_quest_poi.sql]

Tried this Process 2-3 times, no luck :(

i also have used TDB_full_434.03_2013_01_23 + updates_03 + updates in the Repo above result in same error.

I also googled that ; there was a guy here who had this problem too but in french language that i cant understand (translate.google.com didnt helped so much)

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 20
13)
Using ACE version: 6.1.4
TrinityCore rev. b38025d96ed5 2013-06-15 14:22:16 +0200 (master branch) (Win32,
Release) (worldserver-daemon)
<Ctrl-C> to stop.

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

In mysql_stmt_prepare() id: 56, sql: "SELECT difficulty_entry_1, difficulty_entr
y_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3,
 modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, fac
tion_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg,
dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_cl
ass, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell,
 trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type,
 type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resista
nce3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spe
ll5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName
, MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, Racia
lLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6,
 movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM cre
ature_template WHERE entry = ?"
Unknown column 'trainer_spell' 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;root;root;world


#999 Posthumus

Posthumus

    Advanced Member

  • Members
  • PipPipPip
  • 1,136 posts

Posted 15 June 2013 - 05:49 PM

Cannot connect to world database 127.0.0.1;3306;root;root;world

The box said "Requires Windows XP or better." So I installed Linux...


#1000 Vincent-Michael

Vincent-Michael

    Advanced Member

  • Developers
  • PipPipPip
  • 47 posts

Posted 15 June 2013 - 05:59 PM

you need 4.3.4 branch for 4.3.4 server, not master







Also tagged with one or more of these keywords: database, world, world database, mysql, sql, database world, error, install