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

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?

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?