Guest Posted May 15, 2003 Posted May 15, 2003 I thought I had put a new topic here on the subject of database upgrades. It apparently didnt take. Hmmm. So I am doing it again. Anyway, I then read back about 15 pages in Installation and Configuration and found two other posts asking for the same thing in different various terms. But theres been 15 pages posted in just 3 days!!!!! Obviously the posts are coming in far faster than the developers could ever hope to answer them. I dont expect anybody to be answered on anything, at least not by the developers. Really, people, everyone has to take some responsibility on their own for learning the cart and putting some elbow grease into it before asking dumb questions. THIS INCLUDES ME TOO. So cancel my dumb database upgrade question. I *will* eventually figure out on my own how to migrate data from an old db into MS1's db. Then I will try to write a tip to assist others. Or, if there's someone who has already been through this who has a tip, please post it as it would be appreciated by many. Thanks Ahead.
Guest Posted May 16, 2003 Posted May 16, 2003 The schema changes may have been because of the "downloadable products" contribution I had added from Linda McGrath, or it could have been because of changes in the release database schema. I dont know which. I'm not a database guy, but I figured out what to do by reading the mysql manual. Anyway, if you have a changed database schema you will have to ferret out the tables that have the new fields where inserts are failing. Here's what I did: In phpmyadmin I opened the database I wanted to migrate to. In the orders table and orders_status_history table, one at a time, in the "Run SQL query/queries on database" window, I entered one at a time the command to add the fields I was missing. example SQL commands: ALTER TABLE orders ADD customers_company varchar(32); or ALTER TABLE orders_status_history ADD comments text; There were about a dozen of these fields. Voila! After that the cart started working again with the Sept 2002 data. Saved me a ton of work.
d-woo Posted May 16, 2003 Posted May 16, 2003 I feel ya Star! My thing is this: v2.1 has a certain db structure v2.2 has a different db structure. Now, if it were just the two of them, that would be no problem. However my db structures from a Jan 2003 snapshot (based on v2.2) is different from old v2.1 and MS1. That's at least three db structures... I'm aware of the "comments" field in the old "orders" now being in the "order_status_history". My question is this: What is the best tool for comparing differences in db structures (other than comparing table fields ...table by table)? I don't mind working this way...when there is no other alternative.
d-woo Posted May 16, 2003 Posted May 16, 2003 for some reason...when I use the Search button and type in "database" I get no results. I've also tried "database AND compare" ....still nothing. hmmm
d-woo Posted May 16, 2003 Posted May 16, 2003 okay...I found an easier way to compare db structures. http://www.oscommerce.com/forums/viewtopic.php?p=168581 There is also a tool called Diff N Merge which should be able to compare two text files in a GUI.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.