Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 01:12

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

Advertisement



Can't Create a new char Error(s1030) HELP

Discussion on Can't Create a new char Error(s1030) HELP within the SRO Private Server forum part of the Silkroad Online category.

Closed Thread
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2010
Posts: 160
Received Thanks: 11
Can't Create a new char Error(s1030) HELP

Hi, my dears i'm trying all, use a lot of procedures _AddNewChar and nothing fix the problem... this my error

im use this procedure and others but don't fix the problem

SharedManager
Code:
fatal	Query Error!!! Query Result : -1, Query : {?=CALL _AddNewChar (1, 1907,'SDFKLAHSKDHA',34,25256,958.000000,60.000000,1087.000000,2094,3640,3641,3642,3633,10886,44,44,44,69,46,0)}	2017-01-20 00:08:26 014
fatal	SQL Error State:23000, Native Error Code: 223, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Instrucción INSERT en conflicto con la restricción FOREIGN KEY "FK__User__AccountJID". El conflicto ha aparecido en la base de datos "SRO_VT_SHARD", tabl	2017-01-20 00:08:26 025
fatal	{?=CALL _AddNewChar (1, 1907,'SDFKLAHSKDHA',34,25256,958.000000,60.000000,1087.000000,2094,3640,3641,3642,3633,10886,44,44,44,69,46,0)}	2017-01-20 00:08:26 025
fatal	SQL Error State:22007, Native Error Code: F2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]La conversión del tipo de datos varchar en smalldatetime produjo un valor fuera de intervalo.
	2017-01-20 00:08:26 026
fatal	{?=CALL _AddNewChar (1, 1907,'SDFKLAHSKDHA',34,25256,958.000000,60.000000,1087.000000,2094,3640,3641,3642,3633,10886,44,44,44,69,46,0)}	2017-01-20 00:08:26 027
fatal	SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Se terminó la instrucción.
	2017-01-20 00:08:26 028
fatal	{?=CALL _AddNewChar (1, 1907,'SDFKLAHSKDHA',34,25256,958.000000,60.000000,1087.000000,2094,3640,3641,3642,3633,10886,44,44,44,69,46,0)}	2017-01-20 00:08:26 028
fatal	SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Se terminó la instrucción.	2017-01-20 00:08:26 029
fatal	{?=CALL _AddNewChar (1, 1907,'SDFKLAHSKDHA',34,25256,958.000000,60.000000,1087.000000,2094,3640,3641,3642,3633,10886,44,44,44,69,46,0)}	2017-01-20 00:08:26 030
fatal	Failed To execute _AddNewChar ! [jid: 1, odbc err: -1]	2017-01-20 00:08:26 031
fatal	Failed To create new character! [jid: 1, error code: 0]	2017-01-20 00:08:26 031
fatal	Temple : Reputation Check Faild ! - CShardSJ_TempleOfAnubisAndIsisGate 	2017-01-20 00:08:30 183
GlobalManager
Code:
notify	BILLING SERVER[dummy]	2017-01-21 13:54:13 525
notify	BillingMgr- Created!	2017-01-21 13:54:13 525
notify	BillingMgr- Service Initialized!	2017-01-21 13:54:13 525
notify	successfully server task registered	2017-01-21 13:54:13 525
notify	request server certification	2017-01-21 13:54:13 525
notify	Add ServerNotify : (1) - Certification	2017-01-21 13:54:13 899
notify	Add ServerNotify : (698) - GatewayServer	2017-01-21 13:54:13 915
notify	Add ServerNotify : (699) - MachineManager	2017-01-21 13:54:13 915
notify	Add ServerNotify : (700) - DownloadServer	2017-01-21 13:54:13 915
notify	Add ServerNotify : (704) - FarmManager	2017-01-21 13:54:13 930
notify	successfully server certificated	2017-01-21 13:54:13 930
fatal	server cord established : 1 (25.59.137.37:60000)	2017-01-21 13:54:13 930
notify	Successfully DB Initialized!	2017-01-21 13:54:13 977
fatal	Max User Count Restriction Per IP: system default (infinite)	2017-01-21 13:54:14 196
notify	Account DB Successfully Connected!	2017-01-21 13:54:14 196
notify	Silk DB is assigned to Account DB!!	2017-01-21 13:54:14 196
notify	franchied ip refreshed : 1	2017-01-21 13:54:14 367
notify	Punishment Information [Count: 0] loaded.	2017-01-21 13:54:14 398
fatal	GlobalManager is initialized successfully	2017-01-21 13:54:14 430
fatal	server cord established : 2 (25.59.137.37:51232)	2017-01-21 13:54:24 686
notify	Certification request from : MachineManager(25.59.137.37)	2017-01-21 13:54:24 686
fatal	server cord established : 4 (25.59.137.37:51235)	2017-01-21 13:54:57 558
notify	Certification request from : GatewayServer(25.59.137.37)	2017-01-21 13:54:57 574
fatal	server cord established : 5 (25.59.137.37:51236)	2017-01-21 13:54:57 964
notify	Certification request from : FarmManager(25.59.137.37)	2017-01-21 13:54:58 010
fatal	server cord established : 6 (25.59.137.37:51237)	2017-01-21 13:54:59 149
notify	Certification request from : DownloadServer(25.59.137.37)	2017-01-21 13:54:59 149
fatal	execute query error : exec _AddCurrentUserCount 64, 0, '2017-1-21 13:59:13'	2017-01-21 13:59:13 946
fatal	Query Error!!! Query Result : -1, Query : exec _AddCurrentUserCount 64, 0, '2017-1-21 13:59:13'	2017-01-21 13:59:14 056
fatal	SQL Error State:42000, Native Error Code: 1FB2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Error al convertir el tipo de datos varchar a datetime.	2017-01-21 13:59:14 071
fatal	exec _AddCurrentUserCount 64, 0, '2017-1-21 13:59:13'	2017-01-21 13:59:14 071
Toonami2010 is offline  
Old 01/20/2017, 12:13   #2
 
