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 ForumsForm and ListForm and ListUDT Version Upgrade Error on DNN V 4.03.04 & Downgrade ConcernsUDT Version Upgrade Error on DNN V 4.03.04 & Downgrade Concerns
Previous
 
Next
New Post
3/5/2008 3:40 PM
 

DNN SYSTEM: 
DNN Version 4.03.04

PLATFORM: 
Shared Hosting on GoDaddy (SIDE NOTE: Biggest Mistake Ever Made - Stay Away from DNN Shared Hosting with GoDaddy.  If anyone knows how to move a DNN installation off their system I am willing to pay for the assistance.  They do not allow you access to the webconfig file which causes a number of issues.  I fear it may have been the cuase of this issue.)

ISSUE ABSTRACT: 
Problems with UDT v3.04 upgrade, can not return back to UDT v3.03

DESCRIPTION:
I attempted to install UDT Version 3.04 on a DNN Version 4.03.04 .  I already had some UDT forms created using Version 3.03.  The steps I followed included:

1) Log in as Host

2) Select Module Definitions

3) Select Upload New Module

4) Pointed to UDT Version 3.04 Install zip file.

I navigated to the page that was created using UDT Version 3.03 and discovered the following Error where the module used to be displayed:

Unhandled error loading module.
DotNetNuke.Services.Exceptions.ModuleLoadException: Unhandled Error Adding Module to LeftPane ---> System.MissingMethodException: Method not found: 'System.Data.DataSet DotNetNuke.Common.Globals.BuildCrossTabDataSet(System.String, System.Data.IDataReader, System.String, System.String, System.String, System.String, System.String, System.String, System.String, System.Globalization.CultureInfo)'. at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.GetDataSet(Int32 ModuleId, Int32 tabId, UserInfo userInfo, Boolean WithPreRenderedValues) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.GetDataSet(Int32 ModuleId, PortalModuleBase ParentModule, Boolean WithPreRenderedValues) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTable.get_DataSet() at DotNetNuke.Modules.UserDefinedTable.UserDefinedTable.SearchManager.LoadColumns() at DotNetNuke.Modules.UserDefinedTable.UserDefinedTable.SearchManager.SearchControl(SearchControlTypes ControlType) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTable.SearchManager.LoadControls() at DotNetNuke.Modules.UserDefinedTable.UserDefinedTable.Page_Init(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.UserControl.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at System.Web.UI.ControlCollection.Add(Control child) at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings) --- End of inner exception stack trace ---

Fearing the module was not compatible with the DNN version I have I decided to return back to UDT Version 3.03.  Followed the same steps as above to reinstall UDT V3.03.  The process report is listed below:

StartJob Starting Installation
StartJob Reading files
Info Loading 03.01.00.SqlDataProvider
Info File 03.01.00.SqlDataProvider read successfully
Info Loading 03.02.00.SqlDataProvider
Info File 03.02.00.SqlDataProvider read successfully
Info Loading 03.03.00.SqlDataProvider
Info File 03.03.00.SqlDataProvider read successfully
Info Loading DNN_UserDefinedTable.dnn
Info File DNN_UserDefinedTable.dnn read successfully
Info Loading DotNetNuke.Modules.UserDefinedTable.dll
Info File DotNetNuke.Modules.UserDefinedTable.dll read successfully
Info Loading DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.dll
Info File DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.dll read successfully
Info Loading Resources.zip
Info File Resources.zip read successfully
Info Loading Uninstall.SqlDataProvider
Info File Uninstall.SqlDataProvider read successfully
EndJob Reading files done.
 
StartJob Reading DNN file
Info DNN file is in valid 3.0 format.
Info xml loaded.
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'User Defined Table' module
EndJob Dnn load finished successfully
 
Warning Install aborted - New Version older than Installed Version
EndJob Installation successful.

As you can see, a warning that the install was aborted becuase a new version was on the sytem. 

My questions?

Is there anyway I can install module UDT v3.04 on the DNN version 4.03.04? 
How do you uninstall a module? 
If you uninstall a module upgrade and return to the previous module version are your DB Tables preserved?
Is there a resource on DNN website that lists an easy to read and understand grid of what module is compatable with what version of DNN?

Please Help, Please. 

Also, anyone willing to assist me from moving off of GoDaddy (DNN, Files, DB, etc...) to a more quality hoster please e-mail me at ThereIs1robert(at symbol)yahoo.com. 

Thank you for your consideration.

 
New Post
3/6/2008 3:04 AM
 

Rob Won wrote

My questions?

Is there anyway I can install module UDT v3.04 on the DNN version 4.03.04? 

