Help Error flyff v19

03/05/2014 03:33 vidaloka24#1
WorldDialog_2014-03-04_23-20-01
CQuery-LogFile_20140304
error_20140304

When I log into the server it closes alone (google translator):(
03/05/2014 10:45 Burdenz2007#2
@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.

03/05/2014 13:32 Meutledaron#3
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 vidaloka24#4
Quote:
Originally Posted by Burdenz2007 View Post
@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.
:(
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 - DK#5
Quote:
Originally Posted by vidaloka24 View Post
:(
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 xTwiLightx#6
Mal abgesehen davon, dass es 1. das falsche Forum ist und 2. das Problem die Gala Files sind...

Quote:
Originally Posted by Blσσdlυѕт View Post
-> 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:
@locallogi n=NULL
Weil der Vorposter irgend was dämliches kopiert hat.
03/05/2014 21:35 - DK#7
Quote:
Originally Posted by xTwiLightx View Post
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 vidaloka24#8
Quote:
Originally Posted by Meutledaron View Post
Check defineJob.h
Quote:
Originally Posted by Blσσdlυѕт View Post
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 ? :mad:
03/05/2014 23:04 Reavern#9
#moved
03/05/2014 23:33 Lumi#10
Debug your neuz /worldserver.
03/06/2014 00:21 vidaloka24#11
Quote:
Originally Posted by ​Lumi View Post
Debug your neuz /worldserver.
Nobody helps me, I can not resolve these errors :/
WorldDialog_2014-03-05_20-14-36



error_20140305

WorldDialog_2014-03-05_20-14-36 fixed


only error query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'