BWG
  •  BWG
  • 99.4% (Exalted)
  • YAF Lover Topic Starter
2013-11-26T22:04:16Z
Hi,

I'm having problems trying to upgrade on my Win 2003 dev server from 1.6.6.1 to 2. When running the install the following error message is returned:



ERROR:
There is already an object named 'yaf_drop_defaultconstraint_oncolumn' in the database.

STATEMENT:
CREATE PROCEDURE [dbo].[yaf_drop_defaultconstraint_oncolumn](@tablename varchar(255), @columnname varchar(255)) as
BEGIN
DECLARE @DefName sysname

SELECT
@DefName = o1.name
FROM
sys.objects o1
INNER JOIN sys.columns c ON
o1.object_id = c.default_object_id
INNER JOIN sys.objects o2 ON
c.object_id = o2.object_id
WHERE
o2.name = @tablename AND
c.name = @columnname

IF @DefName IS NOT NULL
EXECUTE ('ALTER TABLE ' + @tablename + ' DROP CONSTRAINT [' + @DefName + ']')
END


Not had any problems with previous updates.

Any ideas?

BWG
Sponsor
BWG
  •  BWG
  • 99.4% (Exalted)
  • YAF Lover Topic Starter
2013-11-28T15:13:51Z
I've still not been able to upgrade from 1.9.6.1 on my dev box. When running SQL profiler the upgrade script stops here:

if exists (select top 1 1 from [dbo].[yaf_Message] where UserDisplayName IS NULL)
exec('[dbo].[yaf_forum_initdisplayname]')


I've taken a look at the database and there isn't a sproc called yaf_forum_initdisplayname.

Any idea what's going on?
BWG
  •  BWG
  • 99.4% (Exalted)
  • YAF Lover Topic Starter
2013-12-03T23:10:54Z
Still having the same problem when using SQL2005. However, if I backup the database from SQL2005, restore to SQL2008, and then run the install scripts the upgrade from 1.9.6.1 to 2 completes successfully.

Are there any known problems with upgrading on SQL2005?

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved