Initial database tables

  • Resolved eimisbass

    (@eimisbass)


    4 years, 4 months ago

    Hello,

    My WP version: 5.8.2
    MySQL version: 5.7.36-0ubuntu0.18.04.1
    PHP version: 8.1
    Woocommerce version: 6.0.0

    I am using my own droplet at Digital Ocean.

    I’m a senior Python developer with 5+ years of experience and I was looking for something straightforward for my e-commerce project, so I decided to go with WP + Woocommerce (so not having to build everything from scratch by myself). I was expecting to set it up quickly and for everything to work out of the box, but that unfortunately wasn’t the case.

    I set up the WP + NGINX + MySQL stack easily, but the main problem that I was dealing with was Woocoomerce not being to create initial database tables. All the WP tables were created during installation, but the Woocommerce plugin did not create any tables, I had to create such tables by hand:

    wp_actionscheduler_actions
    wp_actionscheduler_claims
    wp_actionscheduler_groups
    wp_actionscheduler_logs

    And then:
    wp_wc_admin_notes
    wp_wc_admin_note_actions
    wp_wc_category_lookup
    wp_wc_customer_lookup
    wp_wc_download_log
    wp_wc_order_coupon_lookup
    wp_wc_order_product_lookup
    wp_wc_order_stats
    wp_wc_order_tax_lookup
    <. . .> etc.etc. etc.

    I have no other plugins, just Woocommerce installed.

    I created these initial tables, but then in Sentry I got another error message: Unknown column 'is_deleted' in 'where clause' at /wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Notes/DataStore.php in Automattic\WooCommerce\Admin\Notes\DataStore::get_notes

    I know that my question is a bit vague, but is there a workflow with Woocommerce that would just work “out of the box” ? Or maybe there’s a plugin or whatever that would help me to understand why Woocommerce isn’t creating initial database tables? I know I can read the database logs, but I am starting to feel a bit helpless. Is there a flow that would just work out of the box?

    • This topic was modified 4 years, 4 months ago by eimisbass.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter eimisbass

    (@eimisbass)

    4 years, 4 months ago

    Update: I if anyone needs it, I ended up browsing Woocommerce 6.0.0 code and creating all the tables by myself: https://gist.github.com/Eimis/5cdde144947885aafc92ef17f26275fd

    Now it works well. Feel free to lock the thread and apologies for spam. Just still surprised it doesn’t work out of the box.

    mother.of.code

    (@imazed)

    The Mother of Code

    4 years, 4 months ago

    Hey there @eimisbass – this is something WooCommerce certainly should be doing out of the box. Creating database tables is something users should not have to do.

    Were you able to go through the setup wizard without any issues?

    Thread Starter eimisbass

    (@eimisbass)

    4 years, 4 months ago

    No I was not, unfortunately since the db tables were missing, I wasn’t even able to access Woocommerce settings, I got “permission denied” errors. Although after creating those tables (see Github Gist in my previous message) all works fine now.

    Mirko P.

    (@rainfallnixfig)

    4 years, 4 months ago

    Hi @eimisbass,

    It seems like some sort of limitation on your database since all the tables you shared in Gist were automatically created on my WC test database and it was not the case to create them manually. It’s good to hear that is all working fine now. Thank you for letting us know!

    Feel free to start a new thread if you have any more questions.

    Cheers.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Initial database tables’ is closed to new replies.

Tags