module 05.00.00 install failed if DB contains any table with column name DateAdded. error is "Subquery returned more than 1 value" in following query

SELECT name

FROM dbo.sysobjects

WHERE parent_obj = OBJECT_ID(N'{databaseOwner}{objectQualifier}Forum_EmailQueue_TaskEmails')

AND type = 'D'

AND id = ( SELECT cdefault

FROM syscolumns

WHERE name = N'DateAdded'

)

I've confirmed that this is a bug and was able to get Forum_05.00.00_Install.zip to install by unzipping it, updating "04.05.00.SqlDataProvider" and rezipping.

Sebastian's query will fix the issue with the 'DateAdded' field (needs a space inserted in 'top1') but I used:

SELECT cdefault FROM syscolumns WHERE name = N'DateAdded' AND cdefault <> 0

because the existing 3 instances of 'DateAdded' fields in my database, one of which was from the commonly used XMod module, all had a cdefault value of 0.  The 'DateAdded' field used in the forum table had a different value set which may be expected elsewhere.  The file needs to be updated in 2 places.

Hope this helps someone.

Dave