> Forums > Active Social > Community Support > AS 1.7 Upgrade issue with vanity URLs and objectQualifier
Last Post 01 Jul 2010 10:28 AM by Will Morgenweck. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Informative
Matt Marlor
Customers
Matt Marlor
Post Count:375

--
01 Jul 2010 09:49 AM
    BEFORE upgrading to 1.7, are you using the SocialRewriter filter in web.config?

    Disable this by adding <!-- and -->to either side of the tag.

    If you haven't done this and now have a website displaying "Server error in "/" application" or similar - don't panic! Just get into the web.config and add it.

    I also disabled custom skin additions relating to Active Social welcome view, but this may not be necessary.

    Now going to check if there's something in the release notes about this, or otherwise raise a support request to figure out how to get my vanity url's back :-)
    AuTechHeads - An Australian group for geeks. Visit us at http://www.autechheads.com!
    Will Morgenweck Forum Admin
    DotNetNuke Staff
    Will Morgenweck
    Post Count:7672

    --
    01 Jul 2010 09:53 AM
    Hi Matt,
    Please post a ticket with the exact error. We have upgraded several sites with vanity urls enabled and didn't have any problems. ActiveSocial.com is one of the sites.
    Will Morgenweck
    Director of Product Management
    DotNetNuke Corp.
    Matt Marlor
    Customers
    Matt Marlor
    Post Count:375

    --
    01 Jul 2010 09:57 AM
    It's possible it's a conflict with URLmaster, just exploring that now.
    AuTechHeads - An Australian group for geeks. Visit us at http://www.autechheads.com!
    Will Morgenweck Forum Admin
    DotNetNuke Staff
    Will Morgenweck
    Post Count:7672

    --
    01 Jul 2010 10:00 AM
    Matt,
    What prefix are you using for members and groups?
    Will Morgenweck
    Director of Product Management
    DotNetNuke Corp.
    Matt Marlor
    Customers
    Matt Marlor
    Post Count:375

    --
    01 Jul 2010 10:10 AM
    Just a note that this happens even without vanity urls options switched.

    Confirming that the exception noted in my helpdesk job is definitely the error, just tried disabling duplicate URL checking in URLMaster (and disabling URLMaster) and it's unrelated.

    The exception I refer to is


    Exception information:
    Exception type: SqlException
    Exception message: Invalid object name 'dbo.nArAZepRaD8Dr2pr_'.

    The qualifier is there but there's no object :-)
    AuTechHeads - An Australian group for geeks. Visit us at http://www.autechheads.com!
    Matt Marlor
    Customers
    Matt Marlor
    Post Count:375

    --
    01 Jul 2010 10:26 AM
    Will rocks. Sorted it out before I blinked! :-D
    AuTechHeads - An Australian group for geeks. Visit us at http://www.autechheads.com!
    Will Morgenweck Forum Admin
    DotNetNuke Staff
    Will Morgenweck
    Post Count:7672

    --
    01 Jul 2010 10:28 AM
    Thanks for pointing this out Matt. This was definitely a problem with one of our scripts related to objectQualifier. We have corrected the install package, but if anyone else encounters this problem here is script to fix it. Just run this from host sql menu with execute as script checked.

    
    IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'{databaseOwner}[{objectQualifier}activesocial_Util_GetSiteURLs]') AND type in (N'P', N'PC'))
    DROP PROCEDURE {databaseOwner}[{objectQualifier}activesocial_Util_GetSiteURLs]
    GO
    CREATE PROCEDURE {databaseOwner}[{objectQualifier}activesocial_Util_GetSiteURLs]
    AS
    SELECT PortalId,SettingValue as Url
      FROM {databaseOwner}{objectQualifier}activesocial_Settings
      WHERE (SettingName = 'SITEURL' AND SettingValue<>'')
    
    GO
    
    Will Morgenweck
    Director of Product Management
    DotNetNuke Corp.
    You are not authorized to post a reply.
    > Forums > Active Social > Community Support > AS 1.7 Upgrade issue with vanity URLs and objectQualifier
    test
    Copyright 2012 by DotNetNuke Corporation / Terms of Use / Privacy