Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Paypal IPN 2.9


BryceJr

Recommended Posts

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

Link to comment
Share on other sites

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.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

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

.....

.....

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...