dodgydave123 Posted February 26, 2010 Posted February 26, 2010 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 Posted February 26, 2010 Posted February 26, 2010 go to cre loaded support this oscommerce, also why you using 6.2? new one is 6.4
♥mdtaylorlrim Posted February 26, 2010 Posted February 26, 2010 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? Community Bootstrap Edition, Edge Avoid the most asked question. See How to Secure My Site and How do I...?
dodgydave123 Posted February 26, 2010 Author Posted February 26, 2010 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! :)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.