Quantity Units errors - in shopping cart

[MB1]

i'm getting this shopping cart error just kinda curious what it is, as well it won't let me check out

Please update your order. The item: Apeman Training Gloves ... Quantity Units errors -
You ordered a total of: 1

i have have plenty of stock for that attribute so i'm not sure what is going on.

i've installed the latest version of stock by attributes on a clean cart

[MB1]

also getting this errer in the debugger

[28-Jun-2010 08:13:15] PHP Warning: Division by zero in /store/includes/functions/functions_general.php on line 1329
[28-Jun-2010 08:13:15] PHP Warning: Division by zero in store/includes/functions/functions_general.php on line 1329s

which is this line of code

$zc_round = ($x*1000)/($y*1000);

which is not a file i've touched so far in this but i wonder if something else i install is effecting this piece of code or em i looking in the totally wrong place?

[MB1]

i cornered it down to this my last install of group pricing per item, i assumed everything was working but obviously not here is a link to my attempt at merging 1.39d with group pricing per item, i wonder what i did wrong

http://www.2shared.com/file/BHl-BTXw...r_item_1-.html

[MB1]

ok i found the file with that is the issue but i don't know what to do with it

store/includes/classes/shopping_cart.php

i'm just going back to the original code and test each line i modify till i track the issue down to the single line of code

[MB1]

here is the piece of code around line 1135 that is screwing everything up

    $products_array = array();
    reset($this->contents);
    while (list($products_id, ) = each($this->contents)) {
      $products_query = "select p.products_id, p.master_categories_id, p.products_status, pd.products_name, p.products_model, p.products_image,
                                  p.products_price, p.products_weight, p.products_tax_class_id,

                                  p.products_group_a_price, p.products_group_b_price,
                                  p.products_group_c_price, p.products_group_d_price,

                                  p.product_is_free, p.products_priced_by_attribute,
                                  p.products_discount_type, p.products_discount_type_from
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = '" . (int)$products_id . "'
                           and pd.products_id = p.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";

replaces this original code

 $products_array = array();
    reset($this->contents);
    while (list($products_id, ) = each($this->contents)) {
      $products_query = "select p.products_id, p.master_categories_id, p.products_status, pd.products_name, p.products_model, p.products_image,
                                  p.products_price, p.products_weight, p.products_tax_class_id,
                                  p.products_quantity_order_min, p.products_quantity_order_units,
                                  p.product_is_free, p.products_priced_by_attribute,
                                  p.products_discount_type, p.products_discount_type_from
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = '" . (int)$products_id . "'
                           and pd.products_id = p.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";

any ideas? on what to do with this

[MB1]

ok i just merged the 2 instead of replace one for the other and it seems like everything is peachy now

    $products_array = array();
    reset($this->contents);
    while (list($products_id, ) = each($this->contents)) {
      $products_query = "select p.products_id, p.master_categories_id, p.products_status, pd.products_name, p.products_model, p.products_image,
                                  p.products_price, p.products_weight, p.products_tax_class_id,
                                   p.products_quantity_order_min, p.products_quantity_order_units,
                                  p.products_group_a_price, p.products_group_b_price,
                                  p.products_group_c_price, p.products_group_d_price,
                                  p.product_is_free, p.products_priced_by_attribute,
                                  p.products_discount_type, p.products_discount_type_from
                           from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           where p.products_id = '" . (int)$products_id . "'
                           and pd.products_id = p.products_id
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";

[Ajeh]

Before changing code, could you make sure your Products are not setup with a Product Unit of 0 it should be 1 as you cannot but 0 ...

[MB1]

sorry product unit? all the products have stock?

[Ajeh]

Edit your Products ...

Check the settings, the defaults are:

Product Qty Minimum: 1
Product Qty Maximum: 0
Product Qty Units: 1

If you have the Product Quantity Units set to 0 you will get errors ...

[MB1]

would this be done through the admin or through the code?