Rollback issue~

[iwtLive]

Hello,
Can anyone tell me what exactly causes a rollback here?.. and please don't just quote what it says I need an understandable answer so I can fix it, apparently people are abusing dupe since I'm getting a lot of saveToDB error logs.. ~_~

Error saving yolokid Level: 56 Job: 1221
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`moopledev`.`inventoryitems`, CONSTRAINT `FK_inventoryitems_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    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:3562)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
    at client.inventory.ItemFactory.saveItems(ItemFactory.java:163)
    at server.CashShop.save(CashShop.java:445)
    at client.MapleCharacter.saveToDB(MapleCharacter.java:3904)
    at net.server.channel.handlers.ChangeMapHandler.handlePacket(ChangeMapHandler.java:51)
    at net.MapleServerHandler.messageReceived(MapleServerHandler.java:127)
    at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:690)
    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
    at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:47)
    at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:765)
    at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:407)
    at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:236)
    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
    at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:47)
    at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:765)
    at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:109)
    at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
    at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:410)
    at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:710)
    at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:664)
    at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:653)
    at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:67)
    at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1124)
    at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.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) 

I guess the important part from this is

Cannot add or update a child row: a foreign key constraint fails (`moopledev`.`inventoryitems`, CONSTRAINT `FK_inventoryitems_1` FOREIGN KEY (`characterid`) REFERENCES `characters` (`id`) ON DELETE CASCADE) 

unfortunately I do not understand it...

[MentaL]

[Luxray]

It seems that the characterid you're using to put in inventoryitems does not exist in characters.

[iwtLive]

It seems that the characterid you're using to put in inventoryitems does not exist in characters.

that's a little weird, do you know where I might find the problem?

[Luxray]

The given characterid is probably incorrect. Either that or the character does not exist

[iwtLive]

The given characterid is probably incorrect. Either that or the character does not exist

do you have any idea of how I could pinpoint the exact location of the problem?

[sunnyboy]

People are abusing it? Would you mind finding out and tell us what they are doing to produce this error? That way we can most likely give a better answer

[iwtLive]

People are abusing it? Would you mind finding out and tell us what they are doing to produce this error? That way we can most likely give a better answer

that's the only error i found that's being spammed, as for who's doing it.. he keeps on changing accounts.. if i find out where he stands when he does it or some clue i'll put it here

[sunnyboy]

that's the only error i found that's being spammed, as for who's doing it.. he keeps on changing accounts.. if i find out where he stands when he does it or some clue i'll put it here

While you hunt him down, what version is it and look at what he's doing, what maps etc. Any patters he does a lot? Let us know!

[Luxray]

I presume this is duplication. You could try to set an if-statement if the character-id isn't null or matches the account that's logged in and dc/ban otherwise.
Though, it might be better to delve a bit deeper before doing that.
Like Sunnyboy says, every bit of information helps.

[sunnyboy]

I presume this is duplication.

Yeah. he said it in his first post O-o

[Luxray]

Yeah. he said it in his first post O-o

Must've skipped it.
Sorry

[iwtLive]

While you hunt him down, what version is it and look at what he's doing, what maps etc. Any patters he does a lot? Let us know!

i will~ i didn't get the chance to watch him yet he didnt log in

I presume this is duplication. You could try to set an if-statement if the character-id isn't null or matches the account that's logged in and dc/ban otherwise.
Though, it might be better to delve a bit deeper before doing that.
Like Sunnyboy says, every bit of information helps.

i already did that when i blocked some hacks

[Eden Nimni]

Look , I've messed with such problems before , you've changed something in your source that's related to the database,
Can you give me more details about the situation and when it's happening ?