- Posts: 95
- Thank you received: 1
Error message when renewing subscriptions
- David Fletcher
- Topic Author
- Offline
- Premium Member
-
Less
More
5 years 9 months ago #126853
by David Fletcher
Errroe 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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
5 years 9 months ago #126858
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Errroe 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
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
- Premium Member
-
Less
More
- Posts: 95
- Thank you received: 1
5 years 9 months ago #127081
by David Fletcher
Replied by David Fletcher on topic Errroe message when renewing subscriptions
Thanks for prompt answer.
I was already at latest. But I cleared the Joomla cache and now working again.
regards
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
5 years 9 months ago #127099
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Errroe message when renewing subscriptions
Great. Happy to hear that it's now working as expected. Thanks for the update David
Regards,
Tuan
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- David Fletcher
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 95
- Thank you received: 1
5 years 9 months 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
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.
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.