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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...stored procedure dbo.CanDeleteSkin cannot be found DNN 4.4.1 new installstored procedure dbo.CanDeleteSkin cannot be found DNN 4.4.1 new install
Previous
 
Next
New Post
2/7/2007 2:22 AM
 
ErikVB wrote
 psdie wrote

Further to my notes about "04.04.01.SqlDataProvider" not running, causing "CanDeleteSkin" SP error:  the Skins page works perfectly after manually running "04.04.01.SqlDataProvider" against the DB. Note you have to search and replace {databaseOwner} and {objectQualifier} in the script for actual values.

Seems like a straight forward {objectQualifier} bug for the DNN core team.

 

 

That seems contradicting. If replacing {objectQualifier} with actual value causes the script to run ok on your db, then clearly it is not an issue of {objectQualifier}.

If "objectQualifier" is non-blank in "web.config" then some of the upgrade SQL scripts appear to fail/not be run (can check this by looking to see if "CanDeleteSkin" was created in DB). If objectQualifier is blank, the upgrade SQL scripts seem to run fine.

 


 

leupold wrote
as far as I see, the objectqualifier is in place at this part of the script, please check the associated .log file for issues during upgrade and post any error listed, so we can check it.

Please accept, that this is a volunteer project and everyplace where people work, ther might occur issues (this might even happen to you).

I didn't have logs enabled, unfortunately (I believe they are disabled until enabling under "Site Settings", or am I looking in the wrong place: Portals/_default/Logs ?) You should be able to easily reproduce by installing a fresh 4.4.1 installation and changing "web.config" so that "DotNetNuke > SqlDataProvider > objectQualifier" is non-blank.

I appreciate that DNN is a volunteer project and my strongest thanks goes to everyone involved for their efforts. It's just been particularly frustrating with the 4.4.1 release, because we've hit 2 major installation issues (missing DLLs from bin, objectQualifier bug described here) which seem to indicate lack of basic testing.

 

 
New Post
2/7/2007 3:24 AM
 

psdie,

Sebastian is not talking about the site log....

During installation, every sql script will generate a log file, which is normally empty (nothing to report), but will contain the errors encountered during installation if any occured. If any error occurs this will be reported in the browser as well, including a full path to the logfile where the error was entered.

You can find all sql log files in this folder: /Providers/DataProviders/SqlDataProvider/. The log file for dnn 4.4.1 would be named 04.04.01.log


Erik van Ballegoij, Former DNN Corp. Employee and DNN Expert

DNN Blog | Twitter: @erikvb | LinkedIn: Erik van Ballegoij on LinkedIn

 
New Post
2/22/2007 12:21 PM
 
ErikVB wrote

You can find all sql log files in this folder: /Providers/DataProviders/SqlDataProvider/. The log file for dnn 4.4.1 would be named 04.04.01.log

That provides a clue - this log file is missing, suggesting a logic flaw is causing the script not to be run, rather than the script is failing. The only log files I see in the above folder for a freshly installed/run 4.4.1 installation are: "DotNetNuke.Data.log", "DotNetNuke.Schema.log", "DotNetNuke.SetUp.log", all of which are empty.

An important update, BTW:  I installed a fresh 4.4.1 installation with no "objectQualifier" specified in web.config and got exactly the same problem:  the "04.04.01.SqlDataProvider" script isn't running, so "DeleteSkin" SP doesn't get created (can fix fully by running script manually).

From accounts here, I'm not the only one experiencing this problem. For reference though, I'm running IIS on Win2K, SQL Server Express 2005 on a named instance (as is the default), using the following connection string format:

    <add name="SiteSqlServer" connectionString="Server=MYMACHINE\SQLEXPRESS;Database=MYDBNAME;uid=BLAH;pwd=BLAH;" providerName="System.Data.SqlClient" />

Note that I'm seeing exactly the same problem installing on our remote host, who run Win 2003 with SQL Server 2005 (full). Other "web.config" changes, in case relevant:  debug enabled, FCKeditor installed.

Here's a copy of the installation notes displayed during the installation (note that the 4.4.1 SQL script isn't listed):

Installation Status Report

00:00:00.330 - Installing Version: 4.4.1
00:00:00.330 - Installing Script: DotNetNuke.SetUp.SqlDataProvider Success
00:00:00.761 - Installing Script: DotNetNuke.Schema.SqlDataProvider Success
00:00:12.447 - Installing Script: DotNetNuke.Data.SqlDataProvider Success
00:00:17.654 - Installing MemberRole Provider:
00:00:17.754 -   Installing Script: InstallCommon.sql
00:00:20.738 -   Installing Script: InstallMembership.sql
00:00:23.973 -   Installing Script: InstallProfile.sql
00:00:24.454 -   Installing Script: InstallRoles.sql
00:00:26.006 - Performing General Upgrades
00:00:26.697 - Loading Host Settings:
00:00:26.897 - Configuring SuperUser:
00:00:27.949 - Installing Modules:
00:00:27.989 -   Installing Module File Documents_03.01.06_Install:  Success
00:00:31.103 -   Installing Module File FAQs_03.01.00_Install:  Success
00:00:33.857 -   Installing Module File HTML_03.03.00_Install:  Success
00:00:36.000 -   Installing Module File Links_03.03.00_Install:  Success
00:00:37.782 -   Installing Module File NewsFeeds_03.01.01_Install:  Success
00:00:38.543 -   Installing Module File Survey_04.00.20_Install:  Success
00:00:46.064 - Executing Additional Scripts:
00:00:46.074 -   Creating Portal: Haybridge School CMS Demo
00:01:05.030 -   Successfully Installed Portal 0:
00:01:05.030 - Installing Optional Resources:

I hope this helps to identify the problem. Let me know if need further information.

BJ

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...stored procedure dbo.CanDeleteSkin cannot be found DNN 4.4.1 new installstored procedure dbo.CanDeleteSkin cannot be found DNN 4.4.1 new install


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