weird shardmanger error

05/25/2015 05:11 Eslam Galull#1
all i remmber in this time i was trying to copy & past
EGY A or B item lines ( ObjCommon & objitem )

then i deleted the new lines but this error still here .. i cant handle what is that so any idea


[Only registered and activated users can see links. Click Here To Register...]

i try to clear ALL Shared DB to , but i still got that error will shard loading

and btw after click ok , shard loading success and everything gonna be ok

but after a lil time of online time ( 1 hour or less ) server freezed - shard Freez problem -

what i tried :

- changed the shardmanger exe ( same )
- Changed the GS ( same )
- almost changed all server files to standered one ( same )
- db cleaned ( same )


any hints ..


regards
05/26/2015 05:35 Xutan*#2
well,
create a new database SRO_VT_SHARD_2 or whatever
restore old backup to the new database.
check _RefObjCommon in your old backup and your current database
also check _RefObjItem & refskill
i'm sure you will find where the problem is.
05/26/2015 10:07 Eslam Galull#3
what i have done

checked ids from refobjitem which didnt linked in refobjcommon = result 0

about common i will try compare lines

about refskill am pretty sure its not the reasone
05/27/2015 22:59 Eslam Galull#4
up
06/06/2015 07:10 Eslam Galull#5
Up ..

and btw sometimes it shows ( Duplicated user Login Problem in Shard )
06/07/2015 03:31 mtnman33#6
OMG.......... good lord people , read the error its simply a skill problem go to RefSkill.txt and search for the skill "bound' and set it to zero '0' then restart the server and your problem will be solved and you can start the server , once you can finally start your server you can go into the database and fix that skill or any others that it causing start up errors
06/07/2015 13:28 Eslam Galull#7
Quote:
Originally Posted by mtnman33 View Post
OMG.......... good lord people , read the error its simply a skill problem go to RefSkill.txt and search for the skill "bound' and set it to zero '0' then restart the server and your problem will be solved and you can start the server , once you can finally start your server you can go into the database and fix that skill or any others that it causing start up errors
dude you didnt know anything about that error btw :)

wtf
Quote:
skill "bound'
are you understand what you are talking about ! ?
06/07/2015 22:29 Crue*#8
i got it before but i don't remember from where exactly but i'm sure it's from
common,objitem or objchar
06/08/2015 03:43 Eslam Galull#9
Quote:
Originally Posted by Crue* View Post
i got it before but i don't remember from where exactly but i'm sure it's from
common,objitem or objchar
you are right ,, nd when i got a free time i will check every single line there


regards
06/11/2015 09:22 NotEvenMad#10
What I understood in this topic was the following:
You edited your RefObjCommon & RefObjItem (Egypt A and B)

But how could that effect ShardManager?

At least when I've fucked up my RefObjCommon or something I always got GameServer crashing not my Shard.

My ideas:
schedule.cfg

"Maybe you edited something in (server.cfg) like activating some shitty event which is not working."

"Maybe you fucked up the schedule from the DB itself".

Never got this error before, but check what I wrote.
06/12/2015 15:48 Eslam Galull#11
Quote:
Originally Posted by NotEvenMad View Post
What I understood in this topic was the following:
You edited your RefObjCommon & RefObjItem (Egypt A and B)

But how could that effect ShardManager?

At least when I've fucked up my RefObjCommon or something I always got GameServer crashing not my Shard.

My ideas:
schedule.cfg

"Maybe you edited something in (server.cfg) like activating some shitty event which is not working."

"Maybe you fucked up the schedule from the DB itself".

Never got this error before, but check what I wrote.

sure i will do ,,

btw wasnt an edit .. it was copy lines to creat a new weapon with same state then i remmber i just met that error


also i Dont know if error linked with the freez problem or no
06/16/2015 19:36 Eslam Galull#12
i think Mike was Rights its the schedule Problem

Any One Got a schedule Table with Working Arena & CTF & Temples & Titan uniques ?


The Freez Problem Appear Here




So #Request Working SRO_VT_SHARD.dbo._Schedule
06/16/2015 21:43 St0rmSRO#13
Here is my schedule, However i havent added Jupiter Temple yet but everything else is working :)

