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
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsRepositoryRepositoryInstall ErrorInstall Error
Previous
 
Next
New Post
6/13/2006 5:22 PM
 
bshalton

Joined: 9/6/2004
Posts: 33

I get the following error in the upload listing when installing to a dnn 3.0.13 site:

StartJob Begin Sql execution
Info Executing 03.00.00.SqlDataProvider
StartJob Start Sql execution: 03.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'FolderName'. Invalid column name 'DefaultCacheTime'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE dbo.grmRepositoryObjects SET CategoryId = (SELECT Cast(ItemID as varchar(2)) + ';' from dbo.grmRepositoryCategories WHERE dbo.grmRepositoryObjects.ModuleId=dbo.grmRepositoryCategories.ModuleID) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.RepositoryObjects') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN Declare @OldModuleID int Declare @NewModuleID int INSERT INTO dbo.DesktopModules (FriendlyName, Description, Version, isPremium, IsAdmin,BusinessControllerClass,FolderName,ModuleName,SupportedFeatures) VALUES ('Gooddogs Repository', 'This module is a download/resource module', '',0,0,'Gooddogs.Repository.RepositoryController, Gooddogs.Repository','Repository', 'Gooddogs Repository', 3) DECLARE myCursor CURSOR FOR SELECT DISTINCT DesktopModuleID from dbo.DesktopModules WHERE FriendlyName='Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @OldModuleID CLOSE myCursor DEALLOCATE myCursor DECLARE myCursor CURSOR FOR SELECT DISTINCT DesktopModuleID from dbo.DesktopModules WHERE FriendlyName='Gooddogs Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @NewModuleID CLOSE myCursor DEALLOCATE myCursor INSERT INTO dbo.ModuleDefinitions (FriendlyName, DesktopModuleID,DefaultCacheTime) VALUES ('Gooddogs Repository', @NewModuleID,0) DECLARE myCursor CURSOR FOR SELECT DISTINCT ModuleDefID from dbo.ModuleDefinitions WHERE FriendlyName='Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @OldModuleID CLOSE myCursor DEALLOCATE myCursor DECLARE myCursor CURSOR FOR SELECT DISTINCT ModuleDefID from dbo.ModuleDefinitions WHERE FriendlyName='Gooddogs Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @NewModuleID CLOSE myCursor DEALLOCATE myCursor UPDATE dbo.Modules SET ModuleDefID = @NewModuleID WHERE ModuleDefID = @OldModuleID DELETE FROM dbo.ModuleDefinitions WHERE FriendlyName = 'Repository' DELETE FROM dbo.ModuleControls WHERE ModuleDefID = @OldModuleID DELETE FROM dbo.DesktopModules WHERE FriendlyName = 'Repository' END
EndJob

End Sql execution: 03.00.00.SqlDataProvider file

 

 

Any Ideas?

Brian
 
New Post
6/14/2006 11:34 PM
 
Mike Horton


Joined: 7/16/2003
Posts: 4865
Yup. It's because there was a change in DNN between 3.0.X and 3.1 and the .dnn format was changed. I'll post instructions on how to fix it tomorrow after I get to work and dig out a module made for a prior to 3.1 version. However, just to be warned, I'm not sure if you won't have other problems.
 
New Post
6/15/2006 2:54 PM
 
bshalton

Joined: 9/6/2004
Posts: 33

Thanks Mike!

I should probably go ahead and upgrade. I just hate to do it when everything on the site is running so well.

Brian
 
New Post
6/15/2006 3:59 PM
 
Mike Horton


Joined: 7/16/2003
Posts: 4865

Brian,

Here's what you'll need to do to get it installed I think.

1.) Extract the .zip file into its own folder and then open up the .dnn file in whatever text editor you want to.
2.) Remove any lines that have the following tags at the beginning: <foldername>,<modulename>, and <cachetime> and then save the .dnn file
3.) Test the new .dnn file. You can test the .dnn file by browsing to it at the bottom of the Host->Module Definitions page.
4.) If all is good then repack the files into a .zip file and install the new .zip.

Personally I'd upgrade to at least 3.2 if you could. It's got a ton of bug fixes and you won't run into this problem again. I know 3.3 has been released but I won't be putting that on any production sites for a couple of weeks at least. By then any glaring problems should be noted and developers should have any required module updates completed by then.
 
 Page 1 of 1
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsRepositoryRepositoryInstall ErrorInstall Error


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