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
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...GetPropertyDefinitionsByPortal errorGetPropertyDefinitionsByPortal error
Previous
 
Next
New Post
7/24/2006 7:12 PM
 
Victor Velepucha

Joined: 6/1/2006
Posts: 1
I friends, i download the final DotNetNuke(DNN) version (3.3.3) and I try install it, but I have some problems: (I not have any older version)
I have Windows XP Pro SP2 and Microsoft SQL Server  2000 - 8.00.2039 (SP4), Framework v1.1.4322 and v2.0.50727.

I follow these steps:
1.- I create a Login user called userdb and I assign "System Administrators" server role
2.- I create the database named DotNetNuke, with the following collection: SQL_Latin1_General_CP850_BIN
3.- I create a user called userdb in DotNetNuke database and asign it dbo owner.
4.- I create a folder C:\CDotNetNuke and unzip DotNetNuke_3.3.3_Install.zip at this root directory
5.- I modify web.config at appSettings->SiteSqlServer and change to: <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=userdn;pwd=userdn;" />

6.- I create a web site called DotNetNuke in Internet Information Service Console
6.1.- I do right click at DotNetNuke virtual directory and select Properties
6.1.1.- At Tab "Virtual Directory" I changed in "Excecute permissions" to Scripts and Executables.
6.2.- At Tab "Documents" I add Default.aspx page

7.- And I lunch the application from: http://localhost/DotNetNuke/
    And the website redirect to: http://localhost/DotNetNuke/Install/Install.aspx?mode=Install

And install but I get this error:
The stored procedure 'dbo.GetTabByName' doesn't exist.

At the forum http://dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/107/threadid/13584/scope/posts/Default.aspx
say:
* Drop the existing database
* Recreate your database and select SQL_Latin1_General_CP1_CI_AS as your Collation Name (General tab)
* Apply logins according to DNN Install instructions
* Open your local site in a browser (your upgrade should complete successfully)

I follow this steps but I get this new error:
The stored procedure 'dbo.GetPropertyDefinitionsByPortal' doesn't exist

Some idea??
--------------------------------------------------------------

Installing DotNetNuke

Version: 03.03.03


Installation Status Report

00:00:00.078 - Installing Version: 3.1.0
00:00:00.093 - Installing Script: DotNetNuke.SetUp.SqlDataProvider
00:00:00.156 - Installing Script: DotNetNuke.Schema.SqlDataProvider
00:00:02.271 - Installing Script: DotNetNuke.Data.SqlDataProvider
00:00:05.811 - Installing MemberRole Provider:
00:00:05.811 - Executing InstallCommon.sql
00:00:06.406 - Executing InstallMembership.sql
00:00:06.782 - Executing InstallProfile.sql
00:00:06.907 - Executing InstallRoles.sql
00:00:07.221 - Upgrading to Version: 3.1.1
00:00:08.505 - Upgrading to Version: 3.2.0
00:00:08.568 - Upgrading to Version: 3.2.1
00:00:08.615 - Upgrading to Version: 3.2.2
00:00:08.646 - Upgrading to Version: 3.2.3
00:00:09.711 - Upgrading to Version: 3.2.4
00:00:09.758 - Upgrading to Version: 3.2.5
00:00:09.790 - Upgrading to Version: 3.2.6
00:00:09.821 - Upgrading to Version: 3.2.7
00:00:09.836 - Upgrading to Version: 3.3.0
00:00:09.868 - Upgrading to Version: 3.3.1
00:00:09.899 - Upgrading to Version: 3.3.2
00:00:10.087 - Upgrading to Version: 3.3.3
00:00:10.197 - Performing General Upgrades
00:00:10.996 - Loading Host Settings:
00:00:11.074 - Configuring SuperUser:

 

Server Error in '/DotNetNuke' Application.

The stored procedure 'dbo.GetPropertyDefinitionsByPortal' doesn't exist.


 
New Post
9/12/2006 3:22 PM
 
Ken Grimmett

Joined: 4/2/2004
Posts: 1

