PayPal_Shopping_Cart_IPN_v3.1.5 MYSQL error

[Mortenjan]

Hi, i get this error while importing into MYSQL.

 

Feil

 

SQL-spørring:

 

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 '', payer_id varchar(32) NOT NULL default '', payer_status varchar(10) NOT NULL default '', payment_date datetime d[...]

 

MySQL sa: Dokumentasjon

#1067 - Invalid default value for 'quantity'

 

Im not able to make the paypal table.. And therefore i cant delete orders etc on my webpage with paypal module active.

Whats wrong?

Regards Morten

[lrdiii]

Hi, i get this error while importing into MYSQL.

 

Feil

 

SQL-spørring:

 

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 '', payer_id varchar(32) NOT NULL default '', payer_status varchar(10) NOT NULL default '', payment_date datetime d[...]

 

MySQL sa: Dokumentasjon

#1067 - Invalid default value for 'quantity'

 

Im not able to make the paypal table.. And therefore i cant delete orders etc on my webpage with paypal module active.

Whats wrong?

Regards Morten

 

 

Same problem here... Did you ever resolve the error?

Lou