Guild rollback NEED HELP

[mehoh23]

how to fix Guild rollback ? when i out the neuz the and login again the guild is lost., same in the guild status.,

help me pls

 

[raventh1984]

Depends on how you quit the neuz.

If you quit the neuz do you also close down the server files?
If so then you are starting the servers to fast. Make an batch file that launch the server files 1 at an time with arround 5~10 seconds between them

 

[mehoh23]

e closed the neuz automatically.,can you give me a guide to open the pogram and seconds i wait before i procced to another program?

BTW this is my error




2014/08/06 05:39:52
query:GUILD_STR 'A1',@im_idPlayer='0000001',@iserverindex='01',@im_idGuild='000004',@im_szGuild='TalkInEnglishToMe',@iLv_1=0,@iLv_2=0,@iLv_3=0,@iLv_4=0,@im_nLevel=0,@im_nGuildGold=0,@im_nGuildPxp=0,@im_nWin=0,@im_nLose=0,@im_nSurrender=0,@im_dwLogo=0,@im_szNotice='',@im_nClass=0
SQLSTATE:22001 error:[Microsoft][SQL Native Client][SQL Server]String or binary data would be truncated.
2014/08/06 05:39:52
query:GUILD_STR 'A1',@im_idPlayer='0000001',@iserverindex='01',@im_idGuild='000004',@im_szGuild='TalkInEnglishToMe',@iLv_1=0,@iLv_2=0,@iLv_3=0,@iLv_4=0,@im_nLevel=0,@im_nGuildGold=0,@im_nGuildPxp=0,@im_nWin=0,@im_nLose=0,@im_nSurrender=0,@im_dwLogo=0,@im_szNotice='',@im_nClass=0
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2014/08/06 05:39:55
query:MAIL_STR_REALTIME 'S1', '01'
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2014/08/06 07:13:29
query:uspLoggingTrade @pFlag=2, @pTradeID=1407334401, Pserverindex='01', @pidPlayer='0000003', PitemIndex='21', PitemSerialNum=-881021590, PitemCnt=1, @pAbilityOpt=0, PitemResist=0, @pResistAbilityOpt=0 prandomOpt=5293433167360
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2014/08/06 07:13:29
query:uspLoggingTrade @pFlag=2, @pTradeID=1407334401, Pserverindex='01', @pidPlayer='0000003', PitemIndex='21', PitemSerialNum=-881021590, PitemCnt=1, @pAbilityOpt=0, PitemResist=0, @pResistAbilityOpt=0 prandomOpt=5293433167360
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

 

[raventh1984]

This ]String or binary data would be truncated is or could be your problem

You are trying to insert more characters then the allowed space.
Example. If you have an field type varchar(50) and if you are putting more then 50 chars in it it will trancate meaning it will cut off the rest.

So located the error inside your DB for this.

if i am looking at m_szGuild you have 17 chars. Now take an look at the field type its if you dont have it changed varchar(16) so you have 1 char to many
GUILD_TBL m_szGuild

 

[mehoh23]

see this

USE [CHARACTER_01_DBF]GO
/****** Object: Table [dbo].[GUILD_TBL] Script Date: 08/08/2014 03:08:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GUILD_TBL](
[m_idGuild] [char](6) NOT NULL,
[serverindex] [char](2) NOT NULL,
[Lv_1] [int] NULL,
[Lv_2] [int] NULL,
[Lv_3] [int] NULL,
[Lv_4] [int] NULL,
[Pay_0] [int] NULL,
[Pay_1] [int] NULL,
[Pay_2] [int] NULL,
[Pay_3] [int] NULL,
[Pay_4] [int] NULL,
[m_szGuild] [varchar](16) NULL,
[m_nLevel] [int] NULL,
[m_nGuildGold] [int] NULL,
[m_nGuildPxp] [int] NULL,
[m_nWin] [int] NULL,
[m_nLose] [int] NULL,
[m_nSurrender] [int] NULL,
[m_nWinPoint] [int] NULL,
[m_dwLogo] [int] NULL,
[m_szNotice] [varchar](127) NULL,
[isuse] [char](1) NULL,
[CreateTime] [datetime] NULL
) ON [PRIMARY]


GO
SET ANSI_PADDING OF

if you dont mind can you share with me a fix database ?

 

[raventh1984]

change this [m_szGuild] [varchar](16) NULL, to varchar(255) NULL

 

[mehoh23]

okey., by the way how to banned ip ingame?