Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Cannot Create Portal on a 4.3.3 or 4.3.4 Upgrade HELP!Cannot Create Portal on a 4.3.3 or 4.3.4 Upgrade HELP!
Previous
 
Next
New Post
8/14/2006 11:05 PM
 

Okay I have to rescind my last statement...see this thread:

http://dotnetnuke.com/tabid/795/forumid/108/threadid/62223/scope/posts/Default.aspx



Shane Miller
Call Centers 24x7
 
New Post
8/15/2006 12:33 AM
 

The post by laurencepostgate on this thread has some great substance to assist with troubleshooting this:

http://dotnetnuke.com/tabid/795/forumid/107/threadid/45127/threadpage/1/scope/posts/Default.aspx

He / she wrote:

 I can confirm that I had this error when upgrading from 4.0.3 to 4.3.3.
The cause in my case was as people mentioned in this thread the SQL in the provider file "03.02.06.SqlDataProvider" was correct but didn't seem to have been applied to the database.

Basically the original version of the following Stored Proc was still in the database:
"AddPortalInfo" - this original version still has EXTRA variables passed in to it namely:

@FirstName          nvarchar(100),
@LastName           nvarchar(100),
@Username           nvarchar(100),
@Password           nvarchar(50),
@Email              nvarchar(100),

These need to be removed from the stored procedure - it then works fine

It is worth noting that in the Code Behind (Source Code) there is the following comment which explains that this is a quite recent ammendment:

[cnurse]    05/10/2006  Removed unneccessary use of Administrator properties.

I have the advantage of being able to manage my database directly so I could just edit the Stored Proc. If you rely on the DNN interface I would suggest running just the Create Procedure part of the code (Remembering that the top part i.e. the DROP part of the SQL is important):

Remember to change the {databaseOwner} to the owner (if logged in as host you may be able to remove it. Also you can probably remove {objectQualifier} so the statement might look like: "if exists (select * from dbo.sysobjects where id = object_id(N'dbo.[AddPortalInfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)").


Relevant Code From "03.02.06.SqlDataProvider"

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}AddPortalInfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
    DROP PROCEDURE {databaseOwner}[{objectQualifier}AddPortalInfo]
GO

CREATE PROCEDURE {databaseOwner}[{objectQualifier}AddPortalInfo]
    @PortalName         nvarchar(128),
    @Currency           char(3),
    @ExpiryDate         datetime,
    @HostFee            money,
    @HostSpace          int,
    @SiteLogHistory     int,
    @HomeDirectory        varchar(100)

as
DECLARE @PortalID int

insert into {objectQualifier}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 {objectQualifier}Portals SET HomeDirectory = 'Portals/' + convert(varchar(10), @PortalID) WHERE PortalID = @PortalID
END

SELECT @PortalID
GO



Shane Miller
Call Centers 24x7
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Cannot Create Portal on a 4.3.3 or 4.3.4 Upgrade HELP!Cannot Create Portal on a 4.3.3 or 4.3.4 Upgrade HELP!


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out