Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 in products new


nihanshe

Recommended Posts

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_image, p.products_price, p.products_tax_class_id, p.products_date_ad' at line 1

 

select p.products_quantity, p.products_id,.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added DESC, pd.products_name limit 0, 8

 

[TEP STOP]

 

http://turnedpens.co.uk/catalog/products_new.php

 

Regards Kirsty

Link to comment
Share on other sites

select p.products_quantity, p.products_id,.products_name, p.products_image, p.products_price,

 

should be

 

select p.products_quantity, p.products_id, pd.products_name, p.products_image, p.products_price,

 

B)

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

select p.products_quantity, p.products_id,.products_name, p.products_image, p.products_price,

 

should be

 

select p.products_quantity, p.products_id, pd.products_name, p.products_image, p.products_price,

 

B)

 

Hi thanks for the reply I can see the mistake but I have not got a clue how to rectify this problem, looked within DB but thats all just looked, be great if you could throw some more light on this, still a newby sorry.

 

Kind regards Kirsty

Link to comment
Share on other sites

Hi thanks for the reply I can see the mistake but I have not got a clue how to rectify this problem, looked within DB but thats all just looked, be great if you could throw some more light on this, still a newby sorry.

 

Kind regards Kirsty

 

Ok I'm now begging on my knees to get this sorted spent hours trying to sort this error but still no luck just going round in circles guys please help.

Regards Kirsty

Link to comment
Share on other sites

Ok I'm now begging on my knees to get this sorted spent hours trying to sort this error but still no luck just going round in circles guys please help.

 

the original message you posted has the information in it... catalog/products_new.php - somewhere in this file is a call to tep_db_query() with the aforementioned select statement. just scan through the file until you find it and then fix it as spooks suggested.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...