Guest Posted May 10, 2003 Posted May 10, 2003 OK, I finally got this installed on MS1 and everything seemed to be going fine until I tried to place an order using PayPalIPN pay module. When I hit the confirmation button that is supposed to take me to Pay Pal, I get the following error message: 1054 - Unknown column 'orders_status_id' in 'field list' insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('11', '99999', now(), '1', '') [TEP STOP] Any one have any idea what this means and how to fix it? The only thing I can think of is that I added "shipped" in the order_status_id. could this have effected it?
Guest Posted May 10, 2003 Posted May 10, 2003 I looked at the table orders_status_history and found the following: orders_status_history_id, orders_id, new_value, old_value , date_added, customer_notified These are different from what the error is telling me. What should I do?
compugeek2003 Posted May 11, 2003 Posted May 11, 2003 GAW, It appears that your orders_status_history table has the wrong fields in it. The fields that should be in it are as follows: orders_status_history_id orders_id orders_status_id date_added customer_notified comments You got the error because it was trying to insert data into the orders_status_id field which for some reason does not exist in your table. I am not sure what happened to cause your different fields. You could try reloading the table. That would delete any data you have in it now, however. Eric Stamper
Rabyte Posted May 11, 2003 Posted May 11, 2003 Did you make the changes to the MySQL database in "paypalipn.sql"? Just guessin.
Guyver Posted May 11, 2003 Posted May 11, 2003 This is very strange, I've been running paypal ipn for a while now, and have only just got this error!!!.. 1054 - Unknown column 'new_value' in 'field list' insert into orders_status_history (orders_id, new_value, old_value, date_added, customer_notified) values ('1171', '2', '99999', now(), '1') --------------------------------------- Remote Address: 65.206.229.140 Referer : Requested : /paypal_notify.php DB: table orders_status_history orders_status_history_id orders_id old_value date_added customer_notified comments orders_status_id Are we missing some changes!? I'm running 'loaded5'. John
Guyver Posted May 11, 2003 Posted May 11, 2003 Just seen post of mine, check the DB and its not it there!!.. So I've added: INSERT INTO `orders_status` VALUES (99999, 1, 'Paypal Processing'); Will keep an eye on it.. John
Guest Posted May 11, 2003 Posted May 11, 2003 Those are the fields that came with 2.2 db (new_value, old_value). This appears to be different from the MS1. I dropped the old order_status_history table and created a new one without those two fields and added 'comments'. So far, it works now with PayPal IPN. Not an easy module to install. Does anyone know how to pass along the product name to paypal IPN so the product is listed in the Paypal order? I saw some code change that did this for the regular PayPal module, but not for the PayPal IPN.
Guyver Posted May 14, 2003 Posted May 14, 2003 For those who are having this prob. heres the sql to recreate the table to make it 'IPN' friendly: CREATE TABLE orders_status_history ( orders_status_history_id int(11) NOT NULL auto_increment, orders_id int(11) NOT NULL default '0', orders_status_id int(5) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', customer_notified int(1) default '0', comments text, PRIMARY KEY (orders_status_history_id) ) TYPE=MyISAM; Cheers John
Recommended Posts
Archived
This topic is now archived and is closed to further replies.