Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

timoguin

Archived
  • Posts

    4
  • Joined

  • Last visited

Profile Information

  • Real Name
    Tim O'Guin

timoguin's Achievements

  1. timoguin

    EFTnet or Net1

    Apparently there was a Net1 module written for Zencart, but it appears to have fallen off the face of the planet. I've found dozens references to the module for Zencart and dozens of requests for the module for other carts, but the module is simply gone. I've emailed the webmaster for the site that originally hosted it at the following url: http://cedar-park.net/net1.php. It's a 404 now. If anyone has this module, I will port it to oscommerce. Otherwise, I'll write it from scratch because that's the only option I have.
  2. This is, in fact, an issue with MySQL 5. Seems to be more picky with the placement of LEFT JOIN. It appears to assume the LEFT JOIN should be made from the table listed right before the LEFT JOIN command. To fix the problem, I moved products p to be right before the LEFT JOIN for the first query and did a few other rearrangements for the second query. Open includes/modules/featured_sets.php Around line 68, find the following code: $featured_manufacturer_products_query_raw = "select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_MANUFACTURERS_INFO . " mi left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '" . (int)$languages_id . "' and m.manufacturer_featured = '1' order by " . FEATURED_MANUFACTURER_SORT_ORDER . " " . FEATURED_MANUFACTURER_DIRECTION . " limit " . MAX_DISPLAY_FEATURED_MANUFACTURER; I replaced those two lines with one line: $featured_manufacturer_products_query_raw = "select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.pro ducts_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as f inal_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from " . TAB LE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_MANUFACTURERS_INFO . " mi, " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m. manufacturers_id = mi.manufacturers_id and mi.languages_id = '" . (int)$languages_id . "' and m.manufacturer_featured = '1' order by " . FEATURED_MANUFACTURER_SORT_ORDER . " " . FEATURED_MANUFACTURER_DIRECTION . " limit " . MAX_DISPLAY_FEATURED_MANUFACTURER Around line 98, find the following two lines of code: $featured_categories_query_raw = "select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.categories_featured_until, p.products_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where c.categories_featured = '1' and cd.language_id = '" . (int)$languages_id . "' and c.categories_id = cd.categories_id and c.categories_id = p2c.categories_id and cd.categories_id = p2c.categories_id and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' order by " . FEATURED_CATEGORIES_SORT_ORDER . " " . FEATURED_CATEGORIES_DIRECTION . " limit " . MAX_DISPLAY_FEATURED_CATEGORIES; Replace those two lines with the following line: $featured_categories_query_raw = "select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.categories_featured_until, p.products_id, p.products_price, p.prod ucts_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price , IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS_DESCRIP TION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TA BLE_SPECIALS . " s on p.products_id = s.products_id where c.categories_featured = '1' and cd.language_id = '" . (int)$languages_id . "' and c.categories_id = cd.categories_id and c.categories_id = p2c.categories_id and cd.categories_id = p2c.categories_id and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (in t)$languages_id . "' order by " . FEATURED_CATEGORIES_SORT_ORDER . " " . FEATURED_CATEGORIES_DIRECTION . " limit " . MAX_DISPLAY_FEATURED_CATEGORIES; That fixed the errors for me.
  3. Okay, I found another post where someone had the same problem and someone replied saying to change the Tare Weight in the Shipping/Packaging section of the Admin Config. That fixed the problem. I would have deleted my post, but I couldn't find the option to do so.
  4. I have the newest version of OsCommerce and have just installed the newest version of the UPS XML Rates. Everything seems to be working fine except for the weight. The module seems to be adding 3 pounds to all the items. I changed the configuration to show the weight in product listings. One item, for example, is 7 pounds, but when I add to cart and checkout the UPS option will show "1 pkg x 10 lbs total" I've installed everything right, as far as I know, so I don't have a clue why it's doing this. Anyone know?
×
×
  • Create New...