Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

briggers

Pioneers
  • Posts

    13
  • Joined

  • Last visited

Profile Information

  • Real Name
    Richard Brignall
  • Gender
    Male
  • Location
    Bracknell, UK

briggers's Achievements

  1. Enrico, This looks as though you have an extra \.\ somewhere in a file path definition, check your /catalog/admin/configure.php file Richard
  2. Helen, The line is the file system path. On windows it would be something like c:\inetpub\sitename\catalogue\images the line should be whatever you use to browse to the shop home page (on your localhost) followed by /images/ Richard
  3. Addition to post #59 above It seems that after adding a new category (see point 2) it is necessary to "Reset" the cache. Then the new category shows every time. Would it be possible to automatically clear the cache after adding a new category?
  4. Hi Jim, This looks to be an excellent contribution, but I have 2 problems with it. 1. If a category has been selected and therefore expanded, clicking on the top level category does not go back to the top level category page, it stays on the same page but closes the category drop down. To get back to the top level category it is necessary to either click on the category in the breadcrumb or to select another category, then the first one. 2. After adding a new category and a couple of products the new category shows the first time the home page is viewed, but then disappears never to be shown again. Trying again in a different browser again shows the new category the first time a page is viewed but never again. So it looks like a cacheing issue but I'm not sure where to start looking. This installation is the first mod installed on a stock clean osc2.3.1 base Do you have any ideas? Thanks
  5. This is the support thread for the contribution: CKEditor with KFM Filemanager at: http://addons.oscommerce.com/info/8302 I can only answer queries through this forum.
  6. Image enlargement on slave product Has anyone been able to add a "pop-up" enlargement to the image for a slave product in the list of slave products and if so can you give me any idea as to where is the right place. Thanks
  7. I confirm that the changes are to: product_info.php around line 290 change $master_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_master LIKE '%" . $HTTP_GET_VARS['products_id'] . "%'"); to $master_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_master = " . $HTTP_GET_VARS['products_id']); and in includes/modules/master_products.php change line 19 from $master_query = tep_db_query("select products_master from " . TABLE_PRODUCTS . " where products_master LIKE '%" . $HTTP_GET_VARS['products_id'] . "%'"); to $master_query = tep_db_query("select products_master from " . TABLE_PRODUCTS . " where products_master = " . $HTTP_GET_VARS['products_id']); change line 70 from $master_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_tax_class_id, s.specials_new_products_price, s.status, p.products_price from ". TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_master LIKE '%" . $HTTP_GET_VARS['products_id'] . "%' and p.products_status = '1' and pd.language_id = '" . (int)$languages_id . "'"; to $master_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_tax_class_id, s.specials_new_products_price, s.status, p.products_price from ". TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_master = " . $HTTP_GET_VARS['products_id'] . " and p.products_status = '1' and pd.language_id = '" . (int)$languages_id . "'"; Note that you can only assign a slave product to 1 master product
  8. Hi All, This is a great Contribution. It works fine for 2 sites we run and will be incorporated into a further two in the next couple of weeks.# But we have a small "oddity"... Some Master products have listed not just their own Slave products, but also Slave products from a different Master. It looks as though it is due to a query using a "LIKE" clause because the error occurs where the product_id of the master is part of the product_id of another Master product. So we get Master 1 (product_id = 55) Slave 1 of Master 1 Slave 2 of Master 1 Slave 1 of Master 2 (where Master 2 has product_id of 155) Slave 2 of Master 2 I think the erroneous statement is in "/product_info.php" at about line 290, i.e $master_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_master LIKE '%" . $HTTP_GET_VARS['products_id'] . "%'"); where the clause ... where products_master LIKE '%" . $HTTP_GET_VARS['products_id'] . "%'" will select any item whose id contains (in my example above) 55 I am using Master Products 1.5 Has anyone else found the problem and have I got the right place for a correction, which I think should be to drop the leading %, ie: $master_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_master LIKE '" . $HTTP_GET_VARS['products_id'] . "%'"); or to make the LIKES Equals (=) i.e $master_query = tep_db_query("select products_id from " . TABLE_PRODUCTS . " where products_master = " . $HTTP_GET_VARS['products_id'] ); Thanks
  9. If you are making the mods as an update to an existing installation (i.e. making the mods manually) you also need to change an entry in the database table "countries" Change the address_format_id field for the entry United Kingdom from 1 to 2 and Change the address_format_id field for the entry United States from 2 to 1 This field refers to another table "address_format" in which you can define a number of country specific formats for addresses. You may want the change the countries|address_format_id field for other countries depending on where you expect to sell. Great contribution and thanks to all who have contributed!
×
×
  • Create New...