Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

jkz

Plebs
 View Profile  See their activity

  • Posts

    12

  • Joined

  • Last visited

 Content Type 

Posts posted by jkz

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

    in Help and Support

    Posted

    Do you realize, that the updates folder now needs TDB 4.3.4-06 and not TDB 4.3.4-05?

     

    Oh so this http://www.trinitycore.org/f/files/file/9-tdb-full-434/ got updated nice, I was writing what I had last week. Hmm I just strted checking out my version and there is already some in-game langauge problems lol some chars cant speak so probably gonna recompile this sooner then later. hmm hmm :P i'll check that out and probably come back let you know if there are any issues so stay tuned :P peace and see you aokromes my pal ^_^  ;)

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

    in Help and Support

    Posted

    Vage? it's 100% exact how to do the work, if you are unable to follow those steps, stop trying it, btw, now you have TDB 4.3.4-06 and more updates, what you go to do? return again asking for help to AkwardDev?

     

    What do you mean i have TDB 4.3.4-06, I have the version he sent me, and yes if i have problems i have no other solution but ask him, since he was the only one who helped me atleast start and play my server. And about this trinity installation I guess I can repeat my problem again, so you've sent me to the first page where it says

     

    For wow 4.3.4:

    1) Clone 4.3.4 branch.

    2) Import sql/create/create_mysql.sql

    3) Import sql/base/auth_database.sql

    4) Import sql/base/character_database.sql

    5) Download TDB 4.3.4

    6) Apply TDB 4.3.4

    7) DON'T apply updates from sql/updates/world

    8) Clone TDB 4.3.4

    9) Apply updates from TDB repo updates

    10) DON'T apply updates from sql/updates/world

    11) Profit.

    12) NOTICE WE NEVER IMPORT sql/updates/auth or sql/updates/character files on fresh installation.

     

     

    I've done all of that, and 

    TDB_full_434.05_2013_07_17.7z.sql + ( https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha ) world_updates.sql = SQL errors

    Atleast for me last week, downloaded the same files that evening and got errors, first it was file to large but when I solved that had sql errors that were related to world_updates.sql

    Only difference from these instructions on the first page is I had to download it to my desktop and not clone folders with GIT, I dont think that should be a problem, correct me if I'm wrong.

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

    in Help and Support

    Posted

    Well anyhow I managed to get a server running yay  :D  :D  B)  thanks to the very helpful and polite AkwardDev from AC-web who gave me a clean world update for the TDB_full_434.05_2013_07_17.7z.sql I guess he made some custom update since it didnt give any errors unlike this https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha If anyone needs that message me or I dont know, maybe I can post it here if its ok?

     

     

    Sorry dude but thats pretty vague for my specific problem, I mean I understand you're having similar or same questions hundreds times per day but I really cant help you with that, maybe if you're stressed out you should just take a vacation or something. Because not only did you give me a link to the first page that I've already seen and isn't really helpful in my case but you wrote that I should return my computer somewhere, and that really doesnt have anything to do with nothing here except your frustration. So my friendly advice would be to try being more specific and also patient if you're role here is helping people out, if youre role is being a bitchy forum smartass posting sassy content then I guess you're fine. 

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

    in Help and Support

    Posted · Edited by jkz

    That error means a table is missing. Either you didn't create your database properly or, if that table isn't in the "create" SQL files, you missed an update that adds it.

     

    This is the SQL that creates the table, it's from an old bug report / fix posted on github in January:

     

    2014_01_31_00_world_spell_custom_attr.sql

     

    Copy all of it into an SQL file and execute it on your database to create the table. Then import again the one that gave you the error.

    Thanks ive put that in but now I'm getting this

     

    Query:
ALTER TABLE `creature_classlevelstats` CHANGE `comment` `comment` TEXT NULL DEFAULT NULL


