Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Dumb database upgrade question CANCELLED


Guest

Recommended Posts

Posted

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.

Posted

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.

Posted

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.

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...