[Help] Bank Saving (SQL)

**iCaseVac** · 12-05-12

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 :)

**MentaL**

**lordpeter** · 12-05-12

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

**TiredGuy** · 12-05-12

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?

**Control** · 13-05-12

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)

**iCaseVac** · 13-05-12

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

**AngryPepe** · 13-05-12

Which repack\source do you use?

**maplefreak26** · 13-05-12

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.

**iCaseVac** · 14-05-12

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.

[Help] Bank Saving (SQL)

Thread Tools

Search Thread

[Help] Bank Saving (SQL)

Re: [Help] Bank Saving (SQL)

Re: [Help] Bank Saving (SQL)

Re: [Help] Bank Saving (SQL)

Re: [Help] Bank Saving (SQL)

Re: [Help] Bank Saving (SQL)

Re: [Help] Bank Saving (SQL)

Re: [Help] Bank Saving (SQL)

Advertisement