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 ForumsBlogBlogModule Options error after upgrading to 3.5.1Module Options error after upgrading to 3.5.1
Previous
 
Next
New Post
1/14/2009 11:07 AM
 

I've been using older versions of the blog module. I just upgraded a site to 4.9.1 using the upgrade package. After the upgrade, I upgraded some of the modules, including the blog module, which I upgraded to 3.5.0, using the version that shipped with 4.9.1. The blog works fine except for 'Module Options' which results in a ModuleLoadException, and the resulting error showing 'invalid column name' errors. I then upgraded to 3.5.1 and am getting the same error. Has anyone else had this problem? Any thoughts?

[some items removed]
FriendlyName: Blog Module Options
ModuleControlSource: DesktopModules/Blog/ModuleOptions.ascx
AssemblyVersion: 04.09.01
RawURL: /Home/tabid/35/ctl/Module_Options/mid/824/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 (.NET CLR 3.5.30729)
InnerException: Invalid column name 'GroupType'. Invalid column name 'Server'. Invalid column name 'Port'. Invalid column name 'LogonRequired'. Invalid column name 'UserName'. Invalid column name 'Password'.

Thanks in advance...


Rich Campbell
Engage : Your ideas, Our know-how
DNN Experts
St. Louis, MO
314.966.4000
 
New Post
1/14/2009 12:11 PM
 

Hi Rich,

this sounds quite strange. This issue may arise when installing or upgrading, when stored procedures are written in the database. If I uderstand well, this happens whenever you load Module Options.  Could you please execute this SQL script to check if something is wringly set in the blog's options:

SELECT *
FROM {databaseOwner}{objectQualifier}Blog_Settings
WHERE PortalID='xxx' AND TabID='yyy'

update the PortalID and TabID fields accordingly to your install. If you don't want to share private data on this forum, please feel free to send it to dario.rossa [at] dotnetnuke-italia.it.

Best regards,
Dario Rossa

 
New Post
1/14/2009 12:15 PM
 

Dario-

Thanks for the reply. Here are the results:

PortalID Key Value TabID
0 DataVersion 03.05.00 35
0 EnableDNNSearch True 35
0 EnableUploadOption True 35
0 EntryDescriptionRequired False 35
0 ForumBlogInstalled NotInstalled 35
0 MaxImageWidth 400 35
0 PageBlogs 1 35
0 RecentEntriesMax 7 35
0 RecentRssEntriesMax 20 35
0 SearchSummaryMaxLength 255 35
0 ShowSummary False 35
0 ShowUniqueTitle True 35
0 SummaryMaxLength 640 35

Rich Campbell
Engage : Your ideas, Our know-how
DNN Experts
St. Louis, MO
314.966.4000
 
New Post
1/14/2009 2:54 PM
 

Here's the whole stack trace. I'm looking at the source package now....

Error: Blog Module Options is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'GroupType'. Invalid column name 'Server'. Invalid column name 'Port'. Invalid column name 'LogonRequired'. Invalid column name 'UserName'. Invalid column name 'Password'. ---> System.Data.SqlClient.SqlException: Invalid column name 'GroupType'. Invalid column name 'Server'. Invalid column name 'Port'. Invalid column name 'LogonRequired'. Invalid column name 'UserName'. Invalid column name 'Password'. 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.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Blog.Data.SqlDataProvider.Upgrade_ListForum_Groups(Int32 portalID) at DotNetNuke.Modules.Blog.Business.Forum_GroupsController.List(Int32 PortalId) at DotNetNuke.Modules.Blog.ForumBlog.Utils.isForumBlogInstalled(Int32 PortalID, Int32 TabID, Boolean checkNew) at DotNetNuke.Modules.Blog.ModuleOptions.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---


Rich Campbell
Engage : Your ideas, Our know-how
DNN Experts
St. Louis, MO
314.966.4000
 
New Post
1/15/2009 2:32 AM
 

Hi Rich,

the above issue arises because the Blog module tries to upgrade your entries from the old ForumBlog module. Maybe it was there some time ago, and you may not even have it anymore.

Best regards,
Dario Rossa

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogModule Options error after upgrading to 3.5.1Module Options error after upgrading to 3.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