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_2was referencing the wrong table namem5_cartflows_ca_cart_abandonmentwhen it should have beenwp_cartflows_ca_cart_abandonment.The full script line looked like this:
CONSTRAINTwp_cartflows_ca_email_history_ibfk_2FOREIGN 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.