| Posted by: BWG - Tuesday, 26 November 2013 23:04:16 |
|---|
| 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: [i] 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 [/i] Not had any problems with previous updates. Any ideas? BWG |
| Posted by: BWG - Thursday, 28 November 2013 16:13:51 |
|---|
| 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: [i]if exists (select top 1 1 from [dbo].[yaf_Message] where UserDisplayName IS NULL) exec('[dbo].[yaf_forum_initdisplayname]')[/i] I've taken a look at the database and there isn't a sproc called yaf_forum_initdisplayname. Any idea what's going on? |
| Posted by: BWG - Wednesday, 4 December 2013 00:10:54 |
|---|
| 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? |