Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

templste errors


nidger1999

Recommended Posts

Posted

ive installed template monster 50 on to my server, just to see what it looks like as a shop, im running php 5 and mysql 5.

the template gave me loads of errors, but ive followed most of the instructions on here, which are great and it worked, except of my third column. it still gave me an error 1054, i found out it was an error in the index.php file, but im no expert at php, im a real newbie.

but with seeing other adjustments to these templates, i would have a go at fixing the error myself, which i did..Lucky me, it worked..

This is My Website, Its Up about 80% of the time

 

i changed this below:-

Line 290, from:

$current_category_id = 62;
 $listing_sql = "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_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id 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 = '62' order by pd.products_name";
 $new_products_query = tep_db_query($listing_sql);

to:

$current_category_id = 62;
 $listing_sql = "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 " . 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, " . TABLE_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''" . (int)$languages_id . "' and p2c.categories_id = '62''" . (int)$current_category_id . "'";
 $new_products_query = tep_db_query($listing_sql);

 

i know the above works, but it displays a 3rd column, YOU ALSO LIKE, with pictures of products you have brought or like..

but it doesnt matter how many times i buy or look at different products, the pictures on the main index screen dont change..

they stay the same, and it wont email you once ive purcheased some thing.

 

is the code wrong somewhere, to make these pictures change, and what should i do to make the email work, is it something in my SQL.?

 

Thanks

Neil

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...