I'm having the exact same issue but the install is from within VS 2005 using the Starter Kit MSI.

Help
 
New Post
9/25/2006 9:38 AM
 
Heida_Rodelshut

Joined: 8/14/2006
Posts: 8
I have the same problem installing the latest DNN4. I also changed the collation and got exactly the same error. Hopefully someone hears our cry.

Greetings.
Heida
 
New Post
10/8/2006 2:05 PM
 
Darwin

Joined: 9/27/2006
Posts: 1

I have the same problem.

Installing DotNetNuke

Version: 04.03.05


 

Installation Status Report

00:00:01.343 - Installing Version: 3.1.0
00:00:01.625 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:02.109 - Installing Script: DotNetNuke.Schema.SqlDataProvider Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\DotNetNuke.Schema.log for more information)
00:00:09.468 - Installing Script: DotNetNuke.Data.SqlDataProvider Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\DotNetNuke.Data.log for more information)
00:00:18.453 - Installing MemberRole Provider:
00:00:18.453 - Executing InstallCommon.sql
00:00:20.390 - Executing InstallMembership.sql
00:00:21.234 - Executing InstallProfile.sql
00:00:21.453 - Executing InstallRoles.sql
 Error!
00:00:22.359 - Upgrading to Version: 3.1.1 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\03.01.01.log for more information)
00:00:24.390 - Upgrading to Version: 3.2.0 Success
00:00:24.515 - Upgrading to Version: 3.2.1 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\03.02.01.log for more information)
00:00:24.562 - Upgrading to Version: 3.2.2 Success
00:00:24.593 - Upgrading to Version: 3.2.3 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\03.02.03.log for more information)
00:00:26.265 - Upgrading to Version: 3.2.4 Success
00:00:26.343 - Upgrading to Version: 3.2.5 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\03.02.05.log for more information)
00:00:26.578 - Upgrading to Version: 3.2.6 Success
00:00:26.718 - Upgrading to Version: 3.2.7 Success
00:00:26.734 - Upgrading to Version: 3.3.0 Success
00:00:26.812 - Upgrading to Version: 3.3.1 Success
00:00:26.859 - Upgrading to Version: 3.3.2 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\03.03.02.log for more information)
00:00:27.078 - Upgrading to Version: 3.3.3 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\03.03.03.log for more information)
00:00:27.265 - Upgrading to Version: 4.0.0 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\04.00.00.log for more information)
00:00:28.046 - Upgrading to Version: 4.0.1 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\04.00.01.log for more information)
00:00:28.125 - Upgrading to Version: 4.0.2 Success
00:00:28.171 - Upgrading to Version: 4.0.3 Success
00:00:28.218 - Upgrading to Version: 4.0.4 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\04.00.04.log for more information)
00:00:29.671 - Upgrading to Version: 4.0.5 Success
00:00:29.687 - Upgrading to Version: 4.0.6 Success
00:00:29.718 - Upgrading to Version: 4.0.7 Success
00:00:29.750 - Upgrading to Version: 4.3.0 Success
00:00:29.796 - Upgrading to Version: 4.3.1 Success
00:00:29.828 - Upgrading to Version: 4.3.2 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\04.03.02.log for more information)
00:00:29.906 - Upgrading to Version: 4.3.3 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\04.03.03.log for more information)
00:00:30.250 - Upgrading to Version: 4.3.4 Success
00:00:30.281 - Upgrading to Version: 4.3.5 Error! (seeC:\Dotnetnuke_2\Website\Providers\DataProviders\SqlDataProvider\04.03.05.log for more information)
00:00:30.546 - Performing General Upgrades
00:00:33.906 - Loading Host Settings:
00:00:34.140 - Configuring SuperUser:



 







Server Error in '/dotnetnukelocal' Application. 





The stored procedure 'dbo.GetPropertyDefinitionsByPortal' doesn't exist. 


Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: The stored procedure 'dbo.GetPropertyDefinitionsByPortal' doesn't exist.

Source Error: 








