Item Mall Error 0

[Igris32]

I just open my private server ep 4.5 with files i found here on elitepvpers 1 week ago and everything work fine..everything...till yesterday..i come in game,buy Apparence Change Scroll and i dc..error 0. (wtf)
I lost 1 whole day by reading posts on interent but i didnt found solution anywhere soo...i delet whole server and re-make it from zero..
The 1st thing i try when i re-make server was:
-enter with the origin account (admin / admin123)(the only 1 that exist) and buy something from item mall (original one) but i get dc (error 0)
Thats strange cuz i was at 0 Ap and item that i try buy was 99AP soo normaly if item mall work fine it have to say "inssufcient point" and not dc me with error 0..I read on orther posts that some ppl have this error when buy some item that cost AP soo i set cost to 0 AP and try buy again..but nothing change..same error 0 every time.
Thta mean the problem wasnt my Cash.SData but something different and,like i say befor i didnt found any solution.
Dont answer me "use search bottom" cuz i alredy use it and i read 50 useless thread with no solution...

[TeddyBear94]

mh what amount of change scroll u putted in? if u put a to high number in it can dc u and ur server

[Igris32]

Originally Posted by TeddyBear94

mh what amount of change scroll u putted in? if u put a to high number in it can dc u and ur server

i know what u talk about,that happend alredy but only with potion.with orther item it say "inventory is full".
anyway apparance change scroll is in stock of 1 in Cash.SData and also in Item.SData soo the problem is not that.

[JohnHeatz]

Can you show us the logs in which this is shown?

[Igris32]

Originally Posted by JohnHeatz

Can you show us the logs in which this is shown?

Here is the error:

2012-09-14 22:09:47 PS_DBAGENT__system log start (DBAgent01)

2012-09-14 22:09:54 connect game, Name=



2012-09-14 22:09:54 connect game, Name=



2012-09-14 22:11:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-09-14 22:11:04 SaveBuyPointItem 10 Titan qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,10,0,'B1_free0 021','2012-09-14 22:11:04')}

Anway i tryied to make this

Proc [dbo].[usp_Save_User_BuyPointItems_NCash]
@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@textDate varchar(30)
as

Didnt Work..

Im sure that SQL Server 2005 make this error but im not pro soo i dont know how to fix.
Edit: i think i will try to download SQL 2012 But not sure if it will work on XP SP3

[x-DoeSn'TxMaTTeR-x]

I'm having this error too now T.T
So..I tought that was bout installation fkd up and i formatted the VB.
Reinstalled all sent item and cash query started the client and...Still error 0.
But I saw 1 thing.Really strange..
When i started the game,and i went to create a toon, it said error Name already exist.
The very very first and second time i formatted all and reinstalled all...this didn't happened...
Now with all clean, i got this error.And after i fixed it, the item mall continued with error 0.
If you look in epvp, you will see no one have the fix for this..Yeah...there's a guide in the index too but it dont' really work..
there may be an error in the NAME ALREADY EXIST FIX query that fk up the item mall?
I'm sure these 2 things are linked.
Let us know pls! Don't leave us xD

USE [PS_GameData]
GO
drop procedure [dbo].[usp_Save_Char_Item_Add_E]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO


/****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/


CREATE Proc usp_Save_Char_Item_Add_E

@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@MaketimeZ varchar(50),
@Maketype char(1)

AS
DECLARE @Maketime as datetime
SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)
--SET NOCOUNT ON

IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END

INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)

IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

--SET NOCOUNT OFF



GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

[Igris32]

Im almost sure that problem of Item Mall is in this query.

This is my query from: usp_Save_User_BuyPointItems_NCash

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_Save_User_BuyPointItems_NCash]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'

/****** Shoping Mall Fixed by sandolkakos Website: ******/



CREATE Proc [dbo].[usp_Save_User_BuyPointItems_NCash]

@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@UseDate datetime

AS

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @UseType int
DECLARE @ReturnValue int

SET @UseType = 1 -- 掘衙

BEGIN DISTRIBUTED TRANSACTION


EXEC @ReturnValue = PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
IF ( @ReturnValue < 0 )
BEGIN
GOTO ERROR
END
-- ?檣? 離馬(Old, 夥煎 UPDATE僥 陳塒唳辦 醴憮?纂陛 號檜 橾橫陴)
--UPDATE PS_UserData.dbo.Users_Master SET Point=Point-@UsePoint WHERE UserUID=@UserUID
--IF( @@ERROR<>0 OR @@ROWCOUNT=0)
--BEGIN
-- GOTO ERROR
--END

-- ?檣? 煎斜 晦煙
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@Produc tCode,@UseDate)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

'
END

[JohnHeatz]

2012-09-14 22:11:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server][B][COLOR="Red"]Errore durante la conversione del tipo di dati da varchar a datetime[/COLOR][/B]., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

That is the error, just check for the way on doing this conversion, and you will get it fixed, as the error is telling you exactly that there was an "error during the conversion from varchar to datetime".

