Wrong table prefix in table constraint
-
Hello and thank you for this great plugin!
However, just to let you know, we had a problem recently with multiple website and after some research, we realized that there was a problem with the table
wp_cartflows_ca_email_history
.The constraint
wp_cartflows_ca_email_history_ibfk_2
was referencing the wrong table namem5_cartflows_ca_cart_abandonment
when it should have beenwp_cartflows_ca_cart_abandonment
.The full script line looked like this:
CONSTRAINT
wp_cartflows_ca_email_history_ibfk_2
FOREIGN KEY (ca_session_id
) REFERENCESm5_cartflows_ca_cart_abandonment
(session_id
) ON DELETE CASCADEAfter executing this SQL script, everything worked again:
ALTER TABLE wp_cartflows_ca_email_history DROP FOREIGN wp_cartflows_ca_email_history_ibfk_2; ALTER TABLE wp_cartflows_ca_email_history ADD CONSTRAINT wp_cartflows_ca_email_history_ibfk_2 FOREIGN KEY (ca_session_id) REFERENCES wp_cartflows_ca_cart_abandonment(session_id) ON DELETE CASCADE;
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Wrong table prefix in table constraint’ is closed to new replies.