Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
SHardManager - ODBC error while creating a new char SHardManager - ODBC error while creating a new char
You last visited: Today at 04:12

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

Advertisement


Advertise with us!

SHardManager - ODBC error while creating a new char

Discussion on SHardManager - ODBC error while creating a new char within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
SunGm's Avatar
 
elite*gold: 259
The Black Market: 0/0/0
Join Date: Oct 2008
Posts: 39
Received Thanks: 15
SHardManager - ODBC error while creating a new char

Hello !

I ve downloaded the Blue-Sro DB cuz it has a lot of good edits. I can make my char ,play etc... But when i make a new acc and try to make a new char i get an error in-game and at shardmaneger too. I tired it with 3-4 accs , sometimes it works but sometimes not and crash the shared manager.

I ve used db clearing queries , but still not working.

Please help me !

Thanks !
Attached Images
File Type: jpg e1.jpg (14.1 KB, 251 views)
File Type: jpg e2.jpg (335.1 KB, 248 views)
SunGm is offline  
Old 02/13/2014, 08:33   #2
 
elite*gold: 41
The Black Market: 4/0/0
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,196
make sure about DB's names
and check Procedures _AddNewChar also
Crue* is offline  
Thanks
1 User
Old 02/14/2014, 22:41   #3
 
SunGm's Avatar
 
elite*gold: 259
The Black Market: 0/0/0
Join Date: Oct 2008
Posts: 39
Received Thanks: 15
I checked all the configs and everything is fine :/

Here is the log:

4-02-11 21:18:53 [AgentServer] server cord established : 3 (25.186.99.1:14214)
2014-02-11 21:19:10 [SR_ShardManager] SR_ShardManager is initialized successfully
2014-02-11 21:19:46 [SR_GameServer] Invalid Region!![ID:43][ObjName128:KINGDOLLLAR]
2014-02-11 21:19:46 [SR_GameServer] Invalid Region!![ID:44][ObjName128:KINGDOLLAR]
2014-02-11 21:19:46 [SR_GameServer] Invalid Region!![ID:45][ObjName128:KINGDOLLLAR]
2014-02-11 21:19:46 [SR_GameServer] Invalid Region!![ID:46][ObjName128:KINGDOLLLAR]
2014-02-11 21:20:03 [SR_GameServer] SR_GameServer is initialized successfully
2014-02-11 21:21:00 [SR_ShardManager] ScheduleExecutor : Find Failed In Schedule Exe - End(STATE) SCHEDULE_DEF_FLAG_WORLD(DEFINE) 490(SCHIDX)
2014-02-11 21:21:05 [SR_ShardManager] Query Error!!! Query Result : -1, Query : {?=CALL _AddNewChar (8, 14890,'fsdgdfg',67,27471,1205.000000,80.000000,396 .000000,19554,11629,11630,11631,10887,0,39,39,39,6 6,0,0)}
2014-02-11 21:21:05 [SR_ShardManager] SQL Error State:25000, Native Error Code: 10A, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
2014-02-11 21:21:05 [SR_ShardManager] {?=CALL _AddNewChar (8, 14890,'fsdgdfg',67,27471,1205.000000,80.000000,396 .000000,19554,11629,11630,11631,10887,0,39,39,39,6 6,0,0)}
2014-02-11 21:28:03 [AgentServer] 713:SR_GameServer is blind : 0 users are banned
2014-02-11 21:28:03 [FarmManager] server cord closed : 3
2014-02-11 21:28:03 [GlobalManager] agent server is broken !!. all associated user is unregistered : 0
2014-02-11 21:28:03 [SR_ShardManager] server cord closed : 2
2014-02-11 21:28:03 [AgentServer] server cord closed : 2
2014-02-11 21:28:05 [FarmManager] server cord closed : 2
2014-02-11 21:28:05 [SR_ShardManager] server cord closed : 3
2014-02-11 21:28:07 [GlobalManager] server cord closed : 4
2014-02-11 21:28:08 [GlobalManager] server cord closed : 3
2014-02-11 21:28:09 [GlobalManager] server cord closed : 5
2014-02-11 21:28:10 [GlobalManager] server cord closed : 2
2014-02-11 21:28:10 [SR_ShardManager] OnExit() Called


