Register for your free account! | Forgot your password?

You last visited: Today at 23:51

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



help please

Discussion on help please within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2014
Posts: 16
Received Thanks: 1
help please

Help please:
yesterday at ending the configurations of the db i came across the following problem,
and I don't know what could trigger.
If any of you can guide me in your solution, I would be very grateful.
The problem is the following:
To give play to the SV. accounts created may not enter, resulting in error of connection 0.
But the new accounts if they can enter and stay in the game,hasta el momento en que cambian de personaje
o cierran la misma,lo que las deriva con el problema de coneccion.
If someone can guide me in your solution would be grateful.
Greetings.
Takahiro // Maximiliano is offline  
Old 06/23/2014, 09:28   #2
 
elite*gold: 0
Join Date: Feb 2014
Posts: 16
Received Thanks: 1
Hello boys, looking a little more detail in the error i found the following legend.

2014-06-23 01:56:16 ::LoadCharacter 12 (Name Pj) qerr=-1, EXEC usp_Read_Chars_PointLog_R 12

2014-06-23 01:56:16 ErrorMsg=[Microsoft][ODBC SQL Server Driver]Valor de carácter no válido para especificación cast, SQL STATE: 22018, NATIVE ERROR: 0 (0x0)

I go to the list indicated and the code in the same is:
Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO



ALTER Proc [dbo].[usp_Read_Chars_PointLog_R]

@CharID int
--@UseType tinyint

AS

SET NOCOUNT ON


SELECT TOP 10 ProductCode, UseDate, UsePoint FROM PointLog WITH (READUNCOMMITTED) WHERE CharID=@CharID
ORDER BY UseDate desc

SET NOCOUNT OFF
According to the error report said that the error has its beginning in that line of code.
If any of you, I could say where is the error.I'll be very grateful
Many thanks
Takahiro // Maximiliano is offline  
Thanks
1 User
Old 06/25/2014, 23:44   #3




 
Autrux's Avatar
 
elite*gold: 246
Join Date: Dec 2010
Posts: 33,472
Received Thanks: 6,059
Arrow Shaiya -> Shaiya PServer Development

#moved
Autrux is offline  
Old 06/28/2014, 10:18   #4
 
beetols's Avatar
 
elite*gold: 0
Join Date: Jan 2013
Posts: 461
Received Thanks: 561
No veo donde este procedimiento está en la base de datos solicitada si este es el comando completo, entonces estoy seguro u tiene algo mal y que va a resolver el uso de una palabra mágica .. u se encuentra esta palabra en una gran cantidad de temas , por favor asegúrese de que es la palabra correcta .. lo siento por la mala google español traducir
beetols is offline  
Old 06/30/2014, 07:01   #5
 
elite*gold: 0
Join Date: Feb 2014
Posts: 16
Received Thanks: 1
If that is my problem is not well in that line may fail with the template code of the SQL. what gives me that message as above as error, of course I am not an expert in SQL for that reason I would appeal to you to see if they provide their assistance.
Takahiro // Maximiliano is offline  
Old 07/01/2014, 05:11   #6
 
beetols's Avatar
 
elite*gold: 0
Join Date: Jan 2013
Posts: 461
Received Thanks: 561
Your procedure must begin so..
Code:
USE [PS_GameData]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
Begin to use your brain.exe and solve your problems alone as all! or change hobby.
beetols is offline  
Old 07/01/2014, 09:37   #7
 
elite*gold: 0
Join Date: Feb 2014
Posts: 16
Received Thanks: 1
Thank you beetols. the truth I didn't know precisely how my knowledge in SQL is very low. to be carried out in accordance with take a few courses or something to deepen more. again thank you very much.
Takahiro // Maximiliano is offline  
Old 07/01/2014, 11:54   #8
 
beetols's Avatar
 
elite*gold: 0
Join Date: Jan 2013
Posts: 461
Received Thanks: 561
more that here are haven't begin with knowledge in SQL but we try to learn out for work about, you can't create a server thinking that this community is here extra to help you! so good luck learning it, and don't write so stupid posts.. if u can't do something try your self, and if you can't, search it, don't ask.. so you will learn how to do the things, asking and not using your brain you will not learn nothing!
beetols is offline  
Thanks
1 User
Reply




All times are GMT +1. The time now is 23:52.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.