dodgydave123 Posted February 26, 2010 Share 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 Link to comment Share on other sites More sharing options...
drillsar Posted February 26, 2010 Share Posted February 26, 2010 go to cre loaded support this oscommerce, also why you using 6.2? new one is 6.4 Link to comment Share on other sites More sharing options...
♥mdtaylorlrim Posted February 26, 2010 Share 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...? Link to comment Share on other sites More sharing options...
dodgydave123 Posted February 26, 2010 Author Share 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! :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.