Column 'honourExp' not found. error.

Hey,

I can open the game but when i enter the PIC it gives me this error in cmd.

Code:

---

Failed to load character..
java.sql.SQLException: Column 'honourExp' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1145)
        at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2814)
        at client.MapleCharacter.loadCharFromDB(MapleCharacter.java:699)
        at client.MapleCharacter.loadCharFromDB(MapleCharacter.java:620)
        at handling.channel.handler.InterServerHandler.Loggedin(InterServerHandl
er.java:175)

---

Database. Add the Column.

Just for the record, you're getting WAY too many errors.
I'd advice you to switch sources.

Quote:

---

Originally Posted by The Sharingan

Just for the record, you're getting WAY too many errors.
I'd advice you to switch sources.

---

More like he doesn't know how to set-up a server. lmao

Quote:

---

Originally Posted by TheIceBreaker

More like he doesn't know how to set-up a server. lmao

---

That too.

Quote:

---

Originally Posted by Artjom

Hey,

I can open the game but when i enter the PIC it gives me this error in cmd.

Code:

---

Failed to load character..
java.sql.SQLException: Column 'honourExp' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:929)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1145)
        at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2814)
        at client.MapleCharacter.loadCharFromDB(MapleCharacter.java:699)
        at client.MapleCharacter.loadCharFromDB(MapleCharacter.java:620)
        at handling.channel.handler.InterServerHandler.Loggedin(InterServerHandl
er.java:175)

---

---

Well just add them. If you don't even know how to add them, please quit making a server

execute this in My SQL..
XXX=your database name
I used to have this...theres more than just honourexp...I'll just make the sql for you :)

Code:

---

USE vXXX;

ALTER TABLE `characters` ADD COLUMN `honourExp` int(11) NOT NULL DEFAULT 0;
ALTER TABLE `characters` ADD COLUMN `honourLevel` int(11) NOT NULL DEFAULT 0;
ALTER TABLE `characters` ADD COLUMN `damage` int(11) NOT NULL DEFAULT 0;
ALTER TABLE `characters` ADD COLUMN `showdamage` int(11) NOT NULL DEFAULT 0;

---