System Check v1.0.2 > Orphan Clean-up Report

[michatmaster7]

As you requested, I have no clue what this means exactly, other than SQL gibberish, but you wanted to see this report if it found anything:

System Check v1.0.2 > Orphan Clean-up

Number of tests run: 1676, total number of orphans found: 30. Click here to delete all the orphaned records / references.

TABLE: ft_email_template_recipients
- num orphans: 4
- error description:
1. invalid template ID 1 being referenced by the table's Primary Key ID 1
2. invalid template ID 2 being referenced by the table's Primary Key ID 2
3. invalid template ID 9 being referenced by the table's Primary Key ID 35
4. invalid template ID 9 being referenced by the table's Primary Key ID 36
_______________________


TABLE: ft_email_templates
- num orphans: 26
- error description:
1. Invalid email_from_account_id: 0 for email_id = 3
2. Invalid email_from_form_email_id: 0 for email_id = 3
3. Invalid email_reply_to_account_id: 0 for email_id = 3
4. Invalid email_reply_to_form_email_id: 0 for email_id = 3
5. Invalid email_from_account_id: 0 for email_id = 5
6. Invalid email_reply_to_account_id: 0 for email_id = 5
7. Invalid email_reply_to_form_email_id: 0 for email_id = 5
8. Invalid email_from_account_id: 0 for email_id = 6
9. Invalid email_from_form_email_id: 0 for email_id = 6
10. Invalid email_reply_to_account_id: 0 for email_id = 6
11. Invalid email_reply_to_form_email_id: 0 for email_id = 6
12. Invalid email_from_account_id: 0 for email_id = 7
13. Invalid email_reply_to_account_id: 0 for email_id = 7
14. Invalid email_reply_to_form_email_id: 0 for email_id = 7
15. Invalid email_from_account_id: 0 for email_id = 8
16. Invalid email_reply_to_account_id: 0 for email_id = 8
17. Invalid email_reply_to_form_email_id: 0 for email_id = 8
18. Invalid email_from_form_email_id: 0 for email_id = 10
19. Invalid email_reply_to_account_id: 0 for email_id = 10
20. Invalid email_reply_to_form_email_id: 0 for email_id = 10
21. Invalid email_from_form_email_id: 0 for email_id = 15
22. Invalid email_reply_to_account_id: 0 for email_id = 15
23. Invalid email_reply_to_form_email_id: 0 for email_id = 15
24. Invalid email_from_account_id: 0 for email_id = 14
25. Invalid email_reply_to_account_id: 0 for email_id = 14
26. Invalid email_reply_to_form_email_id: 0 for email_id = 14
_______________________

[Ben]

Excellent! I appreciate you posting the results.

Feel free to just use the "click here to delete" link to clean up the dud references.

- Ben