Jump to content
  • 0

Got Error Code: 1048. Column 'SP' Cannot be null from mobs_db.sql from rAthena SVN


zmref

Question


  • Group:  Members
  • Topic Count:  148
  • Topics Per Day:  0.03
  • Content Count:  299
  • Reputation:   6
  • Joined:  06/14/12
  • Last Seen:  

First, I execute the mobs_db.sql on MySQL with error

Next, I execute the items_db.sql on MySQL without errors

so I updated my rAthena SVN but still....

mobs_db.sql: FAILED with error

post-5357-0-78518300-1339649532_thumb.jpg

items_db.sql: SUCCESSFUL

Note:- I followed the steps on rAthena Wiki and it says that it doesn't matter what executes first either items or mobs database.

- What I did were only copy > paste > execute.

What's seems to be the problem?

Is there a problem with the mobs_db.sql from rAthena SVN?

Link to comment
Share on other sites

4 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  113
  • Reputation:   5
  • Joined:  06/06/12
  • Last Seen:  

Its better not to use mobs_db sql or item_db sql.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  148
  • Topics Per Day:  0.03
  • Content Count:  299
  • Reputation:   6
  • Joined:  06/14/12
  • Last Seen:  

What should I use? I just follow the rAthena Wiki. Are there any else latest mobs database available on some links for me to download and execute?.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  113
  • Reputation:   5
  • Joined:  06/06/12
  • Last Seen:  

if you set one of ur settings to read database mobs, revert it. Its better to use db/mobs txt

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  148
  • Topics Per Day:  0.03
  • Content Count:  299
  • Reputation:   6
  • Joined:  06/14/12
  • Last Seen:  

it's now Jun 27 2012 I updated my SVN and then execute the mobs.sql. It compiled, I guess the problem was on the past SVN files

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