Guest Posted January 20, 2009 Share Posted January 20, 2009 I added "MSRP modification by Kevin L. Shelton 9-22-2005 revised for RC2a 4-25-08 Display MSRP & Savings" That I got off of the contributions section. I have double checked all the changes and I did it exactly as it reads. Now when I click on a category I get the error below. And if I click on a product I just get a blank page. Will someone please give me some good advice. Thanx, Shawn 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 ' p.products_price) as final_price from products_description pd, products p left ' at line 1 select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_msrp, 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_msrp, 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 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 = '22' order by pd.products_name limit 0, 20 [TEP STOP] Link to comment Share on other sites More sharing options...
Guest Posted January 20, 2009 Share Posted January 20, 2009 Oh yeah, The admin side looks fine. The changes took affect there. Link to comment Share on other sites More sharing options...
Guest Posted January 22, 2009 Share Posted January 22, 2009 Okay, I went thru all the code again and I did find an error on my part. Now everything is working except for the product info page. When you click on a profuct to see it. just a blank page comes up. I went thru everything once again and everything looks exactly the way it should. Will someone plese help me. Thank You, Shawn Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.