Issue 22 . "Find and Replace SQL queries for DotNetNuke" not working
Last Post 05/24/2012 2:30 PM by Joseph Craig. 1 Replies.
Author Messages Not Resolved
Abraham Tameru
Nuker
Nuker
Posts:13


--
05/24/2012 2:58 AM
    Hi,
    I have some problems using Issue 22 . "Find and Replace SQL queries for DotNetNuke (To fix problems after transferring a localhost database to a live website and other useful functions) By Lee Sykes, July 2007" [http://www.dnncreative.com/Training....aspx] tutorial to adjust my html code.

    When I tried to run the code provided by Kevin Schreiner in SQL server I have the following errors:
    Msg 207, Level 16, State 1, Procedure Replace_DesktopHtml, Line 39
    Invalid column name 'DesktopHtml'.
    Msg 207, Level 16, State 1, Procedure Replace_DesktopHtml, Line 50
    Invalid column name 'DesktopHtml'.
    Msg 207, Level 16, State 1, Procedure Replace_DesktopHtml, Line 51
    Invalid column name 'DesktopHtml'.
    Msg 207, Level 16, State 1, Procedure Replace_DesktopHtml, Line 52
    Invalid column name 'DesktopHtml'.
    Joseph Craig
    DNN MVP
    Posts:11667


    --
    05/24/2012 2:30 PM
    I believe that tutorial was written before the HTML module saved versions. You will have to modify the SQL code to get it to work.

    However, there is a better solution: the F3 module from Engage Software (engage.com). It's free, it's go a UI and requires no SQL knowledge. Just install it and use it.

    Joe Craig, Patapsco Research Group
    Complete DNN Support


    ---