Jump to content
TrinityCore

MDK

Members
  • Posts

    44
  • Joined

  • Last visited

Profile Information

  • Location
    Netherlands

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

MDK's Achievements

Newbie

Newbie (1/14)

1

Reputation

  1. Thanks for referring to that issue. How do you guys work around this?
  2. Hi Codeman, Yes I got the Olemba Seeds working. This was for me one of many quests with gameobjects that didn't work. With a completely new build it does. So I think that I've messed up the previous build with Navicat. I can't otherwise explain it, but I'll stick to MySql (with Workbench) as TrinityCore recommends. Thanks for helping out!
  3. I've started over: 1.) complete new git check out, rebuilt VS project with cmake. 2.) compiled new bnetserver, worldserver 3.) extracted all maps, vmaps ,mmaps and dbc/db2 4.) created new instance and hosted on mysql server 5.7 5.) created all databases auth, characters, hotfixes and world 6.) filled it with DDuarte's TDB 7.2.0. 7.) ran all updates in the updates folder 8.) downloaded and installed Wow Client 7.2.5 9.) created new account and character 10.) tested the quest 9992 Olemba Seeds 11.) The gameobjects are highlighted and drop the items! So case closed, thanks for helping out and giving pointers to solve this issue. As for me I'm very happy with the new 7.2.5 release. I've discovered that the riding/flying trainers do not work also the profession trainers are not responding to gossips. Is that still expected not to work? I've googled the trinitycore issue history and there is mention of that that's been solved. However my trainer table is empty
  4. Ok, so reinstall mysql then. It's probably not only the database that got corrupted? I think I'll rebuild the project also, since I see that the log has a date of 15-05-2017, but I just pulled and built a new worldserver.exe. Something's messed up. I'll start over I think.
  5. Hmm ok, I was able to circumvent the above by applying all the world sql updates from the master branch and then also did that for the hotfix database. Unfortunately the worldserver won't run: TrinityCore rev. eb555dd48b26 2017-05-15 20:36:02 +0200 (master branch) (Win64, Release, Static) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /\__ _\ __ __/\ \__ \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ C O R E /\___/ http://TrinityCore.org \/__/ Using configuration file E:/Games/WowPrivateServer/Legion/Official Legion 7.2.5/worldserver.conf. Using SSL version: OpenSSL 1.0.2k 26 Jan 2017 (library: OpenSSL 1.0.1u 22 Sep 2016) Using Boost version: 1.59.0 Automatic database updates are disabled for all databases! Could not prepare statements of the World database, see log for details. But what log do I access for details...Anyone got experience with this?
  6. Hi Daniel, Being busy right now with the updates of the database. I got the following error, any ideas why that happens?: TrinityCore rev. eb555dd48b26 2017-05-15 20:36:02 +0200 (master branch) (Win64, Release, Static) (worldserver-daemon) <Ctrl-C> to stop. ______ __ /\__ _\ __ __/\ \__ \/_/\ \/ _ __ /\_\ ___ /\_\ \, _\ __ __ \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \ \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \ \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \ \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \ C O R E /\___/ http://TrinityCore.org \/__/ Using configuration file E:/Games/WowPrivateServer/Legion/Official Legion 7.2.5/worldserver.conf. Using SSL version: OpenSSL 1.0.2k 26 Jan 2017 (library: OpenSSL 1.0.1u 22 Sep 2016) Using Boost version: 1.59.0 Updating Auth database... >> Auth database is up-to-date! Containing 11 new and 97 archived updates. Updating Character database... >> Character database is up-to-date! Containing 5 new and 67 archived updates. Updating World database... >> Applying update "2017_04_19_01_world.sql" 'B1EFAB0'... mysql: Could not create or access the registry key needed for the MySQL application to log to the Windows EventLog. Run the application with sufficient privileges once to create the key, add the key manually, or turn off logging for that application. Applying of file 'F:/Development/TrinityCore/TrinityCore/sql/updates/world/master/2017_04_19_01_world.sql' to database 'world' failed! If you are a user, please pull the latest revision from the repository. Also make sure you have not applied any of the databases with your sql client. You cannot use auto-update system and import sql files from TrinityCore repository with your sql client. If you are a developer, please fix your sql query. Could not update the World database, see log for details.
  7. Hi Daniel, I thought so, I'll do the cache clearing first. If that fails, then I'll do the truncate and import the original world sql file. The updates that are relevant are only those in the 7.x folder right? To clarify, I used the Dduarte database. That one is also available by Trinity TDB 720.00 which holds all data until 19-04-2017. I ran updates ontop of that one. If I start over I can truncate the world database but... what do I do next? Just turn on run updates when starting the worldserver?
  8. Hi Daniel, Thanks for testing and helping out. I've applied those settings and restarted the trinitycore worldserver. However the Olemba cones are not clickable. I didn't clear the cache in the client. I'll try this tonight. If that fails then I'm thinking of rebuilding a new database. I've taken the database of dduarte v720 as a basis and then ran the updates. Is that also what you guys have done?
  9. Hi Codeman! I was curious whether you've had any luck with testing my sql scripts and whether you had the same problem or not.
  10. Thanks! Let me know what your findings are!
  11. Hi Codeman, I've added the queries of all three tables for the Olemba Cone. Thanks for helping out! gameobject_loot_template by entry.sql gameobject_template by name.sql gameobject_template_addon by entry.sql
  12. Hi Codeman, Thanks for wanting to look into this. Here's the Olemba Cone gameobject entry in the gameobject_template with data8 column filled with questid. I'm not using Navicat anymore. Switched over to Mysql Workbench. First screenshot gameobject_template entry. second screenshot is that of the gameobject_template_addon table for the Olemba Cone. Gameobject_template_addon is selected on gameobject 182541. Third screenshot is of gameobject_loot_template Using the entry in data1 of the gameobject_template table of Olemba cone (screenshot 1) i.e. entry 19372. Entry 19372 points to Item 25745. This is an Olemba Seed item. However the problem is that I can't click on the gameobject. Any ideas based on these screenshots?
  13. Data8 column in gameobject_template (which points to completed questid) has value 0. Do you suggest to populate that with the questid?
  14. Hi Daniel, Thanks for your reply. I've also checked these entries you describe when gameobject is type = 3 (Chest). This is the case for Olemba Cone gameobject. The only way I got this working was to change questrequired = 1 to questrequired = 0. But... that would mean it would be clickable at all time regardless if there was a quest. Anyone got an idea to get it working with a quest? My question is still what might be out of place here?
  15. Hi AussieGuy and gpn39f, Thanks for your replies, what would you advise me to do further? Check the gameobject_loot_template for entries for in my case the Olemba Cones? Olemba cones are quest related objects.
×
×
  • Create New...