Hello,
I have issue with my database
but i can't find a solution
i didn't make a backup since a long time ago
and now my database start to give me this errors on gameserver
it was working fine but i don't remember what i have done to
result this issue,
i don't have a backup and i can't fix this error
i am looking for help if anyone can help fixing this error without restore old
database backup, the problem not inside server Data folder
because i've tried alot of files and still the same error
and when i make a rollback ( restore old backup )
the problem not appear
Hello, something with your mirror dimension map is wrong. However I don't know the exact solution
Maybe check if you have all regions enabled, specially ID 41. could be useful too...
This seems like a simple region linking issue (LINK_REGION ERROR).
Have you added new regions or tweaked them, and used the exec RefLinkRegions procedure to finish up that work?
Those are few lines of the jupiter continent. Look for the part with the region IDs after the "xxx" declarations:
Do yours from _RefRegion match those I am showing? If not, execute the stored procedure "_LinkRefRegions"
Assure that JUPITER has been declared inside that procedure, otherwise execute this one first (applying changes) and then execute it via "exec _LinkRefRegions":
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_LinkRefRegions] Script Date: 02.05.2016 20:16:40 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_LinkRefRegions]
AS
--- Blow Query is Each Area and FORT matching ---
declare @China int
declare @West_China int
declare @Oasis_Kingdom int
declare @Eu int
declare @Am int
declare @Ca int
declare @JUPITER int
select @China = AssocServer from _RefRegionBindAssocServer where AreaName = 'CHINA'
select @West_China = AssocServer from _RefRegionBindAssocServer where AreaName = 'West_China'
select @Oasis_Kingdom = AssocServer from _RefRegionBindAssocServer where AreaName = 'Oasis_Kingdom'
select @Eu = AssocServer from _RefRegionBindAssocServer where AreaName = 'Eu'
select @Am = AssocServer from _RefRegionBindAssocServer where AreaName = 'Am'
select @Ca = AssocServer from _RefRegionBindAssocServer where AreaName = 'Ca'
select @JUPITER = AssocServer from _RefRegionBindAssocServer where AreaName = 'JUPITER'
update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_JA_AREA'
update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_BJ_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_DW_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_HM_AREA'
update _RefRegionBindAssocServer set AssocServer = @Oasis_Kingdom where AreaName = 'FORT_HT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Eu where AreaName = 'FORT_CT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Am where AreaName = 'FORT_ER_AREA'
update _RefRegionBindAssocServer set AssocServer = @Ca where AreaName = 'FORT_SK_AREA'
update _RefRegionBindAssocServer set AssocServer = @JUPITER where AreaName = 'JUPITER'
begin TRANSACTION
begin
declare @LinkNum int
declare @this_region int
declare @region_x int
declare @region_z int
declare @wRegionID smallint
declare @wTempRID smallint
declare @col_link varchar(256)
declare @query varchar(256)
declare @db_id_to_link smallint
-- clear all existing region link
set @LinkNum = 1
while (@LinkNum <= 10)
begin
set @query = 'update _RefRegion set LinkedRegion_' + cast(@LinkNum as varchar(10)) + ' = 0'
execute (@query)
set @LinkNum = @LinkNum + 1
end
-- loop all region
declare region_cursor CURSOR FOR
select wRegionID
from _RefRegion
OPEN region_cursor
FETCH NEXT FROM region_cursor INTO @wRegionID
WHILE @@FETCH_STATUS = 0
begin
if (@@error = 0 and @wRegionID <> 0)
begin
-- 던전은 스킵!
if (@wRegionID > 0)
begin
set @LinkNum = 8
while (@LinkNum >= 0)
begin
set @region_z = (@wRegionID & 0xff00) / 256
set @region_x = (@wRegionID & 0x0ff)
set @wTempRID = 0;
if (@LinkNum = 0)
begin
set @region_x = @region_x - 1
set @col_link = 'LinkedRegion_1'
end
else if (@LinkNum = 1)
begin
set @region_x = @region_x - 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_2'
end
else if (@LinkNum = 2)
begin
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_3'
end
else if (@LinkNum = 3)
begin
set @region_x = @region_x + 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_4'
end
else if (@LinkNum = 4)
begin
set @region_x = @region_x + 1
set @col_link = 'LinkedRegion_5'
end
else if (@LinkNum = 5)
begin
set @region_x = @region_x + 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_6'
end
else if (@LinkNum = 6)
begin
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_7'
end
else if (@LinkNum = 7)
begin
set @region_x = @region_x - 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_8'
end
set @wTempRID = (@region_z & 0x00ff) * 256
set @wTempRID = @wTempRID + (@region_x & 0x00ff)
select @db_id_to_link = wRegionID
from _RefRegion
where wRegionID = @wTempRID
if (@@ROWCOUNT <> 0)
begin
set @query = 'update _RefRegion set ' + @col_link + ' = ' + cast(@db_id_to_link as varchar(10)) + ' where wRegionID = ' + cast(@wRegionID as varchar(10))
end
else -- 존재하지 않는 region link 는 0으로 채운다
begin
set @query = 'update _RefRegion set ' + @col_link + ' = 0 where wRegionID = ' + cast(@wRegionID as varchar(10))
end
execute(@query)
set @LinkNum = @LinkNum - 1
end
end
end
FETCH NEXT FROM region_cursor INTO @wRegionID
end
CLOSE region_cursor
DEALLOCATE region_cursor
COMMIT TRANSACTION
end
This seems like a simple region linking issue (LINK_REGION ERROR).
Have you added new regions or tweaked them, and used the exec RefLinkRegions procedure to finish up that work?
Those are few lines of the jupiter continent. Look for the part with the region IDs after the "xxx" declarations:
Do yours from _RefRegion match those I am showing? If not, execute the stored procedure "_LinkRefRegions"
Assure that JUPITER has been declared inside that procedure, otherwise execute this one first (applying changes) and then execute it via "exec _LinkRefRegions":
Quote:
Originally Posted by guckguck
Hello, something with your mirror dimension map is wrong. However I don't know the exact solution
Maybe check if you have all regions enabled, specially ID 41. could be useful too...
İbot Error-Error Video- Error İmages-HELP 04/10/2012 - DarkOrbit - 11 Replies SORRY, MY ENGLİSH VERY BAD.I USE TO GOOGLE TRANSLATE :)
Most people trying to ibot but in my computer İbot not working.
Declared out this error everywhere but I do not get answers
Here's the error Video
http://youtu.be/q0fK09v-K3c
[Error] [SR_GameServer] LINK_REGION ERROR 11/01/2011 - SRO Private Server - 5 Replies Anyone knows if this error is commom?
2011-10-16 08:09:36 At initialize Server, Loading Siege data :: CurrentTax = 0
2011-10-16 08:09:36 At initialize Server, Loading Siege data :: CurrentTax = 0
2011-10-16 08:09:36 At initialize Server, Loading Siege data :: CurrentTax = 0
2011-10-16 08:09:42 LINK_REGION ERROR
2011-10-16 08:09:42 LINK_REGION ERROR
2011-10-16 08:09:42 LINK_REGION ERROR
2011-10-16 08:10:13 SR_GameServer is initialized successfully
[Error]Error when using Zero's method/And another Error 09/16/2011 - Shaiya Private Server - 5 Replies well here is a screeny of my problem. Any assistance is greatly appreciated. I haven't come across this error before nor seen any posts up here about it. Also this is me executing the NpcQuest_cvs.bat and yes i changed python to C:/Python27/Python.exe in the command line.
http://img707.imageshack.us/img707/9997/errorgx.p ng
Ok So my second error involves changing Stat points per lvl here is my screen shots
http://img854.imageshack.us/img854/6412/nosave.pn g
[Error] Server Error [/Error] 03/30/2011 - Dekaron Private Server - 7 Replies Okay so i just start the server as usual but then i got this error:
http://i.min.us/ibDMH2.jpg
ERROR ERROR ERROR! 11/08/2008 - Dekaron - 5 Replies Hello, everytime i launch 2moons and log in it freezes just as the map is finished loading and the DAMN CRASH REPORTER comes up and the game closes. Can anyone help me get around this? I tried deleting the bug reporter(LOL) but all that happened was that it crashed without it popping up.
PS. I think i read somewhere that it was caused because i needed to update something or change files, but no one would reply to me :(
I am using the crc bypass from the sticky
Anticipating your...
could be useful too...
