Hi,
I am in the midst of massive upgrades in Joomla and Acy, from v5 to v10. Somewhere around v 9.1(?) we got a ton of errors for foreign key checks. There are many of them, but this is how they start (and continue in a similar vein):
Foreign key lmyaws_fk_acym_mail1 not well set for table #__acym_mail
[ERROR]Could not add the foreign key lmyaws_fk_acym_mail1 on the table #acym_mail : Failed to add the foreign key constraint 'verge_freshj3/lmyaws_fk_acym_mail1' to system tables
Foreign key lmyaws_fk_acym_list_has_mail1 not well set for table #acym_list
I did see another thread that addressed this problem and said "Edit DB table "#acym_step" and drop all the foreign keys from it. Make sure that other DB tables don't have foreign keys that are connected to this table." But, I don't know how to do this - examining the table shows no obvious start point.
Can anyone please advise?