rf online disconnected from server closing program

Status
Not open for further replies.
ZoneServer\ZoneServerLog\NetLog

1 11/22/13 23:26:22 : Cont_UserSave_Complete Database Error(24) account(!LucasNunes , 2000000006), char(MyChar, 15)

ZoneServer\ZoneServerLog\DBLog

20 11/22/13 23:26:22 : Query : update [dbo].[tbl_pvppointlimitinfo] set [updatedate]='2013-11-22 23:26:22',[useup]=1,[limitrate]=3 where serial=15
21 11/22/13 23:26:22 : SqlState:22007, NativeError:242 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]A conversão de um tipo de dados varchar em um tipo de dados datetime resultou em um valor fora do intervalo.
22 11/22/13 23:26:22 : SqlState:01000, NativeError:3621 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]A instrução foi finalizada.
23 11/22/13 23:26:22 : SQLExecDirectA Returns : SQL_ERROR



Any idea how I can fix this?
 
Upvote 0
Run this query on RF_World_Novus

http://forum.ragezone.com/attachments/f152/140957d1385172495-rf-online-disconnected-server-closing-rf_world_sql.rar

Or run this

Code:
USE [RF_WORLD_NOVUS]
GO
/****** Object: Trigger [LastConnTime] Script Date: 05/01/2010 00:13:05 ******/
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

CREATE TRIGGER [LastConnTime] ON [dbo].[tbl_base]
FOR UPDATE
AS
SET NOCOUNT ON;

IF UPDATE (LastConnTime)
BEGIN
update
[dbo].[tbl_base]
set LastConnTime = LastConnTime + 1200000000 where LastConnTime < 1200000000

END
 

Attachments

Upvote 0
Run this query on RF_World_Novus

http://forum.ragezone.com/attachmen...-disconnected-server-closing-rf_world_sql.rar

Or run this

Code:
USE [RF_WORLD_NOVUS]
GO
/****** Object: Trigger [LastConnTime] Script Date: 05/01/2010 00:13:05 ******/
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

CREATE TRIGGER [LastConnTime] ON [dbo].[tbl_base]
FOR UPDATE
AS
SET NOCOUNT ON;

IF UPDATE (LastConnTime)
BEGIN
update
[dbo].[tbl_base]
set LastConnTime = LastConnTime + 1200000000 where LastConnTime < 1200000000

END

actually this trigger did not work, but the logic was for work, I think that should be the number 12000000000 .. I think every year changes!


I ended up recreating the tables using LastConnTime = varchar (50) instead of datatime and solved my problem: D Thaks!
 
Upvote 0
Status
Not open for further replies.
Back