What do you have your password field set to in your mySQL database?
|
Look this is the problem. Any ideas on how to fix?
Code:MySQL ErrorUPDATE `players` SET absX = 2966, absY = 3379, height = 0, rights = 3, password = ryanmb WHERE playerid=8; java.sql.SQLException Unknown column 'ryanmb' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java1666) at com.mysql.jdbc.Connection.execSQL(Connection.java2988) at com.mysql.jdbc.Statement.executeUpdate(Statement.java935) at com.mysql.jdbc.Statement.executeUpdate(Statement.java873) at server.model.players.PlayerSave.query(PlayerSave.java28) at server.model.players.PlayerSave.saveGame(PlayerSave.java246) at server.model.players.PlayerHandler.process(PlayerHandler.java124) at server.Server.main(Server.java24) Game saved for player Rmb938 ClientHandler Client Rmb938 disconnected.
What do you have your password field set to in your mySQL database?
it is set as ryanmb. I am not sure what the problem is since it is just updating the row
ohh it is set as varchar(64) not null
Try setting it as a varchar(32) NOT NULL.
If that doesn't work post back.
it was set at 32 before and I changed it to 64 seeing if that would change it and it didn't. Do you want me to post the code that it is trying to execute?
Well, try one more way.
If it doesn't work post your code.Code:varchar(32) NOT NULL default 'never logged in',
nope that didn't work either so here is my code.
Code:query("UPDATE `players` SET absX = "+p.absX+", absY = "+p.absY+", height = "+p.heightLevel+", rights = "+p.playerRights+", password = "+p.playerPass+" WHERE playerid="+playerId+";");
Try deleting all the old information before inserting the new information.
Your code looks fine though.
« Previous Thread | Next Thread » |
Thread Information |
Users Browsing this ThreadThere are currently 1 users browsing this thread. (0 members and 1 guests) |