Allowed Quantites - Add To Cart On Home Page Not Working

I Changed Allowed Quantities To 1 For All Products

The Add To Cart Button now only works on the product page (add to cart on home page / product list pages does not add item to cart, but just sends user to product page where they can then click button again to order)

So i want to ideally make the Add To Cart work on all pages , or change button to "Product Details" or simlar.

Ta

Remove the required attributes of a product variant.

Thanks but if you mean the check box on product variant titled "Require other product variants are added to the cart" then this is not checked,

I found a solution but it will mean going through (on no) 450 products changing quantity allowed back to 0  and max quantity to 1 instead

I now see what you mean but i have no product variant attributes set

I'll have a go at using MSSQL to update the Product Table