Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

BryceJr

Pioneers
  • Posts

    1,452
  • Joined

  • Last visited

  • Days Won

    2

Posts posted by BryceJr

  1. http://www.sloctcarswaleslimited.co.uk/catalog/

    ...

     

    OSC seems to be asking all the right questions but... i just can't seem to get the answers from fasthosts....

     

    It's asking me for a number of .pem files relating to security certificates....

     

    i've managed to get the paypal public key .pem file but when i asked fasthosts for a .pem file relating to my website, they said they cant give it to me.

     

    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. Please paste the commands you want to run.

     

    If you get the duplicate message it means these fields already exist, so no need to run them again.

     

    You can use phpmyadmin to see which fields exist in the various tables and thus what if anything still needs to be set up.

    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 '',

    .....

    .....

  3. 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...