cached error

[McAfee]

06/28/2011 14:02:22.361, Error sql: SELECT npc_class_id, death_time FROM NpcDeath (0)

06/28/2011 14:02:22.361, Error 42S02:[Microsoft][ODBC SQL Server Driver]

Invalid object name 'NpcDeath'.

06/28/2011 14:03:49.487, Error sql: select [augmentation], [mana_left], [life_time] from [user_item] where [item_id] = 1 (0)

06/28/2011 14:03:49.487, Error 42S22:[Microsoft][ODBC SQL Server Driver][sql Server]Invalid column name 'life_time'.

 

hi I have these errors on cached but it doesnt effect to game I mean I dont see any proplem in game

how can I fix? thx

[McAfee]

no any ideas?

[mcbigmac]

You seriously cannot think of anything to check based on what the errors TELL you, to your face?

 

 

Might also help to tell what your using to see if it's general newb error.

[Sighed]

You seriously cannot think of anything to check based on what the errors TELL you, to your face?

 

 

Might also help to tell what your using to see if it's general newb error.

Kation files. NpcDeath is just a missing sql.

USE [lin2world]
GO

/****** Object:  Table [dbo].[NpcDeath]    Script Date: 06/15/2011 07:45:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[NpcDeath](
[npc_class_id] [int] NOT NULL,
[death_time] [int] NOT NULL,
CONSTRAINT [PK_NpcDeath] PRIMARY KEY CLUSTERED 
(
[npc_class_id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

 

And the other one is another missing SQL.

 

use lin2world
go

ALTER TABLE dbo.user_item ADD
mana_left int NOT NULL DEFAULT 0
GO

use lin2world
go

ALTER  TABLE user_data add 
effective_mana0 int NOT NULL DEFAULT 0,
effective_mana1 int NOT NULL DEFAULT 0,
effective_mana2 int NOT NULL DEFAULT 0,
effective_mana3 int NOT NULL DEFAULT 0
go

ALTER TABLE user_item
ADD life_time int NOT NULL DEFAULT 0
go

 

They are inside the .rar with other sql files, which basically means, McAfee basically don't know how to correctly install a SQL DataBase.