You last visited: Today at 13:02
Advertisement
[Pserver Created] Issues with connection!
Discussion on [Pserver Created] Issues with connection! within the SRO Private Server forum part of the Silkroad Online category.
10/29/2013, 15:38
#1
elite*gold: 0
Join Date: Jul 2009
Posts: 1,861
Received Thanks: 762
[Pserver Created] Issues with connection!
Hey there,
since I am trying to open my own private server (not for public usage, just for me and my friends), I went down through the whole databases and made up the server working.
Well, the server is running, creating a character is possible, except the client language is vietnamese ... must search for an english patched Media.pk2 or must do one on my own, will be easy though.
The actual problem is - after choosing the character and clicking on start, I will disconnect on the character menu. Any ideas how to fix it?
Log of the ShardManager:
Code:
notify successfully server task registered 2013-10-29 15:42:22 625
fatal Schedule Manager : g_pServerBodyOfMyself is NULL !! 2013-10-29 15:42:22 625
notify request server certification 2013-10-29 15:42:22 625
fatal Schedule Manager : g_pServerBodyOfMyself is NULL !! 2013-10-29 15:42:22 635
fatal Schedule Manager : g_pServerBodyOfMyself is NULL !! 2013-10-29 15:42:22 635
fatal Schedule Manager : g_pServerBodyOfMyself is NULL !! 2013-10-29 15:42:22 645
fatal Schedule Manager : g_pServerBodyOfMyself is NULL !! 2013-10-29 15:42:22 645
fatal Schedule Manager : g_pServerBodyOfMyself is NULL !! 2013-10-29 15:42:22 655
notify Add ServerNotify : (704) - FarmManager 2013-10-29 15:42:22 665
notify successfully server certificated 2013-10-29 15:42:22 665
fatal server cord established : 1 (192.168.178.20:15882) 2013-10-29 15:42:22 665
fatal server cord established : 2 (192.168.178.20:4277) 2013-10-29 15:42:25 515
fatal !!! there is no record in this[_RefRentItem] table !!! 2013-10-29 15:42:33 395
notify GameWorld Initialized!! 2013-10-29 15:42:34 405
fatal Locale: Vietnam 2013-10-29 15:42:34 665
warnning CrestFtpUrl: guild/alliance crest ftp url was set 2013-10-29 15:42:34 665
warnning Billing Server was set 2013-10-29 15:42:34 665
warnning Meter Rate Sytem's FirstHour: 22 SecondHour: 23 2013-10-29 15:42:34 665
warnning Scheduler : Os Time Change ( By SMC - SR_Scheduler ) is Impossible !! 2013-10-29 15:42:34 665
warnning Flag event: off 2013-10-29 15:42:34 665
warnning Disable ServerEventSystem 2013-10-29 15:42:34 665
fatal SR_ShardManager is initialized successfully 2013-10-29 15:42:34 755
fatal server cord established : 3 (192.168.178.20:4287) 2013-10-29 15:42:37 065
warnning [ Schedule Data Inserting ... ] 2 - 8 2013-10-29 15:44:32 480
warnning [ Schedule Data Inserting ... ] 2 - 9 2013-10-29 15:44:32 480
warnning [ Schedule Data Inserting ... ] 1 - 16 2013-10-29 15:44:32 480
warnning [ Schedule Data Inserting ... ] 4 - 17 2013-10-29 15:44:32 500
warnning [ Schedule Data Inserting ... ] 3 - 44 2013-10-29 15:44:32 500
warnning [ Schedule Data Inserting ... ] 3 - 45 2013-10-29 15:44:32 500
warnning [ Schedule Data Inserting ... ] 3 - 46 2013-10-29 15:44:32 500
warnning [ Schedule Data Inserting ... ] 3 - 47 2013-10-29 15:44:32 500
warnning [ Schedule Data Inserting ... ] 9 - 53 2013-10-29 15:44:32 500
warnning [ Schedule Data Inserting ... ] 9 - 54 2013-10-29 15:44:32 500
warnning [ Schedule Data Inserting ... ] 10 - 55 2013-10-29 15:44:32 500
warnning [ Schedule Data Inserting ... ] 10 - 56 2013-10-29 15:44:32 500
warnning [ Schedule Data Inserting ... ] 11 - 57 2013-10-29 15:44:32 510
warnning [ Schedule Data Inserting ... ] 11 - 58 2013-10-29 15:44:32 510
warnning [ Schedule Data Inserting ... ] 15 - 245 2013-10-29 15:44:32 510
warnning [ Schedule Data Inserting ... ] 20 - 321 2013-10-29 15:44:32 520
warnning [ Schedule Data Inserting ... ] 21 - 322 2013-10-29 15:44:32 520
warnning [ Schedule Data Inserting ... ] 14 - 359 2013-10-29 15:44:32 520
warnning [ Schedule Data Inserting ... ] 16 - 360 2013-10-29 15:44:32 530
warnning [ Schedule Data Inserting ... ] 16 - 361 2013-10-29 15:44:32 530
warnning [ Schedule Data Inserting ... ] 16 - 362 2013-10-29 15:44:32 530
warnning [ Schedule Data Inserting ... ] 16 - 363 2013-10-29 15:44:32 530
warnning [ Schedule Data Inserting ... ] 16 - 364 2013-10-29 15:44:32 530
warnning [ Schedule Data Inserting ... ] 16 - 365 2013-10-29 15:44:32 530
warnning [ Schedule Data Inserting ... ] 16 - 366 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 17 - 369 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 17 - 370 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 17 - 375 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 17 - 376 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 17 - 377 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 17 - 378 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 17 - 379 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 22 - 382 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 22 - 383 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 22 - 384 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 22 - 385 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 22 - 386 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 22 - 387 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 22 - 388 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 23 - 391 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 23 - 392 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 23 - 393 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 23 - 394 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 23 - 395 2013-10-29 15:44:32 540
warnning [ Schedule Data Inserting ... ] 23 - 396 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 23 - 397 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 18 - 399 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 18 - 400 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 18 - 401 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 18 - 402 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 18 - 403 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 18 - 404 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 18 - 405 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 19 - 406 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 19 - 407 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 19 - 408 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 19 - 409 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 19 - 410 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 19 - 411 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 19 - 412 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 22 - 413 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 22 - 414 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 22 - 415 2013-10-29 15:44:32 550
warnning [ Schedule Data Inserting ... ] 22 - 416 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 22 - 417 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 22 - 418 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 22 - 419 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 23 - 420 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 23 - 421 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 23 - 422 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 23 - 423 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 23 - 424 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 23 - 425 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 23 - 426 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 18 - 428 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 18 - 429 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 18 - 430 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 18 - 431 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 18 - 432 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 18 - 433 2013-10-29 15:44:32 580
warnning [ Schedule Data Inserting ... ] 18 - 434 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 19 - 436 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 19 - 437 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 19 - 438 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 19 - 439 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 19 - 440 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 19 - 441 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 19 - 442 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 8 - 446 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 16 - 452 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 17 - 453 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 31 - 455 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 27 - 456 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 27 - 457 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 27 - 458 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 27 - 459 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 27 - 460 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 27 - 461 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 27 - 462 2013-10-29 15:44:32 590
warnning [ Schedule Data Inserting ... ] 5 - 463 2013-10-29 15:44:32 600
warnning [ Schedule Data Inserting ... ] 6 - 464 2013-10-29 15:44:32 600
warnning [ Schedule Data Inserting ... ] 7 - 465 2013-10-29 15:44:32 600
notify Schedule Manager : Now working.. ! - SCHEDULE_DEF_EGYPT_TEMPLE_HAROERIS_AND_SETH - 57 2013-10-29 15:44:32 600
notify Schedule Manager : Now working.. ! - SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT - 359 2013-10-29 15:44:32 600
notify Schedule Manager : Now working.. ! - SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG - 245 2013-10-29 15:44:32 600
notify Schedule Manager : Now working.. ! - SCHEDULE_DEF_BATTLE_ARENA_RANDOM - 453 2013-10-29 15:44:32 600
notify Schedule Manager : Now working.. ! - SCHEDULE_DEF_BATTLE_ARENA_PARTY - 407 2013-10-29 15:44:32 600
fatal Query Error!!! Query Result : -1, Query : INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT', 359, 'Start', '2013-10-29 15:44:32') 2013-10-29 15:44:34 320
fatal SQL Error State:22007, Native Error Code: F2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
2013-10-29 15:44:34 320
fatal INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT', 359, 'Start', '2013-10-29 15:44:32') 2013-10-29 15:44:38 840
fatal SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Die Anweisung wurde beendet. 2013-10-29 15:44:38 860
fatal INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT', 359, 'Start', '2013-10-29 15:44:32') 2013-10-29 15:44:38 860
fatal AQ_ScheduleInsertLog Query Failed!! Query : INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT', 359, 'Start', '2013-10-29 15:44:32') 2013-10-29 15:44:38 860
fatal Query Error!!! Query Result : -1, Query : INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG', 245, 'Start', '2013-10-29 15:44:32') 2013-10-29 15:44:38 860
fatal SQL Error State:22007, Native Error Code: F2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
2013-10-29 15:44:38 860
fatal INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG', 245, 'Start', '2013-10-29 15:44:32') 2013-10-29 15:44:38 860
fatal SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Die Anweisung wurde beendet. 2013-10-29 15:44:38 860
fatal INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG', 245, 'Start', '2013-10-29 15:44:32') 2013-10-29 15:44:38 860
fatal AQ_ScheduleInsertLog Query Failed!! Query : INSERT INTO _LogSchedule VALUES( 'SR_ShardManager', 705, 'SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG', 245, 'Start', '2013-10-29 15:44:32') 2013-10-29 15:44:38 860
fatal ScheduleExecutor : Find Failed In Schedule Exe - End(STATE) SCHEDULE_DEF_BATTLE_ARENA_PARTY(DEFINE) 407(SCHIDX) 2013-10-29 15:45:01 000
notify Schedule Manager : Schedule processing (0) ! - SCHEDULE_DEF_BATTLE_ARENA_PARTY - 407 2013-10-29 15:45:01 000
fatal ScheduleExecutor : Find Failed In Schedule Exe - End(STATE) SCHEDULE_DEF_BATTLE_ARENA_RANDOM(DEFINE) 453(SCHIDX) 2013-10-29 15:45:01 000
notify Schedule Manager : Schedule processing (0) ! - SCHEDULE_DEF_BATTLE_ARENA_RANDOM - 453 2013-10-29 15:45:01 000
Another view of the errors + dc:
10/29/2013, 18:34
#2
elite*gold: 0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
Private SRO Main Discussions / Questions -> Private SRO Ask the Experts
#moved
10/30/2013, 02:53
#3
elite*gold: 0
Join Date: May 2013
Posts: 1,447
Received Thanks: 1,046
You added ODBC connection ? If yes, and still not working.. check your certification files (*.ini)
10/30/2013, 09:16
#4
elite*gold: 56
Join Date: Oct 2013
Posts: 1,165
Received Thanks: 775
Try this:
1. Connect to your DB with your Microsoft SQL Server Managment Studio
2. Open the Security Tab/Folder
3. Open the Logins Tab/Folder
4. Rightclick on sa and click on Properties
5. On the buttom Default db = master and Default language: English
the reason is following:
The server is working this this date format: 2013-10-30 and if the Default language is german the sql server cant handle it cuz its works with this data format: 30.10.2013
Code:
Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.
Deswegen bin ich ziemlich sicher das es daran liegt
[LoL Garena]Connection Issues?
10/27/2013 - League of Legends - 0 Replies
Der ein oder andere kennt ja die Garena Server wie zb Taiwan oder Philipinen da meine frage ich habe seit 2 Tagen immer nur Connection Probleme dort rauf zu kommen laut der IP Banned country list ist mein land dort nicht dabei wisst ihr vielleicht woran das liegt?
Connection Issues with the site
09/27/2013 - Main - 0 Replies
Hey guys, so I've been racking my brain trying to figure out why I've had so many issues..
But I just noticed this morning, as my Malwarebytes tried to block my access to this website claiming it was "Potentially Malicious", etc, etc.
There's the possibility that other Antivirus/Security softwares will pick up the same thing.
Not sure if there is a grand solution for everyone.. unless we can somehow figure out how to get this website un-blacklisted from, wherever that list is..
But...
I'm having weird connection issues...I think its Riot...
05/22/2012 - League of Legends - 5 Replies
Ok, I'm posting this here because I have no idea whats going on.
Today, I changed my internet service provider hoping it would fix my problem but it did not. I have tried using different computers, and both the computers WORK from a friend's house. Just not mine.
Every single game, this happens :
Lock in my character, the League of Legends logo appears, and then I disconnect from the match. I have to click "retry" and it disconnects again, then I click "retry" one more time. And...
[Issues]Connection
11/24/2011 - Flyff Private Server - 5 Replies
Private server - YouTube
connection issues
07/22/2010 - Allods - 0 Replies
anyone know how to be able to play from sweden using Bahnhof isp
it does not work atm after the last couple patches
All times are GMT +2. The time now is 13:02 .
![[Pserver Created] Issues with connection!](https://www.elitepvpers.com/forum/iconimages/sro-private-server/pserver-created-issues-connection_ltr.gif){kind=small}
Private SRO Main Discussions / Questions -> Private SRO Ask the Experts
