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...Upgrading DNN P...Upgrading DNN P...When trying to add module --> Invalid column name When trying to add module --> Invalid column name 'ModuleTitle'.
Previous
 
Next
New Post
8/22/2010 1:44 AM
 
That procedure that I have at the moment in the base of portal that shows the error:

USE [xxx]

GO

/****** Object: StoredProcedure [dbo].[AddModule] Script Date: 08/22/2010 09:43:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[AddModule]

@ContentItemID int,

@PortalID int,

@ModuleDefId int,

@AllTabs bit,

@StartDate datetime,

@EndDate datetime,

@InheritViewPermissions bit,

@IsDeleted bit,

@CreatedByUserID int

 

AS

INSERT INTO Modules (

ContentItemID,

PortalId,

ModuleDefId,

AllTabs,

StartDate,

EndDate,

InheritViewPermissions,

IsDeleted,

CreatedByUserID,

CreatedOnDate,

LastModifiedByUserID,

LastModifiedOnDate

)

VALUES (

@ContentItemID,

@PortalID,

@ModuleDefId,

@AllTabs,

@StartDate,

@EndDate,

@InheritViewPermissions,

@IsDeleted,

@CreatedByUserID,

getdate(),

@CreatedByUserID,

getdate()

)

SELECT SCOPE_IDENTITY()

 
New Post
8/22/2010 1:50 AM
 
I have checked the clean installation of 5.5 and it seems the procudures are the same. However I have problem at that portal and do not have with clean installation and some of other upgrades
 
New Post
8/22/2010 2:48 PM
 
Yael - That is the correct version of the AddModule stored procedure for DNN 5.5.0. It does not reference the Modules.ModuleTitle, Header, or Footer columns as did the most recent previous version of that same stored procedure which did. That is consistent with no errors being logged during the 5.05.00.SqlDataProvider script's execution. It also appears from the stack trace that was posted earlier, the parameters passed to the ModuleControlle.AddModule also appear to be correct for v 5.5.0. But . . . something is very strange here and seems to be happening to several other users.

Can anyone having the ModuleTitle issue happen when adding a module to the page and who has NOT added the ModuleTitle colum back into the Modules table perform a restart of the SQL Server then see if the issue reoccurs when adding a module after the SQL Server has been restarted?


Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
8/23/2010 1:48 AM
 
I have not added the module title column and just tried to restart MS SQL server. After that I have tried to add HTML module to absolutely new and empty page and got the same error.
 
New Post
8/23/2010 1:51 AM
 
I want to add that I am very interested in a fix of that issue since I can not run localization due to this error since the page and module population for sublanguages does not work due to this issue and I need it badly. So I can provide you any access to the site incl. remote desktop access to th server.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...When trying to add module --> Invalid column name When trying to add module --> Invalid column name 'ModuleTitle'.


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