Error message when renewing subscriptions

  • David Fletcher
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
More
4 months 2 weeks ago #126853 by David Fletcher
Error message when renewing subscriptions was created by David Fletcher
Tuan

I am getting this error message when renewing suscriptions. Also when updating status on a subscription.
Any suggestions please?
thank you

David

An error has occurred.

1452 Cannot add or update a child row: a foreign key constraint fails (`nabo2516_new`.`#__acym_user_has_list`, CONSTRAINT `fk_#__acym_user_has_list2` FOREIGN KEY (`list_id`) REFERENCES `#__acym_list` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)

Return to Control Panel

Please Log in or Create an account to join the conversation.

More
4 months 2 weeks ago #126858 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Error message when renewing subscriptions
Hi David

Did you update your site to latest version of Membership Pro? If not, please update and try again

If you are already using latest version and still see this error, it might cause by something special on your site. In this case, submit a support ticket sending us super admin account of your site so that we can check it

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • David Fletcher
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
More
4 months 1 week ago #127081 by David Fletcher
Replied by David Fletcher on topic Error message when renewing subscriptions
Thanks for prompt answer.
I was already at latest. But I cleared the Joomla cache and now working again.
regards

Please Log in or Create an account to join the conversation.

More
4 months 1 week ago #127099 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Error message when renewing subscriptions
Great. Happy to hear that it's now working as expected. Thanks for the update David

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • David Fletcher
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
More
4 months 1 week ago #127206 by David Fletcher
Replied by David Fletcher on topic Error message when renewing subscriptions
Tuna
It came back again. I then found that this is related to the integration with Acymail6. Some plans undated without error, some did not.
I have set all plans to make no changes to the assigned mailing list, just stay as is, and this creates no error for all plans.
I see in the individual plan settings for Acymail, having set a mail list for an option it can be a changed to another list, but it cannot be deselected from all lists.
David

Please Log in or Create an account to join the conversation.