Forums / Upgrading to 1.5.x / Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

Started by raphael on 15 Aug 2014, 5:51 AM · Views: 4,374

Results 21 to 31 of 31
7 Sep 2014, 12:56 AM
#21
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

lrfowler24:

i dont have the old passwords.....blah blah blah....
I reset the password to Admin...admin...that doesnt work...
seems to me the database has to be edited.............

Hate to ask, which Admin...admin sql was used? Please provide the sql statement not the description of it.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

7 Sep 2014, 1:01 AM
#22
lrfowler24 avatar

lrfowler24

New Zenner

Join Date:
Feb 2010
Posts:
74
Plugin Contributions:
0

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

the first one

7 Sep 2014, 1:07 AM
#23
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

mc12345678:

Hate to ask, which Admin...admin sql was used? Please provide the sql statement not the description of it.

lrfowler24:

the first one

I have never said this before nor had a reason... I'm done.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...

7 Sep 2014, 1:34 AM
#24
rixstix avatar

rixstix

Totally Zenned

Join Date:
Aug 2009
Location:
North Idaho, USA
Posts:
2,015
Plugin Contributions:
0

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

So you have a v1.3.9 database that you haven't a clue of the Admin ID or password and you are using the first set of SQL steps in phpmyadmin which are to reset a v1.5.3 database and expect things to work?

You've not said how you imported the db either.

Rick
RixStix (dot) com
aka: ChainWeavers (dot) com

7 Sep 2014, 1:49 AM
#25
barco57 avatar

barco57

Totally Zenned

Join Date:
Apr 2006
Location:
West Salem, IL
Posts:
2,846
Plugin Contributions:
0

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

mc12345678:

I have never said this before nor had a reason... I'm done.

That's simply beautiful.

Mike
AEIIA - Zen Cart Certified & PCI Compliant Hosting
The Zen Cart Forum...Better than a monitor covered with post-it notes!

7 Sep 2014, 1:56 AM
#26
lrfowler24 avatar

lrfowler24

New Zenner

Join Date:
Feb 2010
Posts:
74
Plugin Contributions:
0

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

you don't understand the first one?
as opposed to the second one?

7 Sep 2014, 2:02 AM
#27
barco57 avatar

barco57

Totally Zenned

Join Date:
Apr 2006
Location:
West Salem, IL
Posts:
2,846
Plugin Contributions:
0

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

He probably does, but asked for something specific.
Even I who have done hundreds of updates, after going through the thread twice, throw up my hands and walk away.....only way for me to add anything useful is to actually eyeball the fileset and databases themselves to see what is talking to what.....

Mike
AEIIA - Zen Cart Certified & PCI Compliant Hosting
The Zen Cart Forum...Better than a monitor covered with post-it notes!

7 Sep 2014, 6:09 AM
#28
lrfowler24 avatar

lrfowler24

New Zenner

Join Date:
Feb 2010
Posts:
74
Plugin Contributions:
0

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

wow....throw up your hands and walk away..!
did you drop your guns too?
manos arriba!...vamanos!!
wow! how dramatic!!

For all others not interested in the dramatics of the totally zenned......:
I ended up updating the old zencart that has the database with all the customer information and everything ....which meant changing the DNS from the new hosting service to the OLD hosting service.....because I am hosting my store on a new host......AND then changing the DNS to the new host .......AND ...importing the up-to-date database into the new database for my new store template on a new host provider..https://www.toomuchfunclub.net
Bingo!

7 Sep 2014, 6:14 AM
#29
barco57 avatar

barco57

Totally Zenned

Join Date:
Apr 2006
Location:
West Salem, IL
Posts:
2,846
Plugin Contributions:
0

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

Touche'...I suppose whatever gets the job done, but that seems as convoluted as the rest of the thread was.....

Mike
AEIIA - Zen Cart Certified & PCI Compliant Hosting
The Zen Cart Forum...Better than a monitor covered with post-it notes!

7 Sep 2014, 7:05 AM
#30
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,901
Plugin Contributions:
23

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

