Probem in Order History?

[gillweb]

I've ceated an account and made a sale all for config purposes. When I log into my account and click on Order History I get a listign of the order but when I view the Actual Order I get and error on the 3rd section down named "ORDER HISTORY". All I get in this box is this:

 

1054 - Unknown column 'osh.comments' in 'field list'



select os.orders_status_name, osh.date_added, osh.comments from orders_status os, orders_status_history osh where osh.orders_id = '2' and osh.orders_status_id = os.orders_status_id and os.language_id = '1' order by osh.date_added



[TEP STOP]

 

Any ideas?

[Guest]

I've ceated an account and made a sale all for config purposes. When I log into my account and click on Order History I get a listign of the order but when I view the Actual Order I get and error on the 3rd section down named "ORDER HISTORY". All I get in this box is this:

 

1054 - Unknown column 'osh.comments' in 'field list'



select os.orders_status_name, osh.date_added, osh.comments from orders_status os, orders_status_history osh where osh.orders_id = '2' and osh.orders_status_id = os.orders_status_id and os.language_id = '1' order by osh.date_added



[TEP STOP]

 

Any ideas?

 

The "comments" field was moved from the "orders" table to the "orders_status_history" table. I brought it up yesterday in the following thread:

 

http://www.oscommerce.com/forums/viewtopic.php?t=34330

 

That thread also has a link to another thread that discusses why the change was made. I discovered this while I was adding a contribution (Paypal IPN).

 

Did you recently add a (newer) contribution to an older snapshot that might have caused this? You're apparently getting this error because you don't have a "comments" field in your "orders_status_history" table. (Well, that's what I'm assuming).

 

-Ray

[gillweb]

I just can't find the code to replace or the code to replace with to get rid of this problem...anyone please HELP :!:

 

I tried placing a "comments" field in the "order_status_history" table in my database but that didn't work as a quick fix. And the link to the other discussion involves a PayPalIPN contrib that i'm not using..

 

I have snapshot 2-3-03 w/contrib's UPS Choice and Attribute Sorter and Copier 5.0

 

:?: :?: :?:

[mbmweb]

Did Anyone find a fix for this?

My system is pretty much default install, with Canada Post shipping and UPS added in, and I have the same problem.

[gillweb]

I know this isn't what you want to hear but I re-installed from a newer snapshot and it fixed itself... :wink:

[mbmweb]

What a mess!

Anyway, I finally was able to find the right orders.php to edit out the comments field:

:arrow: admin/includes/classes/orders.php

Now I can view the orders, but part way down the page I have:

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

 

select new_value, old_value, date_added, customer_notified from orders_status_history where orders_id = '1' order by orders_status_history_id desc

 

[TEP STOP]

 

Now I've done a search through all the files in all the directories and cannot find ANYTHING that says anything about "new_value, old_value" and so on. Anyone have any idea where this query is put together?

 

For Open Source software, OSCommerce has some amazing features, a nice site, and a lot of great developers, but in real-world usage, I'm starting to think it's more expensive to setup and maintain than some of the midrange commercial products out there. :cry:

[mbmweb]

ok, nevermind... For some reason grep wasn't giving me any results, even though it was right there.

 

admin/orders.php - I take out new_value and old_value, and now that part 'looks' ok.

[mbmweb]

Now the invoice sort-of works, but I get some missing info and missing field errors in other spots.

 

What should someone do that wants (needs!) their store online and running, but cannot debug and upgrade the software every day? Are there any stable alternatives to OSCommerce, or?