|
You last visited: Today at 02:05
Advertisement
GUILD STR ERROR
Discussion on GUILD STR ERROR within the Flyff Private Server forum part of the Flyff category.
08/24/2014, 02:18
|
#1
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
GUILD STR ERROR
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
|
#2
|
elite*gold: 0
Join Date: Mar 2008
Posts: 598
Received Thanks: 465
|
Have you tried a shorter guild name?
|
|
|
08/24/2014, 11:59
|
#3
|
elite*gold: 51
Join Date: Sep 2012
Posts: 1,141
Received Thanks: 575
|
GuildName > 16 length = error
|
|
|
08/24/2014, 12:36
|
#4
|
elite*gold: 0
Join Date: Jan 2009
Posts: 1,739
Received Thanks: 1,669
|
Quote:
Originally Posted by TrøublêMakêr
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
|
#5
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
its fix now., @im_szGuild varCHAR(225)
|
|
|
09/03/2014, 15:26
|
#6
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
error again
Quote:
Originally Posted by xTwiLightx
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
|
|
|
|
Similar Threads
|
Guild error said need help
08/08/2014 - Flyff Private Server - 0 Replies
2014/ 8/ 8 10:07:50
OpenGuild(): Player's guild not found - 1, 3
2014/ 8/ 8 10:07:50
OpenGuild(): Player's guild not found - 9, 6
2014/ 8/ 8 10:07:50
OpenGuild(): Player's guild not found - 73, 3
how to fix this?
|
guild war error
07/20/2013 - Metin2 Private Server - 12 Replies
Hallo All
I Have Problem When War Start between 2 guild, then you open the letter so you can go to map guild war it's not warp to the map + the war starter in the city(a1 or b1 or c1)
Plz Help I Need To Fix It:)
|
Guild error Help me
07/14/2013 - 4Story - 4 Replies
GR
Hallo, ich brauche Hilfe! TMAP Spieler spielen das Spiel schaltet sich nach meiner Gilde! Haben Sie eine Abhilfe für dieses? Jeder Kommentar ist sehr wichtig für mich!
--
EN
Hi, I need help! TMAP players play the game shuts down after my guild! Do you have a remedy for this? Every comment is very important for me!
|
getting Guild error
02/10/2009 - Dekaron Private Server - 0 Replies
I recently switched dbases, and since i did that when i create a guild ingame, the player that creates the guild is not appointed leader.
it appears as followed
Player name Class <Blank> Online
If anyone could help me in resolving this, that would be great.
|
[Help]Guild Error.
11/13/2008 - CO2 Private Server - 2 Replies
Hey guys, I'm having a problem in my Guild and need help = / .. Look at the error that is appearing on the console.
System.FormatException: Input string was not in the correct format.
at System.Number.StringToNumber (String str, NumberStyles options, NumberBuffer & number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseUInt32 (String value, NumberStyles options, NumberFormatInfo numfmt)
at COServer_Project.Guild.GuildMessage (String message) in C: \...
|
All times are GMT +2. The time now is 02:05.
|
|