Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

PayPal IPN problem


Guest

Recommended Posts

Posted

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?

Posted

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?

Posted

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

Posted

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

Posted

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

Posted

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.

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...