Error occured at:2014-07-05 03:32:09
Line no.:417
Error Code: 1054 - Unknown column 'comment' in 'creature_classlevelstats'

    I've checked are these some 3.3.5 sql's? I'm trying to run a 4.3.4 server, why do i need these, I mean I'm just trying to run this world update for the TDB and it gives these errors thats just not right. I dont understand why doesnt this TDB_full_434.05_2013_07_17.7z from here http://www.trinitycore.org/f/files/file/9-tdb-full-434/ work with this update here https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha ? Or atleast why doesnt it work on my computer I just added the world database then that update and it gives errors, it cant be right

     

    EDIT:I found this https://github.com/TrinityCore/TrinityCore/commit/894eb9a4454971ad2a2bf290fd3e2ea9e9a46fd0 I tried making a sql out of this lol and execute it had an error lol :P

     

    Quote

    Create the three databases by importing ...sqlcreatecreate_mysql.sql. You now have three databases - auth, characters, and world. You may need to refresh your program in order to see the new databases.

    Click on the "auth" database and import the auth database structure by importing ...sqlbaseauth_database.sql.

    Click on the "characters" database and import the characters database structure by importing ...sqlbasecharacter_database.sql.

    Click on the "world" database and import the world database structure by extracting and importing the "TDB_full_*.sql" file you downloaded from the Download section.

    Click on the "world" database and import any *.sql file available in your ...sqlupdatesworld folder.

    NOTICE WE NEVER IMPORT sqlupdatesauth or sqlupdatescharacter files on fresh installation.

    NEVER ENABLE CONTINUE ON ERROR ON YOUR SQL CLIENT

     

    Click on the "world" database and import any *.sql file available in your ...sqlupdatesworld folder.  

     

    We dont do this for 4.3.4 right?

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

    in Help and Support

    Posted

     

    Lost connection errors can also be a t

    imeout error. If the query is too large it can exceed the timeout and cause the connection to drop. Instead of combining the SQL into one big file, why not import them one at a time?

     

    Here is the script I wrote for Windows.

     

    Thank you for the link although I've split the big update into smaller folders then made 3 sqls shift+left click command window - copy *.sql ,and last sql is giving me that error in my previous post.

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

    in Help and Support

    Posted

    You don't get it: Use mysql -u username -pPASSWORD database < hugefiletoimport.sql instead GUIs

     

    Sorry dont understand what you mean, where do I use username password for what?

     

    And about the sql anyway now I've split the world update into smaller sqls so it can process it, getting this error on last part

     

    Query:
DELETE FROM `spell_custom_attr` WHERE `entry` IN (72347)


Error occured at:2014-07-04 01:12:45
Line no.:308
Error Code: 1146 - Table 'world.spell_custom_attr' doesn't exist

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

    in Help and Support

    Posted

    Another unavoidable error, I create characters database apply  characters_database.sql everything fine, as soon as i go execute the characters update from ..TrinityCoresqlupdatescharacters I add the 2014_03_29_00_characters_groups.sql and error:

     

    Query:
ALTER TABLE `groups` ADD COLUMN `masterLooterGuid` INT(10) UNSIGNED NOT NULL AFTER `raiddifficulty`


Error occured at:2014-06-28 16:00:38
Line no.:1
Error Code: 1060 - Duplicate column name 'masterLooterGuid'

    I'm just following the core tutorial and it doesnt work like this or maybeI've missed some step, but I dont see where could I've failed here


    I told you, use mysql cli.

     

    I was using mysql server 5.6 before xampp had same problems

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

    in Help and Support

    Posted · Edited by jkz

    Hello I've solved the Index 5125 already exists in dbc:'achievement_dbc' just copied the DBC folder from some repack, and my client isnt modified I was just following this tutorial http://collab.kpsn.org/display/tc/How-To_Win+4.3.4#How-To_Win4.3.4-MySQLServerCommunityEdition

     

    Anyway now I'm having trouble with SQL, I've ditched Heidi installed SQLyog, xampp running the mysql server everything fine, and everytime - I create the databases, go apply the updates there are errors. 
    So specifically I execute this last SQL from here http://www.trinitycore.org/f/files/download/9-tdb-full-434/ to world database in SQLyog TDB_full_434.05_2013_07_17.sql so far everything fine and now the problem, I create the world _update file from TrinityCore_4.3.4_DB_Alpha-master/tools with merge_windows.bat and everytime I go apply it to world database it stops at 35% with a huge error message that I cant even paste here so heres just last few lines:

     

    (51729, '', 'Ventaille ligelumière', 'Gesichtsschutz des Lichts', '', '', 'Visera juraluz', '', 'Большой шлем клятвы Свету'),
