WordPress and woo are working but…

  • albertramsbottom

    (@albertramsbottom)


    6 years, 3 months ago

    Lots of errors in my error.log and I am having issues with a few plugins

    I am on multisite and have one working site and two others in development

    mysite2 below is a development site that I have been duplicating products with variations using multisite duplicator.

    There are many more of these errors with many different tables

    [Tue Jan 28 17:37:59.525652 2020] [php7:notice] [pid 11535] [client 90.253.146.94:52444] WordPress database error ALTER command denied to user ‘user’@’localhost’ for table ‘wp_2_wc_category_lookup’ for query ALTER TABLE wp_2_wc_category_lookup CHANGE COLUMNcategory_tree_id category_tree_id BIGINT UNSIGNED NOT NULL made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\\WooCommerce\\Admin\\Install::check_version, Automattic\\WooCommerce\\Admin\\Install::install, Automattic\\WooCommerce\\Admin\\Install::create_tables, dbDelta, referer: https://mysite2.co.uk/wp-admin/edit.php?post_type=product&paged=1&ids=37541%2C37390
    [Tue Jan 28 17:37:59.525899 2020] [php7:notice] [pid 11535] [client 90.253.146.94:52444] WordPress database error ALTER command denied to user ‘user’@’localhost’ for table ‘wp_2_wc_category_lookup’ for query ALTER TABLE wp_2_wc_category_lookup CHANGE COLUMN category_id category_id BIGINT UNSIGNED NOT NULL made by do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\\WooCommerce\\Admin\\Install::check_version, Automattic\\WooCommerce\\Admin\\Install::install, Automattic\\WooCommerce\\Admin\\Install::create_tables, dbDelta, referer: https://mysite2.co.uk/wp-admin/edit.php?post_type=product&paged=1&ids=37541%2C37390

    Any ideas

Viewing 2 replies - 1 through 2 (of 2 total)
  • Yanko

    (@invadum)

    6 years, 3 months ago

    Hey,
    Just disable plugins one by one First of all clean your website cache if you have and disable cache plugin first. When I have a problem with shops it is almost always woocommerce. Did you make any updates of the wp version or you insert new plugin recently?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 3 months ago

    >> ALTER command denied to user ‘user’@’localhost’ <<

    From the mysql command line, try

    GRANT ALL on databasename.* to ‘user’@’localhost’;

    You can type the same into PHPMYADMIN’s SQL window.

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

The topic ‘WordPress and woo are working but…’ is closed to new replies.