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 ListCompatibility of UDT 3.4.0Compatibility of UDT 3.4.0
Previous
 
Next
New Post
9/9/2007 7:23 PM
 

Many thanks for your responses.

The problem I'm getting when I'm adding the module (UDT 3.4.0) is associated with the security. This is because

when I am trying to refresh or perform any other actions I get a server prompt calling me to enter my username and password.

When I click on cancel, then I get an 'unauthorized error'.

The version that was previously installed is 3.3.6.

The upgrade was in two steps, first to 3.3.7 and then to 4.5.5

Other issues with modules...the only thing I can see is the Users Online module. Even if there are more than 1 visitors

the module shows only 1.

 

Here is the site log's errors:

ModuleId: 1021
ModuleDefId: 105
FriendlyName: User Defined Table
ModuleControlSource: DesktopModules/UserDefinedTable/UserDefinedTable.ascx
AssemblyVersion: 04.05.05
PortalID: 6
PortalName: ***.com
UserID: 86
UserName: nectarios
ActiveTabID: 333
ActiveTabName: test
RawURL: /tabid/333/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.***.com/tabid/333/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 02000dc9-d64f-45ac-83d2-6b4b69679f14
InnerException: The stored procedure 'dbo.UserDefinedTable_GetFields' doesn't exist.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlCommand.DeriveParameters
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.UserDefinedTable_GetFields' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.UserDefinedTable_GetFields' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.UserDefinedTable.SqlDataProvider.GetFields(Int32 ModuleId) at DotNetNuke.Modules.UserDefinedTable.UserDefinedTableController.GetFieldsTable(Int32 ModuleId, Boolean AddNewColumn, Boolean AddTrackColumns) 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.BindData() at DotNetNuke.Modules.UserDefinedTable.UserDefinedTable.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: ***

 
New Post
9/10/2007 5:14 AM
 

it looks like there was an error during upgrade and the upgrade script did not run. Please run manually  file
   /desktopModules/UserDefinedTable/Providers/dataProviders/SQLDataprovider/03.04.00.SqlDataProvider
from inside Host :: SQL menu item as script, this shall fix your issue.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
9/10/2007 7:29 AM
 

Hello,

I have run the script as script under the SQL but I got half page of errors.

So, I uninstalled UDT and manually deleted all the stored procedures from the database. Then, I reinstalled

and it worked.

Thanks for your help.

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListCompatibility of UDT 3.4.0Compatibility of UDT 3.4.0


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