The installer could not find the required .SQL install file.

I am upgrading a zencart db from 1.2.0 to Current. Permissions are fine, db connection is fine, DB user has superuser privl'gs. But, when upgrading, (1.2.0 to 1.2.1 for ex) using the 1.3.2 zn_install tool, I get the following error:

mysql SQL Install file does not exist "mysql" more info...

I am using a fresh zip off sourceforge, and the following docs are in my zc_install dir:

convert_infopages_to_ezpages.sql        mysql_upgrade_zencart_121_to_122.sql
db_rebuild_autoincrement.sql            mysql_upgrade_zencart_122_to_123.sql
demo                                    mysql_upgrade_zencart_123_to_124.sql
includes                                mysql_upgrade_zencart_124_to_125.sql
index.php                               mysql_upgrade_zencart_125_to_126.sql
mysql_upgrade_zencart_104_to_111.sql    mysql_upgrade_zencart_126_to_127.sql
mysql_upgrade_zencart_110_to_111.sql    mysql_upgrade_zencart_127_to_130.sql
mysql_upgrade_zencart_110_to_112.sql    mysql_upgrade_zencart_1301_to_1302.sql
mysql_upgrade_zencart_112_to_113.sql    mysql_upgrade_zencart_130_to_1301.sql
mysql_upgrade_zencart_112_to_114.sql    mysql_zencart.sql
mysql_upgrade_zencart_114_patch1.sql    popup_help_screen.php
mysql_upgrade_zencart_114_to_120.sql    techsupp.php
mysql_upgrade_zencart_120_to_121.sql    version.php

All looks good to me... Any suggestions??

Thanks!

-Hannah

Were there any "warnings" on the System Inspection screen prior to going to the Database-Upgrade screen?

What is the link to your zc_install/techsupp.php ?

What is your PHP version?
Who is your host?

I'm working off a local development server at the moment, running php 5.1 and mySQL 4.1, *nix environment. This is not a public server, so I can't give you access to the technical support briefing. No warnings on the system checks pre-upgrade. I do open source CMS development on this box daily, so I doubt my server is at fault.

No worries... I ended up just running all the sql scripts via command line

So much for finding out the cause so that others don't stumble with a similar situation in the future.

Not that it matters ... nobody has ever reported that problem before as far as I recall. So it doesn't look like the majority of commercial webservers are a problem. :P

I'm getting this error right now. mysql_zencart.sql is where it should be but zen cart says it isn't:huh:

Try reloading the:
/zc_install

directory and all of its subdirectories and files ...

This may also mean that other files have problems if this fixes that error ...

Hi.

No that's done nothing. Did you see my screenshot in the other post? Do I need to tick any of the boxes shown? I tried clicking the first and it said 'no mysql". I then tried ignoring any of the boxes and going straight to "done with updates" - and got this http://localhost/new_shop/index.php

I did everything you stated in your well-written guide to upgrade on \new_shop and can't see what I've done wrong.

Just a quick note to let you know I ended up doing a fresh install for new_shop then copying and changing the name of the original database to "newshop" and then selected that through the fresh install. :thumbsup: