Announcement

Collapse
No announcement yet.

DNS error while unsuspending domain in Plesk

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • DNS error while unsuspending domain in Plesk

    Hi,

    If you receive the error message "DNSZone::Table::select() failed: no such row in the table" while un-suspending domains or when you click on the "DNS Settings" button in the Plesk control panel hosted on Windows server, follow the steps below to get this sorted out.

    Error:

    "DNSZone::Table::select() failed: no such row in the table"


    Solution :

    1) Open CMD as ADMINISTRATOR (important to "run as administrator"
    2) C:\>"%plesk_bin%"\dbclient.exe --direct-sql --sql="INSERT INTO dns_zone (name, displayName, email) VALUES ('poesyliang.net', 'poesyliang.net', '[email protected]');"

    3) C:\>"%plesk_bin%"\dbclient.exe --direct-sql --sql="SELECT id, name FROM dns_zone where name='poesyliang.net';"
    id name
    46 poesyliang.net
    47 poesyliang.net

    4) C:\>"%plesk_bin%"\dbclient.exe --direct-sql --sql="UPDATE domains SET dns_zone_id='47' WHERE name='poesyliang.net';"


    Once the above commands are executed, you can now go ahead & perform the desired changes..

  • #2
    Re: DNS error while unsuspending domain in Plesk

    Hello Alfie,

    Cheers ....

    I faced this issue today & miracle happened.I started to search in EUKHOST forums & got the solution in first place. I tried this & Bingo.... My friend issue has been resolved.

    Three cheers for EUKHost guys. You have done wonderful job!!!


    always

    Regards,
    Popeye

    The Sailor Man

    Comment


    • #3
      Re: DNS error while unsuspending domain in Plesk

      Originally posted by Popeye View Post
      Hello Alfie,

      Cheers ....

      I faced this issue today & miracle happened.I started to search in EUKHOST forums & got the solution in first place. I tried this & Bingo.... My friend issue has been resolved.

      Three cheers for EUKHost guys. You have done wonderful job!!!


      always

      Regards,
      Popeye

      The Sailor Man
      Glad that your issue has been fixed Popeye..

      Eukhost forums are enriched with such plethora of knowledgeable solutions & the Support Staff are the real saviors!
      Rock _a.k.a._ Jack Daniel

      Follow eUKhost on Twitter || Join eUKhost Community on Facebook

      Comment


      • #4
        Re: DNS error while unsuspending domain in Plesk

        Good One Alfie...!!!

        Comment


        • #5
          Re: DNS error while unsuspending domain in Plesk

          Originally posted by Popeye View Post
          Hello Alfie,

          Cheers ....

          I faced this issue today & miracle happened.I started to search in EUKHOST forums & got the solution in first place. I tried this & Bingo.... My friend issue has been resolved.

          Three cheers for EUKHost guys. You have done wonderful job!!!


          always

          Regards,
          Popeye

          The Sailor Man
          Agreed with popeye, you guys are great..!
          Taking over the rest..!

          Comment


          • #6
            Re: DNS error while unsuspending domain in Plesk

            Originally posted by Popeye View Post
            Hello Alfie,

            Cheers ....

            I faced this issue today & miracle happened.I started to search in EUKHOST forums & got the solution in first place. I tried this & Bingo.... My friend issue has been resolved.

            Three cheers for EUKHost guys. You have done wonderful job!!!


            always

            Regards,
            Popeye

            The Sailor Man
            Thank you popeye, feedbacks like this helps us to keep going further..
            EUK-SolomonS
            Rise & Shine

            Comment


            • #7
              Re: DNS error while unsuspending domain in Plesk

              Alfie... You the man !!! great finding......
              "It Takes 20 Years To Build A Reputation And Five Minutes To Ruin It. If You Think About That, You'll Do Things Differently. "

              Comment


              • #8
                Re: DNS error while unsuspending domain in Plesk

                Hi Popeye,

                Thank you so much for sharing such wonderful experience & appreciating our work.We always try to provide great level of service to our customers & we are happy that we achieved that.

                Thanks again as you gave your precious time to share this.



                Regards,
                Sandra P

                Comment

                Working...
                X