Upgrading from 1.9.6.1 to 2

Welcome Guest! To enable all features please Login or Register.

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

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

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
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?

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

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.

Project Twitter Updates

Tweets by YAFNET

Important Information:

About Us

Project Twitter Updates

Useful Links

Our Contacts