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

OSX 10.12.4 - worldserver cannot install world sql

udumblamer

By udumblamer,
in Help and Support

 Share

Recommended Posts

udumblamer Newbie

udumblamer

Posted
Posted

Tried everything and installing from RazorSQL too, but no luck. Will downgrade and recompile, previous version never failed.

 

TrinityCore rev. 173db1f5498d+ 2017-05-01 00:25:13 +0200 (master branch) (MacOSX, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.

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

Using configuration file /Users/user/Trinity/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2k  26 Jan 2017 (library: OpenSSL 1.0.2k  26 Jan 2017)
Using Boost version: 1.64.0
Database World is empty, auto populating it...
>> File "" is missing, download it from "https://github.com/TrinityCore/TrinityCore/releases" uncompress it and place the file "" in the directory "/Users/user/Trinity/bin".
Could not populate the World database, see log for details.

Link to comment
Share on other sites
CDawg Newbie

CDawg

Posted
Posted
2 hours ago, codeman8214 said:

Your database is not loading correctly you need to download the newest, add it to your exe directory where your server is or run the sql file in a mysql program like navicat to get the database up.

Do NOT use navicat!

https://trinitycore.atlassian.net/wiki/display/tc/Optional+Software

Please note that the software called Navicat is NOT supported due to issues with how it handles SQL-files with "/* */"-style comments.

Link to comment
Share on other sites
udumblamer Newbie

udumblamer

Posted
  • Author
Posted

Last login: Wed May  3 10:19:59 on ttys000
iMac-di-user:~ user$ cd /Users/user/Trinity/bin/
iMac-di-user:bin user$ worldserver
TrinityCore rev. 173db1f5498d+ 2017-05-01 00:25:13 +0200 (master branch) (MacOSX, Release, Static) (worldserver-daemon)
<Ctrl-C> to stop.

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

Using configuration file /Users/user/Trinity/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2k  26 Jan 2017 (library: OpenSSL 1.0.2k  26 Jan 2017)
Using Boost version: 1.64.0
Updating Auth database...
>> Auth database is up-to-date! Containing 3 new and 97 archived updates.
Updating Character database...
>> Character database is up-to-date! Containing 1 new and 67 archived updates.
Updating World database...
[1146] Table 'world.updates_include' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

Well managed to run queries from TDB_FULL_world sql with SQLPro but got error with Russian/Chinese dialogs, result is incomplete.

Link to comment
Share on other sites
codeman3518 Newbie

codeman3518

Posted
Posted

You need to update your sql files so go to the directory sql/updates/world/master and run the sql files if there are a lot of files to update you can create one file to combine all the files into one. Use command prompt go to the directory cd to sql/updates/world/master or where ever there located and put this in "copy /b *.sql all_files.sql" without the double quotations this will do the trick.

Link to comment
Share on other sites
udumblamer Newbie

udumblamer

Posted
  • Author
Posted
1 hour ago, codeman8214 said:

You need to update your sql files so go to the directory sql/updates/world/master and run the sql files if there are a lot of files to update you can create one file to combine all the files into one. Use command prompt go to the directory cd to sql/updates/world/master or where ever there located and put this in "copy /b *.sql all_files.sql" without the double quotations this will do the trick.

As big world sql file stopped query at around 2xxx line, because of not recognized RU/CH characters, world.updates_include won't exist if created next.

Link to comment
Share on other sites
udumblamer Newbie

udumblamer

Posted
  • Author
Posted
2 hours ago, Aokromes said:

leave core to do the work it correctly imports locales.

Dont know but core exe compiled with no errors but cannot "see" sql database nor run as administrator because of some openssl libs missing error. I can append all compile logs if necessary, no file specification in

19 hours ago, udumblamer said:

>> File "" is missing, download it from "https://github.com/TrinityCore/TrinityCore/releases" uncompress it and place the file "" in the directory "/Users/user/Trinity/bin".

 

Link to comment
Share on other sites
Aokromes Contributor

Aokromes

Posted
Posted
17 minutes ago, udumblamer said:

Dont know but core exe compiled with no errors but cannot "see" sql database nor run as administrator because of some openssl libs missing error. I can append all compile logs if necessary, no file specification in

 

maybe you have openssl 1.1 and you need to force cmake to detect 1.0.2.

https://trinitycore.atlassian.net/wiki/display/tc/OS+X+Requirements

Link to comment
Share on other sites
udumblamer Newbie

udumblamer

Posted
  • Author
Posted (edited)
2 hours ago, Aokromes said:

maybe you have openssl 1.1 and you need to force cmake to detect 1.0.2.

https://trinitycore.atlassian.net/wiki/display/tc/OS+X+Requirements

No base system ssl is <0.9.8, but brew and tar both are from installation guide.

Also error is in sql see ''Орк are two \' \' 

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 ''Орки Черной горы тут повсюду, $gприятель:под' at line 1 (Line 2495)

SQL tried to execute russian that was the error. Removed that line and fixed the sql so world installed. Thanks.

Edited by udumblamer
Link to comment
Share on other sites
udumblamer Newbie

udumblamer

Posted
  • Author
Posted
1 hour ago, udumblamer said:

No base system ssl is <0.9.8, but brew and tar both are from installation guide.

Also error is in sql see ''Орк are two \' \' 

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 ''Орки Черной горы тут повсюду, $gприятель:под' at line 1 (Line 2495)

SQL tried to execute russian that was the error. Removed that line and fixed the sql so world installed. Thanks.

Finally got correct filename from worldserver

Database World is empty, auto populating it...
>> File "TDB_world_720.00_2017_04_18.sql" is missing, download it from "https://github.com/TrinityCore/TrinityCore/releases" uncompress it and place the file "TDB_world_720.00_2017_04_18.sql" in the directory "/Users/habanero/Trinity/bin".

.. so ..

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

Using configuration file /Users/user/Trinity/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.2k  26 Jan 2017 (library: OpenSSL 1.0.2k  26 Jan 2017)
Using Boost version: 1.64.0
Database World is empty, auto populating it...
>> Applying 'TDB_world_720.00_2017_04_18.sql'...

Thank you all!

Link to comment
Share on other sites
 Share
Go to topic listing

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...