Please help !
SunGm is offline  
Old 02/14/2014, 23:49   #4
 
Justin1337*'s Avatar
 
elite*gold: 480
The Black Market: 3/0/0
Join Date: Jan 2012
Posts: 655
Received Thanks: 579
Quote:
Originally Posted by SunGm View Post
I checked all the configs and everything is fine :/

Here is the log:



Please help !
Added you on Skype i'll help you. =)
Justin1337* is offline  
Thanks
1 User
Old 02/16/2014, 05:34   #5
 
elite*gold: 0
The Black Market: 4/0/0
Join Date: May 2013
Posts: 1,447
Received Thanks: 1,046
Just restore default _AddNewChar probably it has something wrong around it.
Anonymous-6723 is offline  
Old 12/16/2016, 21:38   #6
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2010
Posts: 160
Received Thanks: 11
Quote:
Originally Posted by Pr0x! View Post
Just restore default _AddNewChar probably it has something wrong around it.
i have the same problem, Failed To execute _AddNewChar

but i don't se any dbo table with this name

_AddNewChar it's from SRO_VT_SHARD? SRO_VT_ACCOUNT OR SHARLOG
Toonami2010 is offline  
Old 12/16/2016, 23:08   #7
 
janicka's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2008
Posts: 701
Received Thanks: 213
Its stored procedure.
janicka is offline  
Old 12/17/2016, 00:36   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2010
Posts: 160
Received Thanks: 11
Quote:
Originally Posted by janicka View Post
Its stored procedure.
explain me how to fix please
i'll add your on skype
Toonami2010 is offline  
Old 12/17/2016, 18:23   #9
 
janicka's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2008
Posts: 701
Received Thanks: 213
SRO_VT_SHARD go to programmability then go stored procedures and there is it.... Mostly this is messed up when you try add some start items etc......
janicka is offline  
Thanks
1 User
Old 12/19/2016, 02:59   #10
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2010
Posts: 160
Received Thanks: 11
execute query error : exec _AddCurrentUserCount 64, 0,
Query Error!!! Query Result : -1, Query : exec _AddCurrentUserCount 64, 0,
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.
exec _AddCurrentUserCount 64, 0,

i get this error in Global manager what's ?
Toonami2010 is offline  
Old 12/20/2016, 09:01   #11
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2010
Posts: 107
Received Thanks: 31
sro_cyklon is offline  
Reply

« [Help] DC gameserver | 2x Gameserver »

Similar Threads Similar Threads
Shardmanager Error
10/08/2012 - SRO Private Server - 3 Replies
msg is not completely used : IP:XXX.XXX.XXX.XX Ack:0x0318 (0x0000) (MsgType:10), 283 - 272 This can cause the error?
Error ShardManager
08/06/2012 - SRO Private Server - 2 Replies
http://img838.imageshack.us/img838/2117/helpi.png Uploaded with ImageShack.us after runtime error help please.
error while creating a new char
03/24/2012 - SRO Private Server - 2 Replies
http://www10.0zz0.com/2012/03/23/22/244814214.jpg
creating ODBC connection
10/30/2011 - SRO Private Server - 0 Replies
did someone create the odbc connection for the Server Files under Windows 7 could someone tell me how to create this connection? would be great :-) thanks & greetings
[HELP]Error in ShardManager
09/18/2011 - SRO Private Server - 1 Replies
how i fix it? help me friends :) http://i52.tinypic.com/2552a3a.jpg



All times are GMT +1. The time now is 04:13.

elitepvpers - play less, get more - Top

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.