Jump to content
TrinityCore

Psychyn

Plebs
  • Posts

    5
  • Joined

Everything posted by Psychyn

  1. A push seems to have been send that solved the above issue! Someone updated it 14 hours ago and upon inserting the updated sql, it ran without issues. >> Auth database is up-to-date! Containing 4 new and 50 archived updates. Updating Character database... >> Character database is up-to-date! Containing 3 new and 38 archived updates. Updating World database... >> Applying update "2016_01_22_00_world.sql" '3693477'... >> Applied 1 query. Containing 84 new and 815 archived updates. Updating Hotfixes database... >> Hotfixes database is up-to-date! Containing 3 new and 58 archived updates. Realm running as realm ID 1 Thank you so much for the help. =)
  2. Thanks, the errors in the first post are gone but now (that I remembered to save the log), I still got the error of the second post: >> Applying update "2016_01_22_00_world.sql" '5261B86'... ERROR 1062 (23000) at line 584: Duplicate entry '21080' for key 'PRIMARY' Applying of file 'F:/Warcraft/Trinity/sql/updates/world/2016_01_22_00_world.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 update the World database, see log for details. I'm not great at these things yet admittedly, it may be something on my end and braindead easy to fix. I appreciate the help.
  3. After it gave me an error in regards to line 584 (duplicate key, error 1062 (23000)), I've taken the 2016_01_22_00 file out of the trinity/sql/updates/world folder, it loaded the two updates after (2016_01_22_01 & 2016_01_22_02) that and the worldserver is now running. I've put the .sql back afterwards and while I am uncertain it loaded that file at all now, it works at least. I'm unsure if it was on my end, there might have been something wrong with the sql file. line: INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseId`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES -- I've been unable to figure it out. Looked identical to the other lines.
  4. There appears to have been a spacing issue within the .sql file. I managed to fix the above though I received a new error for a next line. I'll keep digging a bit and I'll update how it goes.
  5. Hey there, I've been following the guide over at https://trinitycore.atlassian.net/wiki/display/tc/Server+Setup#ServerSetup-6.x and despite some hiccups and restarting, I think I'm almost there and getting the hang of it. However, I've ran into one problem I'm not sure about. My MYSQL server is running, my Auth server is running, but the moment I boot up the world server it tries to auto-update some files. However, during the updating it crashes with: TrinityCore rev. 773a94041bf3 2016-01-22 13:46:43 +0100 (6.x branch) (Win64, Release) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /\__ _\ __ __/\ \__ \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ C O R E /\___/ http://TrinityCore.org \/__/ Using configuration file worldserver.conf. Using SSL version: OpenSSL 1.0.1q 3 Dec 2015 (library: OpenSSL 1.0.1q 3 Dec 2015) Using Boost version: 1.59.0 Updating Auth database... >> Auth database is up-to-date! Containing 4 new and 50 archived updates. Updating Character database... >> Character database is up-to-date! Containing 3 new and 38 archived updates. Updating World database... >> Applying update "2016_01_22_00_world.sql" '0FAAFD2'... ERROR 1064 (42000) at line 454: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '93140,193141,193142,193143,193144,193145,193146,193147,193148,193149,193150,1931' at line 2 Applying of file 'F:/Warcraft/Trinity/sql/updates/world/2016_01_22_00_world.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 update the World database, see log for details. Anything I've overlooked? I've tried redownloading the files from the Git link, (Right click -> gitExtClone, into /trinity?), can't seem to add the few updates manually. Thanks for any help, going to grab a bite to eat and I'll read any response in a bit.
×
×
  • Create New...