Altered Database tables in 1.5.x?

[philip937]

Hi all.

What tables are changed between 1.3.9h and the latest version of 1.5.x?

I ask because I want to build a fresh install of my site from scratch and when ready to go live I want to import products categories, orders etc

Can anyone advise?

Thanks

Phil

[DrByte]

WE NEVER RECOMMEND COPYING JUST A FEW SELECTIVE TABLES BETWEEN DATABASES!!!!!!

That said, if you think you've got the expertise needed to do that safely, then you should simply run the zc_install "Database Upgrade" step on the old database before copying any data from it into the new site's database. That way the schema changes will be handled properly ... which appears to be the root question from your post.

[philip937]

Well I guess what I'm asking is if none of the product/customer/order tables have changed then once I have a fresh install ill just drop the relevant table and I seer the old ones.

But I'd need to know if this would work, I.e have this tables been changed in any way?

[DivaVocals]

Well I guess what I'm asking is if none of the product/customer/order tables have changed then once I have a fresh install ill just drop the relevant table and I seer the old ones.

But I'd need to know if this would work, I.e have this tables been changed in any way?

No this won't work or it would be included in the upgrade instructions .. (see Dr Bytes post) Suggest following recommendations, do the upgrade and don't look for a shortcut.. There's no gain/upside to the path you are wanting to take.

[philip937]

No.. (see Dr Bytes post) Suggest following recommendations, do the upgrade and not looking for a shortcut..

Well what I'm suggesting is far from a shortcut! The shortcut is upgrading an old database, I am suggesting using a new database and importing certain data!

[DivaVocals]

Well what I'm suggesting is far from a shortcut! The shortcut is upgrading an old database, I am suggesting using a new database and importing certain data!

Then you have your answer.. What you are suggesting is not recommended. The best way to update the database is by following the recommended upgrade path as per Dr Bytes post.

[philip937]

What about old configuration entries for mods that are not compatible with 1.5.x that weren't supplied with uninstall SQL? Which by the way I think should be mandatory to provide for any mods in the download section.

Fair enough ill give it a go with the old db and try and clean it up somewhat.

[DivaVocals]

What about old configuration entries for mods that are not compatible with 1.5.x that weren't supplied with uninstall SQL? Which by the way I think should be mandatory to provide for any mods in the download section.

Fair enough ill give it a go with the old db and try and clean it up somewhat.

if you think you know enough to selectively upgrade your DB then you should be able to put together an uninstall script.. not sure which add-ons you're using but unless it's old, I don't know very many without an uninstall script.

[philip937]

I said I could drop and insert tables on the proviso they are not altered in the new version. And I am capable of removing entries and creating a script I was merely suggesting we shouldn't have to and they should be included in the download.. Chill

[DivaVocals]

I said I could drop and insert tables on the proviso they are not altered in the new version. And I am capable of removing entries and creating a script I was merely suggesting we shouldn't have to and they should be included in the download.. Chill

Well we can go back and forth about all the things you should and shouldn't have to do.. That won't solve your problem.. Based on your post, you have an add-on that has no uninstall script.. So apparently you do have to do some work to remove the DB entries for these add-ons.. Here's what I suggest..

1. Follow the upgrade instructions as Dr Byte advises.. (he is after all the BEST source of the correct method to do this)
2. If your mods really do not have any kind of uninstall script, and you do not know how to back out the DB entries created by them, then you can check the support thread for your add-ons for options to remove the DB entries created by your add-ons..

Good luck..