If it happened in "one" table, it probably happened in lots of others too ... so you'll wanna check everything.
Printable View
It is working properly.
Instead of doing a fresh install, I dropped the orders table, copied the orders table from the working site, did a sql to install the table into the new site, wala, working like it should be.
Yea!!! Going to go have a beer. Thanks Doctor.