I though't I lost my website

  • I usually don’t get angry feedbacks, but I just spend the worst couple of hours in a loooong time.
    After 4 months of working in our new site (we can only use little time everyday) and days before the final release I comment with my partner:
    “look, this plugin looks nice, you can replace in all the pages in case we have make some typo, instead of going one by one”
    And I run to install it and run a test….And I make the worst mistake ever: NOT MAKING A BACKUP BEFORE!!!!
    I was too naive thinking that a plugin with so good reviews needed to be good, but I was wrong.
    Right after I imported the dump the site went down and it was saying that it couldn’t connect to the database.
    I run to check the database from the phpmyadmin and IT WAS EMPTY. Unbelievable I open the dump which was containing only a json file and a sql file.
    I open the sql file and SURPRISE!!! the sql sentences where in a wrong format: THE QUOTE(‘) WAS SCAPED WITH A \’ INSTEAD OF WITH A ”.
    I couldn’t believe it….

    This is what I have done to save my site, in case somebody runs in the same problem:
    I have spend the last 2 hours checking one by one the more than 700 hundreds times than the \’ appears and substituting it with ” (I did one by one not to make a mistake, altough at the end I could have done it automatically).
    After that I substitute ‘SERVMASK_PREFIX’ with ‘wp’.
    When I did that and execute the sql, it was still giving an error with the table commentmeta, because the inserts seemed to be joint with the actual comment table :S.
    After fixing this problem I run the sql and MAGIC my site was back…I couln’t believe.
    I just hope that the developer fix all this problems as soon as possible and for those who read me….ALWAYS BACKUP FIRST (better safe than sorry).

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter lopezvit

    (@lopezvit)

    In case that you want to know how I solved the commentmeta table problem I used this regular expression in notepad++

    First I replace
    ),(
    into this:
    ),\r\n(
    Using the extended search mode.

    And now that you have one line per insert you can safely run this replace in regular expression search mode. This:
    (^\('[^']*','[^']*','[^']*','[^']*').*(\),)$
    into this:
    $1$2

    Hope it helps.

    Plugin Author Yani

    (@yaniiliev)

    @lopezvit,

    I appologize for the hard time recovering your website.
    You could always contact us and we will be more than willing to help incase you run into such issues.
    The plugin is also making a backup before the data is replaces but we don’t advertise that so that’s easy to fix in case you have such issue.

    The escaping of the strings should’ve been fixed by our importer on import. The real problem from what I understand is the comments meta table being joined with your comments table. Earlier today we received another similar report and are looking into this issue.

    I am sorry again for the hard time you had over the last few hours.

    Plugin Author Yani

    (@yaniiliev)

    Hi lopezvit,

    I wanted to follow up and offer you a free license of the PRO version of the plugin as our way to say sorry for your bad experience.
    Could you email me at support at servmask dot com with details on where to send the license to?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘I though't I lost my website’ is closed to new replies.