MapleServer2 icon indicating copy to clipboard operation
MapleServer2 copied to clipboard

Auction house listing error

Open Maplems opened this issue 2 years ago • 0 comments

[2022-09-15 01:44:39] [Fatal] MapleServer2.Network.Session: Exception in recv PipeScheduler: MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot add or update a child row: a foreign key constraint fails (maple2_db.black_market_listings, CONSTRAINT fk_black_market_items_itemuid FOREIGN KEY (item_uid) REFERENCES items (uid) ON DELETE RESTRICT) at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in C:\projects\dapper\Dapper\SqlMapper.cs:line 1053 at Dapper.SqlMapper.QueryImpl[T](IDbConnection cnn, CommandDefinition command, Type effectiveType)+MoveNext() in C:\projects\dapper\Dapper\SqlMapper.cs:line 1081 at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Dapper.SqlMapper.Query[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable1 commandTimeout, Nullable1 commandType) in C:\projects\dapper\Dapper\SqlMapper.cs:line 723 at SqlKata.Execution.QueryFactory.Get[T](Query query, IDbTransaction transaction, Nullable1 timeout) at SqlKata.Execution.QueryExtensions.InsertGetId[T](Query query, Object data, IDbTransaction transaction, Nullable1 timeout) at MapleServer2.Database.Classes.DatabaseBlackMarketListing.Insert(BlackMarketListing listing) in D:\Maple2\MapleServer2_20220912\MapleServer2\Database\Classes\DatabaseBlackMarketListing.cs:line 12 at MapleServer2.Types.BlackMarketListing..ctor(Player player, Item item, Int32 listedQuantity, Int64 price, Int64 deposit) in D:\Maple2\MapleServer2_20220912\MapleServer2\Types\BlackMarketListing.cs:line 31 at MapleServer2.PacketHandlers.Game.BlackMarketHandler.HandleCreateListing(GameSession session, PacketReader packet) in D:\Maple2\MapleServer2_20220912\MapleServer2\PacketHandlers\Game\BlackMarketHandler.cs:line 141 at MapleServer2.PacketHandlers.Game.BlackMarketHandler.Handle(GameSession session, PacketReader packet) in D:\Maple2\MapleServer2_20220912\MapleServer2\PacketHandlers\Game\BlackMarketHandler.cs:line 53 at MapleServer2.Network.PacketRouter1.OnPacket(Object sender, PacketReader reader) in D:\Maple2\MapleServer2_20220912\MapleServer2\Network\PacketRouter.cs:line 23 at MapleServer2.Network.Session.ReadRecvPipe(PipeReader reader) in D:\Maple2\MapleServer2_20220912\MapleServer2\Network\Session.cs:line 263 [2022-09-15 01:44:39] [Information] MapleServer2.Servers.Game.GameServer: Game client disconnected: GameSession from 127.0.0.1:64192

Maplems avatar Sep 14 '22 18:09 Maplems