Code:
1	1	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	3	1	1	0	0	0	23	30	0	3600	0	0		
2	2	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	12	0	0	1800	0	0		
3	2	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	16	0	0	1800	0	0		
4	2	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	20	0	0	1800	0	0		
5	2	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	0	0	0	1800	0	0		
6	2	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	4	0	0	1800	0	0		
7	2	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	8	0	0	1800	0	0		
14	5	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	3	1	7	0	0	0	15	0	0	10740	0	0		
19	11	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	0	0	0	3600	0	0		
20	11	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	12	0	0	3600	0	0		
33	12	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	2	0	0	599	0	0		
34	12	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	5	0	0	599	0	0		
35	12	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	8	0	0	599	0	0		
36	12	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	11	0	0	599	0	0		
37	12	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	14	0	0	599	0	0		
38	12	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	17	0	0	599	0	0		
39	12	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	20	0	0	599	0	0		
40	12	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	23	0	0	599	0	0		
43	13	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	2	5	0	2099	0	0		
44	13	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	5	5	0	2099	0	0		
45	13	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	8	5	0	2099	0	0		
46	13	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	11	5	0	2099	0	0		
51	13	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	14	5	0	2099	0	0		
52	13	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	17	5	0	2099	0	0		
53	13	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	20	5	0	2099	0	0		
54	13	2012-11-11 00:00:00.000	2020-11-11 00:00:00.000	1	1	0	0	0	0	23	5	0	2099	0	0		
64	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	0	0	0	60	0	0		
65	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	1	0	0	60	0	0		
66	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	2	0	0	60	0	0		
67	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	3	0	0	60	0	0		
68	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	4	0	0	60	0	0		
69	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	5	0	0	60	0	0		
70	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	6	0	0	60	0	0		
71	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	7	0	0	60	0	0		
72	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	8	0	0	60	0	0		
73	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	9	0	0	60	0	0		
74	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	10	0	0	60	0	0		
75	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	11	0	0	60	0	0		
76	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	12	0	0	60	0	0		
77	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	13	0	0	60	0	0		
78	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	14	0	0	60	0	0		
79	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	15	0	0	60	0	0		
80	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	16	0	0	60	0	0		
81	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	17	0	0	60	0	0		
82	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	18	0	0	60	0	0		
83	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	19	0	0	60	0	0		
84	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	20	0	0	60	0	0		
85	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	21	0	0	60	0	0		
86	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	22	0	0	60	0	0		
87	4	2012-11-13 00:00:00.000	2020-11-13 00:00:00.000	1	1	0	0	0	0	23	0	0	60	0	0		
97	9	2012-11-17 00:00:00.000	2020-11-17 00:00:00.000	1	1	0	0	0	0	3	0	0	3600	0	0		
98	10	2012-11-17 00:00:00.000	2020-11-17 00:00:00.000	1	1	0	0	0	0	21	0	0	3600	0	0		
100	10	2012-11-17 00:00:00.000	2020-11-17 00:00:00.000	1	1	0	0	0	0	9	0	0	3600	0	0		
101	9	2012-11-17 00:00:00.000	2020-11-17 00:00:00.000	1	1	0	0	0	0	15	0	0	3600	0	0		
105	31	2012-12-12 00:00:00.000	2020-12-12 00:00:00.000	1	1	0	0	0	0	6	0	0	1	0	0		
106	31	2012-12-12 00:00:00.000	2020-12-12 00:00:00.000	1	1	0	0	0	0	18	0	0	1	0	0		
107	14	2012-12-12 00:00:00.000	2020-12-12 00:00:00.000	1	1	0	0	0	0	0	0	0	86400	0	0		
108	15	2012-12-12 00:00:00.000	2020-12-12 00:00:00.000	1	1	0	0	0	0	0	0	0	86400	0	0		
109	16	2012-12-12 00:00:00.000	2020-12-12 00:00:00.000	1	1	0	0	0	0	4	0	0	600	0	0		
110	17	2012-12-12 00:00:00.000	2020-12-12 00:00:00.000	1	1	0	0	0	0	4	5	0	1500	0	0		
114	6	2012-08-09 00:00:00.000	2030-08-09 00:00:00.000	3	1	7	0	0	0	18	0	0	7200	0	0		
117	7	2012-08-09 00:00:00.000	2030-08-09 00:00:00.000	3	1	7	0	0	0	20	1	0	60	0	0		
118	8	2012-08-09 00:00:00.000	2030-08-09 00:00:00.000	3	1	7	0	0	0	20	1	0	36000	0	0		
NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
06/17/2015 16:10 Eslam Galull#14
well , thanks lemme test if i will face that freezing problem again or no