Lost my entire list when updating

  • Resolved FreemanNg

    (@freemanng)


    5 years, 3 months ago

    I just updated the plugin and seem to have lost my entire subscriber list. I formerly had had “test” and “all” lists where “test” had one member and “all” had all my subscribers to date, and now both are empty.

    I still see over 100 contacts, but none of them have any status and none of them belong to either list, whereas before the update, they all had some status and, except for one “test” member, all belonged to the “all” list.

    I could just move everybody to “all” and change their status to “subscribed”, but the problem is that a large number of them had been “unconfirmed” and at least one was “unsubscribed” and I don’t want to suddenly start sending them emails.

    Is there any chance that the original data is still in the db somewhere, and you just changed the fields in an update? (It’s been at least a year since I last updated.) If so, then can you maybe provide me with some MySQL code to convert my data? I have some MySQL proficiency.

    However you do it: Help!!!

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hi,

    Sorry for the inconvenience you had.

    There was a bug in ES 4.3.5 and we fixed it and released ES 4.3.5.1

    You can take a look into “ig_contacts” table and see “unsubscribed” column. If it set to 1 which means contact unsubscribed from list. So, you can go and edit that contact and set unsubscribed for all lists.

    If it’s set to “0” which means user is subscribed. So, you can set as subscribed.

    You can do in bulk from Email Subscribers > Audience as well.

    I have the same problem, but the update didn’t help. How can I access the “ig_contacts” table?

    Thread Starter FreemanNg

    (@freemanng)

    Thanks, I managed to restore things, but fyi, I had to consult one other table.

    ig_contacts only seemed to contain info on whether a contact was unsubscribed or not, but I couldn’t figure out how to deduce whether a contact had been verified. However, I found this info in another table, es_maillist.

    p.s. to @scarlette13: you need to be able to access the underlying WordPress database.

    p.p.s. to @malayladu: given that the “fixed” version of the plugin doesn’t restore people’s data, don’t you think you should provide a tool, or perhaps the capability in your next update, to automatically (or at the user’s request) detect and fix the problem? It seems unreasonable to require that a user be able to access the database.

    @freemanng Thanks for an update.

    We don’t have sufficient data of those people who were unsubscribed from how many lists.

    Still, we will try to figure that out and if possible, we will try to fix this issue automatically so that people don’t have to do it manually.

    BTW, thanks for your suggestion.

    @freemanng thanks for your message. Lucky me I have access to the database and could manage it manually, but I agree with you that this shouldn’t be the solution. I hope this won’t happen again and the manual effort doesn’t need to be done again!

    @freemanng THANK YOU!

    es_emaillist provided me with the data of everyone who subscribed/unsubscribed/never confirmed to specific lists through February 2019 (which is when I believe Email Subscribers upgraded from 3.5 to 4.0), and I was then able to use ig_contacts to discern who has unsubscribed since then.

    While that still means I will now need to individually review the status of everyone who subscribed over the last 10 months, at least this gives me *some* of my subscribers back instead of *none*.

    Really, really appreciate you sharing this information!

    @malayladu

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Lost my entire list when updating’ is closed to new replies.