Moved from 3CeAM to rAthena but then this.

[Zaon]

 

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?

[DeadlySilence]

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

[Zaon]

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

[michaelsoftman]

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.

[Euphy]

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

[Zaon]

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 July 26, 2013 by Zaon

[Zaon]

Bump

[michaelsoftman]

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.

[Zaon]

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