HELP PLEASE! [TrinityCore] Setup problems..

[cJink]

I've been fighting with this whole process for days now, with no prior knowledge of MySQL or anything to do with this, but a background in other programming, so I have SOME knowledge.

Anyways. Finally getting these to start and got past the first error I had (after surfing thru the forums for a bit to find my answer), but now I'm not too sure what's wrong. Authserver.exe seems to be loading fine, but world is having an issue. Here's the log I have:

2010-08-16 14:56:23 Using configuration file worldserver.conf.
2010-08-16 14:56:24 TrinityCore Rev: 9380 Release Hash: 902bae860fe5 (Win32,little-endian) (core-daemon)
2010-08-16 14:56:24 <Ctrl-C> to stop.

2010-08-16 14:56:24 ______ __
2010-08-16 14:56:24 /\__ _\ __ __/\ \__
2010-08-16 14:56:24 \/_/\ \/ _ __ /\_\ ___ /\_\ \ ,_\ __ __
2010-08-16 14:56:24 \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
2010-08-16 14:56:24 \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
2010-08-16 14:56:24 \ \_\ \_\ \ \_\ \_\ \_\ \_\ \__\\/`____ \
2010-08-16 14:56:24 \/_/\/_/ \/_/\/_/\/_/\/_/\/__/ `/___/> \
2010-08-16 14:56:24 C O R E /\___/
2010-08-16 14:56:24 http://TrinityCore.org \/__/

2010-08-16 14:56:24 MySQL client library: 5.1.49
2010-08-16 14:56:24 MySQL server ver: 5.1.49-community
2010-08-16 14:56:24 MySQL client library: 5.1.49
2010-08-16 14:56:24 MySQL server ver: 5.1.49-community
2010-08-16 14:56:24 MySQL client library: 5.1.49
2010-08-16 14:56:24 MySQL server ver: 5.1.49-community
2010-08-16 14:56:24 Realm running as realm ID 1
2010-08-16 14:56:24 Using World DB: TDB 335.10.33
2010-08-16 14:56:24 Using creature EventAI: ACID 3.0.4 - Final Release for Trinity (3.3.2 Client)
2010-08-16 14:56:24 Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
2010-08-16 14:56:24 Using DataDir ./
2010-08-16 14:56:24 WORLD: VMap support included. LineOfSight:1, getHeight:1
2010-08-16 14:56:24 WORLD: VMap data directory is: ./vmaps
2010-08-16 14:56:24 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2010-08-16 14:56:24
2010-08-16 14:56:24 Loading Trinity strings...
2010-08-16 14:56:26
2010-08-16 14:56:26 >> Loaded 860 Trinity strings from table trinity_string
2010-08-16 14:56:26 Initialize data stores...
2010-08-16 14:56:30
2010-08-16 14:56:30 >> Initialized 89 data stores
2010-08-16 14:56:30 Using enUS DBC Locale as default. All available DBC locales: enUS
2010-08-16 14:56:30
2010-08-16 14:56:30 Loading Script Names...
2010-08-16 14:56:30 ERROR: SQL: SELECT DISTINCT(ScriptName) FROM achievement_criteria_data WHERE ScriptName <> '' AND type = 11 UNION SELECT DISTINCT(ScriptName) FROM battleground_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM creature_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM gameobject_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM item_template WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM areatrigger_scripts WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM spell_script_names WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM transports WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM game_weather WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM conditions WHERE ScriptName <> '' UNION SELECT DISTINCT(ScriptName) FROM outdoorpvp_template WHERE ScriptName <> '' UNION SELECT DISTINCT(script) FROM instance_template WHERE script <> ''
2010-08-16 14:56:30 ERROR: query ERROR: Table 'world.spell_script_names' doesn't exist
2010-08-16 14:56:30
2010-08-16 14:56:30 ERROR: >> Loaded empty set of Script Names!
2010-08-16 14:56:30 Loading Instance Template...
2010-08-16 14:56:30 ERROR: Error in instance_template table, probably sql file format was updated (there should be 8 fields in sql).



The last issue I had it seems I just had to update the SQL db with the update files.. Now... I'm not exactly sure WHAT is wrong... Any help would be greatly appreciated!!

[Facebook]

