McAfee Posted July 18, 2011 Share Posted July 18, 2011 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 Quote Link to comment Share on other sites More sharing options...
0 McAfee Posted July 19, 2011 Author Share Posted July 19, 2011 no any ideas? Quote Link to comment Share on other sites More sharing options...
0 mcbigmac Posted July 19, 2011 Share Posted July 19, 2011 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. Quote Link to comment Share on other sites More sharing options...
0 Sighed Posted July 19, 2011 Share Posted July 19, 2011 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. Quote Link to comment Share on other sites More sharing options...
Question
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]
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
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.