MagOptCount (8) has wrong value!

12/31/2015 12:49 sl1nkz#1
Hello everyone,

my server was running fine until today.

I restarted the server and want to start it again.
Then im getting this error:

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

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

anyone know how to fix this error ?

kind regards,

dope
12/31/2015 13:11 Gidzy#2
Create new Database let's say (SHARD2)
Restore Old working backup
And use this query to copy refobjcommon from it
Quote:
USE SRO_VT_SHARD
GO
TRUNCATE TABLE [dbo].[_RefObjCommon]
GO
insert into SRO_VT_SHARD.dbo._RefObjCommon select * from SHARD2.dbo._RefObjCommon
12/31/2015 13:20 sl1nkz#3
Quote:
Originally Posted by Gidzy View Post
Create new Database let's say (SHARD2)
Restore Old working backup
And use this query to copy refobjcommon from it
if i try this im getting this error:

EDIT: Im using SQL2008 R2

Code:
Msg 4712, Level 16, State 1, Line 1
Cannot truncate table 'dbo._RefObjCommon' because it is being referenced by a FOREIGN KEY constraint.
Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'SRO_VT_SHARD_INIT.dbo._RefObjCommon' can only be specified when a column list is used and IDENTITY_INSERT is ON.
01/01/2016 02:40 Gidzy#4
Quote:
Originally Posted by .d0p3_' View Post
if i try this im getting this error:

EDIT: Im using SQL2008 R2

Code:
Msg 4712, Level 16, State 1, Line 1
Cannot truncate table 'dbo._RefObjCommon' because it is being referenced by a FOREIGN KEY constraint.
Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'SRO_VT_SHARD_INIT.dbo._RefObjCommon' can only be specified when a column list is used and IDENTITY_INSERT is ON.
First
Right click on the table < Press Design
uncheck the Foreign key "you can see it clearly"
and close & save table
then Right Click on the table
Scrit table as
Create to
New Query editor window
And delete this " IDENTITY(1,1) "
Now Delete the table manually > Right click Delete
Then press Execute to the query , now you've created a table without identity

< use the query i gave before to copy the table and it will work fine >
if you cant do things i said above add my facebook : [Only registered and activated users can see links. Click Here To Register...] ,i'll help you via TeamViewer , regards
01/01/2016 16:22 sl1nkz#5
alright, i fixed the errors above.

Code:
Resolution: Restored the full SHARD DB with an old backup
But now i get 2 new errors in SR_GameServer.exe

Code:
NULL == pRefFortress
Failed to Create Siege Fortress Instance
Initialize Siege Fortress Manager Failed
Failed To Init Local Data
SR_GameServer is initialized successfully
Anyone know how to fix these errors ?