Database did not upgrade

[athena]

27 degrees out....and I'm in a big drafty building...so cold...

It does seem to be a template issue on the store side.

Now that i'm properly using the override system I see that when I change the template all the attributes show up in the cart....but still no drop down in the admin.

I just deleted all the mods files..a version of SBA for 1.5.1 that is still be worked on but is the best version yet. I double checked for errors and re uploaded them. Dropped the SBA table and re ran the sql. Imported my old SBA table.

It worked so more-perfectly-as-expected on a clean install on the Linux with 1.5.1 but it still won't show in the admin no matter what template I choose....and it seems to have knocked out the normal attribute functions of zen showing in the store.

Maybe I'm just too cold and tired.....my eyes have been glued to this all day...just did not want to be down over the weekend...but I have to stop now and come in tomorrow.

THanks so much for hanging in there with me....

[DrByte]

The subject you gave to this discussion of "Database did not upgrade" doesn't really match the symptoms you describe.
Am I correct in reading that perhaps "Some admin menu options missing" is more correct?

Or am I missing something?

The admin menu was fully rebuilt between v1.3.9 and 1.5.x. All addons which had admin menu options needed to be updated to work with the new system. Perhaps you've got a hybrid of old admin things that are breaking it and preventing the new admin menu from working properly.

[athena]

Hi ....apologize for mis-naming but that was my best perception.

I spent a few days working in my new install of 1.5.1 on a Linux server this week and followed your move from Windows to Linux instructions regarding the import of my old db to the new:

http://www.zen-cart.com/content.php?...fferent-server

In January, when I played with upgrading in a trial run, I recalled the database upgrade process being somewhat different that what I experienced when it came to the real deal yesterday, and when I logged in and the admin looked like my old shop and the mods I installed were no longer there and any attribute features were missing from the live store and I needed to go live last night, I felt a post was in order. Also, when I tried to drop one of the mod tables to re-import it phpmyadmin said the drop was successful yet the table was still there.

OK...so I believe last night with all my activity the server was lagging behind me for some of these operations I'm doing to re-install mods. I went to change my DNS and 24 hours later it still has not propagated. The company I use for that says they are doing some maintenance...but I haven't had it take so long before.

Multiple issues that I will resolve somehow now that I've given up on going live for the weekend. The one consolation is that the store speed has significantly improved, even with my import of my old database. I'll post back when i resolve this.

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?

[athena]

DrByte,

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

I did not use any of my old files from the windows zencart. I did a clean install of 1.5.1 and installed all my mods to make sure they worked. It was beautiful....I even imported some tables from the old db, namely the products tables and the customer's tables, to see how SBA and Edit orders behaved and all seemed so well.

I don't recall now if the cart broke when I imported my old db tables but my recollection is it broke when I ran the zc_install to update the db. All the data is in the tables. All my mods are gone from Admin. My attempts to re-install the mods have been unsuccessful.

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.

[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?

[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]

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.