mikebt Posted July 28, 2010 Posted July 28, 2010 (edited) When I click to view the account history to go to customer account information, I see some 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 ''' at line 1 select count(*) as total from orders o, orders_status s where o.customers_id = '11' and o.orders_status = s.orders_status_id and s.language_id = '1' ' I have read there were errors about this type before but haven't found the right solution. Can someone please tell me what does this mean and is there a easy solution to this error? Edited July 28, 2010 by mikebt Quote
♥zelf Posted July 29, 2010 Posted July 29, 2010 select count(*) as total from orders o, orders_status s where o.customers_id = '11' and o.orders_status = s.orders_status_id and s.language_id = '1' ' It appears you have an extra apostrophe at the end of your sql statement that most likely should be a quote. Should be: "select count(*) as total from orders o, orders_status s where o.customers_id = '11' and o.orders_status = s.orders_status_id and s.language_id = '1'" Post the code from the file and line specified if this does not fix it. Quote Virtual Merchant a.k.a. Elavon, ViaKlix, Nova Payment Module Contribution
mikebt Posted July 29, 2010 Author Posted July 29, 2010 It appears you have an extra apostrophe at the end of your sql statement that most likely should be a quote. Should be: "select count(*) as total from orders o, orders_status s where o.customers_id = '11' and o.orders_status = s.orders_status_id and s.language_id = '1'" Post the code from the file and line specified if this does not fix it. Thanks for responding, but where is this file in order to edit this? Quote
♥zelf Posted July 29, 2010 Posted July 29, 2010 Thanks for responding, but where is this file in order to edit this? I would assume you are talking about /catalog/account_history.php or /catalog/account_history_info.php. If you have a code editor you can search for the first part of the sql statement. Just search for select count(*) in these two files and see if you can find the sql statement that is causing the error. Quote Virtual Merchant a.k.a. Elavon, ViaKlix, Nova Payment Module Contribution
mikebt Posted July 29, 2010 Author Posted July 29, 2010 I would assume you are talking about /catalog/account_history.php or /catalog/account_history_info.php. If you have a code editor you can search for the first part of the sql statement. Just search for select count(*) in these two files and see if you can find the sql statement that is causing the error. The account history seems to be working ok, its the ccbill error that I am worried about now. Any ideas on why when a customer completes an order, the download link that a customers get redirects to a page that doesnt work. It seems the approval urls from ccbill isnt the right urls. Could this be on my end. Any ideas? Quote
♥zelf Posted July 29, 2010 Posted July 29, 2010 The account history seems to be working ok, its the ccbill error that I am worried about now. Whoa! Totally switched problems on me there. Not familiar with ccbil. You will need to contact them for support on this one. Quote Virtual Merchant a.k.a. Elavon, ViaKlix, Nova Payment Module Contribution
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.