I have set up a magento store with 5 stores for different sections of the charity. My problem exists in one store only 'fundraising'. The issue is this:
when a ticket is purchased through the store and paid for via PayPal standard, the transaction is not captured and no invoice is created. If I try to manually create the invoice I get the following error 'Unable to save the invoice'.
Please see contents of the log file below:
2015-05-05T11:20:34+00:00 ERR (3):
exception 'PDOException' with message 'SQLSTATE: Integrity constraint violation: 1062 Duplicate entry 'INV100000001' for key 'UNQ_SALES_FLAT_INVOICE_INCREMENT_ID'' in lib/Zend/Db/Statement/Pdo.php:228
There is lots more the log is huge, I thought that line was the problem. I seriously stuck here so any help would be massively appreciated