|
You last visited: Today at 14:30
Advertisement
Help Error flyff v19
Discussion on Help Error flyff v19 within the Flyff Private Server forum part of the Flyff category.
03/05/2014, 03:33
|
#1
|
elite*gold: 0 
Join Date: Feb 2014
Posts: 8
Received Thanks: 0
|
Help Error flyff v19
WorldDialog_2014-03-04_23-20-01
[2014-03-04 23:20:01] (INFO) InitWorldDialog(86): [ START - DLL LOG ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (QUEST_COOKER02) (5009) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_3RD_LEGEND_LEVEL) (139) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_CHARACTER_LEVEL) (139) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_LEGEND_LEVEL) (129) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_CHARACTER_LEVEL) (129) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_JOB) (32) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_JOB) (16) ]
CQuery-LogFile_20140304
2014/03/04 23:19:45
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
2014/03/04 23:19:45
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "Login timeout expired".
2014/03/04 23:19:45
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
error_20140304
2014/ 3/ 4 23:20:02 OP: 11147199, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0
2014/ 3/ 4 23:20:07 CDbManager::UpdateGuildRanking¿¡¼* (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') ½ÇÆÐ
2014/ 3/ 4 23:20:10 OP: 8038, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0
2014/ 3/ 4 23:20:10 LUA - Event - ID:1, Title:Level Up Event, State:1
2014/ 3/ 4 23:20:10 LUA - Event - ID:2, Title:Level-UP Event Rewards!!, State:1
2014/ 3/ 4 23:20:19 OP: 8344, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0
When I log into the server it closes alone (google translator) 
|
|
|
|
03/05/2014, 10:45
|
#2
|
elite*gold: 0
Join Date: Mar 2009
Posts: 477
Received Thanks: 218
|
@vidaloka24 - for "CQuery-LogFile_20140304" you need to fix this "query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'" on your Database.
Use this code to fix the RANKING_STR.
/****** Object: LinkedServer [RANKING] Script Date: 12/25/2011 00:13:43 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'RANKING', @srvproduct=N'RANKING', @provider=N'SQLNCLI', @datasrc=N'PC-NAME\SQLEXPRESS', @catalog=N'RANKING_DBF'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'RANKING',@useself=N'True',@locallogi n=NULL,@rmtuser=NULL,@rmtpassword=NULL
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'use remote collation', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'remote proc transaction promotion', @optvalue=N'true'
|
|
|
|
|
03/05/2014, 13:32
|
#3
|
elite*gold: 0
Join Date: Apr 2010
Posts: 82
Received Thanks: 27
|
Quote:
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_CHARACTER_LEVEL) (139) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_LEGEND_LEVEL) (129) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_CHARACTER_LEVEL) (129) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_JOB) (32) ]
[2014-03-04 23:20:01] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_JOB) (16) ]
|
Check defineJob.h
|
|
|
|
|
03/05/2014, 16:34
|
#4
|
elite*gold: 0
Join Date: Feb 2014
Posts: 8
Received Thanks: 0
|
Quote:
Originally Posted by Burdenz2007
@vidaloka24 - for "CQuery-LogFile_20140304" you need to fix this "query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'" on your Database.
Use this code to fix the RANKING_STR.
/****** Object: LinkedServer [RANKING] Script Date: 12/25/2011 00:13:43 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'RANKING', @srvproduct=N'RANKING', @provider=N'SQLNCLI', @datasrc=N'PC-NAME\SQLEXPRESS', @catalog=N'RANKING_DBF'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'RANKING',@useself=N'True',@locallogi n=NULL,@rmtuser=NULL,@rmtpassword=NULL
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'use remote collation', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'remote proc transaction promotion', @optvalue=N'true'
|
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@locallogi".
Msg 15600, Level 15, State 1, Procedure sp_serveroption, Line 177
An invalid parameter or option was specified for procedure 'sys.sp_serveroption'.
Query completed with erros .... in sql
|
|
|
|
|
03/05/2014, 18:54
|
#5
|
elite*gold: 7
Join Date: Sep 2012
Posts: 4,462
Received Thanks: 3,213
|
Quote:
Originally Posted by vidaloka24
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@locallogi".
Msg 15600, Level 15, State 1, Procedure sp_serveroption, Line 177
An invalid parameter or option was specified for procedure 'sys.sp_serveroption'.
Query completed with erros .... in sql |
-> you forget your SQL-Name by YOUR-PC\SQLEXPRESS...
Before Delete the old linked Server.
|
|
|
|
|
03/05/2014, 19:33
|
#6
|
elite*gold: 0
Join Date: Jan 2009
Posts: 1,739
Received Thanks: 1,669
|
Mal abgesehen davon, dass es 1. das falsche Forum ist und 2. das Problem die Gala Files sind...
Quote:
Originally Posted by Blσσdlυѕт
-> you forget your SQL-Name by YOUR-PC\SQLEXPRESS...
Before Delete the old linked Server.
|
Hat damit aber überhaupt nichts zu tun.
Zudem ein fehlender Linked Server nicht den Worldserver verschwinden lässt. ;p
Code:
/****** Object: LinkedServer [RANKING] Script Date: 12/25/2011 00:13:43 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'RANKING', @srvproduct=N'RANKING', @provider=N'SQLNCLI', @datasrc=N'PC-NAME\SQLEXPRESS', @catalog=N'RANKING_DBF'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'RANKING',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'use remote collation', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'remote proc transaction promotion', @optvalue=N'true'
#fixed
Quote:
Weil der Vorposter irgend was dämliches kopiert hat.
|
|
|
|
|
03/05/2014, 21:35
|
#7
|
elite*gold: 7
Join Date: Sep 2012
Posts: 4,462
Received Thanks: 3,213
|
Quote:
Originally Posted by xTwiLightx
Mal abgesehen davon, dass es 1. das falsche Forum ist und 2. das Problem die Gala Files sind...
Hat damit aber überhaupt nichts zu tun.
Zudem ein fehlender Linked Server nicht den Worldserver verschwinden lässt. ;p
Code:
/****** Object: LinkedServer [RANKING] Script Date: 12/25/2011 00:13:43 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'RANKING', @srvproduct=N'RANKING', @provider=N'SQLNCLI', @datasrc=N'PC-NAME\SQLEXPRESS', @catalog=N'RANKING_DBF'
/* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'RANKING',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc out', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'use remote collation', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'remote proc transaction promotion', @optvalue=N'true'
#fixed
Weil der Vorposter irgend was dämliches kopiert hat. |
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'" on your Database. <- War darauf bezogen.
|
|
|
|
|
03/05/2014, 22:10
|
#8
|
elite*gold: 0
Join Date: Feb 2014
Posts: 8
Received Thanks: 0
|
Quote:
Originally Posted by Meutledaron
Check defineJob.h
|
Quote:
Originally Posted by Blσσdlυѕт
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'" on your Database. <- War darauf bezogen.
|
OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 2, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [2].
How Edit MateusCochen-pc/Flyffpk ? 
|
|
|
|
|
03/05/2014, 23:04
|
#9
|
elite*gold: 15
Join Date: May 2010
Posts: 5,996
Received Thanks: 2,283
|
Flyff PServer Guides & Releases -> Flyff PServer - Discussions / Questions
#moved
|
|
|
|
|
03/05/2014, 23:33
|
#10
|
ベトナム警察
elite*gold: 725
Join Date: Jan 2012
Posts: 16,370
Received Thanks: 3,428
|
Debug your neuz /worldserver.
|
|
|
|
|
03/06/2014, 00:21
|
#11
|
elite*gold: 0
Join Date: Feb 2014
Posts: 8
Received Thanks: 0
|
Quote:
Originally Posted by Lumi
Debug your neuz /worldserver.
|
Nobody helps me, I can not resolve these errors :/
WorldDialog_2014-03-05_20-14-36
[2014-03-05 20:14:36] (INFO) InitWorldDialog(86): [ START - DLL LOG ]
[2014-03-05 20:14:36] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (QUEST_COOKER02) (5009) ]
[2014-03-05 20:14:36] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_JOB_LEVEL) (15) ]
[2014-03-05 20:14:36] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_EXP_LEVEL) (45) ]
[2014-03-05 20:14:36] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_PRO_LEVEL) (30) ]
[2014-03-05 20:14:36] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_TROUPE_LEVEL) (1) ]
[2014-03-05 20:14:36] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_JOB) (32) ]
[2014-03-05 20:14:36] (ERROR) FLDefinedsToString::load(86): [ DUPLICATE DEFINE : (MAX_JOB) (16) ]
error_20140305
2014/ 3/ 5 20:14:36 OP: 51772874, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0
2014/ 3/ 5 20:14:57 OP: 20169, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0
2014/ 3/ 5 20:14:57 LUA - Event - ID:1, Title:Level Up Event, State:1
2014/ 3/ 5 20:14:57 LUA - Event - ID:2, Title:Level-UP Event Rewards!!, State:1
2014/ 3/ 5 20:15:03 CDbManager::UpdateGuildRanking¿¡¼* (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') ½ÇÆÐ
2014/ 3/ 5 20:15:12 OP: 14742, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0
WorldDialog_2014-03-05_20-14-36 fixed
only error query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
|
|
|
|
All times are GMT +2. The time now is 14:30.
|
|
