Orders not showing up in Paypal or ZC admin (PayPal IPN module)

[DrByte]

Can you go into your phpMyAdmin, select your store database, then select your "paypal" table, click on Export, choose "structure only" (ie: uncheck the "data" checkbox), click on Go.
This should give you your PayPal table structure.
Post that SQL output here.

[TheMusician]

I do not run PHP myAdmin but this should do the trick -- let me know if you need anything else.



-- Definition of table `bos_paypal`
--

DROP TABLE IF EXISTS `bos_paypal`;
CREATE TABLE `bos_paypal` (
`paypal_ipn_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`zen_order_id` int(11) unsigned NOT NULL DEFAULT '0',
`txn_type` varchar(32) NOT NULL DEFAULT '',
`reason_code` varchar(15) DEFAULT NULL,
`payment_type` varchar(7) NOT NULL DEFAULT '',
`payment_status` varchar(17) NOT NULL DEFAULT '',
`pending_reason` varchar(14) DEFAULT NULL,
`invoice` varchar(64) 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(64) DEFAULT NULL,
`address_name` varchar(32) DEFAULT NULL,
`address_street` varchar(64) DEFAULT NULL,
`address_city` varchar(32) DEFAULT NULL,
`address_state` varchar(32) DEFAULT NULL,
`address_zip` varchar(10) DEFAULT NULL,
`address_country` varchar(64) DEFAULT NULL,
`address_status` varchar(11) DEFAULT NULL,
`payer_email` varchar(96) 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(96) NOT NULL DEFAULT '',
`receiver_email` varchar(96) NOT NULL DEFAULT '',
`receiver_id` varchar(32) NOT NULL DEFAULT '',
`txn_id` varchar(17) NOT NULL DEFAULT '',
`parent_txn_id` varchar(17) 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_zen_order_id_zen` (`zen_order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[DrByte]

Are there any PHP errors in your server's errorlog?

[TheMusician]

Unfortunately there are no php errors in the logs. I must have something configured incorrectly as the test install that I did on this same server is having the exact same issues. I will keep poking around trying to determine why this is not working. Thank you for your help so far.

[DrByte]

Whatever's wrong is failing to insert records into the "paypal" table properly during the IPN processing stages.

[afinta]

I am having a very similar/same issue. This is my installation:

Zen Cart 1.3.7.1

Database Patch Level: 1.3.7.1

v1.3.7.1 [2007-09-18 10:31:48] (Fresh Installation)

I am using the PayPal IPN as my sole source of payment. I just made a test order - the PayPal part seemed to go fine - but - the order did not show up in Zen Cart anywhere that I can see, nor did it generate any emails, etc.

I am very new to Zen Cart and PayPal but have followed the instructions and everything seems okay. Again - the PayPal payment went through without issue.

Any ideas?

[MuttOAOA]

I am having a very similar/same issue. This is my installation:

Zen Cart 1.3.7.1

Database Patch Level: 1.3.7.1

v1.3.7.1 [2007-09-18 10:31:48] (Fresh Installation)

I am using the PayPal IPN as my sole source of payment. I just made a test order - the PayPal part seemed to go fine - but - the order did not show up in Zen Cart anywhere that I can see, nor did it generate any emails, etc.

I am very new to Zen Cart and PayPal but have followed the instructions and everything seems okay. Again - the PayPal payment went through without issue.

Any ideas?

I am having the same problem.

[afinta]

Rembrandt I am thinking 1 of 3 things - the port is not open that needs to be, the PayPal account has not been verified yet (since it is not mine but my client's), or - their is a permissions issue with the DB...

I like your avatar.

[MuttOAOA]

I am having the same problem.

Sorry for the scare... there was a typo in my PayPal address. My bad.

I like your avatar.

Thanks. It's a blending of my face and the painting. When I was at the Met I took a picture of me and the painting at the same time and got the same lighting. It was a fun little Photoshop exercise. ;)

[DrByte]

I am using the PayPal IPN as my sole source of payment. I just made a test order - the PayPal part seemed to go fine - but - the order did not show up in Zen Cart anywhere that I can see, nor did it generate any emails, etc.

http://www.zen-cart.com/wiki/index.php/PayPal
Please post your debug logs.