Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Auction house listing error #749

Open
Maplems opened this issue Sep 14, 2022 · 0 comments
Open

Auction house listing error #749

Maplems opened this issue Sep 14, 2022 · 0 comments
Labels
bug Something isn't working good first issue Good for newcomers

Comments

@Maplems
Copy link

Maplems commented Sep 14, 2022

[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

@AngeloTadeucci AngeloTadeucci added the bug Something isn't working label Sep 15, 2022
@AngeloTadeucci AngeloTadeucci moved this to Bugs in MapleServer2 Sep 15, 2022
@Sparkymod Sparkymod added the good first issue Good for newcomers label Sep 20, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working good first issue Good for newcomers
Projects
Status: Bugs
Development

No branches or pull requests

3 participants