Pleas Help Client Crash

[AzarOnline]

_Solved_

[badrbadr]

The solution exists but needs a focus to see
You need to take a backup of the data before you start solving the problem
The solution
Go to the tab to solve the problem in the data and make copies of internal files to him in a file
Then wipe the tab and use the script sent to you after wiping the tab will perform a new repentance does not exist by your problem, *** willing
If you can not do this, please send me a message
/////////
USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_RefPackageItem] Script Date: 9/22/2018 3:31:31 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_RefPackageItem](
[Service] [tinyint] NOT NULL,
[Country] [int] NOT NULL,
[ID] [int] IDENTITY(1,1) NOT NULL,
[CodeName128] [varchar](129) NOT NULL,
[SaleTag] [smallint] NOT NULL,
[ExpandTerm] [varchar](65) NOT NULL,
[NameStrID] [varchar](129) NOT NULL,
[DescStrID] [varchar](129) NOT NULL,
[AssocFileIcon] [varchar](129) NOT NULL,
[Param1] [int] NOT NULL,
[Param1_Desc128] [varchar](129) NOT NULL,
[Param2] [int] NOT NULL,
[Param2_Desc128] [varchar](129) NOT NULL,
[Param3] [int] NOT NULL,
[Param3_Desc128] [varchar](129) NOT NULL,
[Param4] [int] NOT NULL,
[Param4_Desc128] [varchar](129) NOT NULL,
CONSTRAINT [PK__RefPackageItem] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

[AzarOnline]

Thank You for replay But The same Problem

No one know how can i fix this problem?

[loader8]

hi bro
you can make it with this program


vsroNPC will help you with that,
read Edit SQL seccion.

[badrbadr]

Your problem files are not the same between SQL and Client

[thebigbody]

the problem is caused by this stupid program vsro NPC because it rebuild the database ids and lines which won't be compatible with the client lines and ofc will cause a crash
you will have to rebuild all the media texts with the new ids in the db or simply
add your items manually better for u

[badrbadr]

Solve the problem large you need to modify 4 tabs and to modify them follow the following explain how to modify them, but you need to take a backup version of the data
**********
You have to take the following plugins into the following file Test

_RefPackageItem
_RefPricePolicyOfItem
_RefScrapOfPackageItem
_RefShopGoods

Now delete the Tap until we add them again

USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_RefPackageItem] Script Date: 9/24/2018 12:39:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_RefPackageItem](
[Service] [tinyint] NOT NULL,
[Country] [int] NOT NULL,
[ID] [int] IDENTITY(1,1) NOT NULL,
[CodeName128] [varchar](129) NOT NULL,
[SaleTag] [smallint] NOT NULL,
[ExpandTerm] [varchar](65) NOT NULL,
[NameStrID] [varchar](129) NOT NULL,
[DescStrID] [varchar](129) NOT NULL,
[AssocFileIcon] [varchar](129) NOT NULL,
[Param1] [int] NOT NULL,
[Param1_Desc128] [varchar](129) NOT NULL,
[Param2] [int] NOT NULL,
[Param2_Desc128] [varchar](129) NOT NULL,
[Param3] [int] NOT NULL,
[Param3_Desc128] [varchar](129) NOT NULL,
[Param4] [int] NOT NULL,
[Param4_Desc128] [varchar](129) NOT NULL,
CONSTRAINT [PK__RefPackageItem] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


//////////////////////////////////////////////////////////////

USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_RefPricePolicyOfItem] Script Date: 9/24/2018 15:58:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_RefPricePolicyOfItem](
[Service] [tinyint] NOT NULL,
[Country] [int] NOT NULL,
[RefPackageItemCodeName] [varchar](129) NOT NULL,
[PaymentDevice] [int] NOT NULL,
[PreviousCost] [int] NOT NULL,
[Cost] [int] NOT NULL,
[Param1] [int] NOT NULL,
[Param1_Desc128] [varchar](129) NOT NULL,
[Param2] [int] NOT NULL,
[Param2_Desc128] [varchar](129) NOT NULL,
[Param3] [int] NOT NULL,
[Param3_Desc128] [varchar](129) NULL,
[Param4] [int] NOT NULL,
[Param4_Desc128] [varchar](129) NOT NULL,
[index] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__RefPricePolicyOfItem] PRIMARY KEY CLUSTERED
(
[index] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

/////////////////////

USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_RefScrapOfPackageItem] Script Date: 9/24/2018 15:59:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_RefScrapOfPackageItem](
[Service] [tinyint] NOT NULL,
[Country] [int] NOT NULL,
[RefPackageItemCodeName] [varchar](129) NOT NULL,
[RefItemCodeName] [varchar](129) NOT NULL,
[OptLevel] [tinyint] NOT NULL,
[Variance] [bigint] NOT NULL,
[Data] [int] NOT NULL,
[MagParamNum] [tinyint] NOT NULL,
[MagParam1] [bigint] NOT NULL,
[MagParam2] [bigint] NOT NULL,
[MagParam3] [bigint] NOT NULL,
[MagParam4] [bigint] NOT NULL,
[MagParam5] [bigint] NOT NULL,
[MagParam6] [bigint] NOT NULL,
[MagParam7] [bigint] NOT NULL,
[MagParam8] [bigint] NOT NULL,
[MagParam9] [bigint] NOT NULL,
[MagParam10] [bigint] NOT NULL,
[MagParam11] [bigint] NOT NULL,
[MagParam12] [bigint] NOT NULL,
[Param1] [int] NOT NULL,
[Param1_Desc128] [varchar](129) NOT NULL,
[Param2] [int] NOT NULL,
[Param2_Desc128] [varchar](129) NOT NULL,
[Param3] [int] NOT NULL,
[Param3_Desc128] [varchar](129) NOT NULL,
[Param4] [int] NOT NULL,
[Param4_Desc128] [varchar](129) NOT NULL,
[Index] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__RefScrapOfPackageItem] PRIMARY KEY CLUSTERED
(
[Index] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/////////////////////////////////////

USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_RefShopGoods] Script Date: 9/24/2018 15:59:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_RefShopGoods](
[Service] [tinyint] NOT NULL,
[Country] [int] NOT NULL,
[RefTabCodeName] [varchar](129) NOT NULL,
[RefPackageItemCodeName] [varchar](129) NOT NULL,
[SlotIndex] [tinyint] NOT NULL,
[Param1] [int] NOT NULL,
[Param1_Desc128] [varchar](129) NOT NULL,
[Param2] [int] NOT NULL,
[Param2_Desc128] [varchar](129) NOT NULL,
[Param3] [int] NOT NULL,
[Param3_Desc128] [varchar](129) NOT NULL,
[Param4] [int] NOT NULL,
[Param4_Desc128] [varchar](129) NOT NULL,
[index] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__RefShopGoods] PRIMARY KEY CLUSTERED
(
[index] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


////////////////////////////////////
Now add the files again which you have taken in the file Text
Thus the problem was solved from its roots
If there is any problem I am present

[loader8]

Originally Posted by thebigbody

the problem is caused by this stupid program vsro NPC because it rebuild the database ids and lines which won't be compatible with the client lines and ofc will cause a crash
you will have to rebuild all the media texts with the new ids in the db or simply
add your items manually better for u

vsronpc will generate the tablets in .txt too, that is not a problem, lol

[AzarOnline]

Thank you Guys for your replays
it was problem with Id in refPackageitem in media Not Like Db and same For RefScarpofpackageitem index
#Closed