Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Aion
You last visited: Today at 21:13

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

Advertisement



Re Housing Error .

Discussion on Re Housing Error . within the Aion forum part of the MMORPGs category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2009
Posts: 62
Received Thanks: 8
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 08/12/2017, 19:55   #2
 
elite*gold: 0
Join Date: Jan 2009
Posts: 62
Received Thanks: 8
bump
cinus is offline  
Reply


Similar Threads Similar Threads
Backyard Monsters Infinitive Housing..( A lot of Techniques to do it)
07/09/2011 - Facebook - 21 Replies
I HAVE IT.. !!! I AM THINKING IF I WILL SHARE IT DONT PM ME.. OR ELSE.. KICK OUT. .HAHAH !!
WTB housing NA
03/29/2011 - General Gaming Discussion - 1 Replies
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$. Will want to use playerauctions for trade or work out another way of "safe" trading. Thanks for any interest.
Suche Housing System
04/21/2010 - Flyff Private Server - 5 Replies
Suche das Housing System (komplett) und wie man es auf seinen eigenen Pserver draufmachen kann ? Frohe mich wer mir helfen kann :)
Abb Neagh Housing Maps
03/11/2010 - Mabinogi - 22 Replies
Creds go to me and CrystalArc :D extract to your mabinogi folder
Idea About Housing Glitch by the Use of Mods
02/06/2010 - Mabinogi - 14 Replies
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 where you put up a check for sale at your house and when people bought it, it duplicated. If you can edit restrictions (in .dll's) of where you can put a shop can you edit where you can place items such as checks into houses? When nexon patched this they may have only restricted checks from being put into houses. If so I think this glitch can be...



All times are GMT +2. The time now is 21:13.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.