| Sign In | Main | Actions | Rules | Proposals | Players | Board | Message Board |
Some questions that I am frequently being asked by e-mail and their answers for everyone's benefit:
When I submit a proposal I get the following error:
java.sql.SQLException: Column 'madeby' cannot be null at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at com.mysql.jdbc.Connection.execSQL(Connection.java:2226) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1812) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1906) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1831) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1693) at nomopoly3.Proposals.handlePost(Proposals.java:308) at q17.server.http.HttpBranchServer.handlePost(HttpBranchServer.java:54) at q17.server.http.HttpServer.handleConnection(HttpServer.java:257) at q17.server.Server$ConnectionDispatcher.run(Server.java:192)
This happens if you try to submit a proposal when you're not signed in, or your sign in has expired. When you sign in, you must load a page from the server at least every 20 minutes or your sign in will expire. (This is configurable by me, but I have many reasons to keep it this way). Most likely what happened was you went to the Proposals page, and spent more than 20 minutes writing your proposal. For this reason, I recommend that you write your proposals (or anything else that may take some time to write) in a text editor and then copy and paste the text onto the web site.
Sometimes when I load the rules page, I get the the Nomopoly menu bar and page title, and the rest of the page is blank.
Without going into too much detail on database transactions, chances are I was implementing a proposal and/or editing the rules. While I am editing the rules, the rules page is locked until I commit the changes, so your browser won't be able to load it. I don't spend too long editing the rules at one time, so just wait 5 minutes and the problem should go away.
Sometimes the server signs me out for no apparent reason.
One answer may be the situation above, where if you are idle for 20 minues your sign in expires. Also, I occasionally have to restart the server when performing upgrades to the core server software, and when the server restarts all active sign ins are cleared. I try my best to perform necessary server restarts when nobody is online, but I can't make any guarantees.