HELP.
I installed Paypal IPN v2.1 and everything seemed fine. I had 1 order and now when I try to put an order through whether live or testing I get the following error message. What have I done wrong. It doesn't happen with ordinary paypal
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 ('47', 'fred flintstone', '', '123 fred street', '', 'anytown', 'FL3 5TG', 'somewhere', 'United Kingdom', '001236547896', '
[email protected]', '1', 'fred flintstone', '', '123 fred street', '', 'anytown', 'FL3 5TG', 'somewhere', 'United Kingdom', '1', 'fred flintstone', '', '123 fred street', '', 'anytown', 'FL3 5TG', 'somewhere', 'United Kingdom', '1', 'Credit/Debit Card (via PayPal)', '', '', '', '', now(), '4', 'GBP', '1.00000000')
[TEP STOP]
Array
(
[0] => Array
(
[file] => /homepages/21/d189605165/htdocs/dropship/includes/functions/database.php
[line] => 44
[function] => tep_db_error
[args] => Array
(
[0] => 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 ('47', 'fred flintstone', '', '123 fred street', '', 'anytown', 'FL3 5TG', 'somewhere', 'United Kingdom', '001236547896', '
[email protected]', '1', 'fred flintstone', '', '123 fred street', '', 'anytown', 'FL3 5TG', 'somewhere', 'United Kingdom', '1', 'fred flintstone', '', '123 fred street', '', 'anytown', 'FL3 5TG', 'somewhere', 'United Kingdom', '1', 'Credit/Debit Card (via PayPal)', '', '', '', '', now(), '4', 'GBP', '1.00000000')
[1] => 1062
[2] => Duplicate entry '0' for key 1
)
)
[1] => Array
(
[file] => /homepages/21/d189605165/htdocs/dropship/includes/functions/database.php
[line] => 95
[function] => tep_db_query
[args] => Array
(
[0] => 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 ('47', 'fred flintstone', '', '123 fred street', '', 'anytown', 'FL3 5TG', 'somewhere', 'United Kingdom', '001236547896', '
[email protected]', '1', 'fred flintstone', '', '123 fred street', '', 'anytown', 'FL3 5TG', 'somewhere', 'United Kingdom', '1', 'fred flintstone', '', '123 fred street', '', 'anytown', 'FL3 5TG', 'somewhere', 'United Kingdom', '1', 'Credit/Debit Card (via PayPal)', '', '', '', '', now(), '4', 'GBP', '1.00000000')
[1] => db_link
)
)
[2] => Array
(
[file] => /homepages/21/d189605165/htdocs/dropship/includes/modules/payment/paypal_ipn.php
[line] => 180
[function] => tep_db_perform
[args] => Array
(
[0] => orders
[1] => Array
(
[customers_id] => 47
[customers_name] => fred flintstone
[customers_company] =>
[customers_street_address] => 123 fred street
[customers_suburb] =>
[customers_city] => anytown
[customers_postcode] => FL3 5TG
[customers_state] => somewhere
[customers_country] => United Kingdom
[customers_telephone] => 001236547896
[customers_email_address] =>
[email protected]
[customers_address_format_id] => 1
[delivery_name] => fred flintstone
[delivery_company] =>
[delivery_street_address] => 123 fred street
[delivery_suburb] =>
[delivery_city] => anytown
[delivery_postcode] => FL3 5TG
[delivery_state] => somewhere
[delivery_country] => United Kingdom
[delivery_address_format_id] => 1
[billing_name] => fred flintstone
[billing_company] =>
[billing_street_address] => 123 fred street
[billing_suburb] =>
[billing_city] => anytown
[billing_postcode] => FL3 5TG
[billing_state] => somewhere
[billing_country] => United Kingdom
[billing_address_format_id] => 1
[payment_method] => Credit/Debit Card (via PayPal)
[cc_type] =>
[cc_owner] =>
[cc_number] =>
[cc_expires] =>
[date_purchased] => now()
[orders_status] => 4
[currency] => GBP
[currency_value] => 1.00000000
)
)
)
[3] => Array
(
[file] => /homepages/21/d189605165/htdocs/dropship/includes/classes/payment.php
[line] => 182
[function] => confirmation
[class] => paypal_ipn
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] => /homepages/21/d189605165/htdocs/dropship/checkout_confirmation.php
[line] => 257
[function] => confirmation
[class] => payment
[type] => ->
[args] => Array
(
)
)
)
Sorry if this is covered elsewhere in the thread. I did look and couldn't find anything similar
Thanks