|
You last visited: Today at 08:45
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,741
Received Thanks: 1,674
|
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 +1. The time now is 08:46.
|
|
