Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1064 SQL syntax error??


Iniquityclothing

Recommended Posts

hi folks getting this error when trying to search my manufacturer

 

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 'LIMIT 0, 30' at line 1

 

SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id = LIMIT 0, 30

 

any thoughts?

View recent 'helpfull' threads:

 

403 Error problems | Ultimate SEO (contribution support)

Link to comment
Share on other sites

also getting this error when searching for items:

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%016%' or p.products_model like '%016%' or m.manufacturers_name like '%016%') )

 

[TEP STOP]

View recent 'helpfull' threads:

 

403 Error problems | Ultimate SEO (contribution support)

Link to comment
Share on other sites

hi folks getting this error when trying to search my manufacturer

 

any thoughts?

 

That looks like this problem:

http://www.oscommerce.com/forums/index.php?sho...mp;#entry697026

 

Are you not using the most recent release of 2.2?

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...