Please Help Me!. 1064 Error

[dodgydave123]

Hello Guys,

 

First I'd like to say hello as im new here.

 

Im having a few problems with my site.

 

Im using CREloaded 6.2 (PHP5)

 

When i enter my store everything looks fine until i click on a product and i receive this error

 

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, 9' at line 11

 

select m.manufacturers_name, 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 p left join specials_retail_prices s using(products_id)) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, 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 = '100' order by limit 0, 9

 

[TEP STOP]

 

I have tried the fixes found on this forum but it doesnt seem to fix the error.

 

Anyhelp would be great please, Im at the end of my tether!!

 

Thanks Guys

[drillsar]

go to cre loaded support this oscommerce, also why you using 6.2? new one is 6.4

[♥mdtaylorlrim]

the problem is it is expecting a field name after "order by" and not a limit statement. As he said, cre loaded has their own support, but if you can find where that is and what creates it you may be able to fix it.

 

Have you been editing things yourself?

[dodgydave123]

the problem is it is expecting a field name after "order by" and not a limit statement. As he said, cre loaded has their own support, but if you can find where that is and what creates it you may be able to fix it.

 

Have you been editing things yourself?

 

I havent been editing anything, thats why im so confused by the error.

 

I had a few problems a few days ago and my host resolved the issue. I didnt have time to check the site in depth I just checked the homepage and all looked ok. However entering categories I get the error.

 

Thanks for your help guys! :)