Help me fix this mess?

adetia

At some point along the way in the course of updating the AcyMailing starter version, I have 2 entries for the extension in my menu which go to different installs.

One that I keep going back to because I enjoy how it works must be the old version.
When I go to that one it says it is version 5.10.4 and that I can update. (not entirely true).

I could use the new one, but my problem is this:

How do I get one of them (either one at this point) to have all the newsletters/emails from the other. If I have to lose one I'd rather lose the newer one, and keep the data from the old one as it is more "current". I briefly used the other, and I liked the old one so I just kept going back to it, but now AcyMailing is blocking my ability to update Joomla.

Anybody have some suggestions for this novice?

adetia

When I go into the top listing it tells me it is version 7.5.11. The second listing is the 5.10.4 listing if that matters. Basically I'd like to merge the data if there's any way possible, and then sort out what I need to do to correct this. I have "newsletters" in the 5.10.4 that don't exist in the 7.5.11 and I have emails in the 7.5.11 that don't exist in the 5.10.4. Please help 🙂

mihha

You can't merge data from both versions into version 7

What you can do is migrate all the data from version 5 to version 7. That action will remove all the current data in version 7 and will migrate and import data from version 5 into it

adetia

is version 5 dead then? or will it continue to get updates? sorry, i tried to find the answer but couldn't tell for sure.

mihha

Version 5 is not dead and will work with Joomla 3 without any issues.

We won't add new features to it and will update it with bug fixes or reported security fixes.

We will also provide support for our clients that are still using it

adetia

Is there any way for me to preserve this data by exporting? I saw instructions for another user but when I try to do the integrity check i get this error.

Table #acymailing_config OK
Table #acymailing_fields OK
Table #acymailing_filter OK
Table #acymailing_history OK
Table #acymailing_list OK
Table #acymailing_listcampaign OK
Table #acymailing_listmail OK
Table #acymailing_listsub OK
Table #acymailing_mail OK
Table #acymailing_queue OK
Table #acymailing_rules OK
Table #acymailing_stats OK
Table #acymailing_subscriber OK
Table #acymailing_template OK
Table #acymailing_url OK
Table #acymailing_urlclick OK
Table #acymailing_userstats OK
Table #acymailing_geolocation OK
Table #acymailing_action OK
Table #acymailing_forward OK
Table #acymailing_tag OK
Table #acymailing_tagmail OK
primary key missing in #acymailing_history
[ERROR]Could not add the primary key on the table : #acymailing_history

Duplicate entry '1015-1568746351' for key 'PRIMARY'...
Custom fields OK

Just trying to figure out some way to salvage this problem without making it worse.

mihha

You can fix it by yourself using PHPMyAdmin for example

Steps :

take the backup of the table
Check for records with subid=0 and remove them, if found
Add primary key on subid field as shown in the screenshot below :

Hope this helps.

adetia

Thank you for your help - I so appreciate it!

Followed your instructions, but when I try to add the primary key it gives me that error.

mihha

You have to clear duplicates first as explained in point 2 of my suggestion

adetia

right, understood, but i didnt see anything with subid of 0.

mihha

OK. Then search for the number which is reported in the message. Number 402 in your case

Try the following

To fix the user history table, first execute the following sql query:
SELECT CONCAT("DELETE FROM PREFIX_acymailing_history WHERE subid = ", subid, " AND date = ", date, ";") FROM PREFIX_acymailing_history GROUP BY subid, date HAVING COUNT(*) > 1

That will create series of SQL queries which you should run to remove duplicate

After that, set primary key on the column as explained in point 3 of my first reply