(51730, '', 'Garde-jambes ligelumières', 'Beinschützer des Lichts', '', '', 'Musleras juraluz', '', 'Набедренники клятвы Свету'),
(51731, '', 'Garde-épaules ligelumières', 'Schulterschutz des Lichts', '', '', 'Guardahombros juraluz', '', 'Наплечные щитки клятвы Свету'),
(51732, '', 'Jambières d''acolyte cramoisi', 'Gamaschen des purpurroten Akolythen', '', '', 'Leotardos de acólito carmesí', '', 'Поножи послушника из Багрового Легиона'),
(51733, '', 'Robe d''acolyte cramoisi', 'Robe des purpurroten Akolythen', '', '', 'Toga de acólito carmesí', '', 'Одеяние послушника из Багрового Легиона'),
(51734, '', 'Protège-épaules d''acolyte cramoisi', 'Schulterpolster des purpurroten Akolythen', '', '', 'Hombreras de acólito carmesí', '', 'Наплечные пластины послушника из Багрового Легиона'),
(51735, '', 'Gants d''acolyte cramoisi', 'Handschuhe des purpurroten Akolythen', '', '', 'Guantes de acólito carmesí', '', 'Перчатки послушника из Багрового Легиона'),
(51736, '', 'Chaperon d''acolyte cramoisi', 'Kapuze des purpurroten Akolythen', '', '', 'Caperuza de acólito carmesí', '', 'Капюшон послушника из Багрового Легиона'),
(51737, '', 'Capuche d''acolyte cramoisi', 'Gugel des purpurroten Akolythen', '', '', 'Alzacuellos de acólito carmesí', '', 'Клобук послушника из Багрового Легиона'),
(51738, '', 'Protège-mains d''acolyte cramoisi', 'Handlappen des purpurroten Akolythen', '', '', 'Manijas de acólito carmesí', '', 'Повязки послушника из Багрового Легиона'),
(51739, '', 'Mantelet d''acolyte cramoisi', 'Mantelung des purpurroten Akolythen', '', '', 'Manto de acólito carmesí', '', 'Мантия послушника из Багрового Легиона'),
(51740, '', 'Grande tenue d''acolyte cramoisi', 'Gewandung des purpurroten Akolythen', '', '', 'Vestiduras de acólito carmesí', '', 'Облачение послушника из Багрового Легиона'),
(51741, '', 'Pantalon d''acolyte cramoisi', 'Hose des purpurroten Akolythen', '', '', 'Pantalones de acólito carmesí', '', 'Штаны послушника из Багрового Легиона'),
(51742, '', 'Gantelets de lame de l''ombre', 'Stulpen der Schattenklinge', '', '', 'Guanteletes de Hoja de las Sombras', '', 'Рукавицы теневого клинка'),
(51743, '', 'Cuirasse de lame de l''ombre', 'Brustplatte der Schattenklinge', '', '', 'Coraza de Hoja de las Sombras', '', 'Кираса теневого клинка'),
(51744, '', 'Cuissards de lame de l''ombre', 'Beinplatten der Schattenklinge', '', '', 'Quijotes de Hoja de las Sombras', '', 'Ножные латы теневого клинка'),
(51745, '', 'Casque de lame de l''ombre', 'Helm der Schattenklinge', '', '', 'Casco de Hoja de las Sombras', '', 'Полный шлем теневого клинка'),
(51746, '', 'Espauliers de lame de l''ombre', 'Schulterstücke der Schattenklinge', '', '', 'Espaldares de Hoja de las Sombras', '', 'Наплечье теневого клинка'),
(51747, '', 'Tunique de sorcière du givre', 'Tunika der Frosthexe', '', '', 'Guerrera de bruja de Escarcha', '', 'Мундир ледяной ведьмы'),
(51748, '', 'Garde-mains de sorcière du givre', 'Handschützer der Frosthexe', '', '', 'Manoplas de bruja de Escarcha', '', 'Боевые рукавицы ледяной ведьмы'),
(51749, '', 'Chapel de sorcière du givre', 'Kopfstück der Frosthexe', '', '', 'Celada de bruja de Escarcha', '', 'Головной убор ледяной ведьмы'),
(51750, '', 'Garde-jambes de sorcière du givre', 'Beinschützer der Frosthexe', '', '', 'Musleras de bruja de Escarcha', '', 'Набедренники ледяной ведьмы'),
(51751, '', 'Spallières de sorcière du givre', 'Schiftung der Frosthexe', '', '', 'Bufas de bruja de Escarcha', '', 'Наплеч ледяной ведьмы'),
(51752, '', 'Corselet de sorcière du givre', 'Brustschutz der Frosthexe', '', '', 'Coselete de bruja de Escarcha', '', 'Нагрудный доспех ледяной ведьмы'),
(51753, '', 'Poignes de sorcière du givre', 'Handschutz der Frosthexe', '', '', 'Mandiletes de bruja de Escarcha', '', 'Захваты ледяной ведьмы'),
(51754, '', 'Ventaille de sorcière du givre', 'Gesichtsschutz der Frosthexe', '', '', 'Visera de bruja de Escarcha', '', 'Большой шлем ледяной ведьмы'),
(51755, '', 'Kilt de guerre de sorcière du givre', 'Kriegskilt der Frosthexe', '', '', 'Falda de guerra de bruja de Escarcha', '', 'Боевой килт ледяной ведьмы'),
(51756, '', 'Garde-épaules de sorcière du givre', 'Schulterschutz der Frosthexe', '', '', 'Guardahombros de bruja de Escarcha', '', 'Наплечные щитки ледяной ведьмы'),
(51757, '', 'Haubert de sorcière du givre', 'Halsberge der Frosthexe', '', '', 'Camisote de bruja de Escarcha', '', 'Хауберк ледяной ведьмы'),
(51758, '', 'Gants de sorcière du givre', 'Handschuhe der Frosthexe', '', '', 'Guantes de bruja de Escarcha', '', 'Перчатки ледяной ведьмы'),
(51759, '', 'Heaume de sorcière du givre', 'Helm der Frosthexe', '', '', 'Yelmo de bruja de Escarcha', '', 'Шлем ледяной ведьмы'),
(51760, '', 'Kilt de sorcière du givre', 'Kilt der Frosthexe', '', '', 'Falda de bruja de Escarcha', '', 'Килт ледяной ведьмы'),
(51761, '', 'Protège-épaules de sorcière du givre', 'Schulterpolster der Frosthexe', '', '', 'Hombreras de bruja de Escarcha', '', 'Наплечные пластины ледяной ведьмы'),
(51762, '', 'Protège-épaules du convent noir', 'Schulterpolster des dunklen Zirkels', '', '', 'Hombreras del Aquelarre oscuro', '', 'Наплечные пластины мрачного шабаша'),
(51763, '', 'Robe du convent noir', 'Robe des dunklen Zirkels', '', '', 'Toga del Aquelarre oscuro', '', 'Одеяние мрачного шабаша'),
(51764, '', 'Jambières du convent noir', 'Gamaschen des dunklen Zirkels', '', '', 'Leotardos del Aquelarre oscuro', '', 'Поножи мрачного шабаша'),
(51765, '', 'Chaperon du convent noir', 'Kapuze des dunklen Zirkels', '', '', 'Caperuza del Aquelarre oscuro', '', 'Капюшон мрачного шабаша'),
(51766, '', 'Gants du convent noir', 'Handschuhe des dunklen Zirkels', '', '', 'Guantes del Aquelarre oscuro', '', 'Перчатки мрачного шабаша'),
(51767, '', 'Plaques d''épaule de seigneur ymirjar', 'Schulterplatten des Ymirjarfürsten', '', '', 'Hombreras de placas de señor Ymirjar', '', 'Латные наплечники имирьярского повелителя'),
(51768, '', 'Cuissards de seigneur ymirjar', 'Beinplatten des Ymirjarfürsten', '', '', 'Quijotes de señor Ymirjar', '', 'Ножные латы имирьярского повелителя'),
(51769, '', 'Casque de seigneur ymirjar', 'Helm des Ymirjarfürsten', '', '', 'Casco de señor Ymirjar', '', 'Полный шлем имирьярского повелителя'),
(51770, '', 'Gantelets de seigneur ymirjar', 'Stulpen des Ymirjarfürsten', '', '', 'Guanteletes de señor Ymirjar', '', 'Рукавицы имирьярского повелителя'),
(51771, '', 'Harnois de bataille de seigneur ymirjar', 'Kampfplatte des Ymirjarfürsten', '', '', 'Placa de batalla de señor Ymirjar', '', 'Боевой доспех имирьярского повелителя'),
(51772, '', 'Cuirasse de seigneur ymirjar', 'Brustplatte des Ymirjarfürsten', '', '', 'Coraza de señor Ymirjar', '', 'Кираса имирьярского повелителя'),
(51773, '', 'Garde-mains de seigneur ymirjar', 'Handschützer des Ymirjarfürsten', '', '', 'Manoplas de señor Ymirjar', '', 'Боевые рукавицы имирьярского повелителя'),
(51774, '', 'Grand heaume de seigneur ymirjar', 'Großhelm des Ymirjarfürsten', '', '', 'Gran yelmo de señor Ymirjar', '', 'Великий шлем имирьярского повелителя'),
(51775, '', 'Garde-jambes de seigneur ymirjar', 'Beinschützer des Ymirjarfürsten', '', '', 'Musleras de señor Ymirjar', '', 'Набедренники имирьярского повелителя'),
(51776, '', 'Espauliers de seigneur ymirjar', 'Schulterstücke des Ymirjarfürsten', '', '', 'Espaldares de señor Ymirjar', '', 'Наплечье имирьярского повелителя');
*/
TRUNCATE `locales_gameobject`


