@oroco Any chance you could export you creature_template table from the world database? I'm interested to see if that would fix up the problem
TrinityCore 4194 TDB 17 Repack for WoW 3.1.3
50 posts
-
Posted 4 months ago » Permalink
-
I'd take that table too please Oroco or NaturalKiwi I can get it by email
Posted 4 months ago » Permalink
-
ok, correction. I am getting the 1 damage from enemies. Anyone have any more information as to why this is happening?
Posted 4 months ago » Permalink
-
It seems that the min / max damage and attack power values are muffed in the creature templates table. Apparently it is a known issue for the UDB 381 release and should be fixed when the next revision of the database. Some mobs are hitting for more than they should be as well
Posted 4 months ago » Permalink
-
Is it possible to export the data for those tables from a previous working version and then import it into this version? Or will there be some compatibility problems?
Posted 4 months ago » Permalink
-
Haven't tried that but it may be possible, might give it a shot after work tomorrow
Posted 4 months ago » Permalink
-
Alright, I took some database info from a previous release using version 3.0.9 and updated the 3.1.3 database with the new information. Now enemies hit more like they should. I updated their attack power, ranged attack power, min damage, and max damage. The older database had about 1000 fewer entries, so some things I could not update. However I did update 26,300 entries, so that is pretty good. I exported the table to a sql format using phpmyadmin. You can download the file from the following URL.
http://www.mediafire.com/file/jiqyla3mkqy/creature_template.zip
I'll leave it up for a few days. I have only tested it in kara and in elwynn forest starting area. I just hope that old database was correct.
Posted 4 months ago » Permalink
-
I have gotten the server up fine, all gm commands work, instances work, vendors work. Its pretty much perfectly operational. Except for 1 problem.
Upon loging out/exiting game, when I log back in, my character has reset back to default spawn area. All of my items have disappeared, all talents gone, back to starting level. Basically, nothing I do on the character is saved when I log out or exit the game.
Any help at all trying to solve this would be much appreciated.
Posted 3 months ago » Permalink
-
Hey all,
I've got a problem with friends trying to connect to me. All my firewalls are down, all my ports are forwarded, my host file is modified and my realmlist.wtf is set up correctly.
I have my dns address listed in the realmlist database, and yet none of this seems to allow my peers to connect to my server.
Anybody know what I've forgotten to do or what the problem is?
Thanks!
Posted 3 months ago » Permalink
-
no matter what I equip it keeps saying my critical strike rating is zero. Anyone know how to go about fixing that? is there some data missing in one of the tables?
Posted 3 months ago » Permalink
-
I am getting the same error of TrinityRealm/Core stopping when they're started. While reading the forums it was suggested to post the logs, however I'm not finding a logs folder in TrinityCore. When I try to launch TrinityRealm or TrinityCore is says "This application has failed to start because the application configuration is incorrect."
TrinityRealm.conf:
LoginDatabaseInfo = "127.0.0.1;3306;root;######;realmd" #####covered pw
LogsDir = ""
MaxPingTime = 30
RealmServerPort = 3724
BindIP = "0.0.0.0"
PidFile = ""
LogLevel = 0
LogFile = "realmd.log"
LogTimestamp = 0
LogFileLevel = 0
UseProcessors = 0
ProcessPriority = 1
RealmsStateUpdateDelay = 20
WrongPass.MaxCount = 0
WrongPass.BanTime = 600
WrongPass.BanType = 0
LogColors = ""
EnableLogDB = 0
DBLogLevel = 1TrinityCore.conf:
RealmID = 1
DataDir = "."
LogsDir = ""
LoginDatabaseInfo = "127.0.0.1;3306;root;######;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;######;world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;######;characters"
MaxPingTime = 30
WorldServerPort = 8085
BindIP = "0.0.0.0"As I mentioned before, for some reason I'm not getting error logs of any kind in the folders. Which doesnt make sense based on what I'm looking at(not like that it's saying much.) And the .conf files look correct to me. Surely there's more information required to fix this, but i'm not sure what.
Thanks in advanceedit: The ControlServer window reads:
Server started (Port:6832)
New client:1924
Client disconnected: 1924Posted 3 months ago » Permalink
-
@ SkipW
This doesn't seem like a trinitycore problem. However, I think you may have issues regarding Visual C++, Net Framework.
Posted 3 months ago » Permalink
-
@aekom
look in your database either with navicat or sqlyog, go into your [realm or realmd} database and go into Table 'realmlist', make sure the value of 'address' is your ip address for your public connection/DNS Address.
@erytheia
for some wierd arsed reason my website based tool shows up blank, any ideas?
Posted 3 months ago » Permalink
-
@SkipW
are you sill running a previous version of Trinity Core/Realm, if so, change the Ports of the older instance (eg. Reaper-X & Darkend)
Change Realm Port to 3734
Change Core Port to 8086and look in your older instance database either with navicat or sqlyog, go into your [realm or realmd} database and go into Table 'realmlist', make sure the value of 'port' is set for core port.
this will also allow you to utilize multiple clients (eg. 2.4.3 & 3.0.9) with 3.1.3 for a type of multiple realm support.
if you kept the default names for both the old instance and the new instance of trinity, please uninstall by deletion and reinstall the latest executables.
Posted 3 months ago » Permalink
-
@thewi2kbug
Yep like I said in my previous comment, I have my dns address listed in the realmlist database.
I still dunno what the problem is.
Posted 3 months ago » Permalink
-
Ya and i can't load the world sqls my navicat and i think this is the problem when i load i have alot of problems
i need new sqls ya and i use from control.bat updates but i want to add in world databaseHi i have a problem when i start TrinityCore
TrinityRealm start normaly and it don't have any problem
I'll show you the logschat.log = empty
characters.log = empty
db_errors.log =
2009-08-10 09:20:38 SQL: SELECT MAX(guid) FROM creature
2009-08-10 09:20:38 query ERROR: Table 'world.creature' doesn't exist
2009-08-10 09:20:38 SQL: SELECT MAX(guid) FROM gameobject
2009-08-10 09:20:38 query ERROR: Table 'world.gameobject' doesn't exist
2009-08-10 09:24:11 SQL: SELECT MAX(guid) FROM creature
2009-08-10 09:24:11 query ERROR: Table 'world.creature' doesn't exist
2009-08-10 09:24:11 SQL: SELECT MAX(guid) FROM gameobject
2009-08-10 09:24:11 query ERROR: Table 'world.gameobject' doesn't exist
2009-08-10 09:24:11 SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM trinity_string
2009-08-10 09:24:11 query ERROR: Table 'world.trinity_string' doesn't exist
2009-08-10 09:24:11 >> Loaded 0 trinity strings. DB tabletrinity_stringis empty. Cannot continue.
2009-08-10 09:24:13 SQL: SELECT MAX(guid) FROM creature
2009-08-10 09:24:13 query ERROR: Table 'world.creature' doesn't exist
2009-08-10 09:24:13 SQL: SELECT MAX(guid) FROM gameobject
2009-08-10 09:24:13 query ERROR: Table 'world.gameobject' doesn't exist
2009-08-10 09:24:13 SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM trinity_string
2009-08-10 09:24:13 query ERROR: Table 'world.trinity_string' doesn't exist
2009-08-10 09:24:13 >> Loaded 0 trinity strings. DB tabletrinity_stringis empty. Cannot continue.
2009-08-10 09:25:20 SQL: SELECT MAX(guid) FROM creature
2009-08-10 09:25:20 query ERROR: Table 'world.creature' doesn't exist
2009-08-10 09:25:20 SQL: SELECT MAX(guid) FROM gameobject
2009-08-10 09:25:20 query ERROR: Table 'world.gameobject' doesn't exist
2009-08-10 09:25:20 SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM trinity_string
2009-08-10 09:25:20 query ERROR: Table 'world.trinity_string' doesn't exist
2009-08-10 09:25:20 >> Loaded 0 trinity strings. DB tabletrinity_stringis empty. Cannot continue.
2009-08-10 09:25:27 SQL: SELECT MAX(guid) FROM creature
2009-08-10 09:25:27 query ERROR: Table 'world.creature' doesn't exist
2009-08-10 09:25:27 SQL: SELECT MAX(guid) FROM gameobject
2009-08-10 09:25:27 query ERROR: Table 'world.gameobject' doesn't exist
2009-08-10 09:25:27 SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM trinity_string
2009-08-10 09:25:27 query ERROR: Table 'world.trinity_string' doesn't exist
2009-08-10 09:25:27 >> Loaded 0 trinity strings. DB tabletrinity_stringis empty. Cannot continue.
2009-08-10 09:31:58 SQL: SELECT MAX(guid) FROM creature
2009-08-10 09:31:58 query ERROR: Table 'world.creature' doesn't exist
2009-08-10 09:31:58 SQL: SELECT MAX(guid) FROM gameobject
2009-08-10 09:31:58 query ERROR: Table 'world.gameobject' doesn't exist
2009-08-10 09:31:58 SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM trinity_string
2009-08-10 09:31:58 query ERROR: Table 'world.trinity_string' doesn't exist
2009-08-10 09:31:58 >> Loaded 0 trinity strings. DB tabletrinity_stringis empty. Cannot continue.gm_commands.log = empty
ra_commands.log = empty
Server.log =
2009-08-10 09:31:57 Using configuration file TrinityCore.conf.
2009-08-10 09:31:57 TrinityCore2 Rev: 4194 Hash: d5b173cc454e (Win32,little-endian) (core-daemon)
2009-08-10 09:31:57 <Ctrl-C> to stop.2009-08-10 09:31:57 ______ __
2009-08-10 09:31:57 /\__ _\ __ __/\ \__
2009-08-10 09:31:57 \/_/\ \/ _ __ /\_\ ___ /\_\ \ ,_\ __ __
2009-08-10 09:31:57 \ \ \/\'__\/\ \ /' _\/\ \ \ \/ /\ \/\ \
2009-08-10 09:31:57 \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
2009-08-10 09:31:57 \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
2009-08-10 09:31:57 \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
2009-08-10 09:31:57 C O R E /\___/
2009-08-10 09:31:57 http://TrinityCore.org \/__/2009-08-10 09:31:58 MySQL client library: 5.0.56
2009-08-10 09:31:58 MySQL server ver: 5.1.33-community
2009-08-10 09:31:58 MySQL client library: 5.0.56
2009-08-10 09:31:58 MySQL server ver: 5.1.33-community
2009-08-10 09:31:58 MySQL client library: 5.0.56
2009-08-10 09:31:58 MySQL server ver: 5.1.33-community
2009-08-10 09:31:58 Realm running as realm ID 1
2009-08-10 09:31:58 Using World DB: Unknown world database.
2009-08-10 09:31:58 Using creature EventAI: Unknown creature EventAI.
2009-08-10 09:31:58 Will clearlogstable of entries older than 1209600 seconds every 10 minutes.
2009-08-10 09:31:58 Visibility. Distance .Creature can't be greater 165.666656
2009-08-10 09:31:58 Visibility.Distance.Object can't be greater 156.666656
2009-08-10 09:31:58 Using DataDir C:\trinity\TrinityCore\
2009-08-10 09:31:58 WORLD: VMap support included. LineOfSight:0, getHeight:0
2009-08-10 09:31:58 WORLD: VMap data directory is: C:\trinity\TrinityCore\vmaps
2009-08-10 09:31:58 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2009-08-10 09:31:58 ERROR: SQL: SELECT MAX(guid) FROM creature
2009-08-10 09:31:58 ERROR: query ERROR: Table 'world.creature' doesn't exist
2009-08-10 09:31:58 ERROR: SQL: SELECT MAX(guid) FROM gameobject
2009-08-10 09:31:58 ERROR: query ERROR: Table 'world.gameobject' doesn't exist
2009-08-10 09:31:58
2009-08-10 09:31:58 Loading Trinity strings...
2009-08-10 09:31:58 ERROR: SQL: SELECT entry,content_default,content_loc1,content_loc2,content_loc3,content_loc4,content_loc5,content_loc6,content_loc7,content_loc8 FROM trinity_string
2009-08-10 09:31:58 ERROR: query ERROR: Table 'world.trinity_string' doesn't exist
2009-08-10 09:31:58
2009-08-10 09:31:58 ERROR: >> Loaded 0 trinity strings. DB tabletrinity_stringis empty. Cannot continue.Help me please
Posted 3 months ago » Permalink
-
Please someone post here a link for download all world sqls files fixed with all updates and custom updates but fixed
Posted 3 months ago » Permalink
-
@pacha
did you use xampp for your mysql installation, if so most likely you set up the username and password that mysql/navicat requires for connection.
second: on my private server (which i installed mysql from mysql's site) i created the world/realm/characters databases myself, so when the repack asks where you want those installed, they will install.
im sure erytheia though of automatically making the databases by script, but in case that functionality did not work right, please utilize my suggestion to use navicat to create database(s)
P.S. I am running servers for both 2.4.3 (Reaper-X's Repack-TBC) and 3.1.3 (Erytheia's Repack-WotLK), and they both work.
Posted 3 months ago » Permalink
-
Bump .... no problems at all with NEW installation of revision 4194. I have not used repack website, but will be once I have moved to new server machine.
Posted 2 months ago » Permalink
-
hey everyone im having some trouble.so far ive done every thing but when i try run start.bat it comes up with a msg saying the application has failed to start because its side-by-side configuration is incorrect.can some one help me plz i really want this to work?
Posted 1 month ago » Permalink
Reply
You must log in to post.