MagOptCount (8) has wrong value!

[sl1nkz]

Hello everyone,

my server was running fine until today.

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





anyone know how to fix this error ?

kind regards,

dope

[Gidzy]

Create new Database let's say (SHARD2)
Restore Old working backup
And use this query to copy refobjcommon from it

USE SRO_VT_SHARD
GO
TRUNCATE TABLE [dbo].[_RefObjCommon]
GO
insert into SRO_VT_SHARD.dbo._RefObjCommon select * from SHARD2.dbo._RefObjCommon

[sl1nkz]

Originally Posted by Gidzy

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

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.

[Gidzy]

Originally Posted by .d0p3_'

if i try this im getting this error:

EDIT: Im using SQL2008 R2

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 : ,i'll help you via TeamViewer , regards

[sl1nkz]

alright, i fixed the errors above.

Resolution: Restored the full SHARD DB with an old backup

But now i get 2 new errors in SR_GameServer.exe

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 ?