• Resolved pjehan

    (@pjehan)


    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 name m5_cartflows_ca_cart_abandonment when it should have been wp_cartflows_ca_cart_abandonment.

    The full script line looked like this:

    
    CONSTRAINT wp_cartflows_ca_email_history_ibfk_2 FOREIGN KEY (ca_session_id) REFERENCES m5_cartflows_ca_cart_abandonment (session_id) ON DELETE CASCADE
    

    After 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)
  • Plugin Support CartFlows Team

    (@cartflows)

    Hello @pjehan,

    Thank you for reaching out to us.

    We are not sure why this happens. We will figure it out.

    Let us know if you have any questions.

Viewing 1 replies (of 1 total)
  • The topic ‘Wrong table prefix in table constraint’ is closed to new replies.