I'am new to the forum and I would appreciate help in resolving this problem.
I have installed oscommerce shopping cart, with a few modifications one of which is the return products mod.
It seems to work up until you request a return number which gives to 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 'returns (customers_id, rma_value, order_id, customers_name, cus
insert into returns (customers_id, rma_value, order_id, customers_name, customers_acct, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_fax, 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_acct, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, comments, returns_status, returns_reason, currency, currency_value) values ('23083448', '32027706556', '105701', 'Hubert Maniel', '', '', '851 Burnham Drive', '', 'University Park', '60466', 'Illinois', 'United States', '1708-534-5135', '', 'maniel@modchips-usa.com', '2', 'Hubert Maniel', '', '851 Burnham Drive', '', 'University Park', '60466', 'Illinois', 'United States', '2', 'Hubert Maniel', '', '', '851 Burnham Drive', '', 'University Park', '60466', 'Illinois', 'United States', '2', '', '', '5', 'USD', '1.000000')
[TEP STOP]
To see the form in action go to url - http://www.modchips-usa.com/store.osc/catalog/
Login - Email Address: maniel@modchips-usa.com
Password: crush
Click on view on one of the previous orders and find the return this product link. This will take you to the return number request page from there the error occurs.
Attached is the return product page's coding:
