Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

medianetwork

Archived
  • Posts

    2
  • Joined

  • Last visited

Profile Information

  • Real Name
    Maureen Otto

medianetwork's Achievements

  1. I installed RSS Feed v2.2 INSTALL by faaliyet. I did not do Step 1 nor did I do anything with adminsettings.sql as there were no instructions as to where to put it. The instructions did not say to upload it. I completed Step 2 - to the end and it resulted in: 1054 - Unknown column 'p.products_to_rss' in 'where clause' select p.products_id, p.manufacturers_id, p.products_model, p.products_price, p.products_image, p.products_date_added, pd.products_name, pd.products_description, m.manufacturers_name, cd.categories_name, 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_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 LEFT JOIN categories_description cd ON p2c.categories_id = cd.categories_id where p.products_status = '1' and p.products_to_rss='1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' GROUP BY p.products_id ORDER BY p.products_id DESC LIMIT 0 [TEP STOP] Could someone please tell me what I must do in order to make this work? The site is at http://interactive-media-network.com/account I would appreciate hearing from someone. Thank you!
  2. I have installed RSS Feed v2.2 INSTALL by faaliyet however I cannot get it to work. It states: 1054 - Unknown column 'p.products_to_rss' in 'where clause' select p.products_id, p.manufacturers_id, p.products_model, p.products_price, p.products_image, p.products_date_added, pd.products_name, pd.products_description, m.manufacturers_name, cd.categories_name, 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_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 LEFT JOIN categories_description cd ON p2c.categories_id = cd.categories_id where p.products_status = '1' and p.products_to_rss='1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' GROUP BY p.products_id ORDER BY p.products_id DESC LIMIT 0 [TEP STOP] I did not understand Step 1 or what to do with the adminsettings.sql. There was no mention of uploading it in the instructions or where to go, or what to do with it. I did Step 2 to the end and it resulted in the error mention above. Could someone please tell me what I must do to correct this? Every page states the same thing. I would appreciate hearing from someone. The site is http://interactive-media-network.com/account Thank you!!
×
×
  • Create New...