Line 132:                    Response.Write("<h2>Installation Status Report</h2>")
Line 133:                    Response.Flush()
Line 134:                    Services.Upgrade.Upgrade.InstallDNN(strProviderPath)
Line 135:
Line 136:                    Response.Write("<h2>Installation Complete</h2>")

Source File: C:\Dotnetnuke_2\Website\Install\Install.aspx.vb    Line: 134 

Stack Trace: 








[InvalidOperationException: The stored procedure 'dbo.GetPropertyDefinitionsByPortal' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters() +878792
   System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
   DotNetNuke.Data.SqlDataProvider.GetPropertyDefinitionsByPortal(Int32 portalId) +113
   DotNetNuke.Entities.Profile.ProfileController.GetPropertyDefinitionsByPortal(Int32 portalId) +15
   DotNetNuke.Security.Profile.DNNProfileProvider.GetProfileProperties(Int32 portalId, IDataReader dr, UserProfile objProfile) +29
   DotNetNuke.Security.Profile.DNNProfileProvider.GetUserProfile(UserInfo& user) +86
   DotNetNuke.Entities.Users.UserInfo.get_Profile() +49
   DotNetNuke.Services.Upgrade.Upgrade.ParseSuperUser(XmlNode node) +456
   DotNetNuke.Services.Upgrade.Upgrade.InstallDNN(String strProviderPath) +1400
   DotNetNuke.Framework.Install.InstallApplication() in C:\Dotnetnuke_2\Website\Install\Install.aspx.vb:134
   DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) in C:\Dotnetnuke_2\Website\Install\Install.aspx.vb:382
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061







Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 

										

									
										 
									
								
							
						
					
						
					
						

							

								

									

										New Post

											12/11/2006 2:08 AM
										
 
									

								

							

						

					
						

							

								

									

										Tyler Holmes
									

								

							

								
Joined: 5/26/2006

									Posts: 1
								

							

						

							

								

									

										
									

										

											

												

													

														
													

												

											

										

									

								

							

								

									

										

											I have a work around for this error.

I was also getting the same error.

Running (trying to install) DNN 4.3.7 on a Win XP SP2 machine running SQL Server 2005 (no service pack) with a database with collation of SQL_Latin1_General_CP1_CI_AS. It should be of note that the DEFAULT collation for sql server is SQL_Latin1_General_CP1_CS_AS (case sensitive) but this database instance is SQL_Latin1_General_CP1_CI_AS.

If I run the starter kit install with SQL_Latin1_General_CP1_CS_AS i get a "The stored procedure 'dbo.GetTabByName' doesn't exist."

If I change the collation to SQL_Latin1_General_CP1_CI_AS I get The stored procedure 'dbo.GetPropertyDefinitionsByPortal' doesn't exist.

It seems with either collation on that database i was screwed. (I believe SQL_Latin1_General_CP1_CI_AS is the default for SQL Server).

The collation was the only thing I changed during the SqlServer 2005 install. Anyways I instead installed to default install of SqlExpress that came with VS 2005. It seems that having an install of non SQL_Latin1_General_CP1_CI_AS can cause this error.

Cheers,
Tyler
										

									

										 
									

								

							

						

					
				
			
				

					

						

							

								

									 Page 1 of 2
								

									12Next 
								

							

						

					

				

			
				
			
				

					

						

							

								

									

										Previous
									

								
 

									

										Next
									

								

							

						

					

						
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...GetPropertyDefinitionsByPortal errorGetPropertyDefinitionsByPortal 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. 
    
  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. 
    
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
    4. 
    
  4. No Flaming or Trolling. 
    5. 
    
  5. 
    No Profanity, Racism, or Prejudice. 
    6. 
    
  6. 
    Site Moderators have the final word on approving / removing a thread or post or comment.
    7. 
    
  7. 
    English language posting only, please.
    8. 












  

    

    

    

    

    

    

    

  

  

  

    

      

    

    
  

  

  

  	

		
	

	
What is Liquid Content?

  	Find Out
  

  

  	

		
	

	
What is Liquid Content?

  	Find Out
  

  

  	

		
	

	
What is Liquid Content?

  	Find Out