Jump to content
TrinityCore
RedSonja

Update failed.

Recommended Posts

I am running Win10 

Revision pulled today 4a07ca for 335

Fresh New Dbs 

As you can see it ran the updates fine for Auth and Char dbs. But the World will not run, no matter how many times I redo it. Would appreciate it if someone could let me know what I did wrong please. The only things I put in were the fullworldsql like your suppose to and the base for auth and char. Then I have the configs setup to run the updates. Compile went fine no problems there, so I can't figure how why this will not run. I know it should.

Server.log

Share this post


Link to post
Share on other sites
4 hours ago, RedSonja said:

I am running Win10 

Revision pulled today 4a07ca for 335

Fresh New Dbs 

As you can see it ran the updates fine for Auth and Char dbs. But the World will not run, no matter how many times I redo it. Would appreciate it if someone could let me know what I did wrong please. The only things I put in were the fullworldsql like your suppose to and the base for auth and char. Then I have the configs setup to run the updates. Compile went fine no problems there, so I can't figure how why this will not run. I know it should.

Server.log

→DBErrors.log

Share this post


Link to post
Share on other sites

Ok last question then, does the full sql have to be in the same folder with the repo sqls?

And thank you so much for clearing this up for me a lot has changed since I updated last.

Share this post


Link to post
Share on other sites

Ok all clean and fresh clone to be safe,  rev. 258368a

Now I get this. I posted all 3 logs. I have never had this many problems with doing this before, really confused as to what to do next. Have always been able to create dbs and now this, suggestions please.  Thank you in advance.

 

 

 

Logs.png

Share this post


Link to post
Share on other sites
On 28.5.2016 at 4:00 AM, RedSonja said:

Ok all clean and fresh clone to be safe,  rev. 258368a

Now I get this. I posted all 3 logs. I have never had this many problems with doing this before, really confused as to what to do next. Have always been able to create dbs and now this, suggestions please.  Thank you in advance.

 

 

 

Logs.png

Is the mysql user applying the updates and creating the database equipped with the needed set of mysql privileges, and is this user correctly configured in auth and world config files? There could be something wrong with your mysql server setup you might wanna check out.

Share this post


Link to post
Share on other sites

If you still get issues after double checking DB names and user/pass, create the DBs and import the TDB full SQL file manually and start worldserver (and it will apply the SQL updates for you).

Share this post


Link to post
Share on other sites
11 hours ago, Lynx said:

Is the mysql user applying the updates and creating the database equipped with the needed set of mysql privileges, and is this user correctly configured in auth and world config files? There could be something wrong with your mysql server setup you might wanna check out.

Yeah it looks user is to limited on permissions to allow core to import full databases OR updates to it.

  • Upvote 1

Share this post


Link to post
Share on other sites

Also, there are good recommendations for MySQL GUI Tools on TC wiki pages for your platform. You should already be aware of these, but they can assist you setting up the privileges.

You may have made changes to these earlier, just as you did for your db table names.

If in doubt, you can equip a mysql user with all privileges and only allow it to connect from localhost – of course, this only works when your server is running on the same machine as your core.

Share this post


Link to post
Share on other sites

I finally got it to work, I must have uninstalled and reinstalled MySQL Server 20 times. Thanks for the help. I do appreciate it.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...