Missing data when viewed through ZC 1.3.7

20 Oct 2007, 10:02 PM

#1

Totally Zenned

Join Date:: Sep 2004
Location:: Murfreesboro, TN
Posts:: 479
Plugin Contributions:: 0

Missing data when viewed through ZC 1.3.7

We just completed an upgrade on Thursday / Friday nights from zc 1.2.6 - 1.3.7 For the most part things went smooth (as can be expected anyway). During the install process we did the upgrade database option. Once we were able to log back in, the customers show to be from the end of August and yet when I view the tables data in phpMyAdmin the last customer to sign up shows October 17, 2007.

My question is how do I get the MySql data and zc 1.3.7 to sync up.

During testing we had copied our live 1.2.6 database off to the side to test 1.3.7. Once testing was completed we followed upgrading procedures and then change the two configure files accordingly.

We can log into the site under admin and any accounts that were created up to August, but none afterwards. We cannot allow the site to go live due to any overlapping account, order id's, etc.

Any ideas?

tia...

0be1

"Give me one hundred preachers who fear nothing but sin and desire nothing but God, and I care not whether they be clergymen or laymen, they alone will shake the gates of Hell and set up the kingdom of Heaven upon Earth." - John Wesley

21 Oct 2007, 12:59 AM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Missing data when viewed through ZC 1.3.7

When going live, you should do a fresh new database export/import from your live site to your "new" site, and do an upgrade on that newest data. Otherwise you lose information in the process.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

21 Oct 2007, 2:26 AM

#3

0be1

Totally Zenned

Join Date:: Sep 2004
Location:: Murfreesboro, TN
Posts:: 479
Plugin Contributions:: 0

Re: Missing data when viewed through ZC 1.3.7

I thought that is what I did. Is there anyway to just to a database upgrade without doing the whole install process again? I have already fixed the overrides, templates, etc. and I sure would hate to lose all the hours of that plus the upgrades I have already done.

Thanks...

0be1

"Give me one hundred preachers who fear nothing but sin and desire nothing but God, and I care not whether they be clergymen or laymen, they alone will shake the gates of Hell and set up the kingdom of Heaven upon Earth." - John Wesley

21 Oct 2007, 12:50 PM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: Missing data when viewed through ZC 1.3.7

0be1:

Is there anyway to just to a database upgrade without doing the whole install process again?That's what I described above.

DrByte:

When going live, you should do a fresh new database export/import from your live site to your "new" site, and do an upgrade on that newest data. Otherwise you lose information in the process.
ie:
export old
import to new
upgrade new using zc_install

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.