I have HSBC installed and recently installed Paypal IPN Module 1.3. Getting the dreaded 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, ........]
I think it's to do with the order_id as HSBC creates a random number whilst Paypal does an autoincrement - right? How can I change the Paypal IPN to reflect the same style of random order number as HSBC? Either that or change HSBC to be similar to Paypal order id (I don't mind).
Sorry if I am repeating something already on the board but I have searched for a number of hours and can't find a detailed solution.
Thanks