Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

BryceJr

Pioneers
  • Posts

    1,452
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by BryceJr

  1. This link is for installing Paypal IPN but the process to generate security ceritificates applies to your case as well. Read the parts where it discusses generating public/private certificates, keys, etc. Hope this helps you. https://support.lunarpages.com/knowledge_bases/article/187
  2. BryceJr

    Paypal IPN 2.9

    Dumped Paypal IPN 2.9. Use osCommerce PayPal IPN Module v2.3.3 For 2.2MS2 http://www.oscommerce.com/community/contributions,2679 Thanks for those who tried to help. I appreciate it.
  3. BryceJr

    Paypal IPN 2.9

    These are the alter commands in the paypal.sql script. ALTER TABLE orders ADD payment_id INT( 11 ) DEFAULT '0' NOT NULL; ALTER TABLE orders_products_attributes ADD products_options_id INT( 11 ) DEFAULT '0' NOT NULL; ALTER TABLE orders_products_attributes ADD products_options_values_id INT( 11 ) DEFAULT '0' NOT NULL; AND I keep getting "#1067 - Invalid default value for 'quantity' " # Table structure for table `paypal` # DROP TABLE IF EXISTS paypal; CREATE TABLE paypal ( paypal_id int(11) unsigned NOT NULL auto_increment, txn_type varchar(10) 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 '', ...... ...... quantity int(11) NOT NULL default '', ..... .....
  4. BryceJr

    Paypal IPN 2.9

    My apologies if this has been covered. I've been looking for several hours and can't find any answers. In the Paypal IPN 2.9 module, I ran the paypal.sql script and kept getting "#1067 - Invalid default value for 'quantity' " I've tried running the script with globals off and on. The result is the same. I'm out of ideas. I could really use any help or point me to the right direction. I'm running OSCommerce on a local machine (localhost). There are also 3 alter statements in that sql script. It will not alter. I get the message ... "Duplicate column name 'products_options_values_id' ", " Duplicate column .... payment_id", and " Duplicate column .... products_options_id ". I tried commenting one by one. Should I comment them out and run the script without the alter statements? If they are duplicates, should I just leave them alone? Any assistance is much appreciated
×
×
  • Create New...