No

Rob Won wrote

How do you uninstall a module? 
If you uninstall a module upgrade and return to the previous module version are your DB Tables preserved?

If you uninstall a module, the data tables will also be removed

Rob Won wrote

Is there a resource on DNN website that lists an easy to read and understand grid of what module is compatable with what version of DNN?

Sure, the main download page: http://www.dotnetnuke.com/tabid/125/default.aspx (and also the project download pages). Where did you download from?

Sorry Rob, only chance now, even if hosted on GoDaddy, is to upgrade your DNN installation.

 

 
New Post
3/11/2008 4:25 PM
 

Thank you for the answers Stefan,

Since GoDaddy is so restrictive when it comes to modifying the webconfig file and crippling being able to add most all DNN modules I took your advice Stefan and moved (transfered, migrated, whatever the exact term is) to PowerDNN.  I backed up the SQL Server DB from GoDaddy which created a .BAK file and was forced to FTP to the hosting site and download all the web files.  Once downloaded I zipped up the web files and FTP'ed both the web files in a zip and SQL .BAK file to powerDNN for them to install on their servers.  ( I share this for other users who may experience a similar struggle as myself).

Once on the new servers I connected to my SQL Server using SQL Server Express 2005 Management Studio (Download for free from here) hoping to export my userdefined table data and at least rescue the information that was entered by portal users.  Looking through the data tables I discovered I did not see any dbo.userdefinedtables or anything similar.  I did some research on the forum and in a post it was said that the userdefined tables would be in sequence as dbo.userdefine.  Since, I do not see any tables that leave to concluse two things; 1) they are gone.  2) I am mistaken to belive that the tables for the UDT are dbo.userdefine.... 

QUESTION 1:  Does installing UDT v3.04 overwrite the tables created in V3.03?

QUESTION 2:  For confirmation sake what are the dbo tables the UDT module creates.  If the other thread is accurate please post that thread. 

Even with the upgrade to DNN 4.8 the UDT control is still producing errors.  It was suggested to me by PowerDNN to manually uninstall UDT V3.03 and manually install version v3.04. 

QUESTION 3:  How does one manually uninstall UDT v3.03 and manually install UDT v3.04? 

Thank you in advance. 

 

 
New Post
3/11/2008 4:33 PM
 

Q1: When you install UDT 3.4.0, any previously existing (not deleted) version of the module will be upgraded in place. any data will be preserved and migrated to the new structure

Q2: UDT creates (assuming you did not specify an objectQualifier in the SQL dataprovider section of your web.config file) the following tables:

  • dbo.UserDefinedFields
  • dbo.UserDefinedRows
  • dbo.UserDefinedData

Q3: if you delete the module in Host :: module definitions menu item, all created table will be deleted and data be lost.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
3/12/2008 10:15 AM
 

Thank you Mr. Leupold, It is an honor to have you answer my question. 

As a summary, I mistakenly installed UDT V. 3.04 on DNN 4.03.  The install showed errors (Module version incompatable with DNN Version).  I panicked and then reinstalled UDT v3.03 back on the host.  I attempted to insert a module and errors appeared in the module without any module settings menu allowing me to delete them.  Frustrated, I upgraded to a new hosting provider so I could upgrade DNN, thinking that would cure the problem. 

Still did not work and further investigation revealed the tables were all gone.  Perhaps when I stupidly removed UDT V3.04 and reinstalled V3.03. 

Accepting the fact that I lost all the data and the data tables I set to rebuild the form. 

Since, I was on DNN 4.81 now, the [HOST > Module Definition > Module Setting] allows you to uninstall and check the delete the files box.   I selected that option and uninstalled the module.  Below is the error that appeared.    

 
A critical error has occurred.
Multiple controls with the same ID 'ScriptManager' were found. FindControl requires that controls have unique IDs.

I have no idea what this means and the UDT module no longer is displayed in the Module Definition window leading me to believe it was deleted. 

I then re-installed the UDT V 3.04 by adding back this module individually as a new module. 

The installation produced no errors and when I inserted the module the interface displayed and everything seemed to work fine.  I am currently now in the process of rebuilding the form and should any issues arise I will repost the information, in case it sheds some clues to others with their issues. 

A special thanks to Stephan and Sebastian for taking the time to help a stranger.  God bless you both. 

I hope the detail descriptions of what occurred prove to be helpful to others.

Trebor
 
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListUDT Version Upgrade Error on DNN V 4.03.04 & Downgrade ConcernsUDT Version Upgrade Error on DNN V 4.03.04 & Downgrade Concerns


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