Hi there.

This is my first time using DotNetNuke and I've been battling with this install error for a while now. Everything is fine and the scripts seem to install and the procedures and tables appear in the database but then it fails and I get this error:

Installing Database - Version 05.00.00...FAILURE ERROR: See x:\xxxxxxxxx\Providers\DataProviders\SqlDataProvider\05.00.00.log for more information

But the 05.00.00.log just seem to be a bunch of procedures that run. I can't seem to find any info on this either as maybe it's an error with the new version?

Any help would be great!
 

Hi Jeff.

This is the last procedure in the file. That's what's confusing though. The error doesn't point you to an error log as such. Just this file.

IF EXISTS (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}vw_SearchItems]') and OBJECTPROPERTY(id, N'IsView') = 1)
    DROP VIEW {databaseOwner}[{objectQualifier}vw_SearchItems]
GO

CREATE VIEW {databaseOwner}[{objectQualifier}vw_SearchItems]
AS
    SELECT    
        si.SearchItemID,
        m.PortalID,
        tm.TabID,
        m.ModuleID,
        m.ModuleTitle AS Title,
        si.Description,
        si.Author,
        si.PubDate,
        si.SearchKey,
        si.Guid,
        si.HitCount,
        si.ImageFileId,
        u.DisplayName AS AuthorName
    FROM  {databaseOwner}{objectQualifier}SearchItem AS si
        LEFT OUTER JOIN {databaseOwner}{objectQualifier}Users AS u ON si.Author = u.UserID
        INNER JOIN {databaseOwner}{objectQualifier}Modules AS m ON si.ModuleId = m.ModuleID
        INNER JOIN {databaseOwner}{objectQualifier}TabModules AS tm ON m.ModuleID = tm.ModuleID
GO

The only thing other thing I can think of that is causing it is that I am using sql server 2000.

Yes. Silly error on my part. I was looking in the 05.00.00.SqlDataProvider file which is why it didn't make much sense. That said, the 05.00.00.log file does not exist in the specified location.

I've tried an install again giving full access permissions to the database user as database owner with the same result. The same error message.