Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
    Chris Hood
  1. Thanks for a wonderful contribution! I've installed this and it's working perfectly, I've got one (hopefully simple) question. What all would need to be changed if I wanted this page named distributor.php (as opposed to wholesale.php)? Sorry for the newbie question, I'm still learning php. Thanks!
  2. shubee

    [Contribution] Product Sort Order

    After installing this mod, when I go to view my products I receive this error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC limit 0, 99' at line 1 select p.products_sort_order, p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_sort_order, 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 products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '8' order by p.products_sort_order asc ASC limit 0, 99 [TEP STOP] I've searched through this forum and can't seem to find an answer for where things went wrong. Initially I had some trouble getting the product_sort.sql to run properly, but managed to get it to work thanks to daveboyce's suggestion. I'm no programmer by any means, but I'm usually able to work my way through most problems I've caused for myself. Any ideas as to why I'm receiving this error and what to do about it? Thanks!
  3. shubee

    Get 1 Free

    Well, I think I've figured out my problem here. Our site was built on STS (before I came on board...). It took me a while to find the correct files used to create the product pages, which are buried under /catalog/includes/modules/sts_inc/... Has anyone else had success installing this contribution on an STS cart? This contribution is exactly what I'm looking for, any pointers on installing it would be greatly appreciated. Thanks! Chris
  4. shubee

    Get 1 Free

    Thanks for the quick reply. I'll look into it further this evening!
  5. shubee

    Get 1 Free

    I'm having a couple of problems that really have me scratching my head. I'm no programmer by any means, but I can usually work through most of the problems I run in to, these have me stumped: I'm running a fairly well modded cart w/ STS and several contributions www.shubee.com. After installing this contribution, the basic functionality works rather well, however: 1. I can't get any text to display anywhere regarding Get 1 Free. I've included the code in product_info.php, but nothing shows on my product pages - not even in the page source. I even tried to implement J Geoff's patch to include the text on all product pages but no luck. 2. When the user adds the necessary quantity to get 1 free, the cart successfully adds one free product (still no mention of getting one free though) seen here: -> however if they later updates their cart to have less than the minimum quantity to receive their free gift, the free item is removed and seems to be replaced with an item at regular price: Even stranger, if they later updated their cart again to include the free gift, the extra item that was added at regular price stays in the cart. I'd love to be able to use this contribution, but can't seem to wrap my head around where my problems are. Any help will be greatly appreciated!