Make sure you apply the three script files in sql/scripts (Not the CMake of course)

---------- Post added at 02:36 PM ---------- Previous post was at 02:29 PM ----------

Also I think yoru database was incorrectly applies or out of date.
Make sure you pull the latest rev of Revision af9b70fe5e: / and apply it to an empty world database, then apply the three script files, then the updates.
Then it should boot fine.

[cJink]

Applied all three scripts in sql/scripts (world_script_texts, world_script_waypoints, and world_scripts_full) and still receive the same error in the log when I try to load.

---------------------------------------------------------------

And double checked to make sure I had latest DB, and seems to be the same..
Think I may have messed up somewhere when I set up.. Going to del everything I have currently and try to run it all again, hopefully getting better results. I'll post when I finish (may not be today) but if anyone else has any ideas as to why I get this message, please do tell.. Thanks thus far, and in advance =]

[Facebook]

Yessir. If you empty your database and reinstall with TDB33, and apply all updates, it should work fine.

[cJink]

Ok so I've started from the beginning again, and got the same error. I'm going to write out exactly what I've done:

1- Recompiled the servers
2- Set up a new SQL DB, following directions from the outdated install guide on here
3- Executed "create_mysql.sql" which added auth, world, and character db's.
4- Executed the Auth and Characters sql's found in "sql/base/" (Up to this point it was done in Navicat Lite, but for some reason I had to use the MySQL Query Browser to open and execute the world db files.)
5- Checked to make sure I had latest DB in TDB directory, and then executed the TDB_335.10.32_8874.sql file to add world info.
6- Then I executed the 3 world sql files in sql/scripts, and the updates found in TDB/updates/ that had a version # higher than 8874 (there being 4, 8875's) I get 2, I think, that have an error on a line.
7- Auth runs no prob, World has the same error.

These updates are where it goes a little awry.. I have errors when I run the updates, usually its 1 line that errored. Navicat just skips the errors..so..

Now what I'm thinking now is.. Do I have to run all the updates in sql/updates/ also? Or do I need to just run those other ones in TDB?

[AlienCCL]

Just download repack with revision 9380 and took from it DataBase, u using another database revision

u not created world.spell_script_names table thats all the problem . just look in another database from another repack this table and dump it and execute to your db.

[Facebook]

Hmmm. delete your world db, and refill it with TDB_335, then apply all updates including the ones in 3.3.5_old

Not sure if it'll work, but it's definately worth a try.

(Start with the ones in the old folder, then in the updates folder)

[AlienCCL]

2010-08-16 14:56:30 ERROR: query ERROR: Table 'world.spell_script_names' doesn't exist
2010-08-16 14:56:30
2010-08-16 14:56:30 ERROR: >> Loaded empty set of Script Names!
2010-08-16 14:56:30 Loading Instance Template...
2010-08-16 14:56:30 ERROR: Error in instance_template table, probably sql file format was updated (there should be 8 fields in sql).

this is only SQL problem , not dbc as i know

[cJink]

SUCCESS!!!! What was unclear in EVERY tutorial out there is the fact that you must use all the Trinity/sql/updates AS WELL AS the ones that were in the database directory (TDB/updates in my case). I never executed any of those scripts. THANK YOU SOO MUCH

[Facebook]

That's interesting, because you shouldn't have to. You should be able to just apply the full, and it should work. But oh well, glad it's functioning for you. :P

[cJink]

Haha figures. Ok 1 more quick problem. I'm guessing it would be simple. I've created the gm account, and when I went to another computer on the network, I can connect, see my server, see my realm, yet I get stuck on the "Logging into game server" screen right afterwards. There doesnt seem to be any firewall popups on the server's end, and I've read the only IP that needed to be changed was in "auth-realmlist", which I switched from 127.0.0.1 to my IP address for it thru my router.

[Facebook]

Make sure port 8085 is open.

EDIT: And 3306, and 3724.

[cJink]

WAS having a few p.forwarding issues, tyvm. Fought with my router enough and now its all up and working!!! THAAANKS!!!

[Facebook]

Yessir. Glad I could help you.

[Demonith]

How i PForwarding ? what i need to put and everyting plz make a tut on this image plzzzzzzzzzzzzz!!! I cant connect to realm ?