• Login
  • Register

DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

SQL for cleanup auto page redirects?

You are not authorized to post a reply.
Sort:


Basic Member


Posts:69
Basic Member

    DNN932: If you rename a page, a redirect is generated. Useful, but not during development of a site where page names are changed frequently.

    I want to remove all the page redirects just before putting the site live.

    Does anybody have an SQL statement that I can use to do the cleanup in one go?


    XCESS expertise center b.v.Regards,
    Ernst Peter
    LinkedIn Profile Ernst Peter Tamminga

    XCESS: DNN gebaseerde Webapplicaties en Business Apps, zie xcess.nl


    Advanced Member


    Posts:246
    Advanced Member

      DELETE FROM TabUrls WHERE HttpStatus = 301


      Veteran Member


      Posts:813
      Veteran Member

        AFAIK: DELETE From TabUrls Where [HttpStatus] = '301'



        Veteran Member


        Posts:813
        Veteran Member

          Posted By Sebastian Leupold on 16 Oct 2019 07:01 AM
          DELETE FROM TabUrls WHERE HttpStatus = 301

          :-)

           

           



          Basic Member


          Posts:69
          Basic Member

            Posted By Timo Breumelhof on 16 Oct 2019 07:02 AM

            AFAIK: DELETE From TabUrls Where [HttpStatus] = '301'

            Thank you both.

            I think I will apply:

            DELETE FROM {databaseOwner}[{objectQualifier}TabUrls] 
            WHERE [HttpStatus] = '301'

             


            XCESS expertise center b.v.Regards,
            Ernst Peter
            LinkedIn Profile Ernst Peter Tamminga

            XCESS: DNN gebaseerde Webapplicaties en Business Apps, zie xcess.nl


            Veteran Member


            Posts:980
            Veteran Member

              When TImo and Sebastian post identical answers within a minute of one another, you know it's the right answer!
              Joe Craig
              DNN MVP
              Patapsco Research Group


              Veteran Member


              Posts:519
              Veteran Member

                Joe,

                they are not identical. Sebastian wrote:

                [...] WHERE HttpStatus = 301

                Timos answer was:

                [...] WHERE HttpStatus = '301'

                As the column HttpStatus is nvarchar(50), Timos answer is syntactically correct, even if Sebastian's answer will work as well (because SQL Server does an implicit conversion...)

                Happy DNNing!
                Michael
                (smart alleck) :-)

                Michael Tobisch
                DNN★MVP

                dnnWerk Austria
                DNN Connect


                Veteran Member


                Posts:980
                Veteran Member

                  I surrender, sir!
                  Joe Craig
                  DNN MVP
                  Patapsco Research Group


                  Advanced Member


                  Posts:246
                  Advanced Member

                    I didn't verify my statement, just wanted to provide EPT with a quick suggestion. I know, he is able to fix smaller typos :)
                    You are not authorized to post a reply.

                    These Forums are dedicated to discussion of DNN Platform.

                    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.

                    Would you like to help us?

                    Awesome! Simply post in the forums using the link below and we'll get you started.

                    Get Involved