BryceJr Posted December 22, 2007 Share Posted December 22, 2007 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 Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted December 22, 2007 Share Posted December 22, 2007 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. Quote 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 More sharing options...
BryceJr Posted December 22, 2007 Author Share Posted December 22, 2007 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 '', ..... ..... Quote Link to comment Share on other sites More sharing options...
BryceJr Posted December 27, 2007 Author Share Posted December 27, 2007 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.