Invalid object name 'sys.views'. · YAF.NET Support Forum

ablakov1
54.2% (Neutral)
YAF Forumling Topic Starter

13 years ago

Hello
When i try to upgrade to 1.9.4 beta 2 i get the following message in installation page:

FILE:
mssql/views.sql

ERROR:
Invalid object name 'sys.views'.

STATEMENT:
/*
** Views
*/

/****** Object:  View [dbo].[yaf_vaccess]    Script Date: 09/28/2009 22:26:00 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[yaf_vaccess]'))
DROP VIEW [dbo].[yaf_vaccess]

I am using windows 2003 SP2 and SQL2000 SP4.

Thanks

Sponsor

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Jaben
100% (Exalted)
YAF Developer

13 years ago

It's this bug:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126523

Not totally sure about SQL Server 2k support going forward. Does anyone want to be a SQL Server 2k fixer for the project going forward?

Edited by user 13 years ago | Reason: Not specified

herman_herman
100% (Exalted)
YAF MVP

13 years ago

Jaben wrote:
It's this bug:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126523

Not totally sure about SQL Server 2k support going forward. Does anyone want to be a SQL Server 2k fixer for the project going forward?

Jaben,
I think I have found a workaround for this but can't contact you via PM.Your Inbox is full.

Jaben
100% (Exalted)
YAF Developer

13 years ago

herman_herman wrote:

Jaben wrote:
It's this bug:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126523

Not totally sure about SQL Server 2k support going forward. Does anyone want to be a SQL Server 2k fixer for the project going forward?

Jaben,
I think I have found a workaround for this but can't contact you via PM.Your Inbox is full.

Hmm... try now.

thebeloved
56% (Neutral)
YAF Forumling

13 years ago

ablakov1 wrote:
Hello
When i try to upgrade to 1.9.4 beta 2 i get the following message in installation page:

[code]FILE:
mssql/views.sql

ERROR:
Invalid object name 'sys.views'.

...

Thanks

I confirm that i have found similar error messages also in "constraint.sql", related to creation of primary index keys.

My hosting company also relies the db on SQLServer2000

Edited by user 13 years ago | Reason: Not specified

Gianni Mantellini
Napulevola Vice-CEO
http://www.napulevola.it/

herman_herman
100% (Exalted)
YAF MVP

13 years ago

For now you can try this patch.please report back if there is any problem.

Important Information:

The YAF.NET Support Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close