Hi folks

Stats:
aquarius server
PHP 5.2.5
MySQL 5 (recently upgraded)
OSCommerce 2.2rc2

I have a store that has had several problems of late. We solved Echo not allowing a connection for unknown reasons by switching servers. In the process I reinstalled OSCommerce. Now it seems we are out of synch with the db somehow. When checking out I get the following:


Checking the db shows the columns for the table orders_status_history are:


In searching for an answer to this issue, I see that many are having problems with OSC after upgrading MySQL 5. I've even found a few posts here that talk about the 1054 error and left joins, but they all talk about a different column and table.

Any help is greatly appreciated.

Thanks very much for the timely reply. got sidetracked myself.

To answer the question, I installed fresh but with existing data. Just hooked right in. Not sure that I ran anything for the db, and that could indeed be my issue. Where abouts would I find the db upgrades in the oscommerce-2.2rc2a folder?

I actually did a bunch of stuff to different environments (setting up each to try things out) trying to solve a nasty but (turned out to be an Echo thing) and in the process have myself in a bit of a mess I guess because I don't recall exactly what I did in each. But the base install I believe is 2.2rc2 with old data.

I'm realizing that I must do some mysql upgrading. One of the problems I had was that I attempted to upgrade in one of the test installs I have running and had no end of misery. Is there an easy way to bring my table structure into line with existing data?

Many thanks!
/Jon