I have 5 country domains (mysite.es, mysite.fr, etc.) to deploy in the next week.   I've spent the better part of a day with nothing but failures on trying to clone the root portal out.   Updating the SQL script made a minor improvement; instead of the error message 'Error Creating Portal', now it's 'Error Configuring Portal.'

I'm really feeling the heat here, this was supposed to be the least complicated part of making the new site; DNN is built around the portal concept and it's pretty disheartening to find that even the most basic of portal exports (using the generic templates even) is not working.

Can someone please provide a step-by-step as to how to create a portal manually by editting the DB and cloning files into the portal sub-dir? Is this possible?  I've gone through my DB deleting the failed portal creation attempts and the overall scheme doesn't look that complex, is it necessary to use this stored procedure stuff to carry on?   

  

24 hours later and I'm still just getting "Error creating Portal".

Here's what my stored proceedure looks like now:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

 

ALTER PROCEDURE [dbo].[AddPortalInfo]

@PortalName nvarchar(128),

@Currency char(3),

@ExpiryDate datetime,

@HostFee money,

@HostSpace int,

@SiteLogHistory int,

@HomeDirectory varchar(100)

as

DECLARE @PortalID int

insert into Portals (

PortalName,

ExpiryDate,

UserRegistration,

BannerAdvertising,

Currency,

HostFee,

HostSpace,

Description,

KeyWords,

SiteLogHistory,

HomeDirectory

)

values (

@PortalName,

@ExpiryDate,

0,

0,

@Currency,

@HostFee,

@HostSpace,

@PortalName,

@PortalName,

@SiteLogHistory,

@HomeDirectory

)

SET @PortalID = SCOPE_IDENTITY()

IF @HomeDirectory = ''

BEGIN

UPDATE Portals SET HomeDirectory = 'Portals/' + convert(varchar(10), @PortalID) WHERE PortalID = @PortalID

END

SELECT @PortalID

I got the same error, even after totally deleting the SP and running the script again,

I am running 4.3.4 and I can't create any portals at all - nore parent or child.

/Vels