Error occured at:2014-06-28 15:23:27
Line no.:337641
Error Code: 2013 - Lost connection to MySQL server during query

    Can you tell me what is wrong here?

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

    in Help and Support

    Posted · Edited by jkz

    Thank you so you suggest SQLYog, it can process large files like that? and about this worldserver issue do you think thats sql, or cmake/visual studio made the error I have a 64setup

     

    and also, while adding sql's to databases I had a lot of errors I disabled Heidi to stop when it gets an error. So would my wow server run with all those sql errors, and how does sql work, I think I executed a few duplicate sqls into databases do they just overwrite each other or does that create problems?

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

    in Help and Support

    Posted

    So I'm trying to run the server on windows vista it just freezes when I run worldserver application and pops the message in the thread title, I can run authserver fine and DBErrors LOG doesnt show anything. Worldserver LOG file shows this - 

     

    Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1g 7 Apr 2014 (library: OpenSSL 1.0.1g 7 Apr 2014)
Using ACE version: 6.1.4
TrinityCore rev. b102c1c97906 2014-06-19 23:01:05 +0200 (4.3.4 branch) (Win64, Release) (worldserver-daemon)
<Ctrl-C> to stop.


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


Realm running as realm ID 1
Using World DB: TDB 434.05
Using enUS DBC Locale
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 1072 Trinity strings from table trinity_string in 24 ms
Initialize data stores...
Index 5125 already exists in dbc:'achievement_dbc'

    Anyone know what could be the problem here?

     

    Also one other thing I was using Heidisql this is my first time installing or trying to run a server, I mostly had trouble with sql and maybe you shouldnt recommend Heidi in your tutorial here http://collab.kpsn.org/display/tc/How-To_Win+4.3.4#How-To_Win4.3.4-MySQLServerCommunityEdition because when you get to the part adding that large sql from batch file world updates to your world database, Heidi gives an error and stops I've split them up and run seperately but got alot of errors, is Navicat maybe better for this or some other tool?

     

    Any help appreciated, thank you

×
×
  • Create New...