[x-DoeSn'TxMaTTeR-x]

I resolved deleting my virtual machine reinstalling it with Omega server file and msql 2008 and not the 2005.
Ty anyway

[Igris32]

Originally Posted by JohnHeatz

2012-09-14 22:11:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server][B][COLOR="Red"]Errore durante la conversione del tipo di dati da varchar a datetime[/COLOR][/B]., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

That is the error, just check for the way on doing this conversion, and you will get it fixed, as the error is telling you exactly that there was an "error during the conversion from varchar to datetime".

Ehm,tell me where is the problem dont help me to solve it.
I alredy know the problem is here ( i think) but i dont know to solve it. That way i ask help here

CREATE Proc [dbo].[usp_Save_User_BuyPointItems_NCash]

@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@UseDate datetime

AS

SET NOCOUNT ON
SET XACT_ABORT ON

[qesha]

hi guys i got insert error when i am trying to Execute Cash.sdata in SQL server 2005 it's says Msg 213, Level 16, State 1, Line 1
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 2
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 3
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 4
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 5
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 6
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 7
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 8
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 9
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 10
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 11
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 12
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 13
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 14
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 15
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 16
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 17
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 18
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 19
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 20
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 21
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 22
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 23
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 24
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 25
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 26
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 27
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 28
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 29
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 30
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 31
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 32
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 33
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 34
Insert Error: Column name or number of supplied values does not match table definition.
Msg 213, Level 16, State 1, Line 35
Insert Error: Column name or number of supplied values does not match table definition.
help me please

[Truth1010]

You might want to post the actual values you are trying to input into SQL. I assume it is from the ShStudio script once you saved Cash.Sdata, and you're not trying to import the Sdata itself to your database..somehow..

If i remember correctly, it's because the values given by ShStudio don't include 1 or more of the useless columns in that DB table, you just need to drop/recreate the table without any columns that aren't present in the Sql Script made by ShStudio and it'll work properly.

This is an example of what i assume the data you are trying to write into SQL looks like.

 Spoiler

INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('Lv15 Accessories','Acc001',0,22001,2,40001,2,23001,1,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

And this is what my 'Cash' table looks like. Compare it to your own to see if you have any more/less columns.

 Spoiler

USE [PS_GameDefs]
GO

/****** Object: Table [dbo].[ProductList] Script Date: 25/08/2014 15:51:47 ******/
DROP TABLE [dbo].[ProductList]
GO

/****** Object: Table [dbo].[ProductList] Script Date: 25/08/2014 15:51:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ProductList](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[ProductName] [varchar](50) NOT NULL,
[ProductCode] [varchar](20) NOT NULL,
[BuyCost] [int] NOT NULL,
[ItemID1] [int] NOT NULL,
[ItemCount1] [tinyint] NOT NULL,
[ItemID2] [int] NULL,
[ItemCount2] [tinyint] NULL,
[ItemID3] [int] NULL,
[ItemCount3] [tinyint] NULL,
[ItemID4] [int] NULL,
[ItemCount4] [tinyint] NULL,
[ItemID5] [int] NULL,
[ItemCount5] [tinyint] NULL,
[ItemID6] [int] NULL,
[ItemCount6] [tinyint] NULL,
[ItemID7] [int] NULL,
[ItemCount7] [tinyint] NULL,
[ItemID8] [int] NULL,
[ItemCount8] [tinyint] NULL,
[ItemID9] [int] NULL,
[ItemCount9] [tinyint] NULL,
[ItemID10] [int] NULL,
[ItemCount10] [tinyint] NULL,
[ItemID11] [int] NULL,
[ItemCount11] [tinyint] NULL,
[ItemID12] [int] NULL,
[ItemCount12] [tinyint] NULL,
[ItemID13] [int] NULL,
[ItemCount13] [tinyint] NULL,
[ItemID14] [int] NULL,
[ItemCount14] [tinyint] NULL,
[ItemID15] [int] NULL,
[ItemCount15] [tinyint] NULL,
[ItemID16] [int] NULL,
[ItemCount16] [tinyint] NULL,
[ItemID17] [int] NULL,
[ItemCount17] [tinyint] NULL,
[ItemID18] [int] NULL,
[ItemCount18] [tinyint] NULL,
[ItemID19] [int] NULL,
[ItemCount19] [tinyint] NULL,
[ItemID20] [int] NULL,
[ItemCount20] [tinyint] NULL,
[ItemID21] [int] NULL,
[ItemCount21] [tinyint] NULL,
[ItemID22] [int] NULL,
[ItemCount22] [tinyint] NULL,
[ItemID23] [int] NULL,
[ItemCount23] [tinyint] NULL,
[ItemID24] [int] NULL,
[ItemCount24] [tinyint] NULL,
CONSTRAINT [PK_ProductList] PRIMARY KEY CLUSTERED
(
[RowID] 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

[nubness]

It's the good old issue. Remove the RowID column or make it an identity and it'll work.

[shaiyacreatureboang]

Before you post it in SQL you add ('''Name of Sale', More......)

[Pave99]

Originally Posted by shaiyacreatureboang

Before you post it in SQL you add ('''Name of Sale', More......)

Please don't bring back old threads.