[Release] Fix bug AQ succeeded but AsyncQueryCompleted() error occurred

[Laag#82]

Hello to everyone.

This error comes from table (_Inventory)

PHP Code:


Write this (NourAyman in rage....)


Disconnect when buy anything from any shop !

If drop any item get DC and get fatal error line on GameServer
If split any item get DC and get fatal error line on GameServer
If collect dropped get DC and get fatal error line on GameServer
If transfer item to storge get DC and get fatal error line on GameServer 


Error

PHP Code:

Query: {CALL _STRG_SPLIT_ITEM (?, ?, 0, 1,11578, 13,34, 3,2)} 


PHP Code:

Query: {CALL _STRG_ADD_EXPENDABLE (?, ?, 28, 64,38907, 1)} 


PHP Code:

Query: {CALL _STRG_ADD_EQUIP_NORMAL (?, ?, 14, 50449,27, 24247,0,0,56)} 


PHP Code:

AQ Failed! Log out!! [AQType: 1] 


PHP Code:

https://www.elitepvpers.com/forum/sro-private-server/4235920-aq-failed-log-out-aqtype-5-a.html 


PHP Code:

AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 


PHP Code:

https://www.elitepvpers.com/forum/sro-private-server/2408356-help-costum-npc-items-cant-buy-coin.html 


How can this problem be solved

After clean (SRO_VT_SHARD)

Delete

PHP Code:

_Inventory 


Rebuild

PHP Code:

USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_Inventory]    Script Date: 7/9/2021 3:18:38 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_Inventory](
    [CharID] [int] NOT NULL,
    [Slot] [tinyint] NOT NULL,
    [ItemID] [bigint] NOT NULL,
 CONSTRAINT [PK_Inventory] PRIMARY KEY CLUSTERED 
(
    [CharID] ASC,
    [Slot] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[_Inventory]  WITH CHECK ADD  CONSTRAINT [FK__Inventory__Char] FOREIGN KEY([CharID])
REFERENCES [dbo].[_Char] ([CharID])
GO

ALTER TABLE [dbo].[_Inventory] CHECK CONSTRAINT [FK__Inventory__Char]
GO

ALTER TABLE [dbo].[_Inventory]  WITH CHECK ADD  CONSTRAINT [FK__Inventory__Items] FOREIGN KEY([ItemID])
REFERENCES [dbo].[_Items] ([ID64])
GO

ALTER TABLE [dbo].[_Inventory] CHECK CONSTRAINT [FK__Inventory__Items]
GO 


Good Luck to everyone

[zagorodnov]

it's not "fix", it's bullshit

[Laag#82]

Originally Posted by zagorodnov

it's not "fix", it's bullshit

how do you know that

[_SGA_]

If this happens to you, make sure the MSSQL user account you're using for the server has the rights to change modify add delete to mssql. If there is no problem with the user accounts than it means you messed up the stored procedures (mssql queries found in stored procedures section of mssql manager). Replace them with working ones from another database especially the ones related to items and inventory.

[zagorodnov]

Originally Posted by khaleed2010

how do you know that

Your players lost all invertory. it's very bad way.
And you're not fixing the problem, you're fixing the consequences

[Abdo knight]

how you know that ?

[sasa5214]

Thank you ^^ <3

[KjDBun]

do you have any other way?