Jump to content
  • 0

Error while executing main.sql


Kami675

Question


  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  90
  • Reputation:   1
  • Joined:  10/17/13
  • Last Seen:  

Hello everyone! I am attempting to setup an offline sever(fairly new to this so I apologize) and I am receiving errors while attempting to execute the main.sql in workbench. I attempted to delete said portion causing the error but then another error arises and a lot of warnings. I'm not quite sure what to do and turn to you guys for assistance! The photos below are 1.) photo of when i try to execute without erasing anything 2.) when I erase the clan portion of the main.sql. I'm not entirely sure how to fix this. I am following the rathena wiki installation instructions and it gave me this error and I also tried this other tutorial which also gives me the same errors. Does anyone have any insight on how to solve these errors? I appreciate any and all help!

 

Screenshot_6.png

Screenshot_7.png

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  40
  • Topics Per Day:  0.02
  • Content Count:  209
  • Reputation:   10
  • Joined:  08/30/19
  • Last Seen:  

make sure to double click your schema

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  34
  • Topics Per Day:  0.01
  • Content Count:  90
  • Reputation:   1
  • Joined:  10/17/13
  • Last Seen:  

7 hours ago, Takuyakii said:

make sure to double click your schema

i did double click it, still gives me the same error(s)

Link to comment
Share on other sites

  • 0

  • Group:  Forum Moderator
  • Topic Count:  93
  • Topics Per Day:  0.02
  • Content Count:  10015
  • Reputation:   2351
  • Joined:  10/28/11
  • Last Seen:  

you executed the mains.sql more than one time, or you didnt clear the existing data before you execute the script.

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  5
  • Topics Per Day:  0.00
  • Content Count:  15
  • Reputation:   0
  • Joined:  08/12/12
  • Last Seen:  

i get the same error.  error with main.sql. the others works fine. and error only with latest rathena. need solution 

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  15
  • Reputation:   3
  • Joined:  01/29/24
  • Last Seen:  

the duplicate entry error is obviously because you already ran the script once, it cant override stuff, SQL wont work like that...

 

simply drop the database rathena, create a new database with the same name and import again i guess...

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