DB:SELECT GuNum, ChaNum, GuDeputy, ChaName, GuName, GuRank, GuMoney, GuIncomeMoney, GuMarkVer, GuBattleWin, GuBattleDraw, GuBattleLose, GuBattleLastTime, GuAllianceBattleWin, GuAllianceBattleDraw, GuAllianceBattleLose, GuMakeTime, GuExpireTime, GuAuthorityTime, GuAllianceSec, GuAllianceDis, GuNotice FROM viewGuildInfo
DB:42S22, NativeError:207, [Microsoft][SQL Native Client][SQL Server]Invalid column name 'GuAuthorityTime'.
[Gaea Server] Start Succeeded
[Gaea Server] ---------------
Server Update Thread Create OK
WSASocket OK
Bind OK
192.168.1.174:5502
Server Accept Thread Create OK
(Client ID:99) (192.168.1.174:5003)
============================
Session Server Connection OK
============================
SessionSndSvrInfo 192.168.1.174 CH:1
(Client ID:0) (192.168.1.174:5113)
INFO:Field Server CH(0) FIELD(0) ID(0) Connection OK
NET_MSG_BASE 1019
=======================================================
Server Start OK
I use 2 pc to log and host Sql, this happens when agent server starts and i created id using the RanManager V3.2 to test and later use another pc to connect and make char but it wont log into game, just at char screen. any ideas..?
DB:SELECT GuNum, ChaNum, GuDeputy, ChaName, GuName, GuRank, GuMoney, GuIncomeMoney, GuMarkVer, GuBattleWin, GuBattleDraw, GuBattleLose, GuBattleLastTime, GuAllianceBattleWin, GuAllianceBattleDraw, GuAllianceBattleLose, GuMakeTime, GuExpireTime, GuAuthorityTime, GuAllianceSec, GuAllianceDis, GuNotice FROM viewGuildInfo
DB:42S22, NativeError:207, [Microsoft][SQL Native Client][SQL Server]Invalid column name 'GuAuthorityTime'.
[Gaea Server] Start Succeeded
[Gaea Server] ---------------
Server Update Thread Create OK
WSASocket OK
Bind OK
192.168.1.174:5113
Server Accept Thread Create OK
============================
Session Server Connection OK
Field Server also have this error
Try To Execute this Script to Your RanGame1 DataBase
1. First Delete dbo.GuildInfo Then execute this script.
This script will add column like
GuAuthorityTime
-----------------------------------------------
USE [RanGame1]
GO
/****** Object: Table [dbo].[GuildInfo] Script Date: 12/21/2011 18:47:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GuildInfo](
[GuNum] [int] IDENTITY(1,1) NOT NULL,
[ChaNum] [int] NOT NULL CONSTRAINT [DF_GuildInfo_ChaNum] DEFAULT ((0)),
[GuDeputy] [int] NOT NULL CONSTRAINT [DF_GuildInfo_GuDeputy] DEFAULT ((0)),
[GuName] [varchar](33) NOT NULL CONSTRAINT [DF_GuildInfo_GuName] DEFAULT (''),
[GuNotice] [varchar](401) NOT NULL CONSTRAINT [DF_GuildInfo_GuNotice] DEFAULT (''),
[GuRank] [int] NOT NULL CONSTRAINT [DF_GuildInfo_GuRank] DEFAULT ((0)),
[GuMoney] [money] NOT NULL CONSTRAINT [DF_GuildInfo_GuMoney] DEFAULT ((0)),
[GuIncomeMoney] [money] NOT NULL CONSTRAINT [DF_GuildInfo_GuIncomeMoney] DEFAULT ((0)),
[GuMarkVer] [int] NOT NULL CONSTRAINT [DF_GuildInfo_GuMarkVer] DEFAULT ((0)),
[GuExpire] [int] NOT NULL CONSTRAINT [DF_GuildInfo_GuExpire] DEFAULT ((0)),
[GuMakeTime] [datetime] NOT NULL CONSTRAINT [DF_GuildInfo_GuMakeTime] DEFAULT (getdate()),
[GuExpireTime] [datetime] NOT NULL CONSTRAINT [DF_GuildInfo_GuExpireTime] DEFAULT ('1970-02-01'),
[GuAllianceSec] [datetime] NOT NULL CONSTRAINT [DF_GuildInfo_GuAllianceSec] DEFAULT ('1970-02-01'),
[GuAllianceDis] [datetime] NOT NULL CONSTRAINT [DF_GuildInfo_GuAllianceDis] DEFAULT ('1970-02-01'),
[GuMarkImage] [image] NOT NULL CONSTRAINT [DF_GuildInfo_GuMarkImage] DEFAULT (''),
[GuStorage] [image] NOT NULL CONSTRAINT [DF_GuildInfo_GuStorage] DEFAULT (''),
[GuAuthorityTime] [datetime] NOT NULL,
[GuAllianceBattleLose] [varchar](100) NOT NULL,
[GuAllianceBattleDraw] [varchar](100) NOT NULL,
[GuAllianceBattleWin] [varchar](100) NOT NULL,
[GuBattleLastTime] [datetime] NOT NULL,
[GuBattleLose] [varchar](50) NOT NULL,
[GuBattleDraw] [varchar](50) NOT NULL,
[GuBattleWin] [varchar](50) NOT NULL,
CONSTRAINT [PK_GuildInfo] PRIMARY KEY CLUSTERED
(
[GuNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY],
CONSTRAINT [IX_GuildInfo_Name] UNIQUE NONCLUSTERED
(
[GuName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [SECONDARY]
GO
SET ANSI_PADDING OFF
--------------------------------------------
2. Second execute this script too. this is for viewGuildInfo
--------------------------------------------
USE [RanGame1]
GO
/****** Object: View [dbo].[viewGuildInfo] Script Date: 12/21/2011 18:11:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
-------------------------------------------------------------------------------
-- view_GuildInfo.sql
-------------------------------------------------------------------------------
ALTER VIEW [dbo].[viewGuildInfo]
AS
SELECT dbo.GuildInfo.GuNum, dbo.GuildInfo.ChaNum, dbo.GuildInfo.GuDeputy,
dbo.ChaInfo.ChaName, dbo.GuildInfo.GuName, dbo.GuildInfo.GuNotice,
dbo.GuildInfo.GuRank, dbo.GuildInfo.GuMoney, dbo.GuildInfo.GuIncomeMoney,
dbo.GuildInfo.GuMarkVer, dbo.GuildInfo.GuExpire, dbo.GuildInfo.GuMakeTime,
dbo.GuildInfo.GuExpireTime, dbo.GuildInfo.GuAllianceSec, dbo.GuildInfo.GuAllianceDis,
dbo.GuildInfo.GuAuthorityTime, dbo.GuildInfo.GuAllianceBattleLose, dbo.GuildInfo.GuAllianceBattleDraw,
dbo.GuildInfo.GuAllianceBattleWin, dbo.GuildInfo.GuBattleLastTime, dbo.GuildInfo.GuBattleLose,
dbo.GuildInfo.GuBattleDraw, dbo.GuildInfo.GuBattleWin
FROM dbo.GuildInfo INNER JOIN
dbo.ChaInfo ON dbo.GuildInfo.ChaNum = dbo.ChaInfo.ChaNum
-----------------------------------------------------------------
HOPE THIS WILL HELP YOU!