Duplicate Invoice

[directprint]

Noticed this in the log.

Jul 14 2008 16:36 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

[DrByte]

Somehow your PayPal table must have bad structure, because it's failing at the point where it stores transaction data to the table named "paypal" (or whatever your table-prefix is, plus "paypal").

Can you use phpMyAdmin and dump out just the structure of the "paypal" table to text/SQL format, and post it here?

[DrByte]

Noticed this in the log.

Jul 14 2008 16:36 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us.

That's an expected response in many cases.

[directprint]

Structure of Paypal table

DROP TABLE IF EXISTS `paypal`;
CREATE TABLE `paypal` (
`paypal_ipn_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int(11) unsigned NOT NULL DEFAULT '0',
`txn_type` varchar(40) NOT NULL DEFAULT '',
`module_name` varchar(40) NOT NULL DEFAULT '',
`module_mode` varchar(40) NOT NULL DEFAULT '',
`reason_code` varchar(40) DEFAULT NULL,
`payment_type` varchar(40) NOT NULL DEFAULT '',
`payment_status` varchar(32) NOT NULL DEFAULT '',
`pending_reason` varchar(32) DEFAULT NULL,
`invoice` varchar(128) DEFAULT NULL,
`mc_currency` char(3) NOT NULL DEFAULT '',
`first_name` varchar(32) NOT NULL DEFAULT '',
`last_name` varchar(32) NOT NULL DEFAULT '',
`payer_business_name` varchar(128) DEFAULT NULL,
`address_name` varchar(64) DEFAULT NULL,
`address_street` varchar(254) DEFAULT NULL,
`address_city` varchar(120) DEFAULT NULL,
`address_state` varchar(120) DEFAULT NULL,
`address_zip` varchar(10) DEFAULT NULL,
`address_country` varchar(64) DEFAULT NULL,
`address_status` varchar(11) DEFAULT NULL,
`payer_email` varchar(128) NOT NULL DEFAULT '',
`payer_id` varchar(32) NOT NULL DEFAULT '',
`payer_status` varchar(10) NOT NULL DEFAULT '',
`payment_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`business` varchar(128) NOT NULL DEFAULT '',
`receiver_email` varchar(128) NOT NULL DEFAULT '',
`receiver_id` varchar(32) NOT NULL DEFAULT '',
`txn_id` varchar(20) NOT NULL DEFAULT '',
`parent_txn_id` varchar(20) DEFAULT NULL,
`num_cart_items` tinyint(4) unsigned NOT NULL DEFAULT '1',
`mc_gross` decimal(7,2) NOT NULL DEFAULT '0.00',
`mc_fee` decimal(7,2) NOT NULL DEFAULT '0.00',
`payment_gross` decimal(7,2) DEFAULT NULL,
`payment_fee` decimal(7,2) DEFAULT NULL,
`settle_amount` decimal(7,2) DEFAULT NULL,
`settle_currency` char(3) DEFAULT NULL,
`exchange_rate` decimal(4,2) DEFAULT NULL,
`notify_version` decimal(2,1) NOT NULL DEFAULT '0.0',
`verify_sign` varchar(128) NOT NULL DEFAULT '',
`last_modified` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`date_added` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
`memo` text,
PRIMARY KEY (`paypal_ipn_id`,`txn_id`),
KEY `idx_order_id_zen` (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

[directprint]

Just received an order from overseas that didn't create a duplicate invoice, but it has no invoice details and paypal ipn appears to have not communicated with the store to verify the order. However checking my paypal account, the money is there and the transaction.

Stange things are happening.

[DrByte]

Most bizarre. That's the correct table structure, and the data it's trying to submit fits within the field lengths and matches the required data types. Quite strange.

[directprint]

Should I just do a fresh install into another directory and use the same database to see if it causes any problems, I haven't added many mods apart from the direct debit payment option.

I can also try using a fresh database and if all works I can just try and import all the products I have added. Might need help with what tables to import.

[DrByte]

It's worth a test of a fresh setup, sure.

[directprint]

I guess that will be the next plan, stay tuned to this stange problem.

[directprint]

Sent a PM, still have the same problem with fresh install and new database, so this must be some bug in 1.3.8a