After more and more digging I found the problem.
I Did to installs with copies of the same database. The first is SQL2005 and that went OK.
The second, my production machine is a SQL2000 and that is creating the trouble.
I extracted the file 05.01.00.SqlDataProvider from HTML_Community_05.01.02_Install.zip
and I executed this file in queryanayser. This is what I get:
(2295 row(s) affected)
(2295 row(s) affected)
Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'DesktopHtml'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'CreatedByUser'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'CreatedDate'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'CreatedByUser'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'CreatedDate'.
(1 row(s) affected)
(1 row(s) affected)
(2295 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
I restored everthing and executed the script step by step to find the problem. But going step by step no errors!
Then I executed bigger parts of the script and Yes the errors came back. This is the part:
IF NOT EXISTS (select * from dbo.sysobjects where id = object_id(N'dbo.HtmlTextLog') and OBJECTPROPERTY(id, N'IsTable') = 1)
BEGIN
update dbo.HtmlText
set Content = DesktopHtml,
Version = 1,
IsPublished = 1,
CreatedByUserID = CreatedByUser,
CreatedOnDate = CreatedDate,
LastModifiedByUserID = CreatedByUser,
LastModifiedOnDate = CreatedDate
ALTER TABLE dbo.HtmlText
DROP COLUMN DesktopHtml, DesktopSummary, CreatedByUser, CreatedDate
CREATE TABLE dbo.HtmlTextLog
(
HtmlTextLogID int NOT NULL IDENTITY (1, 1),
ItemID int NOT NULL,
StateID int NOT NULL,
Comment nvarchar(4000),
Approved bit NOT NULL,
CreatedByUserID int NOT NULL,
CreatedOnDate datetime NOT NULL
) ON [PRIMARY]
ALTER TABLE dbo.HtmlTextLog ADD CONSTRAINT
PK_HtmlTextLog PRIMARY KEY CLUSTERED
(
HtmlTextLogID
) ON [PRIMARY]
CREATE TABLE dbo.HtmlTextUsers
(
HtmlTextUserID int NOT NULL IDENTITY (1, 1),
ItemID int NOT NULL,
StateID int NOT NULL,
ModuleID int NOT NULL,
TabID int NOT NULL,
UserID int NOT NULL,
CreatedOnDate datetime NOT NULL
) ON [PRIMARY]
ALTER TABLE dbo.HtmlTextUsers ADD CONSTRAINT
PK_HtmlTextUsers PRIMARY KEY CLUSTERED
(
HtmlTextUserID
) ON [PRIMARY]
ALTER TABLE dbo.HtmlText WITH NOCHECK ADD CONSTRAINT
FK_HtmlText_WorkflowStates FOREIGN KEY
(
StateID
) REFERENCES dbo.WorkflowStates
(
StateID
) ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT FOR REPLICATION
ALTER TABLE dbo.HtmlTextLog WITH NOCHECK ADD CONSTRAINT
FK_HtmlTextLog_HtmlText FOREIGN KEY
(
ItemID
) REFERENCES dbo.HtmlText
(
ItemID
) ON UPDATE NO ACTION
ON DELETE CASCADE
NOT FOR REPLICATION
ALTER TABLE dbo.HtmlTextLog WITH NOCHECK ADD CONSTRAINT
FK_HtmlTextLog_WorkflowStates FOREIGN KEY
(
StateID
) REFERENCES dbo.WorkflowStates
(
StateID
) ON UPDATE NO ACTION
ON DELETE NO ACTION
NOT FOR REPLICATION
ALTER TABLE dbo.HtmlTextUsers WITH NOCHECK ADD CONSTRAINT
FK_HtmlTextUsers_HtmlText FOREIGN KEY
(
ItemID
) REFERENCES dbo.HtmlText
(
ItemID
) ON UPDATE NO ACTION
ON DELETE CASCADE
NOT FOR REPLICATION
END
GO
Especially this part is producing the errors
set Content = DesktopHtml,
Version = 1,
IsPublished = 1,
CreatedByUserID = CreatedByUser,
CreatedOnDate = CreatedDate,
LastModifiedByUserID = CreatedByUser,
LastModifiedOnDate = CreatedDate
After these errors the rest of this block is not executed and you end up with no HTML text in your portals and a lot of errors.
Because the step by step methode worked I decided to cut this block in to after:
ALTER TABLE dbo.HtmlText
DROP COLUMN DesktopHtml, DesktopSummary, CreatedByUser, CreatedDate
I inserted:
END
GO
IF NOT EXISTS (select * from dbo.sysobjects where id = object_id(N'dbo.HtmlTextLog') and OBJECTPROPERTY(id, N'IsTable') = 1)
BEGIN
And Yes! it executed with no errors. I am not a SQL guru, mayby there is one who can explain! Again it is a SQL2000 machine. My SQL2005 machine did'n experience this problem.
so far so good, but not so good ! packing if back in the zipfile etc. Rolling back and installing :-) again an error in teh same module. This one I could not figure out.
But rolling back, removing the HTML_Community_05.01.02_Install.zip from the package and installing again, went OK, and the succes came with installing the faulty module via Host --> module definitions etc.
I hope you get some inspiration from this!
p.s where can I find the install log from the modules??