[HELP]Server Vanganth 1.2.3.5

[annakin]

At me the following problem.

The server works normally, is started and works without errors but when the Player bowls off or does restart l2Server falls, errors thus anywhere doesn't leave, falls silently.

I checked all broad gulls but anywhere there are no problems.

At me costs Win2003 x64 MSSQL 2005 x64.

All necessary Software is established.

I tried to find a problem and have reached that that the problem in base lin2world in the table user_items and procedure lin_createitems seems

I tried to establish base from assemblage Dvamp the server works with errors but at an exit of their game it doesn't fall, however with its native base it falls.

Who can prompt in what a problem?

[annakin]

in CacheD no1 error.

 

[annakin]

After crash L2server create this log file "linError.log"

 

A:I:S:E:PE:DI:DE:BO=1.000000:1.000000:1.000000:1.000000:1.000000:0:0:0
L:Y:X:H=0:0:0:0:0
Crashed Thread[3].
Server Up Time : Tue Jun 14 17:15:42 2011
Current Time : Tue Jun 14 17:27:44 2011
Elapsed Time : 0 days 0 hours 12 minutes 2 seconds
IOBufferPool - 39995 / 40000,  PendingWrite 393 bytes [0] 
=============== object report
user[1/0], npc[0/0], item[5/0], usersocket[1]
=============== npc server connection log 
no connect

[(2832) 2011/06/14 17:27:44]: =======================
an Access Violation in module L2Server.exe at 0033:0061fc3b.
start at 2011/6/14 17:15:41
Read from location ffffffff caused an access violation.

Registers:
EAX=00750061 CS=0033 EIP=0061fc3b EFLGS=00010202
EBX=04b7de40 SS=002b ESP=4a49fda0 EBP=03e9dfc0
ECX=03e9dfc0 DS=002b ESI=00000001 FS=0053
EDX=04c599ec ES=002b EDI=00000001 GS=002b
Bytes at CS:EIP:
48 8b 00 ff d0 c6 44 1e 08 00 ff 03 8b 4b 04 8b 
Stack dump:
4a49fda0: 092d3e01 00000000 00403d52 00000000 0e446748 00000000 3e720044 00000000
4a49fdc0: fffffffe ffffffff 00400000 00000000 00a05220 00000000 00062f00 00000000
4a49fde0: 00977230 00000000 0004c158 00000000 00000000 00000000 00624b22 00000000
4a49fe00: 00977230 00000000 00000000 00000000 00a05220 00000000 00400000 00000000
4a49fe20: 00000032 00000000 00000000 00000000 00000003 00000000 00000000 00000000
4a49fe40: 4308b1a4 00000000 fffffffe ffffffff 00000009 00001000 00010000 00000000
4a49fe60: fffeffff 000007ff 0000000f 00000000 00000004 000021d8 00010000 25020006
4a49fe80: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
4a49fea0: 00000000 00000000 00000000 00000000 00918960 00000000 00625449 00000000
4a49fec0: 00000000 00000000 00000003 00000000 00000000 00000000 00000000 00000000


ver = Dec 16 2005_22:03:13


GuardInfo : 

[ilExt] Last used packet[0] Ex[0] IOThread [0][47] (good):  void IOThread_common(void *arglist)
    Lock Stack  : 

[ilExt] Last used packet[0] Ex[0] IOThread [1][218] (good):  void IOThread_common(void *arglist) -> garbage collect -> inline void CTLPipeBase::Read(CReadCallback *pReadCallback) -> inline void CTLPipeBase::CThreadPipe::Read(CReadCallback *pReadCallback)
    Lock Stack  : 

[ilExt] Last used packet[0] Ex[0] IOThread [2][265] (good):  void IOThread_common(void *arglist) -> garbage collect -> inline void CTLPipeBase::Read(CReadCallback *pReadCallback) -> inline void CTLPipeBase::CThreadPipe::Read(CReadCallback *pReadCallback)
    Lock Stack  : 

[ilExt] Last used packet[46] Ex[0] IOThread [3][297] (ahehe):  void IOThread_common(void *arglist) -> garbage collect -> inline void CTLPipeBase::Read(CReadCallback *pReadCallback) -> inline void CTLPipeBase::CThreadPipe::Read(CReadCallback *pReadCallback)
    Lock Stack  : 

ListenThread [13][109] (good):  void ListenThread_common() -> unsigned __stdcall WaitThread(void *)
    Lock Stack  : 

MainThread [12][297] (good):      Lock Stack  : 

GuardInfo end 



[(2832) 2011/06/14 17:27:44]: *.\ioc.cpp:648(Tue Dec 13 02:52:40 2005) exception

[annakin]

I tried all options, including the reinstallation of all software a few times.

But the server still Crash.

[Garuda]

weird your problem, server files work fine.

have you try install on native installation?

[annakin]

Yes, I already knew that the problem with me.

But I do not understand what exactly is the problem, since I have reinstalled all the software and install different software but nothing works.

The most interesting is that the problem is I have only in the assembly and other assembly-type of Vampire are functioning normally

[annakin]

If possible, list what software should stand for the assembly

[annakin]

I found something, if you rename a table in user_item user_item_bak

then the server does not drop when you exit the game, but if there are errors in CacheD

Hence I understand the problem in this table

[annakin]

I found the problem.

The problem was the encoding tables

 

That's originally stood

 

CREATE TABLE [dbo].[user_item] (
  [item_id] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [char_id] int NOT NULL,
  [item_type] int NOT NULL,
  [amount] int NOT NULL,
  [enchant] int NOT NULL,
  [eroded] int NOT NULL,
  [bless] tinyint NOT NULL,
  [ident] int NOT NULL,
  [wished] tinyint DEFAULT 0 NOT NULL,
  [warehouse] int NOT NULL
)
ON [PRIMARY]
GO

 

But it should be

 

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[user_item] (
  [item_id] int IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL,
  [char_id] int NOT NULL,
  [item_type] int NOT NULL,
  [amount] int NOT NULL,
  [enchant] int NOT NULL,
  [eroded] int NOT NULL,
  [bless] tinyint NOT NULL,
  [ident] int NOT NULL,
  [wished] tinyint DEFAULT 0 NOT NULL,
  [warehouse] int NOT NULL
)
ON [PRIMARY]
GO

 

 

[annakin]

No what I described above does not solve the problem.

Server is still falling.

Who has ideas why the server may drop when a player leaves the game.

[annakin]

May-be needed for this assembly which is soft and what that other options?

If there is something that describe how to install and configure the assembly

[Hazel]

http://maxcheaters.com/forum/index.php?topic=210604.0 try this.

[annakin]

I tried to use it, but with version 1.2.3.6 I have a client does not pass on choosing a server, but when I put 1.2.3.5 comes into play

[annakin]

Perhaps a server crash due to the fact that the server is running on a test machine with the following parameters:

3GB RAM

CPU 2

Win 2003 x64

MSSQL 2005 x64

[sandeagle]

i saw the error in my little server,when i was changed the Itemdata.txt and the itemID more than 10000,the error showed and server crash when the l2npc.exe runing...i dont knwo why and i ask it with Vanganth,he tell me he didnot limited the  item id...anyway maybe the problem is not the mssql or config,maybe its the Scripts...you could try it...IMHO

[annakin]

omg thx man.. its work. i remove itemd ID in itemdata more 10000 and server work good :)