Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

2.3 and 2.2 database, compatible?


ggrant3

Recommended Posts

I am finally going to start working on switching over to the 2.3 version but I was thinking about something last night. Is the db for v2.3 the same as v2.2(RC).

 

Could I just upload the files portion only and point them to the current db?

 

Also, is there a specific faq area/thread for the 2.3 version because I have a few questions that most likely have already been answered but I can't find much in a search on here because typing in "v2.3" doesn't produce any results.

Link to comment
Share on other sites

@@ggrant3,

 

NO, there are differences between the two. If you want to use your RC database you will need to integrate it into the v2.3.1 tables....the IMPORT function will not work.

 

 

Chris

Link to comment
Share on other sites

Migrating 2.2 to 231 involves adding fields, removing fields, changing field sizes adding keys etc.

 

Also the link between customer and address book needs to be migrated.

 

When I do it, I use mysqldiff, an open source application, to do most of it.

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Just read the 2.3.1 upgrade documentation, it is easier than I described above.

 

Just the data in some of the dbs I converted was a little flaky.

 

e.g. not all products had images.

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

I used phpmyadmin and uploaded the individual tables to my computer in csv format. Opened the files in excel and altered the tables so they matched and uploaded them again. It worked as a test, but it did take a while doing one table at a time. I did also find that you can save a csv file with the column names at the top.

REMEMBER BACKUP, BACKUP AND BACKUP

Link to comment
Share on other sites

I have tried a couple times to upgrade to the 2.3.1 version and something is wrong. As a stock osc site everything functions fine, but I can't get any of my customer or order history or any of my products to appear.

 

I have done this process a couple of times I still have no customer, or order history and my products don't show up.

 

What I have been doing is:

  • create a backup database of my current shop
  • create a new database
  • modify the new database to the 2.3.0/2.3.1 standards (per the upgrade guide making the sql changes)
  • upload the 2.3.1 catalog files
  • go through the installation process
  • then the new 2.3.1 shop works fine as a "new" store, but it doesn't show any of my existing data.

 

By starting out with an existing database and then converting it (per the 2.3.1 upgrade guide) shouldn't all of my customer & order history & products appear?

 

Am I leaving a step out?

Link to comment
Share on other sites

the installation overwrites the db.

 

You can edit oscommerce.sql in the installation folder so it does not overwrite certain files

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

the installation overwrites the db.

 

You can edit oscommerce.sql in the installation folder so it does not overwrite certain files

 

HTH

 

G

 

 

Ooooo, yeah I guess I can see that happening....um..now. Just went through the stock files and I see what you mean. I didn't realize there was a database file in there that was overwriting my db that I put in and updated 5 mins before. But I guess there would have to be in order to setup the stock db, whoops.

 

So correct me if I am wrong (which I may be :) ) but could I just upload my database again, modify it to the 2.3.1 requirements, and then modify the oscommerce.sql file like you mentioned but just have

 

DROP TABLE IF EXISTS counter;
CREATE TABLE counter (
 startdate char(8),
 counter int(12)
);
DROP TABLE IF EXISTS counter_history;
CREATE TABLE counter_history (
 month char(8),
 counter int(12)
);

as the only code in there. I looked and it doesn't seem that there are any other references to "counter" anywhere else in that file (other than that small section of code) so it doesn't seem like removing everything else in that file and leaving only that piece of code would cause a problem. Well besides erasing my current counter information which I can simply re-enter via the database anyways.

 

Or is there a different recommendation you have that may be better, safer, or easier?

Link to comment
Share on other sites

Ooooo, yeah I guess I can see that happening....um..now. Just went through the stock files and I see what you mean. I didn't realize there was a database file in there that was overwriting my db that I put in and updated 5 mins before. But I guess there would have to be in order to setup the stock db, whoops.

 

So correct me if I am wrong (which I may be :) ) but could I just upload my database again, modify it to the 2.3.1 requirements, and then modify the oscommerce.sql file like you mentioned but just have

 

DROP TABLE IF EXISTS counter;
CREATE TABLE counter (
 startdate char(8),
 counter int(12)
);
DROP TABLE IF EXISTS counter_history;
CREATE TABLE counter_history (
 month char(8),
 counter int(12)
);

as the only code in there. I looked and it doesn't seem that there are any other references to "counter" anywhere else in that file (other than that small section of code) so it doesn't seem like removing everything else in that file and leaving only that piece of code would cause a problem. Well besides erasing my current counter information which I can simply re-enter via the database anyways.

 

Or is there a different recommendation you have that may be better, safer, or easier?

 

Well that doesn't work.

 

I guess I will have to pick apart the db file.....fun

 

Maybe I am missing a valuable piece of information but it seems like this process is awful difficult for me to get implemented.

Link to comment
Share on other sites

You just need to work out which tables contain the data you want and delete the drop and create and insert command for each table you do not want overwritten

 

Categories, cat desc, all the products, manu and manu desc to name the ones I can think of off the top of my head.

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...