Rochet2
-
Posts
967 -
Joined
-
Last visited
-
Days Won
83
Posts posted by Rochet2
-
-
Drop world DB
Recreate world DB
Run TDB_full_335.53_2014.03.29.sql to it (or whatever its called). Just the big SQL. No updates.
Navitage to TC Source/sql/updates/world
Run all SQLs in order in that folder.
On windows you can easily merge them with a bat: copy *.sql mrg.sql
-
So they are permanently lost for members?
I cant see them in solved nor is there an archive visible anywhere.And just a side note, the other thread(s) I was referring to were in custom code section.
I think that is a pretty bad move. What about all the good data they have
-
I have been noticing that the forum has lost some topics, and not only recently.
When I go to my profile and see my posted topics, I cant see the old ones at all, nor do I find them by searching.
There was also a thread in the help section I believe about single gossip items being displayed in gossip windows.
The thread is now gone and all links to it are invalid.
The error is saying I do not have permission to view the topic.. But I am logged in.
It seems the topic is there, or some remnants of it at least, since when you go to this address it fills in the topic name to the url:
http://www.trinitycore.org/f/topic/6320-
Anyone else noted such?
Is it a bug?
Some feature deleting old threads?
Mods hiding threads ?_?
-
Here is a direct link to visualstudio downloads to the right section:
http://www.visualstudio.com/downloads/download-visual-studio-vs#d-express-windows-desktop
system requirements here:
http://www.visualstudio.com/en-us/products/visual-studio-express-vs
Note that its the desktop version.
Express 2013 for Windows Desktop
-
-
and which compiler did you choose in Cmake?
-
Delete cmake cache maybe and retry?
-
Express for Windows Desktop that is
-
The config files are for example:
worldserver.conf.dist
You need to remove the .dist extension before you can use the config with your server.
Then you should add the DB connection info:
Basically you insert the same login info you did to heidisql.
And also provide the database names, which should be correct already if you used the SQL file to create the databases and did not make your own or rename the base databases created by the SQL.
Atm you can ignore all the complicated guidance since its your first time and you wont be going live likely, and hopefully..
But anyways, the guide tells you that you should not use the main SQL account for the server to DB connections.
The main SQL account has access to everything, which is why if someone finds an exploit etc, he may be able to modify permissions etc in DB.
So you should, if the server shows on the net, create a new SQL user that has less permissions and set it to the configs.
Try finding a text block in the config file that looks like:
LoginDatabaseInfo = "127.0.0.1;3306;trinity;trinity;auth"
WorldDatabaseInfo = "127.0.0.1;3306;trinity;trinity;world"
CharacterDatabaseInfo = "127.0.0.1;3306;trinity;trinity;characters" -
Those are not exes. As you should clearly see from the program type.
I suggest you set windows to show known file extensions.
Btw .. what folder do you refer to with built map?
The extractors should all be in binDebug or binRelease (depending on which you chose to compile as)
as long as you chose to compile the tools in cmake like I instructed and (re) compiled your core.
-
Hmm, what you do is you move the extractors, for example mapextractor.exe to your wow folder, where the wow.exe is and then start the extractor.
Let it do it's job and after it is finished, you should have folders named maps and dbc in the same folder. Then move those to the server folder where trinitycore.exe is.
The other extractors you should also move to the wow directory like the mapextractor. But instead of running them, you should create a bat, like you did before, with the instructed contents:
vmap4extractor.exe md vmaps vmap4assembler.exe Buildings vmaps pause
And then run it. The bat should be saved to the wow installation directory where the extactors and wow.exe is.
NOTE that it is said that you should run wow at least once before extracting anything.
~Said someone somewhere at some time. Very very trusted source :3
-
You need to start up cmake
Then when you originally set the paths and clicked configure you got the check list.
It should be visible by default now if you configured once already. Check the box for tools.
Configure, Generate, Compile the core and the tools will be in your compilation directory.
-
Just open up notepad or any text editor.
write this:
copy *.sql mrg.sql
Then save it as mrg.bat to the folder (/sql/updates/world)
Then double click it.
Then run the mrg.sql in /sql/updates/world as instructed.
-
How did you install your MySQL? (where did you get it?)
Are you sure the account credentials are right? Port, account name and password.. -
Hey, thanks for answering but it still wont work :<
This is what i see after i open Create_mysql in heidi: http://i41.tinypic.com/2d8gmpu.png
or is it just me that is doing someting wrong :s
You need to connect to your database..
Make a new connection and insert your IP (if mysql is on the same computer, use 127.0.0.1 or localhost) and the acc and pass.
Should be pretty straight forward ..
I believe it is also instructed so in program window ..
Seems to me like you never even tried to make the DB in the first place, which would be a sad thing.
You dont need to keep the source up to date when you just made it ..
And you need the database to run the server, cant skip that.
-
go to /sql/create in your source.
open create_mysql.sql in heidi and run it.
go to /sql/base in your source.
(Dummy note, you select a DB by clicking on it on the left so it has a green check mark on it)
open auth_database.sql and run it to auth DB
open characters_database.sql and run it to characters DB
Open heidi, select world database, close heidi.
Go to http://www.trinitycore.org/f/files/ and download the latest TDB.
Note that the latest is at the BOTTOM (this may change?) Be sure to look at the version numbers for what is latest.
Open the zip you downloaded and run the TDB_full_xxxxxxxxxx.sql
When attempting to run the file, its too large and you are prompted with a window to choose to load the file to the editor or run directly.
Since we earlier chose world DB, it should be open by default, so we can choose run directly. The file will be run to world DB.
go to /sql/updates/world in your source
create a new bat file (a text file with .bat file extension) and write this into it:
copy *.sql mrg.sql
Run the bat (double click it)
Run the newly created mrg.sql in the same folder to your world DB.
If prompted for too large file again, just click to run directly since we still have world DB as default as mentioned above.
Set up the configs and you are good to go .. I guess.
Correct me if I am wrong. I wrote this from memory, but I think it went right.
-
Damn ubisoft, someone got to my account and changed the email. I got an email saying the email was changed and the only way to contact ubisoft is to call them.. there is no recovery no nothing.If i ever need to it again i'll just recover the password.
-
I would try but i have no clue of what my password is
lol
How about you try changing your password?
If there is anything saved to anything, it shouldnt track you changing your pass and thus cant log in. (dont save the pass)
-
characters and auth sqls are in the source folders:
Source/sql/base/The world structure was left out for some reason, so you pretty much need to run the full DB from the downloads and then all necessary updates from Source/sql/updates/world.
-
Change this on line 299 in GOMove:
sLog->outErrorDb("Gameobject (Entry %u GoType: %u) have invalid displayId (%u), not spawned.", e, objectInfo->type, objectInfo->displayId);
to
sLog->outError(LOG_FILTER_SQL,"Gameobject (Entry %u GoType: %u) have invalid displayId (%u), not spawned.", e, objectInfo->type, objectInfo->displayId);
This is caused by the script being scripted for an earlier version of trinity.
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
Did you read this?
http://collab.kpsn.org/display/tc/Database_master
There is no base SQL for world DB.
Download TDB, run the full SQL
run the updates from source/sql/updates/world.
And I have a hunch the characters and auth DB were possibly not installed correctly ..
You only need to run the base SQL from source/sql/base/ for the auth and character DB.
Dont run any updates to them.