Jump to content
TrinityCore

Wronglebowski

Members
  • Posts

    16
  • Joined

  • Last visited

Everything posted by Wronglebowski

  1. Trying to use your pre-compiled package I can't find the setup_database.sh file. Is it missing?
  2. I was following the instructions in the "Using Pre-Compiled Packages" thread.
  3. Forgive me if this is a really dumb question but I can't find the "setup_database.sh" file? I just did a fresh install on Debian. No errors or issues. I did a "Find / -name "setup_database.sh" but I've got nothing. Suggestions?
  4. I'm moving from a dedicated Windows Server 2016 environment to a more powerful host with ESXi. How does everyone feel about what host OS is best for Trinity Core? Moving forward I'll likely be migrating all of my game servers onto Docker VMs or other VMs. If Linux what distro would you recommend?
  5. That's exactly what I did When I "Update" my Trinity core I download the precompiled branch, extract it, deposit in the Trinity Core folder I have. I overwrite all existing files so the new files take precidence. Then I launch core.
  6. So, the table I'm having trouble with is the characters table. When I run the create script it claims the table already exists. Do I need to backup the data, drop the table, let the create script run then import the data back? I feel like I'm likely missing an update that ran between now and the last time I updated. For the record this is my log. "Updating Auth database... >> Auth database is up-to-date! Containing 8 new and 19 archived updates. Updating Character database... >> Character database is up-to-date! Containing 1 new and 22 archived updates. Updating World database... >> World database is up-to-date! Containing 155 new and 2303 archived updates. Unknown column 'critChance' in 'field list' In mysql_stmt_prepare() id: 31, sql: "SELECT casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience FROM character_aura WHERE guid = ?" In mysql_stmt_prepare() id: 82, sql: "INSERT IGNORE INTO auctionbidders (id, bidderguid) VALUES (?, ?)" Table 'characters.auctionbidders' doesn't exist In mysql_stmt_prepare() id: 83, sql: "DELETE FROM auctionbidders WHERE id = ?" Table 'characters.auctionbidders' doesn't exist In mysql_stmt_prepare() id: 166, sql: "INSERT INTO character_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" Unknown column 'critChance' in 'field list' In mysql_stmt_prepare() id: 425, sql: "INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges, critChance, applyResilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" Unknown column 'critChance' in 'field list' Could not prepare statements of the Character database, see log for details."
  7. Is there any way to pump up the spawn/respawn rate and such?
  8. Hey all, I'm having some trouble with my world. It seems like the Herbs/Mining Nodes don't want to respawn, ever. Is there a line in the config file or something I missed?
  9. Looks like there's been a development in how movemaps and such are extracted and read, and I'll have to regenerate. Doing that now, is there any major fixes/developments I should be aware of in the last six months?
  10. Thanks, I figured I'd need to do something like that. I've always just relied on the launcher program itself to deploy the updates. Can someone give me an ELI5 on how to do them manually?
  11. Hey all, I've had a 3.3.5 server setup for some time now. Previously I updated the server once a week but after my friends stopped playing I stopped updating. Here I am six months later trying to update and I keep getting a DB Error when launching. "In mysql_stmt_prepare() id: 70, sql: "DELETE FROM spawn_group WHERE spawnType = ? AND spawnId = ?" Table 'world.spawn_group' doesn't exist" Looks like I need to tweak or update a DB somewhere, but I don't want to break anything. I kept my old folder setup so I'm still running that environment for now. Any help would be great, thanks!
  12. Hey all, I finally got my server up and running but I'm having a hard time finding a client that's 3.3.5a and will cooperate. I've tried a few torrents and direct downloads but all the clients don't have the standard realmlist.wtf file and when I edit the config in the WTF Folder and then launch WoW it just keeps changing it back to whatever private server I downloaded it from before. I also don't see anything about an authserver.wtf which I thought I'd need to edit as well. Any ideas?
  13. Hello all, so I've been using the precompiled binaries in an attempt to get my work 3.3.5a server up and running but I've hit a roadblock. I believe I have followed all instructions correctly but something appears to be off. I started the worldserver and building the World DB went off without any issues. It correctly picked up the "Full" DB and then patched from there. Where I have issues is when it moves onto Character DB. I did import sql/base/character_database.sql, when I launch I get the following error. (See file attached) DBErrors.log
  14. Looks like a great time saver! So when I click the second link(I'm assuming for DB?) Apparently it failed to compile the last round? Is there a way to retrieve the last successful compile?
×
×
  • Create New...