Database Syntax Error Help

[gallactor72]

The Basics: I'm using v2.2 of osCommerce with PWA(1.1.2), Moneris and CC payment modules, and UPS XML shipping module. When I attempt to edit orders, or click on the invoice or packing slip - I get the following 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 'select customers_name, customers_company, customers_street_addre

select customers_id, select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '1'

[TEP STOP]

 

Everything else in the Admin panel seems to be working the way it should. Can someone point me to the right page I should be looking at? I realize that the mistake is probably a typo or something but I'm not sure where to start looking. Any help would be greatly appreciated.

 

Cheers,

Tim

[Jan Zonjee]

I get the following 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 'select customers_name, customers_company, customers_street_addres

Can someone point me to the right page I should be looking at? I realize that the mistake is probably a typo or something but I'm not sure where to start looking.

Looks like you made a typo in admin/includes/classes/order.php. The trouble spot is in the function query (starts at line 27). You can't have two select statements in there: select customers_id, select customers_name, customers_company....

[gallactor72]

Looks like you made a typo in admin/includes/classes/order.php. The trouble spot is in the function query (starts at line 27). You can't have two select statements in there: select customers_id, select customers_name, customers_company....

 

Woohoo! That fixed the problem! Thank you for your help. I greatly appreciated it.

 

Cheers,

Tim