Problems after migration/recreation

  • Resolved TonyPearl

    (@tonypearl)


    2 years, 10 months ago

    Hello,

    I had to rebuild a site because of some issues I was having…one of which was a malware infection. What a nightmare.

    After the fresh WP installation & rebuild, I needed all my MP data (subscribers, newsletters, stats, etc.), so I followed the instructions here:

    https://kb.mailpoet.com/article/377-how-to-migrate-mailpoet-database-tables

    After installing/activating the latest MailPoet 3 and Premium,
    I dropped all the _mailpoet tables in my DB,
    then imported them from my previous site installation.

    However, after that, I could NOT create a Newsletter.
    When I Emails>Newsletters>Create, the little circle just kept spinning and nothing happened.
    When I tried to Duplicate a previous Newsletter broadcast (Emails>Newsletters>Duplicate), a dump of coding issues appeared on my screen.

    Even though my subscribers, lists, and emails all show up,
    I just can’t get this plugin to work anymore, no matter what I do.

    I really, really, really need my data… I Have over 100 emails I’ve painstakingly written, along with their timed release as ‘Welcome’ emails, and not to mention my subscribers, the lists, stats, etc.

    Some ideas I have:
    -Export all the tables as csv, then import them as such into the new DB.
    -Install a test site on a different domain, or on a subdomain or directory of my intended domain, then try importing the tables again and see what happens. But I somehow doubt that would work either.

    After the horrible experience I had to reconstruct my site, there’s no way I’m going to risk it all crashing again by installing MP on this domain until I know that this will work 100%. In fact, I’m thinking of just running my mailing from a different WP installation on a subdomain of my main site, like mail.DOMAIN.com – just to insulate the site/database from my main one. I had noticed some DB bloating from the queues.

    What else can we possibly do here to get this to work?
    I really love MailPoet and want to keep using it!

    Thank you in advance for your help!

    -Tony

    P.S. I’m running this on a very good server, with php 7.4.
    I’ll be happy to supply any data we need for this.

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Support Dani F. a11n

    (@danielinhou)

    2 years, 10 months ago

    Hi there @tonypearl 👋🏽!

    Thank you for reaching out to MailPoet Support. I totally get your frustration, redoing a site is never a nice experience.

    Even though my subscribers, lists, and emails all show up,

    So, I think that importing the database tables worked, because the date is already on your new site.

    When I tried to Duplicate a previous Newsletter broadcast (Emails>Newsletters>Duplicate), a dump of coding issues appeared on my screen.

    Could you please share those error messages with us? That could shed some light on this issue.

    Looking forward to hearing back from you!

    Cheers!

    Thread Starter TonyPearl

    (@tonypearl)

    2 years, 10 months ago

    Hello and thanks for your reply!

    Ok, after great pains of recreating this in my test site, here is the code dump I’m seeing:

    `An exception occurred while executing ‘INSERT INTO test_mailpoet_newsletters (hash, subject, type, sender_address, sender_name, status, reply_to_address, reply_to_name, preheader, body, sent_at, unsubscribe_token, ga_campaign, created_at, updated_at, deleted_at, parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“b1ba66d831fd”, “Copy of [subscriber:firstname | default:friend], Did you listen to our Group Coaching Call Replay yet?”, “standard”, “tony@SITEREDACTED.com”, “Tony Pearl”, “draft”, “EMAILREDACTED@gmail.com”, “Tony Pearl”, “Here’s the replay of our call from last Sunday”, “{\”content\”:{\”type\”:\”container\”,\”columnLayout\”:false,\”orientation\”:\”vertical\”,\”image\”:{\”src\”:null,\”display\”:\”scale\”},\”styles\”:{\”block\”:{\”backgroundColor\”:\”transparent\”}},\”blocks\”:[{\”type\”:\”container\”,\”columnLayout\”:false,\”orientation\”:\”horizontal\”,\”image\”:{\”src\”:null,\”display\”:\”scale\”},\”styles\”:{\”block\”:{\”backgroundColor\”:\”#ffffff\”}},\”blocks\”:[{\”type\”:\”container\”,\”columnLayout\”:false,\”orientation\”:\”vertical\”,\”image\”:{\”src\”:null,\”display\”:\”scale\”},\”styles\”:{\”block\”:{\”backgroundColor\”:\”transparent\”}},\”blocks\”:[{\”type\”:\”image\”,\”link\”:\”\”,\”src\”:\”http:\/\/SITEREDACTED.com\/wp-content\/uploads\/2017\/09\/INFOREDACTED-logo-e1507313589412.png\”,\”alt\”:\”your-real-estate-course-logo\”,\”fullWidth\”:false,\”width\”:\”199px\”,\”height\”:\”70px\”,\”styles\”:{\”block\”:{\”textAlign\”:\”center\”}}},{\”type\”:\”text\”,\”text\”:\”

    —

    What can you make of this?

    oh, and it still does nothing when I click on ‘create’ newsletter.

    Thanks – looking forward to hearing back from you!
    -Tony

    • This reply was modified 2 years, 10 months ago by TonyPearl.
    Plugin Author Bruna a11n

    (@bruberries)

    2 years, 10 months ago

    Hi @tonypearl,

    Thanks for sharing the error logs with us.

    May I ask you if you’re trying to run the import via SQL dump file?

    If so, could you please try exporting the tables from your previous database as CSV and importing them into the new site database, as you mentioned in the original post?

    Let us know if it works!

    Thread Starter TonyPearl

    (@tonypearl)

    2 years, 10 months ago

    Hi Bruna! So great to hear from you again!
    Yes, I’ll get right on that and get back to you.

    Keeping my fingers crossed,
    Tony

    Thread Starter TonyPearl

    (@tonypearl)

    2 years, 10 months ago

    Hello again,

    Out of curiosity, do I need to do that CSV export/import for ALL the tables in MP?
    There’s a lot of them. Just trying to save time lol

    Thanks,
    Tony

    Thread Starter TonyPearl

    (@tonypearl)

    2 years, 10 months ago

    Hi,

    Ok, I’ve been able to export/import MOST of the tables as CSV files
    EXCEPT for these:

    mailpoet_newsletter_templates (3,785 KB)
    mailpoet_scheduled_tasks (2,084 KB)
    maipoet_sending_queues (58,599 KB)

    Even if I zip those files & still try to import them one at a time in the CSV format, it won’t work. It just takes too long. There’s probably too many rows with massive data.

    Then I get this error message (after several minutes of a spinning circle):
    “ERROR: Maximum execution time of 300 seconds exceeded (ImportCsv.php:365)”

    Question: Do I truly need those tables? Can I get by without them?
    If not, what else can be done here?

    Also, it sucks to have to import these tables as csv, because you have to do it one. at. a. time. Ugh!

    Thanks in advance for any further assistance!

    Plugin Author Bruna a11n

    (@bruberries)

    2 years, 10 months ago

    Hi @tonypearl

    mailpoet_newsletter_templates

    If you don’t have any previous custom templates saved that you’d like to recover, it’s okay to skip this table.

    mailpoet_scheduled_tasks
    maipoet_sending_queues

    These are important tables if you’d like to keep the proper data of past sent newsletters.

    mailpoet_scheduled_tasks – where all scheduled tasks (including the ones from the sending_queue) and their statuses are stored.

    maipoet_sending_queues – where all rendered individual emails from the created newsletters associated with their task_ID are stored.

    Not importing these tables may compromise the information displayed for your past newsletters, so I recommend doing it.

    Then I get this error message (after several minutes of a spinning circle):
    “ERROR: Maximum execution time of 300 seconds exceeded (ImportCsv.php:365)”

    You can look into increasing the maximum execution time on your php.ini, or you can split your CSV files into smaller, lighter files and process them separately.

    Thread Starter TonyPearl

    (@tonypearl)

    2 years, 10 months ago

    Hi Bruna,

    Thanks for your reply.

    After further inspection of my database, I believe that the tables associated with MailPoet have been corrupted, most likely because of the malware infection. 🙁

    So now my big question is: Is it possible to fix it?
    If so, how? Or who could possibly help me with that?
    Or am I just completely screwed here?

    Again – any ideas or suggestions would be greatly appreciated!

    Thanks in advance,
    -Tony

    Elvira K.

    (@treibalen)

    2 years, 9 months ago

    Hi there @tonypearl,

    Thanks for getting back to us!

    I’m sorry to hear that your MailPoet tables got corrupted.

    I’m afraid it’s not something that we can assist you with, but if you have a test site, I recommend installing MailPoet there to have all empty tables correctly created, then try importing old data for each table and carefully comparing their structure and data.

    Maybe you have a backup of your old site _before_ the malware? If so, you could export this data instead.

    I hope you’ll get it working!

    Thread Starter TonyPearl

    (@tonypearl)

    2 years, 9 months ago

    Hello again,

    Wow – after much searching, experimenting, and trial & error,
    I’m ecstatic to report that I was finally able to find an uncorrupted (hopefully) version of my database. I migrated the data over, did a quick test, and BAM!

    I am officially back in business!!

    Can’t tell you how relieved I am. Hundreds of emails that represented an uncountable number of hours writing & crafting them have all been successfully recovered now.

    Thanks again for your support!

    -Tony

    Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    2 years, 9 months ago

    Hey again @tonypearl !

    So so glad to hear that you are back up and running.

    Cheer!

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Problems after migration/recreation’ is closed to new replies.