PayPal IPN Checkout issues: IPN Admin page & PP requiring signup

[DrByte]

It's always best not to change any database structural configuration unless you know exactly what you're doing.

The correct structure of the "paypal" table is:

CREATE TABLE paypal (
  paypal_ipn_id int(11) unsigned NOT NULL auto_increment,
  zen_order_id int(11) unsigned NOT NULL default '0',
  txn_type varchar(40) NOT NULL default '',
  reason_code varchar(15) 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_zen_order_id_zen (zen_order_id)
) TYPE=MyISAM;

[Veazer]

It's always best not to change any database structural configuration unless you know exactly what you're doing.

The correct structure of the "paypal" table is:

CREATE TABLE paypal (
  paypal_ipn_id int(11) unsigned NOT NULL auto_increment,
  zen_order_id int(11) unsigned NOT NULL default '0',
  txn_type varchar(40) NOT NULL default '',
  reason_code varchar(15) default NULL,
  
...[excess deleted}

Ahh! Then that means that there might be a bug in zencart's removal of prefixes in the DB, correct? After my upgrade, my paypal table only had 'order_id'. It looks like it must have searched the full DB for instances of 'zen_' and removed them, including those that needed to be there. Should I report this to a developer or would that include you?

I really appreciate your help in solving this issue.

[DrByte]

That would be me.

Zen Cart does not rename any field names when it does its prefix-rename routine. It only touches table names.


But back to the point: Is your table structure complete? If not, use the above information to fix it. If it's correct, then do as many test transactions as you feel you need to be comfortable that things are working right.

Are your PayPal transactions working properly now ?

[Veazer]

Zen Cart does not rename any field names when it does its prefix-rename routine. It only touches table names.

I'll take your word on that, but I can absolutely assure you I have never changed any table names or field names prior to this. Doesn’t it seem odd that the only field with a name problem happens to be the one with the missing 'zen_' prefix, and that’s the same prefix ZC removed from the tables? I still have a copy of the old DB, I can try to recreate the situation if you like. If you're 100% certain that the routine doesn't touch field names I won't bother.

But back to the point: Is your table structure complete? If not, use the above information to fix it. If it's correct, then do as many test transactions as you feel you need to be comfortable that things are working right.

Yes, thanks for providing the table. Everything in the paypal table is exactly what it should be except for the 'zen_order_id' field that needed the prefix added. Sorry for not clarifying this before.

Are your PayPal transactions working properly now ?

It's still requiring customers to create an account, but like you said that's a PP issue not zen. Other than that it seems to be functioning correctly, still some more testing to do though. No errors in the IPN admin pages now.

Many thanks for help.

[DrByte]

Yay !