Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

fredfillah

Archived
  • Posts

    71
  • Joined

  • Last visited

Profile Information

  • Real Name
    fred
  • Location
    Maryland, USA

fredfillah's Achievements

  1. I tried to install this and there are some strange things happening. The attribute prices are still showing up in the pull down menus as +/- the base price...I thought this contrib showed the final adjusted price so that customers don't have to add and substract. Also, once an item is in the shopping cart, the pricing is wacky. If an item is added with a + attribute, the price seems to work...it only shows the final price, but if I add a $0 attribute, then the final price is $0 and it's also scratched out. Here's my test site to demonstrate. My Webpage Any assistance would be greatly appreciated. Thanks, Fred
  2. I've installed the product_listing_col contrib and I am getting the following 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 'select p.products_image, pd.products_name, p.products_id, p.ma select count(select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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 p, products_description pd, manufacturers m left join 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 = \'1\' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = \'17\' order by pd.products_name) as total This sql is being passed from index.php as $listing_sql, however I'm having trouble debugging....anyone seen this before? Thanks, Fred
  3. I just installed this (twice) and there seems to be something wrong. I'm working with 2.2-MS2. There are 2 issues: 1. on product_info.php page, the attributes are still showing the prefix (+/-). I thought this contrib shows the total pricing (instead of +/-). 2. when I add something to the shopping cart, the Total price column shows the price with a line through it and $0.00 under it. I've tried both the "Simple" and "Advanced" configuration...no change. My site is http://67.18.24.57. I would be tremendously grateful for any assistance. Thanks, Fred
  4. Here's the fix (thanks dreamscape). http://www.oscommerce.com/forums/index.php?showtopic=80361
  5. Thanks for the contrib. So, I'm having a similar issue to quin, however I've arranged the sort order to: Sub-total - 1 Qty Discount - 2 Tax - 3 Shipping - 4 Total - 5 The Total is displaying correctly (including discount) on the order confirmation page, however when I process the credit card trxn the full amount is being charged. Any thoughts on what might be causing this? Thanks, Fred
  6. I got this working on 2.2ms2 with a few changes to the contribution (noted below). admin/categories.php 2. change si($additional to sizeof($additional 3. change tep_db_query("de from...to tep_db_query("delete 4. I had to change permissions on the images file (you may not have to). Change perms as follows (UNIX) chmod 644 button_images_*.gif catalog/popup_image.php $products_values should be $products (see below) should be... <?php echo tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], POPUP_IMAGE_WID TH, POPUP_IMAGE_HEIGHT); ?>
  7. I am having the same problem with Featured Products contrib (with the rotate add-on) and osC 2.2. The workaround (hack) to disable the "Featured Products" link is to: 1) Comment out the SQL query that fails in catalog/featured_prorducts.php around line 56. Comment out the following lines /* Disable Featured Product link $featured_products_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by p.products_date_added DESC, pd.products_name"; $featured_products_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_FEATURED_PRODUCTS_LISTING, $featured_products_query_raw, $featured_products_numrows); $featured_products_query = tep_db_query($featured_products_query_raw); while ($featured_products = tep_db_fetch_array($featured_products_query)) { $featured_products_array[] = array('id' => $featured_products['products_id'], 'name' => $featured_products['products_name'], 'image' => $featured_products['products_image'], 'price' => $featured_products['products_price'], 'specials_price' => $featured_products['specials_new_products_price'], 'tax_class_id' => $featured_products['products_tax_class_id'], 'date_added' => tep_date_long($featured_products['products_date_added']), 'manufacturer' => $featured_products['manufacturers_name']); } */ 2) Comment out the line that creates the link. It in catalog/includes/functions/featured.php around line 67. Comment out the line // $info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>'); and add $info_box_contents[] = array('align' => 'left', 'text' => TABLE_HEADING_FEATURED_PRODUCTS ); I'm using MySQL v4.0.13. Which version are you using? Anyway, this worked for me...good luck.
×
×
  • Create New...