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

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

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.

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

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 )

• This reply was modified 7 years, 4 months ago by OliverHamburg.