1054 - Unknown column 'payment_info' in 'field list'

[Guest]

hi i have the standard nochex payment module installed (not apc), when a customer has paid , they get this message when nochexs are sending them back to my site

1054 - Unknown column 'payment_info' in 'field list'

 

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_info, cc_type, cc_owner, cc_number, cc_expires, date_purchased, last_modified, orders_status, currency, currency_value) values ('12', 'danny ferris', , '1', 'NOCHEX', '', '', '', '', '', now(), now(), '1', 'GBP', '1.00000000')

 

[TEP STOP]

 

i removed the address parts from above

Heeeeeeeeeeeeeeeelllllllllllllllpppppppppppppp needed please :(

Edited March 2, 2006 by gazza74

[satish]

hi i have the standard nochex payment module installed (not apc), when a customer has paid , they get this message when nochexs are sending them back to my site

1054 - Unknown column 'payment_info' in 'field list'

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, payment_info, cc_type, cc_owner, cc_number, cc_expires, date_purchased, last_modified, orders_status, currency, currency_value) values ('12', 'danny ferris', , '1', 'NOCHEX', '', '', '', '', '', now(), now(), '1', 'GBP', '1.00000000')

 

[TEP STOP]

 

i removed the address parts from above

Heeeeeeeeeeeeeeeelllllllllllllllpppppppppppppp needed please :(

 

 

Well you need to add one field in order table or remove payment_info from the insert query.

In your orders table that field is not existying and this query neeeds it.

 

Satish Mantri