Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by BryceJr

  1. BryceJr

    Front end voucher

    Gift Voucher (GV) and Discount Coupons (DC) for RC1, RC2, RC2a Does this contribution show that there's a discount code available for a specific product somewhere? I was watching the video. I saw configuration from the admin and then checkout. http://www.clubosc.com/gift-vouchers-rc1-and-rc2.html Does the customer know if there's a discount available when they visit the store?
  2. BryceJr

    Ok - I give Up! - I Need Help!

    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
  3. 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
  4. 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.
  5. 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 '', ..... .....