Register for your free account! | Forgot your password?

You last visited: Today at 22:53

  • Please register to post and access all features, it's quick, easy and FREE!

 

Re Housing Error .

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2009
Posts: 46
Received Thanks: 7
Re Housing Error .

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



cinus is offline  
Old   #2
 
elite*gold: 0
Join Date: Jan 2009
Posts: 46
Received Thanks: 7
bump


cinus is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Backyard Monsters Infinitive Housing..( A lot of Techniques to do it)
I HAVE IT.. !!! I AM THINKING IF I WILL SHARE IT DONT PM ME.. OR ELSE.. KICK OUT. .HAHAH !!
21 Replies - Facebook
WTB housing NA
Looking to purchase any type of housing on the na server. please let me know the location and the attachments. Not looking to use more than 150$....
1 Replies - General Gaming Discussion
Suche Housing System
Suche das Housing System (komplett) und wie man es auf seinen eigenen Pserver draufmachen kann ? Frohe mich wer mir helfen kann :)
5 Replies - Flyff PServer - Discussions / Questions
Abb Neagh Housing Maps
Creds go to me and CrystalArc :D extract to your mabinogi folder
22 Replies - Mabinogi
Idea About Housing Glitch by the Use of Mods
I'm just hoping to get some real help here not a discussion on why we should or should not do this. As you all may know there used to be a glitch...
14 Replies - Mabinogi



All times are GMT +1. The time now is 22:53.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.