Oscommerce Account information error

[mikebt]

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

[♥zelf]

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.

[mikebt]

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?

[♥zelf]

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.

[mikebt]

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?

[♥zelf]

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.