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

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.

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;

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

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.

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

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?

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?I am having the same problem.

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.

afinta:

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. ;)

afinta:

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.

Hi all,

I am still working on tracking this issue down.

Here is my server config

IIS 6 - up to date
PHP 5.2.1
MySQL 5.2.3

I installed the latest version of zenCart 1.3.7.1 with the sample store data

I then installed PayPal IPN per instructions yet I ended up with the same issue, of no order data being sent to paypal, just the order total. Could there be an issue with IIS that would prevent PayPal and zenCart from talking?

Thank you for all of the input and guidance so far:bigups:.