Database did not upgrade

[DrByte]

Multiple issues that I will resolve somehow now that I've given up on going live for the weekend.

I didn't say this before, but I'm especially puzzled now since you've mentioned it: You're attempting to do way too much all at once. DNS propagation is never instantaneous (although there are advanced ways to minimize risks of downtime, unless you had the forethought to adjust TTLs a few days ahead and reset them after migration) so you should never attempt a move and upgrade at the same time.
It would have been much better to simply keep the old site live until your new site was ENTIRELY ready and tested. Then once you were ready to "go live", you could THEN down-for-maintenance, copy the database, import it, upgrade it, apply any necessary adjustments for mods and customizations, do some last minute testing and then flip the DNS over.
All explained at http://www.zen-cart.com/entry.php?3-...d-of-upgrading

Moving AND making big changes (including upgrading) AT THE SAME TIME is ... well ... something I'd only tackle if it was an emergency. But you just now said you've been planning it for a couple months, so rather than hold my tongue I figured it best to share my recommendation based on much experience.

OK...one question: I admit I skipped a step in above instructions, namely: "Grab the "Fix_Cache_Key" utility to reset your Admin->Sessions->Session Directory key so that it uses the proper folder path for your new server" as I did not understand it's use. Could that have been in issue in all this?

Not likely. Usually the symptoms from that are inability to log in.

[athena]

I think I was posting when you were posting.....see above your post....

Yeah, I thought that was what I was doing. as i just posted, i did not use any of the old files from 1.3.9h. Just my database from the old zencart was imported.

[DrByte]

if my old database had info in it that was not compatible with the new zencart it could break it?

Loaded question. I don't think you're saying what you really mean.

Your old version's database, when imported, is not immediately compatible with the new version, until after you run zc_install to upgrade it.
If your question was really whether data added by old plugins would cause a problem, the answer is no. You can remove any useless data manually at a later time.

I even imported some tables from the old db, namely the products tables and the customer's tables,

Selectively copying individual tables from the old database WITHOUT FIRST UPGRADING the database, will potentially result in compatibility problems. I NEVER RECOMMEND COPYING INDIVIDUAL TABLES BETWEEN DATABASES as a shortcut or fasttrack or magic trick. Always import the ENTIRE database, so that ALL the data is preserved.

I don't know what to do. I'm inclined to create a new db and try and import one table at a time and not run the zc_install at all.

Strongly not recommended.

If you're merely missing menu items from the admin, then that will require special focused investigation. Is that the ONLY problem you're actually having now?

[athena]

My cart is still running on the old windows but is down for maintenance.

New cart is down for maintenance, functioning, but is missing attributes in the product info page, and is not calculating stock properly at check out. I just checked out with all five of something and it adjusted only to showing four in stock, subtracting only one. This was working beautifully before I tried to update the db.

I successfully installed mods before importing my db: Sales Report (now Missing from admin) zenlightbox (missing but working) SBA (missing not working) Edit orders (missing from config menue but seems to be working) Payment and shipping mods are there and working. Info at a glance (working) Ordered steps (working) Cash on Pickup (working)


Try as I might I can not get SBA to re-install or phpmyadmn to accept any sql statements - keeps saying everything is there. The files are there...the db table is there. i've deleted and uploaded the files again and again over several hours from last night through today at least three separate sessions.

If I could have run the db upgrade on my windows server maybe this all would have been avoided.

I'm wondering if I just create new db and point my zencart to it do I need to run the install?

[kobra]

I successfully installed mods before importing my db

If any of your mods had sql for them - importing your database wiped them out and they will need to be re-run

[athena]

your already answered that...sorry.....

Your old version's database, when imported, is not immediately compatible with the new version, until after you run zc_install to upgrade it.

It just all seems corrupted now.

[athena]

You know....the phpmyadmin just will not successfully run any of the sql files for these mods.

I really need a proceedure for getting my old data into a new 1.5.1 zencart.

Because the php is old on my windows server I can't upgrade there. I integrated all my modifications into 1.5.1 and it is sound. I tested it and it is sound.

The old db just won't play nice and the zc_install upgrade did not seem to work.

I need a proceedure to follow that does.

If I just have the host move everything for me, all the old files and old db....then I guess i could run the zc_install db upgrade and then delete all my old files off the server and upload my 1.5.1...am I missing something here????? That seems stupid and redundant and like I'll be left with the same issues.

[DrByte]

You know....the phpmyadmin just will not successfully run any of the sql files for these mods.

"will not successfully run"? Does it give a particular error message?

I really need a proceedure for getting my old data into a new 1.5.1 zencart.

Export from old server, then import to new server.

If I just have the host move everything for me, all the old files and old db....then ...

If you engage your host to do it, then I'd strongly suggest you stop at the point of them copying the database and files over. Nothing more. Details here: http://www.zen-cart.com/content.php?...fferent-server

[athena]

how does the zc_install upgrade the db?

Is there a list of things it does?

Is there a sql script to do this? (My host asked if they could try and run it for me or figure out what went wrong)

[DrByte]

I am almost 100% certain the problem is NOT zc_install. My only uncertainty lies in the fact that I'm going only on symptoms you've posted about.

There's more to the upgrade than merely running a batch of SQL statements. Some are also run dynamically by PHP code which validates certain data and makes updates based on what it discovers is needed. But, if you and your host want to tackle it, have at it. /zc_install/sql/ contains the basic upgrade sql. The dynamic PHP stuff isn't as easily extracted. Your efforts should be considered as RESEARCH ONLY and not as something that results in a live site after experimentation.