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

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_'

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 ?