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 1 to 20 of 31
15 Aug 2014, 5:51 AM
#1
raphael avatar

raphael

New Zenner

Join Date:
Jan 2011
Posts:
47
Plugin Contributions:
0

Despirately need help with importing 1.3.9 db to 1.5.3 fresh install

Hello I am in desperate need of help with my upgrade/install from zc 1.3.9 to 1.5.3. My hosting provider is GoDaddy. Basically I have a fresh new install of v1.5.3. I then did the procedure using phpMyAdmin to drop the dba and import the old db from 1.3.9. I am going this rout because it would take me months to reload the product catalog by hand.

I am now getting the following error "ERROR 0071: There appears to be a problem with the database. Maintenance is required". I followed the procedure to edit the db prefixes in the configure.php file and the error remains. Please can someone help me. I’m completely open to a join.me session where someone with good knowledge and experience could guide me through getting my zencart back up and running.

15 Aug 2014, 12:17 PM
#2
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,140
Plugin Contributions:
56

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

When you installed ZC v1.5.3, did you first create a ***new ***database for the v1.5.3 content?

15 Aug 2014, 12:29 PM
#3
raphael avatar

raphael

New Zenner

Join Date:
Jan 2011
Posts:
47
Plugin Contributions:
0

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

lat9:

When you installed ZC v1.5.3, did you first create a ***new ***database for the v1.5.3 content?

No didn't create a db.. I used the auto installer process which is provided by Godaddy. I actually made it through the v1.5.3 install to where that was up and running "empty thought". The trouble starts when trying to load the 1.3 db which has all of my product content.

15 Aug 2014, 1:51 PM
#4
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

raphael:

No didn't create a db.. I used the auto installer process which is provided by Godaddy. I actually made it through the v1.5.3 install to where that was up and running "empty thought". The trouble starts when trying to load the 1.3 db which has all of my product content.

Two (potentially three) things wrong with that, 1) should not use an autoinstaller, 2) when installing it's far easier in the whole process to use the same database table prefix in the new install as the old version. The potential third is using the host that is being used, but I have seen some successfully operate with it.

Can think of two ways to progress forward: create a new database and install ZC as advised through this website, or 2) identify the database currently associated with this new install and install as directed on website.

Have you since loading the old databases in gone back to zc_install to upgrade the database before trying to "use" it? (Not mentioned above)

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

15 Aug 2014, 5:07 PM
#5
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

The other problem with the autoinstaller is that you will NOT have a zc_install directory left after the auto install. You cannot update the database without the files in that directory.

I'd recommend you delete the auto-install, the database, and start over with a download of the latest 1.5.3. There ARE things in the download that won't be in the auto installer.

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

28 Aug 2014, 7:12 AM
#6
wrickspam avatar

wrickspam

New Zenner

Join Date:
Dec 2011
Location:
Emmen, The Netherlands
Posts:
85
Plugin Contributions:
0

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

On your old installation install apsona shopadmin -> export all the products+cats

On your new installation install apsona shopadmin -> import all the products+cats

wouldnt that be much easier ?

its worth a try i think

28 Aug 2014, 10:50 AM
#7
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

wrickspam:

On your old installation install apsona shopadmin -> export all the products+cats

On your new installation install apsona shopadmin -> import all the products+cats

wouldnt that be much easier ?

its worth a try i think

It would address (potentially) the products and categories, but it would not address alllll the other data that is contained in the database such as customers, purchase history, configuration settings, plugin associated data, etc...

State potentially regarding thecategories/products because I am not familiar with the inner workings of apsona to know if it does nything to identify the current database version on import and export and takes any action (if such is necessary) to upgrade the data.

Bottom line, this is not the way to upgrade a database. It would preserve the products/categories in one way or another.

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

2 Sep 2014, 9:50 AM
#8
wrickspam avatar

wrickspam

New Zenner

Join Date:
Dec 2011
Location:
Emmen, The Netherlands
Posts:
85
Plugin Contributions:
0

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

yes but if you are having problems with the upgrade process, its worth a try and i did it in this way when i had a half corrupted database and managed to save most of it...

you are right this does not include the orders/customers but this can help a lot if you want to keep your products and cats!

2 Sep 2014, 11:20 PM
#9
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

wrickspam:

yes but if you are having problems with the upgrade process, its worth a try and i did it in this way when i had a half corrupted database and managed to save most of it...

you are right this does not include the orders/customers but this can help a lot if you want to keep your products and cats!

Nodding in agreement, it will help salvage information that may otherwise end up lost. I wanted to be sure that others did not consider this as a way to salvage everything. Ie, to understand what they will and won't have after the fact.

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

3 Sep 2014, 2:10 PM
#10
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

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

