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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackCannot install on DNN 5.5.1Cannot install on DNN 5.5.1
Previous
 
Next
New Post
11/24/2010 4:08 AM
 
Hello,
I tried to install the feedback module on a DNN 5.5.2 host, and got this error:

System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'.

Is there a fix available, or a workaround?

Here's the complete log:

Install Package:: DotNetNuke.Modules.Feedback
Info:: Inizio installazione
Info:: Inizio installazione - DNN_Feedback
Info:: Inizio installazione - Script
Info:: Inizio esecuzione SQL
Info:: Cartella creata
Info:: Creato
Info:: Esecuzione 03.02.01.SqlDataProvider
Info:: Inizio esecuzione SQL: 03.02.01.SqlDataProvider file
Info:: Fine esecuzione SQL: 03.02.01.SqlDataProvider file
Info:: Creato
Info:: Esecuzione 04.04.01.SqlDataProvider
Info:: Inizio esecuzione SQL: 04.04.01.SqlDataProvider file
Info:: Fine esecuzione SQL: 04.04.01.SqlDataProvider file
Info:: Creato
Info:: Esecuzione 04.04.02.SqlDataProvider
Info:: Inizio esecuzione SQL: 04.04.02.SqlDataProvider file
Info:: Fine esecuzione SQL: 04.04.02.SqlDataProvider file
Info:: Creato
Info:: Esecuzione 04.04.03.SqlDataProvider
Info:: Inizio esecuzione SQL: 04.04.03.SqlDataProvider file
Info:: Fine esecuzione SQL: 04.04.03.SqlDataProvider file
Info:: Creato
Info:: Esecuzione 05.00.00.SqlDataProvider
Info:: Inizio esecuzione SQL: 05.00.00.SqlDataProvider file
Info:: Fine esecuzione SQL: 05.00.00.SqlDataProvider file
Info:: Creato
Info:: Esecuzione 05.00.01.SqlDataProvider
Info:: Inizio esecuzione SQL: 05.00.01.SqlDataProvider file
Info:: Fine esecuzione SQL: 05.00.01.SqlDataProvider file
Info:: Creato
Info:: Esecuzione 05.00.02.SqlDataProvider
Info:: Inizio esecuzione SQL: 05.00.02.SqlDataProvider file
Info:: Fine esecuzione SQL: 05.00.02.SqlDataProvider file
Info:: Creato
Info:: Esecuzione SQL terminata
Info:: Componente installato con successo - Script
Info:: Inizio installazione - Module
Info:: EccezioneSystem.Data.SqlClient.SqlException: 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(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleDefinition(Int32 DesktopModuleId, String FriendlyName, Int32 DefaultCacheTime, Int32 createdByUserID) at DotNetNuke.Entities.Modules.Definitions.ModuleDefinitionController.SaveModuleDefinition(ModuleDefinitionInfo moduleDefinition, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Entities.Modules.DesktopModuleController.SaveDesktopModule(DesktopModuleInfo desktopModule, Boolean saveChildren, Boolean clearCache) at DotNetNuke.Services.Installer.Installers.ModuleInstaller.Install()
Info:: Installazione Fallita - Module
Info:: Sto riportando il componente allo stato precedente - Script
Info:: Componente riportato allo stato precedente - Script
Info:: Installazione Fallita - DNN_Feedback
Info:: Cartella temporanea di installazione eliminata
Info:: Installazione Fallita


Thank you,
al.
 
New Post
11/24/2010 8:25 AM
 
This is not an error caused by the Feedback module but rather by having an older version of iFinity URL Master either currently installed or installed at one time then deleted. As a test, please try installing a different module. I suspect that you will receive the same error. If you are currently using URL Master you will need to upgrade to their latest version which is compatible with the removal of the ModuleTitle column from the Modules table which occurred in DotNetNuke version 5.05.00. If you had previously installed URL Master but later un-installed it, the un-install did not properly remove or disable a trigger on inserts to the Modules table. It is the SQL statements run in response to that trigger which are causing the problem now.

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
11/26/2010 6:37 AM
 
William,
thanks for your reply. In my case I don't have URL Master, but the free Friendly URL provider (also from iFinity), but believe the problem is the same.
Unfortunately, I don't see any update for this provider - I'm asking at iFinity forums.
Thanks again,
al.

 
New Post
11/28/2010 5:39 PM
 
William is correct in his diagnosis.

If you are on DotNetNuke 5.5 or later, you will need at least one of these versions:
- Url Master 1.16
- Url Master 2.1 (latest version recommended)

It is also correct that earlier versions of the module had a bug in the uninstall code.  So if the module has been removed, you'll need to manually remove the trigger from the Modules table.

You can download the latest versions from this page : Url Master Downloads

The Friendly Url Provider is NOT affected by this problem as it doesn't use any module specific database code.

 
New Post
11/29/2010 7:14 AM
 
Bruce,
thank you for clarifying the situation about FriendlyURL.
So the problem is with the feedback module and DNN 5.5.x... am I the only one getting this error?
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackCannot install on DNN 5.5.1Cannot install on DNN 5.5.1


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