Problem upgrading - it says sql files are missing?

Hello,

I am trying to upgrade the database but it seems that the following files are missing:

mysql_upgrade_zencart_135_to_136.sql SQL Install file does not exist
"mysql_upgrade_zencart_135_to_136.sql"

mysql_upgrade_zencart_136_to_137.sql SQL Install file does not exist
"mysql_upgrade_zencart_136_to_137.sql"

Where do I get these files from so I can upgrade?
I have tried downloading the latest zencart but these files are not there.

Thanks.

I'm also trying to upgrade my database and after entering my username and password and clicking on the upgrade database button in the install I was took to the next page which was completely blank! Is there another way to upgrade the database?

Thanks

Steven

ksmglobal, The files are in the download. Please download and look again.

Nedward, I think the install is expecting the admin folder to be named admin. Make a temporary change for this during the upgrade then go back and rename the folder to a secured or random characters.

Zen Cart team, If I am correct about the admin folder statement above, would you consider adding another variable on the upgrade page to include the admin folder new name?

just add a blank admin/includes folders and a blank configure.php

Merlinpa1969:

just add a blank admin/includes folders and a blank configure.php

Hi Merlin,

Question -- What if you have additions that were added to your admin, such as "quickupdates" or the QBI module? Wouldn't it be best to just rename the folder back to admin, rather than create a blank so that the additional files created remain? Or are they completely overwritten? How do I integrate the new with the old but keep my customizations? -- I have a lot of customizations on a couple of carts, and am very nervous about updating them. I've not updated before, so I'm completely a newbie at the updating process. Are there instructions on this process included in the readme files or is this in the "help" section? Sorry for my lameness.

Thanks as always for your energy.
Kinget

kinget:

Wouldn't it be best to just rename the folder back to admin, rather than create a blank so that the additional files created remain?

The best way is to simply rename your "admin" folder back to "admin" for the 3 minutes it takes to do the database upgrade. Then rename it back to your custom name once the upgrade is done.

Granted, the zc_install upgrade process no longer requires visibility of the admin folder during upgrades. As long as it can validate the storefront as being functional, it will ignore the admin side during the upgrade.

Nedward:

I'm also trying to upgrade my database and after entering my username and password and clicking on the upgrade database button in the install I was took to the next page which was completely blank! Is there another way to upgrade the database?You most likely have some files that didn't upload successfully.

DrByte:

The best way is to simply rename your "admin" folder back to "admin" for the 3 minutes it takes to do the database upgrade. Then rename it back to your custom name once the upgrade is done.

Granted, the zc_install upgrade process no longer requires visibility of the admin folder during upgrades. As long as it can validate the storefront as being functional, it will ignore the admin side during the upgrade.

Thank you for clarifying.
Kinget :-)

Hi I got past my upgrading the database problem by resetting the admin name and password.
I'm sure I was entering the correct name and password in my earlier attempts, but if I wasn't shouldn't Zencart have said so?

Instead I was just given a white page. Odd.:blink:

anyway keep up the good work guys, I'll keep plugging away with my new install.

Regards

Steven

DrByte:

You most likely have some files that didn't upload successfully.

I have the same problem as Ned did. A blank screen after starting the database upgrade.

Ive used Beyond Compare to make sure all the files are there. They are.
Ive reset the admin password.

Still get a blank screen.

Anyone got any ideas what's going on?

Mark

Nedward:

Hi I got past my upgrading the database problem by resetting the admin name and password.
I'm sure I was entering the correct name and password in my earlier attempts, but if I wasn't shouldn't Zencart have said so?Yes, if the wrong username/password are used, it will say so.

Resetting the password shouldn't be necessary, and is unlikely to be related to blank screen problems.

mriffey:

I have the same problem as Ned did. A blank screen after starting the database upgrade.

Still get a blank screen.What version are you upgrading from?
Did the installer flag any warnings/alerts prior to getting to the upgrade page?
You are upgrading in a test area, right?

DrByte:

What version are you upgrading from?
Did the installer flag any warnings/alerts prior to getting to the upgrade page?
You are upgrading in a test area, right?

I uploaded the source files for 1.3.8 to an EMPTY folder.

I exported the data from an existing 1.2.6 zencart (since the templates arent compatible) and created a new copy of the database for this 1.3.8 installation.

I copied the config files from that same existing 1.2.6 zencart and altered the dbname to point at the new db. The userid accessing both DBs is the same, so I know it works (ie: the live cart still works).

All the permissions are set right.

Been using ZC for years, OsC before that.

I ended up having to upgrade manually using the sql scripts (I dont use prefixes), and then completed the install normally.

Too many people are reporting this in too many situations for it to be "just dumb user mistakes", IMO. Especially with no error messages and a blank browser page.

If you'd like the sql script of the backup so you can test privately, PM me.

Mark