Code:
java.sql.SQLException: Field 'pet' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524)
at com.rs2.net.RegisterListener$Register.run(RegisterListener.java:99)
This is what happens when I try to register a new account using the client provided, I port forwarded, set up my SQL, and changed the password in the server.
Base: http://www.rune-server.org/runescape...ml#post2724179
EDIT: By editing out Pet, and Running I got the account to register however now when I log in it says..
Code:
[00:00:01]: Injected FlagMap with 105531 objects covering 208255 tiles in 330ms.
[00:00:01]: listening for connections on port 43594.
[00:00:32]: java.sql.SQLException: Column 'running' not found.
[00:00:32]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055
)
[00:00:32]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
[00:00:32]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
[00:00:32]: at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:11
36)
[00:00:32]: at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2777)
[00:00:32]: at com.rs2.net.Login.process(Login.java:210)
[00:00:32]: at com.rs2.net.Login.read(Login.java:363)
[00:00:32]: at com.rs2.net.ConnectionListener.read(ConnectionListener.java:1
23)
[00:00:32]: at com.rs2.net.ConnectionListener.run(ConnectionListener.java:77
)
[00:00:32]: at java.lang.Thread.run(Thread.java:662)
[00:00:32]: Zoft logged in [idx=1, online=1]
[00:00:33]: java.sql.SQLException: Column 'running' not found.
[00:00:33]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055
)
[00:00:33]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
[00:00:33]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
[00:00:33]: at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:11
36)
[00:00:33]: at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2777)
[00:00:33]: at com.rs2.net.Login.process(Login.java:210)
[00:00:33]: at com.rs2.net.Login.read(Login.java:363)
[00:00:33]: at com.rs2.net.ConnectionListener.read(ConnectionListener.java:1
23)
[00:00:33]: at com.rs2.net.ConnectionListener.run(ConnectionListener.java:77
)
[00:00:33]: at java.lang.Thread.run(Thread.java:662)
[00:00:33]: Zoft logged in [idx=1, online=1]
[00:00:34]: java.sql.SQLException: Column 'running' not found.
[00:00:34]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055
)
[00:00:34]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
[00:00:34]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
[00:00:34]: at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:11
36)
[00:00:34]: at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2777)
[00:00:34]: at com.rs2.net.Login.process(Login.java:210)
[00:00:34]: at com.rs2.net.Login.read(Login.java:363)
[00:00:34]: at com.rs2.net.ConnectionListener.read(ConnectionListener.java:1
23)
[00:00:34]: at com.rs2.net.ConnectionListener.run(ConnectionListener.java:77
)
[00:00:34]: at java.lang.Thread.run(Thread.java:662)
[00:00:34]: Zoft logged in [idx=1, online=1]