Checkout:Position quantities and position total are 0 but total sum is fine

  • Resolved OliverHamburg

    (@oliverhamburg)


    7 years, 2 months ago

    Hi,
    using the most recent versions of WordPress 4.8.2 and Woocommerce 3.1.2 I have the following effect

    In the basket everything is fine:

    • quantity >= 1
    • position value = >=1
    • position sum is correct

    Checking out, each order position has

    • quantity = 0
    • position value = 0
    • position sum = 0
    • the total sum is still correct

    Same, wrong details are in the order emails and in the order details shown at Woocommerce

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter OliverHamburg

    (@oliverhamburg)

    The basket holds goods, but after making the purchase the quantity is set to zero

    Thread Starter OliverHamburg

    (@oliverhamburg)

    Solution: The database user did not have the right to drop a table. The database scheme update for Woocommerce uses this command and failed silently.
    After granting the mysql user the drop table right and re-starting the database update for Woocommerce everything was fine.

    porta030

    (@porta030)

    Hi Oliver. I have the same problem. I’ve read your solution, but my knowledge about mysql is poor.
    I would be very grateful if you would explain in more detail how to grante the mysql user the drop table right, step by step.

    Regards,
    Bojan

    Thread Starter OliverHamburg

    (@oliverhamburg)

    Hi,
    simply use PhpMyAdmin, select

    • your database
    • Privileges
    • the database user defined for WordPress
    • Edit Privileges
    • Check: Structure:Drop
    • Save

    or do it on MySql’s commandline with
    Grant Drop on ... to ..
    ( https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql )

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Checkout:Position quantities and position total are 0 but total sum is fine’ is closed to new replies.