Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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/23/2010 12:39 PM
 
Frozen DNN


Joined: 3/30/2007
Posts: 515
As you know, if you look above, I was having this problem too but I was using a module that was incompatible with DNN 5.5 (URL Master). Bruce, the maker of URL Master, upgraded his module to make it compatible with DNN 5.5. I installed it on my website and everything just works fine now. So please check with your module developers whether their modules are compatible with DNN 5.5. Based on my experience, one incompatible module can affect other modules. I hope this helps.
 
New Post
8/23/2010 1:08 PM
 
Skip Floyd


Joined: 5/14/2003
Posts: 21
Just Updated from 5.4.2 because of Events module issues in 5.4.2. The upgrade ran without errors and all seamed well until I tried to install the 5.03 Events Module. I received this Error Start Sql execution: 03.02.00.SqlDataProvider file SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsMasterAssignedModules ( @ModuleID int ) AS Select a.ModuleID as ModuleID, 0 as PortalID, a.MasterID, a.SubEventID as SubEventID, b.ModuleTitle as SubEventTitle from dbo.EventsMaster a join dbo.Modules b on a.SubEventID = b.ModuleID WHERE a.ModuleID = @ModuleID Group BY b.ModuleTitle, a.MasterID, a.ModuleID, a.SubEventID Order By b.ModuleTitle System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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.ModuleControls d on b.ModuleDefID = d.ModuleDefID left join dbo.TabModules t on a.ModuleID = t.ModuleID left join dbo.Tabs c on t.TabID = c.TabID where d.ControlSrc = 'DesktopModules/Events/Events.ascx' 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 System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsMasterGet ( @ModuleID int, @SubEventID int ) AS Select @ModuleID as ModuleID, b.PortalID, 0 as MasterID, a.ModuleID as SubEventID, a.ModuleTitle as SubEventTitle from dbo.Modules a left join dbo.TabModules t on a.ModuleID = t.ModuleID left join dbo.Tabs b on t.TabID = b.TabID where a.ModuleID = @SubEventID Group BY a.ModuleTitle, b.PortalID, a.ModuleID Order By a.ModuleTitle System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ModuleTitle'. Invalid column name 'ModuleTitle'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsMasterSave ( @MasterID int, @ModuleID int, @SubEventID int ) AS IF @MasterID = 0 OR @MasterID IS NULL INSERT dbo.EventsMaster ( ModuleID, SubEventID ) VALUES ( @ModuleID, @SubEventID ) ELSE UPDATE dbo.EventsMaster SET ModuleID = @ModuleID, SubEventID = @SubEventID WHERE MasterID = @MasterID Select a.MasterID, a.ModuleID, b.ModuleTitle, a.SubEventID from dbo.EventsMaster a left join dbo.Modules b on a.SubEventID = b.ModuleID WHERE a.MasterID = @@Identity Group BY a.MasterID, a.ModuleID, b.ModuleTitle, a.SubEventID System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ModuleTitle'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.EventsAVCalendarList ( @PortalID int ) AS SELECT ModuleID, Version + ' - ' + ModuleTitle as VersionTitle FROM dbo.Modules M left join dbo.ModuleDefinitions b on M.ModuleDefID = b.ModuleDefID left join dbo.DesktopModules c on b.DesktopModuleID = c.DesktopModuleID WHERE c.ModuleName = 'Calendar' AND PortalID = @PortalID
 
New Post
8/23/2010 2:57 PM
 
Robert Buzek


Joined: 4/15/2007
Posts: 14
I had the same issue with events after upgrading to 5.5, so I reinstalled the events module under extensions and that seemed to have fixed that issue.
 
New Post
8/23/2010 3:10 PM
 
William Severance


www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
Further analysis of the issue when I had more time today showed that while there is a definite issue with failure of the Html module to upgrade properly and to throw Modules.ModuleTitle column errors, the issue is limited to the My Work function of the Html module. I have logged that issue (versioning/packaging problem) to Gemini.

So, we still have the Modules.ModuleTitle column error which several posters in this thread have confirmed is happening on adding ANY module to the page following the upgrade to 05.05.00.

I'll keep looking into it. One poster indicated that it might be related to a need to upgrade URL Master after upgrading to DNN 05.05.00. Are any of the others experiencing this issue also using URL Master?
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 3:13 PM
 
William Severance


www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
Skip,

That is a known issue with the Events module. Please see this blog post about the need to upgrade Events to the latest version:

http://www.dotnetnuke.com/Community/B...
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
 
 Page 6 of 9
Previous123...567...9Next 
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