GUILD STR ERROR

08/24/2014 02:18 Ecrypter#1
HI EPVPERS

i have a problem about the guild str, and when i create a guild i got an error in the error logs

and this is my problem
PHP Code:
2014/08/23    16:07:56
query:GUILD_STR 'A1',@im_idPlayer='0000001',@iserverindex='01',@im_idGuild='000001',@im_szGuild='www.alysium.com',@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/23    16:07:56
query:GUILD_STR 'A1',@im_idPlayer='0000001',@iserverindex='01',@im_idGuild='000001',@im_szGuild='www.alysium.com',@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/23    16:08:13
query:GUILD_STR 'A2',@im_idPlayer='0000002',@iserverindex='01',@im_idGuild='000001',@im_szGuild='',@iLv_1=0,@iLv_2=0,@iLv_3=0,@iLv_4=0,@im_nLevel=4,@im_nGuildGold=0,@im_nGuildPxp=0,@im_nWin=0,@im_nLose=0,@im_nSurrender=0,@im_dwLogo=0,@im_szNotice='',@im_nClass=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state 

hope you can advice my problem

sorry for my bad english
08/24/2014 11:16 Mognakor#2
Have you tried a shorter guild name?
08/24/2014 11:59 TrøublêMakêr#3
GuildName > 16 length = error
08/24/2014 12:36 xTwiLightx#4
Quote:
Originally Posted by TrøublêMakêr View Post
GuildName > 16 length = error
This one has a length of 15 (wondering why dots are allowed...).

Can you show us the table definition of your GUILD_TBL?
08/25/2014 01:34 Ecrypter#5
its fix now., @im_szGuild varCHAR(225)
09/03/2014 15:26 Ecrypter#6
Quote:
Originally Posted by xTwiLightx View Post
This one has a length of 15 (wondering why dots are allowed...).

Can you show us the table definition of your GUILD_TBL?
this is my GUILD_TBL

PHP Code:
USE [CHARACTER_01_DBF]
GO
/****** Object:  Table [dbo].[GUILD_TBL]    Script Date: 09/03/2014 09:25:24 ******/
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](225) 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 OFF