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

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Register-Link not working after UpgradeRegister-Link not working after Upgrade
Previous
 
Next
New Post
5/3/2011 5:12 PM
 
Hi there.

After upgrading to 5.6.2 i have one problem with my site. Everything is working pretty well but Register as a new user.

During the upgrade i had no errors, as usual in the past.

When a new potential user clicks REGISTER you will see:
A critical error has occurred.
The stored procedure 'dbo.GetFolderPermissionsByFolderPath' doesn't exist.

Well, after checking the DB i must say, this is true but as mentioned above, i had no errors, so why wasn't this procedure not created and how can i solve it?

I tried to do again the upgrade (copying the files from the package into the directory where the installation is and restarting the website) but this does just nothing. Only a white screen in the browser.

Thanks a lot in advance

Kai
 
New Post
5/3/2011 7:44 PM
 
At this point it will most likely be necessary to roll back to the prior version from the backups of the file system and the database which you hopefully created before the upgrade. It is generally not possible to re-reun an upgrade. Attempts to do so will often result in the white screen you are seeing.

Before doing so, please check for non-empty  xx.xx.xx.log.resources files located in the site's \Providers\DataProviders\SqlDataProvider folder for each version xx.xx.xx between the version from which you upgraded and 05.06.02. You'll likely find a related SQL error. It's odd, however, that you did not see any SQL errors during the upgrade.

From which version did you upgrade?

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
5/4/2011 2:50 AM
 
Thanks for the quick reply.

Of course do i have a backup. This is a question of experience.
And i was afraid that the only solution would be a rollback, as i added some content after upgrading.....

The last errors i found  were (shortened a little....)
    Upgrade from 5.6.0 to 5.6.1
        There is already an object named 'UpdateTabModuleVersionByModule' in the database.

    Upgrade from 5.6.1 to 5.6.2
        

The operation failed because an index or statistics with name 'IX_Messaging_Messages_ToUserID_Status_SkipPortal' already exists on table 'Messaging_Messages'.

The operation failed because an index or statistics with name 'IX_Messaging_Messages_FromUserID_Status' already exists on table 'Messaging_Messages'.

System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_EventLogTypes'. Cannot insert duplicate key in object 'dbo.EventLogTypes'.

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[AddFolder]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.AddFolder
There is already an object named 'AddFolder' in the database.

There is already an object named 'UpdateFolder' in the database.

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[GetFolderPermissionsByFolderPath]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.GetFolderPermissionsByFolderPath
There is already an object named 'GetFolderPermissionsByFolderPath' in the database.

There is already an object named 'GetUserCountByPortal' in the database.

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[GetEventLog]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.GetEventLog
There is already an object named 'GetEventLog' in the database.

There is already an object named 'DeleteEventLog' in the database.

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[DeleteFile]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.DeleteFile
There is already an object named 'DeleteFile' in the database.

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[DeleteFiles]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.DeleteFiles
There is already an object named 'DeletePortalLanguages' in the database.

There is already an object named 'AddSkin' in the database.

There is already an object named 'GetSchedule' in the database.

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'dbo.[GetBanner]') AND OBJECTPROPERTY(id, N'IsPROCEDURE') = 1)
    DROP PROCEDURE dbo.GetBanner
There is already an object named 'GetBanner' in the database.

There is already an object named 'GetUsersByProfileProperty' in the database.



As you can see, it seems that the DROP-Call failes very often as after that the next error says that there is allready an object with that name.
Funny enough, regarding the function i'm "missing", it is NOT there.

However, i'm just restoring my old installtion, will restart the webserver at all (to close all handles for sure) and will try an upgrade again. Then we will see.

Kai
 
New Post
5/4/2011 5:17 AM
 
Update: Success.

Here is what i did:
- Rollback to last "good known" Backup (in my case: 5.6.1 files and db)
- Stopping WWW and DB Service
- Restarting WWW and DB Service
- Called my Page once
- Performing Upgrade (no errors)
- checking Log-Files: empty (HURRA!!!)
- Testing REGISTER.... : Yeah, working.

I think there were some file locks or db-locks preventing to make an errorfree upgrade in the past. But why the hack showed me the website during the upgrade no error? There will always be some last mystics .....

So, here the advice:
Before doing an upgrade and if anyhow possible, do the following:
- backup files and db
- stop www and db service on your host
- restart them
- call your portal once (to get the app-pool up and running)
- do the upgrade

Thanks anyway

Kai
 
New Post
5/4/2011 8:02 AM
 
Kai,

Congratulations on a successfull update! I hate to suggest rolling back but sometime's its the best/only way to go.

I've seen in the forums a number of cases where the SQL procedure or index drops failed for no apparent reason. Not sure if its a failure of the IF EXISTS condition or the DROP itself. In a few cases it is clearly due to case sensitivity (DNN requires a case insensitive colation) or a missing {objectQualifier} token in the script.

Perhaps an DBA or SQL expert here can offer some explaination of how the IF EXISTS . . . DROP can fail.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Register-Link not working after UpgradeRegister-Link not working after Upgrade


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