Database upgrade from 1.3.9 to 1.5.4

Hi,

I' searched this forum for the answers about database upgrade and I have found some but none of them applied in my case. Let me explain in details.
I installed fresh copy of Zen cart 1.5.4 and create new (empty) database for this copy. My intention now is to link this zen cart copy to an old database that was used on my previous 1.3.9 zen cart website.

After I installed new Zen cart site I did the next:

1. I uploaded the old database
2. I re-write configure.php files (both non-admin and admin) with the old database name, database user and database user password. I did this in this way: first downloaded configure.php files, made the changes mentioned above and uploaded them back to the server.
3. I run zc_install and chose database upgrade.
4. I was asked for Admin Username (from Zen Cart® Admin area) and Password. I entered admin username and password for the admin area but failed. This is the problem: Admin Password required to proceed with upgrade
   It was clearly stated that I have to enter username and password of my website admin area and I did it.
5. I have searched this forum looking for the solution and found this: https://www.zen-cart.com/showthread.php?190672-Issue-with-upgrading-db-database-upgrade-required-please-run-the-1-3-9-to-1-5-0-upg
6. Following the suggestions from this topic, this time I entered my admin username and password of my database user but I saw the same problem as above.

Can someone help me to solve this problem? What username and password should I use?
To make this process easier for me in MYPHPAdmin area I created database user and its password and assigned it with full privileges to both - the new database and the old one).

Many thanks

I re-write configure.php files (both non-admin and admin) with the old database name, database user and database user password.
Your new DB already has a user & pass - no need to change this to the older ones
I was asked for Admin Username (from Zen Cart® Admin area) and Password. I entered admin username and password for the admin area but failed.
You need to use an admin name that was for your old DB and also the correct pass from the old DB/ZenCart

Sorry, but this is still confusing for me.

kobra:

Your new DB already has a user & pass - no need to change this to the older ones

My new DB has the same user & pass as the old DB. It means that I only changed DB name in configure.php file (at the beginning of this process I created one DB user in MySQL and assigned it to both DBs).

kobra:

You need to use an admin name that was for your old DB and also the correct pass from the old DB/ZenCart

Did I understand well? I have to use admin & password for the admin area of the website that was in place when I was using old DB. Not the admin username & password that I'm currently using for my fresh copy of zen cart site.

Did I understand well? I have to use admin & password for the admin area of the website that was in place when I was using old DB. Not the admin username & password that I'm currently using for my fresh copy of zen cart site.

Yes - you imported your old DB and the users and passwords are contained in the DB

Your fresh Admin user & pass have been overwritten

Can the dumped_db.sql be imported into the new db after setting up the store in a demo folder online without re-uploading the zc_install?

I skipped over the upgrade db because it was late.

webskipper:

Can the dumped_db.sql be imported into the new db after setting up the store in a demo folder online without re-uploading the zc_install?
If I understand you then NO
One needs to perform the Database upgrade to have a working "correctly" install and to do so requires the re-running of zc_install

I admit that I put off this upgrade from 1.5.1 to 1.5.4. I'm rusty now.


I backed up the old db per the instructions at:


https://www.zen-cart.com/content.php?144-how-can-i-do-a-database-backup-with-phpmyadmin


Then did a fresh install into a temporary directory /store/


Not wanting to install a gazillion old mods, I uploaded a responsive mod and looks like most of my old mods are included.


Satisfied with the look, It was time to import the old db to get the products loaded.


I opened the new db with php-admin and imported the old db.


401 queries executed

I did re-upload zc_install and chose option to upgrade the database. My browser cache is disabled.


None of my products are in the store. Just the demo products.

What's the next step?

webskipper:

None of my products are in the store. Just the demo products.

What's the next step?
Did your old DB have a prefix?? where your new DB did not or the reverse?

I do not use prefixes.

I have been looking at the debug results tonight and researching articles. Seeking to be re-enlightened.

Admin page works, except the Website Maintenance link results in a 500 error website/store/admin_name/configuration.php?gID=20

Debug log error: Access denied for user 'giggity'@'localhost' (using password: YES) in /home4/alright/public_html/store/includes/classes/db/mysql/query_factory.php on line 62

I did delete the mod. Just using the Classic template.

webskipper,

Do you have your cats & products appearing in your admin?
If so, have you cleared your browser's cache?

Yes and yes.

Yes cache is disabled and kept clear.

webskipper:

Yes and yes.
Well then are your 2 configure.php files pointing to the same places?

webskipper:

I do not use prefixes.

I have been looking at the debug results tonight and researching articles. Seeking to be re-enlightened.

Admin page works, except the Website Maintenance link results in a 500 error website/store/admin_name/configuration.php?gID=20

Debug log error: Access denied for user 'giggity'@'localhost' (using password: YES) in /home4/alright/public_html/store/includes/classes/db/mysql/query_factory.php on line 62

I did delete the mod. Just using the Classic template.

In "deleting" the mod, you were referring to the responsive template that was identified as added above, correct?

While the identification of which database is associated with which side of the store continues applicable, there's a few things that can be checked/done. 1) regarding the above, what user groups exist in the admin access area? To what group is your profile attached/assigned? 2) earlier stated that in the process of loading the old database that accessed the database and then imported the old database. Were the tables dropped as part of that process? Ie, all data in the database related only to the old database? 3) when performing the database upgrade, at the point of being offered checkboxes for upgrading from and to a version, were the checkboxes between and including the previous version of ZC preselected? If so, this condition doesn't make sense as the zc_install process uses the store side database information not the admin side when performing a database only upgrade. That is unless the zc_install earlier on installed an older version of ZC and then the upgrade upgraded the old style of the blank database and that there is a discrepancy between the store side and admin side database information or if the above statement of the cache being cleared because not being maintained is untrue.