Well, here's what I think should have been done. The original poster used an autoinstaller. That was a lot of Rafael's problem. It also should not have anything to do with Irfowler24 doing what needs to be done.

First and always foremost, you MUST get control of the original store. That means you need to be able to access the admin section and the database. Once that is done you are back to a working site.

Download the current version of Zen Cart. Even if I downloaded it yesterday, I will still check before starting an upgrade.

Then take a look at http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading and see if you have any questions. If not, follow the directions. It's worked for thousands.:yes:

Irfowler24 jumped in mid-stream at post number 12 apparently assuming everyone could see or understand what is going on with his site. IMHO matters were exacerbated when we tried to deal with this without a common core of experience. One person talking photography while the other answers carpentry is not very productive. We weren't informed about the new site info as the posting tips were bypassed
The next thing you know, no one understands any of it.

It also doesn't help if (and we see it ALL the time) the person who starts the thread decides to do something different that what is asked. <example> "Do you have a backup of your old database?"</example> Next post...."Well I blew away the admin config and brought in the old one and even THAT doesn't work!"

Shoot, I saw answers to 5 or 6 different problems in the first seven posts. That's apparently when the OP bailed.

Hindsight tells me I should have mentioned DrByte's tutorial http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading in post 5. But that may or may not have helped Irfowler24. I'm still not sure if he (she?) realized a hijacking was taking place.
Back to the not-so-original post> So....I've imported the old database into the new database......

and I go to zc_install............... but then my zencart admin password doesn't work anymore...................

I even go to the zencart admin page ,,,,,,,and the password doesn't work........

I change the configure pages back to the old database ,..........and I am able to log into the admin page............but then...I only have a new blank database,,,,,,,,with no imported stuff..

what could possibly be wrong?Well, for one thing, it's like your car stalled on the freeway and you rotated the tires, got a new battery, changed the antifreeze in the radiator, and never looked at the gas gauge. When we ask if you have looked at the gauge (because we know you have two tanks), you say yes. We ask both, or just one? Just one. We ask, main or alt" You reply, the first one. Can you see where no one is getting anywhere that way?
It's not uncommon for both noobs and experienced coders to do this. The new guy just blindly tries everything that even MIGHT work and the experienced coder thinks they don't need to know the Zen Cart infrastructure before changing the foundation. Both have a humbling, confusing experience. I've been there, done that, and have the shirt, hat, and a tote bag.:P

Case in point, it was just eight minutes after Irfowler24 answered a proffered question that he (she?) Came back with new information on steps that were either done BEFORE the original post or DURING the long eight-minute wait for an answer.
The frustration continues when the advice to use the original database's admin doesn't work because> so........................ I change the configure pages back to point to (tmf_club) .......the newly created database with the new install........... (everything is a new install)............ and the passwords work ..I can go into the admin page.......... but there's no products (of course)...Now we're trying to undo a totally un-required change (to the configs) and get back on track with the database problem.
Regardless of which way one gets to the database upgrade page, it states that you should NOT use the MySql Password but use the one for the Admin area. Perhaps it would be more clear if it reminded the user that this might mean the one in the database being upgraded. Hard to get real precise there without confusing someone.
ANYWHO.....
Sorry for the four-page "discussion" but, IMHO, the bottom line is that we can't stop the noob or "pro" from throwing as much #$*(# at the wall as they do. Perhaps we can curtail some of this by saying, "Have you followed the steps listed here and, if so, which step is confusing?"

In that same vein, I suggest that new installs be directed to the /docs folder with the same queston. Once we know which step is bogging things down, we can respond better. Each time someone tries to explain, paraphrase, or expound, we seem to get in trouble.:(

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

7 Sep 2014, 4:30 PM
#31
lrfowler24 avatar

lrfowler24

New Zenner

Join Date:
Feb 2010
Posts:
74
Plugin Contributions:
0

Re: Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

yes yes...autoinstallers ARE NOT GOOD.