[HELP] Itemmall crash game Error 0

04/13/2014 14:23 sony65#1

Hi all, i need help please ..
I have edit my cash.Sdata et item.Sdata i have make a event, no problem, players can play, and now when i buy on the itemmall i have that error : connection with server has been disconnected ERROR 0, help me please i have delete and restart download in my database and i have the problem, i use SQL 2005 and i can't use 2008 R2 or 2012 ... I can't play and my players wait me :(

I have test service.msc and i have error too ..

Please help me ! :(

(sorry for my english, i am french ...)

04/13/2014 19:10 Autrux#2

#moved

04/15/2014 19:55 Tryne01#3

Same problem, i have already tested some scripts :

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

(Logs are like it :[Only registered and activated users can see links. Click Here To Register...] )

Can it work in SQL server 2005? Must i updrage to sql server 2008?

04/16/2014 09:35 QQers19#4

That should fix your problem:

Code:

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_User_BuyPointItems_NCash]    Script Date: 2014-01-21 19:10:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****** Shoping Mall	Fixed by sandolkakos	Website: http://www.universalgamesonline.com.br ******/



ALTER Proc [dbo].[usp_Save_User_BuyPointItems_NCash]

@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@textDate varchar(30)

AS

DECLARE @UseTime datetime
set @UseTime=CONVERT(datetime, @textDate, 120) 

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,ProductCode,UseDate)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@ProductCode,@textDate)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

04/16/2014 15:40 Tryne01#5

Sry, but my error 0 is still here :(

04/16/2014 17:57 QQers19#6

Show logs
D:\ShaiyaServer\PSM_Client\Bin\Log

04/16/2014 23:14 sony65#7

Thanks all for test to help me, but my error 0 stay with all sql script .. it is an SQL error, if you want i can give you my logs :

2014-04-16 23:06:12 PS_DBAGENT__system log start (DBAgent01)

2014-04-16 23:06:21 connect game, Name=

2014-04-16 23:06:21 connect game, Name=

2014-04-16 23:07:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de donn�es varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2014-04-16 23:07:35 SaveBuyPointItem 10 Sony qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,10,0,'Justia_s et','2014-04-16 23:07:35')}

2014-04-16 23:09:49 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de donn�es varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2014-04-16 23:09:49 SaveBuyPointItem 10 Sony qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,10,0,'B2_Secor ','2014-04-16 23:09:49')}

2014-04-16 23:11:36 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de donn�es CHAR en type DATETIME a donn� une valeur hors limite de date et d'heure., SQL STATE: 22007, NATIVE ERROR: 242 (0xF2)

2014-04-16 23:11:36 SaveBuyPointItem 10 Sony qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,10,0,'B2_Secor ','2014-04-16 23:11:34')}

Can you help me for fix that error ? :/ i don't know how ... (Sorry i am french)

Thanks all for test to help me, but my error 0 stay with all sql script .. it is an SQL error, if you want i can give you my logs :

2014-04-16 23:06:12 PS_DBAGENT__system log start (DBAgent01)

2014-04-16 23:06:21 connect game, Name=

2014-04-16 23:06:21 connect game, Name=

2014-04-16 23:07:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de donn�es varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2014-04-16 23:07:35 SaveBuyPointItem 10 Sony qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,10,0,'Justia_s et','2014-04-16 23:07:35')}

2014-04-16 23:09:49 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de donn�es varchar en datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2014-04-16 23:09:49 SaveBuyPointItem 10 Sony qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,10,0,'B2_Secor ','2014-04-16 23:09:49')}

2014-04-16 23:11:36 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]La conversion d'un type de donn�es CHAR en type DATETIME a donn� une valeur hors limite de date et d'heure., SQL STATE: 22007, NATIVE ERROR: 242 (0xF2)

2014-04-16 23:11:36 SaveBuyPointItem 10 Sony qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,10,0,'B2_Secor ','2014-04-16 23:11:34')}

Can you help me for fix that error ? :/ i don't know how ... (Sorry i am french)

See that post : [Only registered and activated users can see links. Click Here To Register...] I don't understand how to inject the sql script of castor ... because i have a error for convert varchar in datatime ..

I HAVE FIX THAT ERROR !!!!!!!!! It is an error to convert varchar in datatime, for fix it, you need to delete SQL SERVER 2005 and re-download in english version !!!!!!! :D

04/18/2014 10:20 Blober#8

I think these big letter were not needed.

But i suggest you to use SQL Server 2008R2 or 2012.

04/18/2014 12:15 Tryne01#9

I've resolved my problem. I've installed SQL server 2008 R2 and it work great now, it was a SQL server 2005 problem .. Thxs everybody for help :)

04/18/2014 19:02 sony65#10

2005 is not a problem just install in english language ! :) because i use Sql 2005 and i don't have a problem, just use english language because the script of ShStudio are english ! :)

04/24/2014 14:33 Boul27#11

An other way to solve this probleme is to set the input language of you user (i my case Shaiya, to english, and restart )
After this, my dateformat for my sql User Shayia was ymd , the good format (i think it's easier that uninstal and reinstal)

edit : sorry for my bad english, i'm french

11/10/2015 18:38 arybb#12

hola buenas tardes. pues disculpa no se escribir en ingles, em hace rato, que estoy haciendo un server. busco mas que todo un episodio 4-5, ya los e hecho a cada rato. en mi computador pero se da el caso deq ya teniendo todo listo , el unico error que me queda. segun creo yo es este. tanto en los files 4.5 como ep 5.

2015-11-10 11:53:29 PS_DBAGENT__system log start (DBAgent01)

2015-11-10 11:53:37 connect game, Name=

2015-11-10 11:53:37 connect game, Name=

2015-11-10 12:38:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]MSDTC no est� disponible en el servidor 'SERVIDOR-PC'., SQL STATE: 42000, NATIVE ERROR: 8501 (0x2135)

2015-11-10 12:38:20 SaveBuyPointItem 1 ?? qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(1,1,5000,' Accesorios PvP-15','2015-11-10 12:38:18')}

....
ese es el error tengo varios meses en este plan y por ello no e logrado montar mi servidor.. espero pronta respuesta si alguno ya a solucionado.. gracias

11/11/2015 18:23 killer870#13

intenta de prender el servicio MSDTC en la computadora donde tienes el servidor montado. no se como puedas llegar e los servicios desde tu compu porque la verdad no uso espa�ol en la computadora. Pero busca en google como puedes entrar a los SERVICIOS. ya que lo actives, reinicia toda la compu y mira si eso lo arreglo. msdtc = Microsoft Distributed Transaction Coordinator