Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 - You have an error in your SQL syntax


Guest

Recommended Posts

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

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

Archived

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

×
×
  • Create New...