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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Database Publishing Wizard Error - Invalid column name Database Publishing Wizard Error - Invalid column name 'ModuleTitle'
Previous
 
Next
New Post
4/9/2012 11:36 PM
 

I am trying to move a DotNetNuke site to a new host.  The site was version 4.7.0.  Performed all incremental updates through 6.1.4 so that the current site has the same version of the destination on the new host.  Using the Database Publishing Wizard, I get the following error.  I am not sure what this means though or how to resolve.  I am relatively new to DNN and any help would be greatly appreciated. Thanks.

TITLE: SqlPubWiz
------------------------------

An error occured while trying to publish the following script:
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[EventsMasterAvailableModules]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[EventsMasterAvailableModules]
(
 @PortalID int,
 @ModuleID int
)
AS
Select @ModuleID as ModuleID, c.PortalID, 0 as MasterID, a.ModuleID as SubEventID, a.ModuleTitle as SubEventTitle
from dbo.Modules a
  left join dbo.ModuleDefinitions b on a.ModuleDefID = b.ModuleDefID
  left join dbo.DesktopModules d on b.DesktopModuleID = d.DesktopModuleID
  left join dbo.TabModules t on a.ModuleID = t.ModuleID
  left join dbo.Tabs c on t.TabID = c.TabID
  where
     d.BusinessControllerClass = ''DotNetNuke.Modules.Events.EventController, DotNetNuke.Modules.Events'' AND
     c.PortalID = @PortalID and
     a.ModuleID Not In  (select SubEventID from dbo.EventsMaster where ModuleID = @ModuleID) AND
     a.ModuleID Not In (select ModuleID from dbo.EventsMaster where SubEventID = @ModuleID) AND
     a.ModuleID != @ModuleID
Group BY a.ModuleTitle, c.PortalID, a.ModuleID
Order By a.ModuleTitle
'
END

------------------------------
ADDITIONAL INFORMATION:

Invalid column name 'ModuleTitle'.
Invalid column name 'ModuleTitle'.
Invalid column name 'ModuleTitle'. (System.Web.Services) 

 
New Post
4/10/2012 2:33 AM
 
you need to upgrade Events module (and maybe other modules as well) to latest version.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
4/10/2012 9:06 PM
 
Thank you Sebastian. This is probably a dumb question but how do I identify what modules are installed?
 
New Post
4/10/2012 10:31 PM
 
    Login in as host account (super user), then click "Host - Extensions" , you will find all installed modules(skins) under "Installed extensions" section.

    By the way, your sql error is mainly because the ModuleTitle field has been removed in new dnn versions.

Over 20 + professional dnn modules for News Article, Store, Video Gallery, Photo Gallery, Ultra Flash Player,YouTube Video, Image Slide show, Skin Chameleon and much more from DnnModule.com
 
New Post
4/11/2012 8:18 PM
 
Thanks!! The information is much appreciated.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Database Publishing Wizard Error - Invalid column name Database Publishing Wizard Error - 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