Vell Posted December 8, 2015 Report Share Posted December 8, 2015 (edited) Hello, I have some problems with database 3.3.5. What i did : create_mysql / auth_database / characters_database Now i DL : TDB_full_world_335.60_2015_11_07.sql and i start : world_2015_07_14_2015_11_07 => error characters_2015_08_26_2015_11_03 => error auth_2015_08_21 => error all for missing table .. However, i follow 2 tutorials ... and i can't follow it : https://trinitycore.atlassian.net/wiki/display/tc/Databases+Installation Because : Someone can help me to explain what i forgot. Thx Sorry for my bad english ps : I search and any time "apply update" That not work Edited December 8, 2015 by Velyss Link to comment Share on other sites More sharing options...
Magnuss Posted December 8, 2015 Report Share Posted December 8, 2015 The wiki is fucked atm heavily. But you have to explain more in detail what you have done and what kind of error you got. Link to comment Share on other sites More sharing options...
Vell Posted December 8, 2015 Author Report Share Posted December 8, 2015 I have just problem with .sql so like i said, i created DB with create_mysql + auth_database + characters_databaselike all tutorial said. After that, all tutorial says : Apply TDB full 335, so i dowloaded last relaese : see in first topic. And when i applyed that : world_2015_07_14_2015_11_07 => Erreur SQL (1146) : Table 'world.version' doesn't exist characters_2015_08_26_2015_11_03 => Erreur SQL (1054) : Unknown column 'corpseGuid' in 'field list' Link to comment Share on other sites More sharing options...
Rochet2 Posted December 8, 2015 Report Share Posted December 8, 2015 You are not supposed to run the update files from the TDB download if you are creating a new DB. Instead you only run the TDB full sql file to world database and then you run the updates from sql/updates/world which is located in the source you downloaded: https://github.com/TrinityCore/TrinityCore/tree/3.3.5/sql/updates/world Far easier way of setting up the database is by using the new system that creates it for you. Delete existing databases make sure the database creation system is enabled (under UPDATE SETTINGS) and database settings are correct (under CONNECTIONS AND DIRECTORIES) in worldserver.conf Download TDB full and place the files to server folder (so the TDB full is next to the worldserver.exe) start worldserver.exe and press enter when it asks if you want to create databases Note that if you get errors you may have deleted or moved the source folder that was used to compile the server. In that case you should download the source and set SourceDirectory to the source path under CONNECTIONS AND DIRECTORIES in worldserver.conf. Otherwise check your mysql login credentials and read the error message as it may tell you what to do. once server is up you can start using it normally Link to comment Share on other sites More sharing options...
Magnuss Posted December 8, 2015 Report Share Posted December 8, 2015 What you have imported are only update files. You don't need them. Just import only the TDB_full_world_335.60_2015_11_07.sql It creates a new full world DB. To create the table structures of auth and character DB use the auth_database.sql and characters_database.sql in your sql/base/ folder of TC source code. Use the autoupdate feature to update your DB. Unfortunately I have to say with a defective wiki it's a hard job for a newbie to setup all the necessary stuff. Link to comment Share on other sites More sharing options...
Magnuss Posted December 8, 2015 Report Share Posted December 8, 2015 4 minutes ago, Rochet2 said: Save the config and start worldserver.exe During startup it should ask if you want to create the new databases, simply press enter each time. That's cool. Didn't know that :-) Link to comment Share on other sites More sharing options...
Vell Posted December 8, 2015 Author Report Share Posted December 8, 2015 (edited) Ok, so, i deleted all. Updates.AutoSetup = 1 Updates.EnableDatabases = 7 (<=> ALL) LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth" WorldDatabaseInfo = "127.0.0.1;3306;trinity;trinity;world" CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters" In HeidiSQL, i created a new user : user name : trinity user password : trinity Privileges : ALL Now, when i started worldserver : Applying of file 'create_table.sql' to database 'auth' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query. Failed to create database auth! Has the user `CREATE` priviliges? DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://www.trinitycore.info/display/tc/TrinityCore+Home However user exist and privileges too ... ps : In past, with wamp it was really simple ... now not really Edited December 8, 2015 by Velyss Link to comment Share on other sites More sharing options...
Vell Posted December 8, 2015 Author Report Share Posted December 8, 2015 (edited) And when i apply create_mysql and auth_database + characters_database Worldserver : >> File "TDB_full_world_335.60_2015_11_07.sql" is missing, download it from "http://www.trinitycore.org/f/files/category/1-database/" and place it in your server directory. Could not populate the World database, see log for details. but in : https://github.com/TrinityCore/TrinityCore/tree/3.3.5/sql I have no file named : TDB_full_world_335.60_2015_11_07.sql .... And in : http://www.trinitycore.org/f/files/category/1-database/ There are no files .. Edited December 8, 2015 by Velyss Link to comment Share on other sites More sharing options...
Magnuss Posted December 8, 2015 Report Share Posted December 8, 2015 Here I found a download link: https://github.com/TrinityCore/TrinityCore/releases There is a zip file with TDB_full_world_335.60_2015_11_07.sql But I like Rochets post of creating db's very much if is working ;-) Never tried. Edit: ok, after you edit your post it seems you found it already ^^ Link to comment Share on other sites More sharing options...
Vell Posted December 8, 2015 Author Report Share Posted December 8, 2015 I try again but i download (.7z) it before, it contains : updates_tdb_33559_to_33560_only (folder) which contains : auth_2015_08_21.sql characters_2015_08_26_2015_11_03.sql world_2015_07_14_2015_11_07.sql not TDB_full_world_335.60_2015_11_07.sql And Source code zip = my source folder I really don't understand ... I have NO file named TDB_full_world_335.60_2015_11_07.sql Must i rename "world_2015_07_14_2015_11_07" in "TDB_full_world_335.60_2015_11_07.sql " ??? Link to comment Share on other sites More sharing options...
Rochet2 Posted December 8, 2015 Report Share Posted December 8, 2015 Corrected the steps a bit above. 7 minutes ago, Velyss said: I try again but i download (.7z) it before, it contains : updates_tdb_33559_to_33560_only (folder) which contains : The sql should be right next to the folder. http://prntscr.com/9bp8yr Link to comment Share on other sites More sharing options...
Vell Posted December 8, 2015 Author Report Share Posted December 8, 2015 Oh, i'm so sorry, i didn't see .... -.- But now : worldserver : Database World is empty, auto populating it... >> Applying 'TDB_full_world_335.60_2015_11_07.sql'... Applying of file 'TDB_full_world_335.60_2015_11_07.sql' to database 'world' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query. Could not populate the World database Maybe one day that will work >< Link to comment Share on other sites More sharing options...
Magnuss Posted December 8, 2015 Report Share Posted December 8, 2015 6 minutes ago, Velyss said: Oh, i'm so sorry, i didn't see .... -.- no problem, had the same problem 2 weeks ago when I tried to install WOD :-) Are you sure you have correct SQL rights ? May try to add ANY new test database and a table manually with your sql client and your trinity user to check. Link to comment Share on other sites More sharing options...
Vell Posted December 8, 2015 Author Report Share Posted December 8, 2015 That's ok !!!! So : I applied TDB ... sql with HeidiSQL ... because with worldserver that didn't work. AND ! after new error i renamed : C:\Users\****\Desktop\Trinity\Source\sql\updates\auth C:\Users\****\Desktop\Trinity\Source\sql\updates\characters C:\Users\****\Desktop\Trinity\Source\sql\updates\world to : C:\Users\****\Desktop\Trinity\Source\sql\updates\_auth C:\Users\****\Desktop\Trinity\Source\sql\updates\_characters C:\Users\****\Desktop\Trinity\Source\sql\updates\_world And serv is up !!! Thx Magnuss and Rochet2 ! ^^ Link to comment Share on other sites More sharing options...
Magnuss Posted December 8, 2015 Report Share Posted December 8, 2015 hmmm, any idea why you need the underscore ? May this will occurs problems when you are pulling new updates from the repository. Link to comment Share on other sites More sharing options...
Vell Posted December 8, 2015 Author Report Share Posted December 8, 2015 (edited) In fact, in try to upload all time ... so i changed name of folder and worldserver can't found update and so, it doesn't crash. I don't know why it doesn't like it x) Edited December 8, 2015 by Velyss Link to comment Share on other sites More sharing options...
Recommended Posts