elite*gold: 0
Join Date: Jan 2009
Posts: 974
Received Thanks: 453
Get the full procedure from another shard database , if that querry is not working, there are lots of database released
leo2111 is offline  
Old 01/21/2017, 18:31   #3
 
elite*gold: 0
Join Date: Jan 2010
Posts: 160
Received Thanks: 11
Quote:
Originally Posted by leo2111 View Post
Get the full procedure from another shard database , if that querry is not working, there are lots of database released
hello brother thankyou for answer me, i use alot of querrys. i have some dbs works good, but when i use that querryes in Devias db i get same problem every time
Toonami2010 is offline  
Old 01/22/2017, 10:16   #4

 
Nexiero's Avatar
 
elite*gold: 4
Join Date: Jan 2016
Posts: 257
Received Thanks: 105
Quote:
Originally Posted by Toonami2010 View Post
hello brother thankyou for answer me, i use alot of querrys. i have some dbs works good, but when i use that querryes in Devias db i get same problem every time
Devias' DB suks
Nexiero is offline  
Old 01/22/2017, 13:11   #5
 
elite*gold: 0
Join Date: Jan 2009
Posts: 974
Received Thanks: 453
Quote:
Originally Posted by Toonami2010 View Post
hello brother thankyou for answer me, i use alot of querrys. i have some dbs works good, but when i use that querryes in Devias db i get same problem every time
add my skype , I'll try to fix it for you
leo2111 is offline  
Old 01/25/2017, 13:57   #6
 
elite*gold: 0
Join Date: Jan 2017
Posts: 20
Received Thanks: 2
its from the start item or start stats check if its make sense you can't start with 34574468446546848 gold or stat points , check them
LinusHadron is offline  
Old 01/28/2017, 13:20   #7
 
elite*gold: 0
Join Date: Jan 2017
Posts: 50
Received Thanks: 7
check the towns and the AddNewChar Proceduer
Spectrum74 is offline  
Old 01/28/2017, 21:44   #8
 
elite*gold: 0
Join Date: May 2012
Posts: 179
Received Thanks: 56
Create new char error S1030 is a simple fix , this can only happen when you remove the abuse filter or any main parts of it , just replace the abuse filter with and working one and all will be fine .
mtnman33 is offline  
Old 12/18/2017, 15:28   #9
 
elite*gold: 0
Join Date: Oct 2010
Posts: 103
Received Thanks: 6
@ Ppl still have this bug: I was delete all character and now possible to creat new char.
tubeo is offline  
Old 12/18/2017, 19:58   #10


 
ZαKuRα's Avatar
 
elite*gold: 23
Join Date: Feb 2011
Posts: 644
Received Thanks: 481
Hope this can help you
Attached Files
File Type: txt S1030.txt (8.6 KB, 424 views)
ZαKuRα is online now  
Old 12/24/2017, 14:56   #11

 
elite*gold: 11
Join Date: Aug 2017
Posts: 105
Received Thanks: 47
RESTORE YOUR DATABASE
Dex* is offline  
Closed Thread


Similar Threads Similar Threads
Failed to create a character S1030
12/06/2022 - SRO Private Server - 8 Replies
Ok now i have new problem i cant find answer in epvp - Failed to Create a Character S1030 *View image: SRO 10 - Then when i trying create acc in game my SR_ShardManager gioing crash *View image: SRManager error RefRegioBindAssocAServer All region Open EU CH i cannot create chine and eu Some ideas helps ;)?
Failure to create a character (S1030)
06/11/2016 - SRO Private Server - 4 Replies
As the title says. I've cleaned SHARD and used a completely new _AddNewChar and restored the database a several times.
SRO can't create character (S1030)
04/14/2015 - Silkroad Online - 2 Replies
hello everyone! the error (S1030) its back! i cant create characters.. how can i fix it? 1) database is clean 2) tb.AddNewChar is fixed and working 100% PLEASE HELP!
[Help] Character Create Error S1030 how to fix it
01/08/2015 - SRO Private Server - 3 Replies
how can i fix this problem anyone have a solution http://prntscr.com/5pxj1b i hope someone can tell me how this can be fixed



All times are GMT +1. The time now is 01:18.


Powered by vBulletin®
Copyright ©2000 - 2026, 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 ©2026 elitepvpers All Rights Reserved.