Re Housing Error .

08/09/2017 21:30 cinus#1
Hi someone tell me what going on with this error and how to fix this ???
Code:
2017-08-09 19:20:38,811 ERROR [main] mysql5.MySQL5HousesDAO [MySQL5HousesDAO.java]:152] Could not store studio data. Column 'acquire_time' cannot be null
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'acquire_time' cannot be null
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HousesDAO.insertNewHouse(MySQL5HousesDAO.java]:148) [na:na]
	at mysql5.MySQL5HousesDAO.storeHouse(MySQL5HousesDAO.java]:103) [na:na]
	at com.aionemu.gameserver.model.house.House.save(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:38,844 ERROR [main] mysql5.MySQL5HouseBidsDAO [MySQL5HouseBidsDAO.java]:104] Cannot insert house bid
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`al_server_gs`.`house_bids`, CONSTRAINT `house_id_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HouseBidsDAO.addBid(MySQL5HouseBidsDAO.java]:101) ~[na:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:38,849 ERROR [main] mysql5.MySQL5HousesDAO [MySQL5HousesDAO.java]:152] Could not store studio data. Column 'acquire_time' cannot be null
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'acquire_time' cannot be null
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HousesDAO.insertNewHouse(MySQL5HousesDAO.java]:148) [na:na]
	at mysql5.MySQL5HousesDAO.storeHouse(MySQL5HousesDAO.java]:103) [na:na]
	at com.aionemu.gameserver.model.house.House.save(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:38,888 ERROR [main] mysql5.MySQL5HouseBidsDAO [MySQL5HouseBidsDAO.java]:104] Cannot insert house bid
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`al_server_gs`.`house_bids`, CONSTRAINT `house_id_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HouseBidsDAO.addBid(MySQL5HouseBidsDAO.java]:101) ~[na:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:38,893 ERROR [main] mysql5.MySQL5HousesDAO [MySQL5HousesDAO.java]:152] Could not store studio data. Column 'acquire_time' cannot be null
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'acquire_time' cannot be null
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HousesDAO.insertNewHouse(MySQL5HousesDAO.java]:148) [na:na]
	at mysql5.MySQL5HousesDAO.storeHouse(MySQL5HousesDAO.java]:103) [na:na]
	at com.aionemu.gameserver.model.house.House.save(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:38,933 ERROR [main] mysql5.MySQL5HouseBidsDAO [MySQL5HouseBidsDAO.java]:104] Cannot insert house bid
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`al_server_gs`.`house_bids`, CONSTRAINT `house_id_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HouseBidsDAO.addBid(MySQL5HouseBidsDAO.java]:101) ~[na:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:38,939 ERROR [main] mysql5.MySQL5HousesDAO [MySQL5HousesDAO.java]:152] Could not store studio data. Column 'acquire_time' cannot be null
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'acquire_time' cannot be null
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HousesDAO.insertNewHouse(MySQL5HousesDAO.java]:148) [na:na]
	at mysql5.MySQL5HousesDAO.storeHouse(MySQL5HousesDAO.java]:103) [na:na]
	at com.aionemu.gameserver.model.house.House.save(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:38,977 ERROR [main] mysql5.MySQL5HouseBidsDAO [MySQL5HouseBidsDAO.java]:104] Cannot insert house bid
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`al_server_gs`.`house_bids`, CONSTRAINT `house_id_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HouseBidsDAO.addBid(MySQL5HouseBidsDAO.java]:101) ~[na:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:38,981 ERROR [main] mysql5.MySQL5HousesDAO [MySQL5HousesDAO.java]:152] Could not store studio data. Column 'acquire_time' cannot be null
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'acquire_time' cannot be null
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HousesDAO.insertNewHouse(MySQL5HousesDAO.java]:148) [na:na]
	at mysql5.MySQL5HousesDAO.storeHouse(MySQL5HousesDAO.java]:103) [na:na]
	at com.aionemu.gameserver.model.house.House.save(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:39,016 ERROR [main] mysql5.MySQL5HouseBidsDAO [MySQL5HouseBidsDAO.java]:104] Cannot insert house bid
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`al_server_gs`.`house_bids`, CONSTRAINT `house_id_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HouseBidsDAO.addBid(MySQL5HouseBidsDAO.java]:101) ~[na:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:39,022 ERROR [main] mysql5.MySQL5HousesDAO [MySQL5HousesDAO.java]:152] Could not store studio data. Column 'acquire_time' cannot be null
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'acquire_time' cannot be null
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HousesDAO.insertNewHouse(MySQL5HousesDAO.java]:148) [na:na]
	at mysql5.MySQL5HousesDAO.storeHouse(MySQL5HousesDAO.java]:103) [na:na]
	at com.aionemu.gameserver.model.house.House.save(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:39,124 ERROR [main] mysql5.MySQL5HouseBidsDAO [MySQL5HouseBidsDAO.java]:104] Cannot insert house bid
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`al_server_gs`.`house_bids`, CONSTRAINT `house_id_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HouseBidsDAO.addBid(MySQL5HouseBidsDAO.java]:101) ~[na:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:39,130 ERROR [main] mysql5.MySQL5HousesDAO [MySQL5HousesDAO.java]:152] Could not store studio data. Column 'acquire_time' cannot be null
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'acquire_time' cannot be null
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HousesDAO.insertNewHouse(MySQL5HousesDAO.java]:148) [na:na]
	at mysql5.MySQL5HousesDAO.storeHouse(MySQL5HousesDAO.java]:103) [na:na]
	at com.aionemu.gameserver.model.house.House.save(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:39,160 ERROR [main] mysql5.MySQL5HouseBidsDAO [MySQL5HouseBidsDAO.java]:104] Cannot insert house bid
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`al_server_gs`.`house_bids`, CONSTRAINT `house_id_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HouseBidsDAO.addBid(MySQL5HouseBidsDAO.java]:101) ~[na:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:39,165 ERROR [main] mysql5.MySQL5HousesDAO [MySQL5HousesDAO.java]:152] Could not store studio data. Column 'acquire_time' cannot be null
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'acquire_time' cannot be null
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HousesDAO.insertNewHouse(MySQL5HousesDAO.java]:148) [na:na]
	at mysql5.MySQL5HousesDAO.storeHouse(MySQL5HousesDAO.java]:103) [na:na]
	at com.aionemu.gameserver.model.house.House.save(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:39,199 ERROR [main] mysql5.MySQL5HouseBidsDAO [MySQL5HouseBidsDAO.java]:104] Cannot insert house bid
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`al_server_gs`.`house_bids`, CONSTRAINT `house_id_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
	at sun.reflect.GeneratedConstructorAccessor463.newInstance(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33]
	at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
	at mysql5.MySQL5HouseBidsDAO.addBid(MySQL5HouseBidsDAO.java]:101) ~[na:na]
	at com.aionemu.gameserver.services.HousingBidService.addHouseToAuction(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.fillBidData(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.services.HousingBidService.start(Unknown Source) [AL-Game.jar:na]
	at com.aionemu.gameserver.GameServer.main(Unknown Source) [AL-Game.jar:na]
2017-08-09 19:20:39,221 INFO  [main] HOUSE_AUCTION_LOG [null:-1] HousingBidService: added 72 new house bids.
2017-08-09 19:20:39,222 INFO  [main] HOUSE_AUCTION_LOG [null:-1] HousingBidService loaded. Minutes till start: 5324
2017-08-09 19:20:39,224 INFO  [main] com.aionemu.gameserver.model.house.MaintenanceTask [null:-1] Initializing House maintenance task...
2017-08-09 19:20:39,242 INFO  [main] com.aionemu.gameserver.services.TownService [null:-1] Loaded 25 elyos towns.
2017-08-09 19:20:39,243 INFO  [main] com.aionemu.gameserver.services.TownService [null:-1] Loaded 25 asmodians towns.
2017-08-09 19:20:39,246 INFO  [main] com.aionemu.gameserver.services.ChallengeTaskService [null:-1] ChallengeTaskService initialized.
2017-08-09 19:20:39,249 INFO  [main] com.aionemu.gameserver.ai2.manager.LookManager [null:-1] LookManager initialized
2017-08-09 19:20:39,252 INFO  [main] com.aionemu.gameserver.services.SupportService [null:-1] SupportService initialized
2017-08-09 19:20:39,255 INFO  [main] com.aionemu.gameserver.services.RestartService [null:-1] Checking AutoShutdown Schedule...
2017-08-09 19:20:39,255 INFO  [main] com.aionemu.gameserver.services.RestartService [null:-1] Starting RestartService ...
2017-08-09 19:20:39,257 WARN  [main] com.aionemu.gameserver.services.RestartService [null:-1] Automatic restart/shutdown system disable.
2017-08-09 19:20:45,203 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:119] OS: Windows 8.1 Build: 6.3
2017-08-09 19:20:45,206 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:119] OS Arch: amd64
2017-08-09 19:20:45,207 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:119] ..................................................
2017-08-09 19:20:45,208 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:119] ..................................................
2017-08-09 19:20:45,210 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:114] Available CPU(s): 4
2017-08-09 19:20:45,211 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:114] Processor(s) Identifier: Intel64 Family 6 Model 94 Stepping 3, GenuineIntel
2017-08-09 19:20:45,211 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:114] ..................................................
2017-08-09 19:20:45,211 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:114] ..................................................
2017-08-09 19:20:45,211 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:124] Java Platform Information
2017-08-09 19:20:45,212 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:124] Java Runtime  Name: Java(TM) SE Runtime Environment
2017-08-09 19:20:45,212 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:124] Java Version: 1.7.0_80
2017-08-09 19:20:45,212 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:124] Java Class Version: 51.0
2017-08-09 19:20:45,213 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:124] ..................................................
2017-08-09 19:20:45,213 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:124] ..................................................
2017-08-09 19:20:45,213 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:129] Virtual Machine Information (JVM)
2017-08-09 19:20:45,214 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:129] JVM Name: Java HotSpot(TM) 64-Bit Server VM
2017-08-09 19:20:45,214 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:129] JVM installation directory: C:\Program Files\Java\jdk1.7.0_80\jre
2017-08-09 19:20:45,215 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:129] JVM version: 24.80-b11
2017-08-09 19:20:45,216 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:129] JVM Vendor: Oracle Corporation
2017-08-09 19:20:45,216 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:129] JVM Info: mixed mode
2017-08-09 19:20:45,217 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:129] ..................................................
2017-08-09 19:20:45,217 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:129] ..................................................
2017-08-09 19:20:45,220 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] +----
2017-08-09 19:20:45,220 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] | Global Memory Informations at 19:20:45:
2017-08-09 19:20:45,220 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] |    |
2017-08-09 19:20:45,221 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] | Allowed Memory: 8386176 KB
2017-08-09 19:20:45,222 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] |    |= Allocated Memory: 3621472 KB (43,1838%)
2017-08-09 19:20:45,222 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] |    |= Non-Allocated Memory: 4764704 KB (56,8162%)
2017-08-09 19:20:45,223 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] | Allocated Memory: 3621472 KB
2017-08-09 19:20:45,223 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] |    |= Used Memory: 2160539 KB (25,7631%)
2017-08-09 19:20:45,223 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] |    |= Unused (cached) Memory: 1460933 KB (17,4207%)
2017-08-09 19:20:45,224 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] | Useable Memory: 6225637 KB (74,2369%)
2017-08-09 19:20:45,226 INFO  [main] com.aionemu.commons.utils.AEInfos [AEInfos.java:109] +----
2017-08-09 19:20:45,227 INFO  [main] com.aionemu.gameserver.GameServer [null:-1] AL GameServer started in 52 seconds.
2017-08-09 19:20:45,230 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] ==================================================
2017-08-09 19:20:45,230 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] ==============>Aion Lightning Core<===============
2017-08-09 19:20:45,231 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] ==========>developed by Aion Core Group<==========
2017-08-09 19:20:45,231 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] ======================>and<=======================
2017-08-09 19:20:45,232 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] ===============>Aion German Group<================
2017-08-09 19:20:45,232 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] ==================================================
2017-08-09 19:20:45,233 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] Thanks to all who helped this project!
2017-08-09 19:20:45,233 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] Major Patch: 4.7
2017-08-09 19:20:45,234 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] Minor Patch: 4.7.5.15
2017-08-09 19:20:45,234 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] Copyright: 2014-2015
2017-08-09 19:20:45,236 INFO  [main] com.aionemu.gameserver.utils.ZCXInfo [null:-1] ==================================================
2017-08-09 19:20:45,258 INFO  [main] com.aionemu.commons.network.NioServer [NioServer.java:119] Server listening on all available IPs on Port 7777 for Game Connections
Thx
08/12/2017 19:55 cinus#2
bump