[Help] Bank Saving (SQL)

I know it's a SQL issue just dunno how to fix..
I put items in bank, close bank, re-open, the items are still there. Log off >> back in>> items are gone.
Error:

Code:

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cann ot add or update a child row: a foreign key constraint fails (`v97`.`inventoryit ems`, CONSTRAINT `FK_inventoryitems_2` FOREIGN KEY (`accountid`) REFERENCES `acc ounts` (`id`) ON DELETE CASCADE) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:2113) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2409) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2327) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2312) at client.ItemFactory.saveItems(ItemFactory.java:156) at server.MapleStorage.saveToDB(MapleStorage.java:132) at client.MapleCharacter.saveToDB(MapleCharacter.java:4122) at client.MapleClient.disconnect(MapleClient.java:621) at net.MapleServerHandler.sessionClosed(MapleServerHandler.java:105) at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.sess ionClosed(DefaultIoFilterChain.java:662) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextSession Closed(DefaultIoFilterChain.java:386) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$900(Defa ultIoFilterChain.java:51) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.ses sionClosed(DefaultIoFilterChain.java:797) at org.apache.mina.filter.codec.ProtocolCodecFilter.sessionClosed(Protoc olCodecFilter.java:317) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextSession Closed(DefaultIoFilterChain.java:386) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$900(Defa ultIoFilterChain.java:51) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.ses sionClosed(DefaultIoFilterChain.java:797) at org.apache.mina.core.filterchain.IoFilterAdapter.sessionClosed(IoFilt erAdapter.java:95) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextSession Closed(DefaultIoFilterChain.java:386) at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireSessionClos ed(DefaultIoFilterChain.java:379) at org.apache.mina.core.service.IoServiceListenerSupport.fireSessionDest royed(IoServiceListenerSupport.java:210) at org.apache.mina.core.polling.AbstractPollingIoProcessor.removeNow(Abs tractPollingIoProcessor.java:535) at org.apache.mina.core.polling.AbstractPollingIoProcessor.removeSession s(AbstractPollingIoProcessor.java:497) at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(Ab stractPollingIoProcessor.java:61) at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run (AbstractPollingIoProcessor.java:974) at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnabl e.java:64) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cann ot add or update a child row: a foreign key constraint fails (`v97`.`inventoryit ems`, CONSTRAINT `FK_inventoryitems_2` FOREIGN KEY (`accountid`) REFERENCES `acc ounts` (`id`) ON DELETE CASCADE) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou rce) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:2113) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2409) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2327) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2312) at client.ItemFactory.saveItems(ItemFactory.java:156) at server.MapleStorage.saveToDB(MapleStorage.java:132) at client.MapleCharacter.saveToDB(MapleCharacter.java:4122) at client.MapleClient.disconnect(MapleClient.java:695) at net.MapleServerHandler.sessionClosed(MapleServerHandler.java:105) at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.sess ionClosed(DefaultIoFilterChain.java:662) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextSession Closed(DefaultIoFilterChain.java:386) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$900(Defa ultIoFilterChain.java:51) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.ses sionClosed(DefaultIoFilterChain.java:797) at org.apache.mina.filter.codec.ProtocolCodecFilter.sessionClosed(Protoc olCodecFilter.java:317) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextSession Closed(DefaultIoFilterChain.java:386) at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$900(Defa ultIoFilterChain.java:51) at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.ses sionClosed(DefaultIoFilterChain.java:797) at org.apache.mina.core.filterchain.IoFilterAdapter.sessionClosed(IoFilt erAdapter.java:95) at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextSession Closed(DefaultIoFilterChain.java:386) at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireSessionClos ed(DefaultIoFilterChain.java:379) at org.apache.mina.core.service.IoServiceListenerSupport.fireSessionDest royed(IoServiceListenerSupport.java:210) at org.apache.mina.core.polling.AbstractPollingIoProcessor.removeNow(Abs tractPollingIoProcessor.java:535) at org.apache.mina.core.polling.AbstractPollingIoProcessor.removeSession s(AbstractPollingIoProcessor.java:497) at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(Ab stractPollingIoProcessor.java:61) at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run (AbstractPollingIoProcessor.java:974) at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnabl e.java:64) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)

Hope any1 can help me out, thanks :)

Re: [Help] Bank Saving (SQL)

it's not saving to database?
player.saveToDB(true);

Re: [Help] Bank Saving (SQL)

Quote:

Originally Posted by lordpeter

it's not saving to database?
player.saveToDB(true);

Uh Noo
When you log out it saves so how would saving before logout help?

Re: [Help] Bank Saving (SQL)

nn
ot add or update a child row: a foreign key constraint fails (`v97`.`inventoryit
ems`, CONSTRAINT `FK_inventoryitems_2` FOREIGN KEY (`accountid`) REFERENCES `acc
ounts` (`id`) ON DELETE CASCADE)

Re: [Help] Bank Saving (SQL)

And this means...?
What can I do to save it?

Re: [Help] Bank Saving (SQL)

Which repack\source do you use?

Re: [Help] Bank Saving (SQL)

What are your tables in?
MyISAM or InnoDB?

Make sure all your tables are one of them, you cannot have one of them InnoDB and one of the MyISAM.

Re: [Help] Bank Saving (SQL)

How can I check for something like that? =\

Edit: I found in the MySQL options "InnoDB default storage engine"..

Edit 2: Fixed, GMs can't put items in bank and therefore, i got the stupid bat error.