[NSFW] error after updation to version 4.3

  • Hi,
    i made an update to woocommerce 4.3. The database structurce and the database rights are set to normal defined database standard of verison 4.3. When i am opoening the admin page of wp i am getting the following error message:

    ?WooCommerce lzbD6m_wc_reserved_stock table creation failed. Does the wp_t82jn user have CREATE privileges on the wp_ridb2 database?“.

    PHP-error log shows the following error message:

    [10-Jul-2020 17:59:09 UTC] WordPress-Datenbank-Fehler Table ‘lzbd6m_wc_reserved_stock’ already exists für Abfrage
    CREATE TABLE lzbD6m_wc_reserved_stock (
    order_id bigint(20) NOT NULL,
    product_id bigint(20) NOT NULL,
    stock_quantity double NOT NULL DEFAULT 0,
    timestamp datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    expires datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
    PRIMARY KEY (order_id, product_id)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
    von require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Installer->install, Automattic\WooCommerce\Blocks\Installer->maybe_create_tables, Automattic\WooCommerce\Blocks\Installer->maybe_create_table

    How to resolve the issue?

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

    (@rynald0s)

    Automattic Happiness Engineer

    Hi @nscunex!

    As per the error message you are seeing there, it looks like your user, “wp_t82jn” does not have the correct permission to be able to CREATE in the database. You will need to reach out to your host and have them help set the correct permissions/privileges for your user.

    Please let us know if that helps resolve the issue.

    Cheers!

    Thread Starter nscunex

    (@nscunex)

    The concerning table already exists. I have full rights on the database. Other plugins in this wordpress installataion dont cause such error constellation in this way.
    Here are some additional information for you:

    We use MySQL 5.7 and PHP 7.4.7 …
    The PHP error log shows the following message in this case:

    2020-07-11T22:30:17+00:00 CRITICAL syntax error, unexpected ‘if’ (T_IF) in C:\Inetpub\vhosts\antheia-seifen.de\httpdocs\wp-content\plugins\woocommerce\packages\woocommerce-blocks\src\Installer.php in Zeile 56

    Our recent database version marker of woocommerce is set to version “430”. All needed tables are present and the database structure is correcty set to the most recent version of the database.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[NSFW] error after updation to version 4.3’ is closed to new replies.