User Creation Error

[EvilMario]

Hi everyone,

I've setup a MySQL DB, and checked out and built the project. I've been having a bit of trouble with user creation though. I know it's a table missing in the database, but I'm not sure what to do to fix this. Here's the trace/error. Any advice would be greatly appreciated.

Macintosh:Shoddybattle rootuser$ java -cp dist/ShoddyBattle.jar shoddybattle.AccountEditor USERNAME PASSWORD 2
Loading properties file...
Loading metagame definition file...
Connecting to database...
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'shoddybattle.users' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
at netbattle.database.registry.DatabaseImpl.getPassword(DatabaseImpl.java:215)
at netbattle.database.registry.DatabaseImpl.containsUser(DatabaseImpl.java:177)
at netbattle.database.registry.DatabaseImpl.addNewUser(DatabaseImpl.java:642)
at shoddybattle.AccountEditor.main(AccountEditor.java:101)
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'shoddybattle.users' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
at netbattle.database.registry.DatabaseImpl.addNewUser(DatabaseImpl.java:655)
at shoddybattle.AccountEditor.main(AccountEditor.java:101)
User already exists; password will not be modified.
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'shoddybattle.users' doesn't exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)
at netbattle.database.registry.DatabaseImpl.setUserLevel(DatabaseImpl.java:1023)
at shoddybattle.AccountEditor.main(AccountEditor.java:111)
User level set successfully.