Guest Posted July 31, 2006 Share Posted July 31, 2006 Hi guys, Got myself an SQL error after I tried to delete a user I added while trying the DEMO site (default install) Here's the details: Clients Total commande Date d'achat Statut Action 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 '-20, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '4' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 TEP STOP] Could someone assist? Thx Link to comment Share on other sites More sharing options...
Jack_mcs Posted July 31, 2006 Share Posted July 31, 2006 There is a fix for that in the security update contribution. Look for the change for the split_page_results.php file. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Guest Posted July 31, 2006 Share Posted July 31, 2006 There is a fix for that in the security update contribution. Look for the change for the split_page_results.php file. Jack Oh god... Am a newbie on oscommerce. Trying it as an alternative to Mambo's e-commerce solutions. Euh, could you please be more specific. Like where do I get that patch? :'( Yves Link to comment Share on other sites More sharing options...
Guest Posted July 31, 2006 Share Posted July 31, 2006 http://www.oscommerce.com/community/bugs,1605 fix at the end of the page http://www.oscommerce.com/solutions/downloads latest package includes all fixes. Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 1, 2006 Share Posted August 1, 2006 Oh god... Am a newbie on oscommerce. Trying it as an alternative to Mambo's e-commerce solutions. Euh, could you please be more specific. Like where do I get that patch? :'( Yves Per you PM, what further information do you need? The threads Mark mentioned contain the solution. Are you having trouble with how to edit the files? One of the strengths of oscommerce is that it is easily changed. Unfortunately, that can also be a curse since you need to make such changes yourself (or hire someone to do them). If you can be more specific with what problem you are having, then someone will help you. It is not difficult but can be intimidating initially. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Guest Posted August 1, 2006 Share Posted August 1, 2006 http://www.oscommerce.com/community/bugs,1605fix at the end of the page http://www.oscommerce.com/solutions/downloads latest package includes all fixes. Thanks to all of you pepople. The responses has been fast and you're a reliable bunch. :thumbsup: I did find the fix just before the last reply to my post by reading the Annoncement section. A recent announce, "osCommerce 2.2 Milestone 2 051112 Update Released", explains that the split page result bug I had is a known bug that has been fixed in that release. Again thx all. YvesDL Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.