Hi all,
I had the same problem and I resolved it:
After I upgraded to VM 2.6.17 Paypal still didn't notify payments. The problem was in the table [DBPREFIX]_virtuemart_payment_plg_paypal. Upgrading process didn't update the table structure.
Maybe you have to remove Paypal method from Payment Method List and recreate it and the table is updated.
I recreated the table directly to DB with the query below (my previous table was empty) and all works fine.
Joomla 2.5.28
VM 2.6.17
Regards,
Fra
CREATE TABLE IF NOT EXISTS `x94uf_virtuemart_payment_plg_paypal` (
`paypal_method` varchar(200) DEFAULT NULL,
`paypal_fullresponse` text,
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`virtuemart_order_id` int(1) unsigned DEFAULT NULL,
`order_number` char(64) DEFAULT NULL,
`virtuemart_paymentmethod_id` mediumint(1) unsigned DEFAULT NULL,
`payment_name` varchar(5000) DEFAULT NULL,
`payment_order_total` decimal(15,5) NOT NULL,
`payment_currency` smallint(1) DEFAULT NULL,
`email_currency` smallint(1) DEFAULT NULL,
`cost_per_transaction` decimal(10,2) DEFAULT NULL,
`cost_percent_total` decimal(10,2) DEFAULT NULL,
`tax_id` smallint(1) DEFAULT NULL,
`paypal_custom` varchar(255) DEFAULT NULL,
`paypal_response_mc_gross` decimal(10,2) DEFAULT NULL,
`paypal_response_mc_currency` char(10) DEFAULT NULL,
`paypal_response_invoice` char(32) DEFAULT NULL,
`paypal_response_protection_eligibility` char(128) DEFAULT NULL,
`paypal_response_payer_id` char(13) DEFAULT NULL,
`paypal_response_tax` decimal(10,2) DEFAULT NULL,
`paypal_response_payment_date` char(28) DEFAULT NULL,
`paypal_response_payment_status` char(50) DEFAULT NULL,
`paypal_response_pending_reason` char(50) DEFAULT NULL,
`paypal_response_mc_fee` decimal(10,2) DEFAULT NULL,
`paypal_response_payer_email` char(128) DEFAULT NULL,
`paypal_response_last_name` char(64) DEFAULT NULL,
`paypal_response_first_name` char(64) DEFAULT NULL,
`paypal_response_business` char(128) DEFAULT NULL,
`paypal_response_receiver_email` char(128) DEFAULT NULL,
`paypal_response_transaction_subject` char(128) DEFAULT NULL,
`paypal_response_residence_country` char(2) DEFAULT NULL,
`paypal_response_txn_id` char(32) DEFAULT NULL,
`paypal_response_txn_type` char(32) DEFAULT NULL,
`paypal_response_parent_txn_id` char(32) DEFAULT NULL,
`paypal_response_case_creation_date` char(32) DEFAULT NULL,
`paypal_response_case_id` char(32) DEFAULT NULL,
`paypal_response_case_type` char(32) DEFAULT NULL,
`paypal_response_reason_code` char(32) DEFAULT NULL,
`paypalresponse_raw` varchar(512) DEFAULT NULL,
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) NOT NULL DEFAULT '0',
`modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) NOT NULL DEFAULT '0',
`locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`locked_by` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Payment Paypal Table' AUTO_INCREMENT=1 ;