Jump to content
  • 0

Server UP - Debug?


Currently

Question


  • Group:  Members
  • Topic Count:  162
  • Topics Per Day:  0.04
  • Content Count:  313
  • Reputation:   1
  • Joined:  01/22/12
  • Last Seen:  

When I run the runserver.sql, this debug shows up in login.sql window.

I think the schemas upon trying to install the MySQL properly is where I messed up.

Any answer or solution please? Thank you!

post-1726-0-23457900-1355264078_thumb.jpg

Link to comment
Share on other sites

6 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  12
  • Topics Per Day:  0.00
  • Content Count:  45
  • Reputation:   7
  • Joined:  04/03/12
  • Last Seen:  

be aure you are import SQL files to your database

if you imported it ! check database name in inter_athena.conf =)

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  118
  • Topics Per Day:  0.03
  • Content Count:  1942
  • Reputation:   197
  • Joined:  01/08/12
  • Last Seen:  

did you change you inter_athena.conf? log_login_db: loginlog?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  162
  • Topics Per Day:  0.04
  • Content Count:  313
  • Reputation:   1
  • Joined:  01/22/12
  • Last Seen:  

Yes, I did both. I also have it loginlog. Is it on MySQL though or more like setups in rAthena SVN files?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  14
  • Topics Per Day:  0.00
  • Content Count:  139
  • Reputation:   10
  • Joined:  11/10/11
  • Last Seen:  

Yes, I did both. I also have it loginlog. Is it on MySQL though or more like setups in rAthena SVN files?

You need to check both. Make sure the SQL table is imported correctly and the inter_athena.conf is setup correctly

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  162
  • Topics Per Day:  0.04
  • Content Count:  313
  • Reputation:   1
  • Joined:  01/22/12
  • Last Seen:  

Here's what I did during the installation.

Made a schema "ragnarok".

Executed "main.sql" in that ragnarok schema.

Then created another schema called "log" <- Not sure if I should have.

Executed "logs.sql" in that log schema.

bnm.bmp

bnm1.bmp

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  22
  • Topics Per Day:  0.00
  • Content Count:  1479
  • Reputation:   172
  • Joined:  12/14/11
  • Last Seen:  

DB error - table log.loginlog doesn't exist

First of all, do you have any login information / char information on your server? if yes, well skip this lines with stars below, if no, I suggest you to do it

1. ****Drop the schema "ragnarok" and "log" (I mean delete them, completely)

2. ****Create new schema: "ragnarok" and "log"

3. Double click (or 4 or 3 click) the "ragnarok" schema (so the text "ragnarok" will be bolded)

4. Load: main.sql

5. Double / 3 / 4 click the "log" schema

6. Load: logs.sql

and it should do the trick.

Well, sorry, I don't know whether you should double / 3 / 4 click. I use the older version of MySQL Query Browser. I can't use Workbench. I don't know either it's buggy or what, it stops responding quite oftenly.

Link to comment
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
Answer this question...

×   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.

×
×
  • Create New...