Jump to content
  • 0

Moved from 3CeAM to rAthena but then this.


Zaon

Question


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.00
  • Content Count:  60
  • Reputation:   0
  • Joined:  07/30/12
  • Last Seen:  

jHFii9L.png

 

Got this error. Couldn't create a character it just says "Character Creation is Denied".

Even my other characters, which are fine in 3CeAM, are not there.

 

Help please?

Link to comment
Share on other sites

8 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  181
  • Reputation:   53
  • Joined:  04/07/13
  • Last Seen:  

Obviously the 'robe' column is missing in the 'char' table. Did you import the rAthena sql files properly and without any error?

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.00
  • Content Count:  60
  • Reputation:   0
  • Joined:  07/30/12
  • Last Seen:  

Yes I didn't encounter any errors with updating my SQL Database.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  48
  • Topics Per Day:  0.01
  • Content Count:  410
  • Reputation:   29
  • Joined:  04/04/12
  • Last Seen:  

Check your char table manually.  You may have to drop all of your tables and just execute rAthena's main.sql and logs.sql to start.  3ceam's don't have the same fields as rA's.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  72
  • Topics Per Day:  0.02
  • Content Count:  2997
  • Reputation:   1130
  • Joined:  05/27/12
  • Last Seen:  

You have to execute all the SQL upgrade files in trunk/sql-files/upgrades - yes, there's a lot. xD

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.00
  • Content Count:  60
  • Reputation:   0
  • Joined:  07/30/12
  • Last Seen:  

You have to execute all the SQL upgrade files in trunk/sql-files/upgrades - yes, there's a lot. xD

Once I execute everything it'll work withouth any problems?

 

Edit: I executed everything WITHOUT ERRORS but the same thing still happened.

 

: DB Error - Unknown column 'robe' in 'field list'
Edited by Zaon
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.00
  • Content Count:  60
  • Reputation:   0
  • Joined:  07/30/12
  • Last Seen:  

Bump

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  48
  • Topics Per Day:  0.01
  • Content Count:  410
  • Reputation:   29
  • Joined:  04/04/12
  • Last Seen:  

The fields are in a different order with 3ceam.

 

In rAthena, it goes head_bottom, robe, last_map, etc

In 3ceam, it goes head_bottom, last_map, rename, delete_date, robe, etc

 

Either re-arrange the fields in the table, or delete the whole table and start over with rAthena's.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  19
  • Topics Per Day:  0.00
  • Content Count:  60
  • Reputation:   0
  • Joined:  07/30/12
  • Last Seen:  

The fields are in a different order with 3ceam.

 

In rAthena, it goes head_bottom, robe, last_map, etc

In 3ceam, it goes head_bottom, last_map, rename, delete_date, robe, etc

 

Either re-arrange the fields in the table, or delete the whole table and start over with rAthena's.

 

Ohh thanks. I'll try this

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