mysql errors, Urgent help needed

[Guest]

Hi,

 

I have some errors in mysql and i hope that someone can help as i don't have alot of experience with these, and its causing errors on my site.

 

First, when i try to upload a file from easypopulate it does about the first 1000 fine, then at the bottom of the screen it has the 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 '0,0, CURRENT_TIMESTAMP ,CURRENT_TIMESTAMP)' at line 1

 

INSERT INTO categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified ) VALUES (184,,0,0, CURRENT_TIMESTAMP ,CURRENT_TIMESTAMP)

 

Second, with paypalipn enabled, when you come to the order confirmation page, after chooseing paypal, you get the error:

 

1062 - Duplicate entry '0' for key 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 ('49', 'Customer Name', '', 'Customer Address', '', 'Customer Town', 'Customer Postcode', 'United Kingdom', 'United Kingdom', 'Customer Phonne', 'Customer Email', '1', 'PayPal (Credit Card / Debit)', '', '', '', '', now(), '5', 'GBP', '1.00000000')

 

 

Does anyone know how to fix these problems?

 

Many Thanks for any help