database table missing

  • Resolved travelavenger

    (@travelavenger)


    3 years, 12 months ago

    Hi there,

    in the apache error, there is an error related to the plugin to see if it can be solved:

    WordPress database error Table ‘{database}.wp_cartflows_ca_email_history’ doesn’t exist for query UPDATE wp_cartflows_ca_cart_abandonment as ca SET order_status = ‘lost’ WHERE ca.order_status = ‘abandoned’ AND DATE(ca.time) <= DATE_SUB( ‘2020-07-09 15:14:07’ , INTERVAL 30 DAY)\r\n

    Please advise, thank you!

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support CartFlows Team

    (@cartflows)

    3 years, 12 months ago

    Hello @travelavenger,

    Thank you for reaching out to us.

    The errors mean that quarry is unable to find the required database table.

    Can you please check if the ‘wp_cartflows_ca_email_history’ table exists in your database?

    Looking forward to hearing from you.

    Thread Starter travelavenger

    (@travelavenger)

    3 years, 12 months ago

    Hi there,

    thank you for your reply. we only have 2 tables related to the plugin:

    wp_cartflows_ca_cart_abandonment
    wp_cartflows_ca_email_templates

    Please advise on the solution, if possible provide the SQL for the table.

    Please also confirm if other tables are missing,

    Thank you very much for your kind assistance!

    Plugin Support CartFlows Team

    (@cartflows)

    3 years, 12 months ago

    Hello @travelavenger,

    There should be four tables for the plugin.

    1. wp_cartflows_ca_cart_abandonment
    2. wp_cartflows_ca_email_templates
    3. wp_cartflows_ca_email_history
    4. wp_cartflows_ca_email_templates_meta

    Are you using any other plugins that handle the database or like that?

    Looking forward to hearing from you.

    Thread Starter travelavenger

    (@travelavenger)

    3 years, 12 months ago

    Hi there,

    Actually there were just the 2 database table I mentioned created when the plugin was being installed.

    it was Version 1.2.7

    how can I fix it? please advise, thank you!

    Plugin Support CartFlows Team

    (@cartflows)

    3 years, 11 months ago

    Hello @travelavenger,

    Can you please reinstall the plugin again and check if all database tables are available?

    Are there any plugins installed that might be causing this?
    
    Here is what you can do to check:
    
    – Deactivate all plugins (except Woocomerce & cart abandonment ) temporarily and see if that solves the error.

    – Then, activate plugins one by one to see which plugin is causing the problem.

    Looking forward to hearing from you.

    Thread Starter travelavenger

    (@travelavenger)

    3 years, 11 months ago

    Hi there,

    I deactivate the plugin , drop the 2 tables I mentioned, and reactivated, same result with just the 2 tables.

    Maybe the sql of creating the 2 extra tables has issue? i am using mysql Ver 5.7.30

    i am currently deactivate the plugin first because it generate too many error message in log.

    Please advise, thanks!

    Plugin Support CartFlows Team

    (@cartflows)

    3 years, 11 months ago

    Hello @travelavenger,

    Can you please check the error log of the database, if is there any error while creating the database table?

    Also, check the Woocommerce error log for the error.

    You can contact your host regarding this issue. They may help you to resolve this issue.

    Let us know how it goes.

    Thread Starter travelavenger

    (@travelavenger)

    3 years, 11 months ago

    there is no error during the process, I am actually using a VPS and manage myself.

    If you could provide me the SQL of creating the 2 tables would be great.

    once I run the sql at phpmyadmin, I can see if there is any sql error specially using the latest version of mysql where foreign key or data structure might cause some error.

    thank you!

    • This reply was modified 3 years, 11 months ago by travelavenger.
    Plugin Support CartFlows Team

    (@cartflows)

    3 years, 11 months ago

    Hello @travelavenger,

    It’s strange! Can you please submit the contact form on our portal so our developers can check this issue on priority.

    https://wordpress.org/support/topic/read-this-first-42/

    Looking forward to hearing from you.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘database table missing’ is closed to new replies.

Tags