[Pserver Created] Issues with connection!

10/29/2013 15:38 blapanda#1
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:
[Only registered and activated users can see links. Click Here To Register...]
10/29/2013 18:34 Haxor#2
#moved
10/30/2013 02:53 Anonymous-6723#3
You added ODBC connection ? If yes, and still not working.. check your certification files (*.ini)
10/30/2013 09:16 Syloxx#4
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