Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

moisea

Archived
  • Posts

    117
  • Joined

  • Last visited

Profile Information

  • Real Name
    moise

moisea's Achievements

  1. hello, i installed wislist 3.0 on my osc site whic was working perfectly fine on my localhost until i decided to upload it on my server. now i am getting the following error messages eventhough no changes or contributions have been added... 1054 - Unknown column 'p.products_id' in 'on clause' select pd.products_id, pd.products_name, pd.products_description, 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, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = '3' and p.products_id = pd.products_id and pd.language_id = '1' order by products_name [TEP STOP] i checked on my page and found out that, i get this error when i logged in as a registered customer.i also read few posts suggesting to replace 'p.products_id' by 'pd.products_id' but i don't know which file to make the change from. is it from the index.php file or.....? need help here please. finally, would i need to update to the 3.5d wishlist version? many thanks...
  2. any ideas please, getting desperate here. thanks
  3. hello, i would like to know if there is a contribution presenting images in php this way? with 3 or two small images that would allow me to just hover over one in order to see it on top in a larger image. any contribution? thanks for your help.
  4. hello forum, i would like know if anyone has an idea on how get the product description to display LIKE IN HERE. Is there a contribution for this? serious help needed please!!!!!!!!!! hope to hear from you soon........ many thanks.
  5. hi, did anyone try to install master products combined with the family products contibutions? i tried but failed as both contribs look similar. - they both have this same sql line INSERT INTO configuration_group VALUES (16, 'Master Products', 'Master Products - configuration options', 16, 1); however, to try to solve this problem i did for the Family products sql the following code. INSERT INTO configuration_group VALUES (17, 'Family Products', 'Family Products - configuration options', 17, 1); here i changed the values of 16 (default) to 17 and i did not get any error. - Also in admin/categories.php i tried to accomodate both contribs and i do get a parse error from the family products contrib. bit and catalog menu in admin only opens up if the Family products codes are cancelled out but without any button showing. // Master Products 'products_listing_status' => tep_db_prepare_input($HTTP_POST_VARS['products_listing_status']), 'products_master_status' => tep_db_prepare_input($HTTP_POST_VARS['products_master_status']), 'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']), 'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id']), 'products_master' => tep_db_prepare_input($HTTP_POST_VARS['products_master'])); // Master Products EOF // Family Products 'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id']), 'products_family' => tep_db_prepare_input($HTTP_POST_VARS['products_family'])); // Family Products EOF anyone knows how to fix this? how to merge Master products and family products contibutions? :blush: :blush: :blush: :( many thanks.
  6. hi, i was wondering if there was a way of combinning familly products and master products as both of then look quite similar. i was told that the latter was inspired from the first one. i tried to do this but got stuck on this sql file INSERT INTO configuration_group VALUES (16, 'Master Products', 'Master Products - configuration options', 16, 1); which are on both contributions. was thinking of using the one above and this INSERT INTO configuration_group VALUES (17, 'Family Products', 'Family Products - configuration options', 17, 1); any idea?
  7. Hi, i have resolved the problem, thank you all for your help. :thumbsup:
  8. hi matti, i reinstalled osc ms2 (clean shop) and tried to installed the master products version 1.1.5 contrib as advised, however, i am still getting the following error eventhough no changes to site being made. i do not know where this come from. :( any idea on how to solve my problem? many thanks.
  9. hello, i tried the master products contribution version 1.1.5 and i ended up having a database error. i discussed about this subject on here without any success. so in came on here in order to try my luck. anybody encountered the same problem? seriously need help. many thanks.
  10. hi flex5150, i am having some problemes with contrib. i have installed the last post of matti/johnson but somehow i am getting the following the error 1054 - Unknown column 'p.products_listing_status' in 'where clause' select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_listing_status = '1' order by p.products_date_added desc limit 9 [TEP STOP] can someone please help? thanks
  11. hello, i would like to know how to get product_listing to alternate list , using a mouseover css, when it displays lets say two or more items. Same style as in mystore/catalog/admin/ under configuration displaying my store attributes. many thanks.
×
×
  • Create New...