This can be upgraded from 1.39 - 1.53 in a test environment, then published to the live site/final location. It takes an hour or two and worst case I manually edit the SQL data. This ensures no corruption, no lost data and any plugins can be found/fixed or removed if they are not compatible with 1.53.

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian

3 Sep 2014, 7:44 PM
#11
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

Me thinks Raphael has joined the other two ninja turtles elsewhere.:P

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

6 Sep 2014, 7:54 AM
#12
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

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?

6 Sep 2014, 12:57 PM
#13
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

lrfowler24:

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...................
Which password are you trying? The old password used to access the old database or the new password used to create the new install? Are you using the zc_install folder that comes with the Zc 1.5.3 Hotfix 1 version downloaded from this website?
lrfowler24:

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?
At what point in time did you make the backup of your old database? Before or after an action was taken to make it blank as you describe just above? If when the configure.php file settings are pointing at the old database and the old database is blank?! Then that indicates well, a blank database and that possibly a "frresh" install was performed on it. Please don't panic yet though. Some of this could be corrected.

Actually, I'm going to leave the above included here, but if all that you need to do is "reset" the password to support upgrading, go to this FAQ and perform the operation applicable to the version from which you are upgrading from, then do the zc_install with the credentials created from that action.
http://www.zen-cart.com/content.php?44-how-do-i-change-or-reset-my-admin-password-%28i-lost-it%29

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

6 Sep 2014, 3:18 PM
#14
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

I'm using the new password ...like I tried 100 times.......

6 Sep 2014, 3:26 PM
#15
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

ok..here's the scenario.............................2 databases .................. 1 is with the imported stuff from the old database.......................(tmf_test)........ .......i change the configure files to suit (tmf_test)............. the products show up in the zencart template but it says....... Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels.

ok..................... so then I do a zc_install........... I go to update database........... the @$!@!@# password doesnt work (the new password for the new admin page),,,,,,,,,,,,,

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)...

so............this seems to indicate there is a weird password thing with (tmf_test).?:wacko:

6 Sep 2014, 3:45 PM
#16
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

lrfowler24:

ok..................... so then I do a zc_install........... I go to update database........... the @$!@!@# password doesnt work (the new password for the new admin page),,,,,,,,,,,,,

Try using

the OLD, existing ADMIN password used/saved within the database version being updated

NOT the NEW password for the NEW admin.

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

6 Sep 2014, 11:57 PM
#17
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

even the old passwords dont work.............I can even say I lost my password........zencart sends me a new password........and it still doesnt work!!!

7 Sep 2014, 12:16 AM
#18
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:

Which password are you trying? The old password used to access the old database or the new password used to create the new install? Are you using the zc_install folder that comes with the Zc 1.5.3 Hotfix 1 version downloaded from this website?

At what point in time did you make the backup of your old database? Before or after an action was taken to make it blank as you describe just above? If when the configure.php file settings are pointing at the old database and the old database is blank?! Then that indicates well, a blank database and that possibly a "frresh" install was performed on it. Please don't panic yet though. Some of this could be corrected.

Actually, I'm going to leave the above included here, but if all that you need to do is "reset" the password to support upgrading, go to this FAQ and perform the operation applicable to the version from which you are upgrading from, then do the zc_install with the credentials created from that action.
http://www.zen-cart.com/content.php?44-how-do-i-change-or-reset-my-admin-password-%28i-lost-it%29

lrfowler24:

even the old passwords dont work.............I can even say I lost my password........zencart sends me a new password........and it still doesnt work!!!

So... When you populate the database with your old database, the old database table is formatted differently than the current database expected by the code. So, asking for a new password is likely not to populate the database properly... So, either you must use the old password (which you say you have forgotten) or you must set the password to something you know... If you goto the link above there are instructions to do that from myphpadmin. As I said you will need to follow the instructions applicable to the version of your old database...

Also, there are questions above that are unanswered like are you using the zc_install folder that comes with the hotfix 1 version of ZC? If not there is a known problem with the zc_install folder of the first release of zc 1.5.3 that are corrected in the hotfix.

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

7 Sep 2014, 12:28 AM
#19
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

mc12345678:

So, either you must use the old password (which you say you have forgotten) or you must set the password to something you know...

You also realize that when we say OLD password, we also mean to use the OLD admin name that is associated with the OLD password in the zc_installer.

Wouldn't it be easier to verify functionality of a vanilla v1.5.3 install with demo data, then import the OLD database into the database that you just proved functional.

Then, run zc_install using the admin login and matching password of the OLD database.

Modifying the config files to match a different database as it sounds like you are doing has the potential to compound the problem.

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

7 Sep 2014, 12:51 AM
#20
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

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.............