Guest Posted March 27, 2003 Share Posted March 27, 2003 During Credit Card Checkout process, on last step am confronted with -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 ('3', '1', now(), '1', '') [TEP STOP] I cannot seem to find any help in these Forum's and am wondering if anyone could help me? Thank you! Holt :shock: Link to comment Share on other sites More sharing options...
Guest Posted March 27, 2003 Share Posted March 27, 2003 In additon, in the admin control panel, there is another error message on pending orders. Is as follows: 1054 - Unknown column 'orders_status_id' in 'field list' select orders_status_id, date_added, customer_notified, comments from orders_status_history where orders_id = '3' order by date_added [TEP STOP] Any help would be greatly appreciated. Holtster Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2003 Share Posted March 29, 2003 It took forever, a whole day to figure out this one, and have decided to post a message to help all! Upon upgrading to 2.2ms1 from 2.1x I had big problems. Everytime I uploaded the backup of my sql database, eveything was great except the payment modules would not work. Only Credit Card Payment was available. So I edited the sql file, removed every line that had any references to MODULE_PAYMENT within it using Wordpad. This fixed my problems, and hope it may fix yours! Visit http://www.IntelliBuys.com for a glimpse! Unrelated,EDITED PLEASE DO NOT ADVERTISE, Thanks Linda :idea: Thank You! Holt Harrison Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2003 Share Posted March 29, 2003 hey.... i have that same issue....... only i started from a straight install of 2.2ms1 and not an upgrade. my error is this 1054 - Unknown column 'customers_company' in 'field list' insert into orders (customers_id, customers_name, customers_company, customers_street_address, blah blah) [TEP STOP] I'm wondering if I need to delete the module part in sql like you did too... anyone have any suggestions? Link to comment Share on other sites More sharing options...
Guest Posted March 29, 2003 Share Posted March 29, 2003 I had some problems with the import even after the 'fix'. I found that if I used the PHPmyadmin to export just the category and product fields that upon restoring the backup to original install, then importing the sql file within PHPmyadmin instead of the control panel for OSCommerce, that I had no further issues. I hope this helps!~ :arrow: Holt Link to comment Share on other sites More sharing options...
arames Posted May 28, 2003 Share Posted May 28, 2003 HI there.... I am pulling my hair out! Please help me. I am kind of newbie .... I had the version 2.2 installed and everything was perfect. Now I have more then 250 new products coming so I decided to install the new version 2.2 MS.1. The only problem is when customers are trying to pay the ALWAYS get this 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 ('612', '1', now(), '1', 'this is a test. Hope it works') [TEP STOP] Please help me, what shall I do ..... pleeeeeeeeeeease :oops: Thank you a million time in advance. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.