SQL Problem. argh someone please help

[Guest]

Hi ,

Can someone please help me.

When someone checks out and completes an order.

this error comes ups

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 '), '2102', 'AUD', '1.00000000')' at line 1

 

insert into orders (customers_id, 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, date_purchased, orders_status, currency, currency_value) values ('36', 'greg burridge', '', '7 test rd', '', 'new south wales', '4000', '', 'Australia', '614111111', '[email protected]', '1', 'test me', '', '7 test rd', '', 'brisbane', '4000', '', 'Australia', '1', 'test me', '', '7 test rd', '', 'brisbane', '4000', '', 'Australia', '1', 'Bank Transfer Payment', '', '', '', '', date_add(now(), INTERVAL HOUR), '2102', 'AUD', '1.00000000')

 

[TEP STOP]

 

I am going nuts.. i cannot seem to fix this problem

can someone please help me

 

thanks

 

greg

[muskokee]

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 '), '2102', 'AUD', '1.00000000')' at line 1

greg

 

Hi Greg,

 

try this thread

 

Sheri

[Guest]

try locating the query and change this part

 

date_add(now(), INTERVAL HOUR)

 

to

 

date_add(now(), INTERVAL 1 HOUR)