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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Errors installing Dnn 4.3-The stored procedure Errors installing Dnn 4.3-The stored procedure 'dbo.GetTabByName' doesn't exist.
Previous
 
Next
New Post
6/16/2006 4:26 AM
 
Hi.

I can't install Dnn 4.3.

When installing
.....
00:00:13.960 - Upgrading to Version: 4.0.7
00:00:13.970 - Upgrading to Version: 4.3.0
00:00:13.990 - Performing General Upgrades

I'v got error : The stored procedure 'dbo.GetTabByName' doesn't exist.

Exception Details: System.InvalidOperationException: The stored procedure 'dbo.GetTabByName' 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>")

My configuration :
- www server - win 2000, I' installing dnn in virtual directory (root web site is .net 1.1)
- sql server : sql 2005

And really there's no GetTabByName sp in database.

I've tried to install from 'install' and 'source' version, result is the same - error.
I've tried to create database with compability level  SQL 2000 and SQL 2005 - result is the same - error.


On my environment installation is 'unstable' - once I've manage to install everything but got some errors when trying to login.
Other time I've got other error when installing - The stored procedure dbo.GetModuleById or Definition doesn't exist.

please help.
Are you succesful instaling DNN 4.03 ?

Modelski.Tomasz@gmail.com
http://IT.tmod.pl
 
New Post
6/21/2006 12:02 AM
 

Try to install version 3x first then continue install with version 4x. I still have another error, you can see this to solve problem.

http://www.dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/107/threadid/46282/scope/posts/Default.aspx

 
New Post
6/21/2006 5:31 PM
 

I'm getting the exact same error.  I'm installing to a clean server (DotNetNuke not installed before).  Can't figure out why some stored procedures are there, but not others.

I'm using ASP.NET 2.0.

Also, Install PDF says to...

It can also be caused if you are attempting to carry out a fresh installation (new

Database) into a root folder where a previous installation of DotNetNuke existed. In this

scenario the dnn.config file is reporting that the Database Version and Assembly

Version are in sync, but this is not the case as we are using a new Database. To solve this

error, delete the dnn.config file from the /Install folder.

But the dnn.config file doesn't exist.

 
New Post
6/27/2006 4:47 PM
 

I have same problem but got it fixed.

Check MS SQL Server Collation, and Database collation make sure you are using Case Insensitive, otherwise you are screwed.

sample: SQL_Latin1_General_CP1_CI_AS

Also as defaul MS SQL 2005 format is using case sensative so some dataprovider code for DNN installation may not work.

I am changing those scripts now and hopefully I can sent to DNN and let them adjust their scripts.

 
New Post
7/6/2006 2:22 PM
 
How exactly do you do that ?
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Errors installing Dnn 4.3-The stored procedure Errors installing Dnn 4.3-The stored procedure 'dbo.GetTabByName' doesn't exist.


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