[RESOLVED] Re-Add Deleted Lead

[Aron Prins]

Alrighty guys - It's fixed but BOYYY what a job this was :O

After providing @twisted1919 the login details, he figured out that the constraints where not present in some tables of my database.

This caused the list_field_value table to be out of sync with the list_subscriber table. The lead was apparently deleted from the list_subscribers table, but the corresponding record was not deleted from the list_field_value table.

After adding the constraints and syncing the tables manually (thanks to twisted for some nifty snippets!) everything is working FINE!

Thanks everyone

Cheers,
Aron

 

[frm.mwz]

Alrighty guys - It's fixed but BOYYY what a job this was :O

After providing @twisted1919 the login details, he figured out that the constraints where not present in some tables of my database.

This caused the list_field_value table to be out of sync with the list_subscriber table. The lead was apparently deleted from the list_subscribers table, but the corresponding record was not deleted from the list_field_value table.

After adding the constraints and syncing the tables manually (thanks to twisted for some nifty snippets!) everything is working FINE!

Thanks everyone

Cheers,
Aron

great, has someone figured how it came to be (e.g. dbf upgrade, mwz upgrade, extension ops, etc or else?)

good time to renew support