SQL Install file does not exist

[losse]

Hi
I'm running the database upgrade off zc_install. I get this error when trying to run it:

SQL Install file does not exist
The installer could not find the required .SQL install file. This should exist within the 'zc_install/sql' directory and be called something like 'mysql_zencart.sql'.

When I look in the zc_install/sql folder, the file is there! Just wondering why it's doing that. I tried changing the permissions to 777 but that didn't work either.

What I'm trying to do is get the "Your database appears to need patching to a higher level. See Admin->Tools->Server Information to review patch levels." error off my homepage.

[losse]

Anyone? I'm surprised no one else is experiencing this!?

[Vger]

I'm surprised no one else is experiencing this

Actually, it is a common occurence - but only on Windows servers. If Windows servers were people they wouldn't be able to find their own way home in the dark.

There are two possible solutions:

1. Hardcode the full pathway to the sql file in all affected files.
2. Move to a Linux server.

Vger

[losse]

Vger
What do I actually hardcode? Where is the SQL file referenced so that I can find and change the path?

[Vger]

zc_install\techsupp.php(256): $path = (substr_count(__FILE__,'zc_install') || file_exists('mysql_zencart.sql')) ? '../' : '';
zc_install\techsupp.php(273): <?php if (substr_count(__FILE__,'zc_install') <1 && !file_exists('mysql_zencart.sql') ) {
zc_install\includes\languages\english.php(361): define('POPUP_ERROR_TEXT', 'The installer could not find the required .SQL install file. This should exist within the \'zc_install/sql\' directory and be called something like \'mysql_zencart.sql\'.');

Vger

[DrByte]

When I look in the zc_install/sql folder, the file is there!

The help text isn't telling you exactly which file is missing. It's simply giving an example, and that example is for a fresh new install, not an upgrade.

Which database-upgrade "checkboxes" did you have checked?
What *.sql filenames exist in your /zc_install/sql/ folder?

[losse]

Hi there
I actually clicked on all the checkboxes in the DB update section. Here they are:

Upgrade DB from 1.0.4 to 1.1.1
Upgrade DB from 1.1.0 to 1.1.1
Upgrade DB from 1.1.1 to 1.1.2
Upgrade DB from 1.1.2 or 1.1.3 to 1.1.4
Upgrade DB from 1.1.4 to 1.1.4-patch1
Upgrade DB from 1.1.4-x to 1.2.0
Upgrade DB from 1.2.0 to 1.2.1
Upgrade DB from 1.2.1 to 1.2.2
Upgrade DB from 1.2.2 to 1.2.3
Upgrade DB from 1.2.3 to 1.2.4
Upgrade DB from 1.2.4 to 1.2.5
Upgrade DB from 1.2.5 to 1.2.6
Upgrade DB from 1.2.6 to 1.2.7
Upgrade DB from 1.2.7 to 1.3.0
Upgrade DB from 1.3.0 to 1.3.0.1
Upgrade DB from 1.3.0.1 to 1.3.0.2
Upgrade DB from 1.3.0.2 to 1.3.5
Upgrade DB from 1.3.5 to 1.3.6
Upgrade DB from 1.3.6 to 1.3.7
Upgrade DB from 1.3.7 to 1.3.8
Upgrade DB from 1.3.8 to 1.3.9


As for which SQL files exist in the folder, it's the following. I've truncated the file names just to expedite the post.

mysql_upgrade_zencart_104_to_111.sql
110 to 111
110-112
112-113
112-114
114 patch 1
114-120
120 - 121
121 - 122
122 - 123
123 - 124
124 - 125
125 - 126
126-127
127-130
1301-1302
1302-135
130-1301
135-136
136-137
137-138
138-139
mysql_zencart.sql

[DrByte]

I actually clicked on all the checkboxes in the DB update section.

Um, why?

[losse]

I wanted to make sure that I had all the updates installed... That wasn't a good thing?

[DrByte]

The software evaluates your database to see what's needed, and automatically checks the boxes for the steps that it knows need to be done.
If in doubt, clicking the "Recheck" button will re-scan and see what's needed.

In almost all cases you should never normally need to check a box that isn't automatically checked. They're made available for ease of troubleshooting if it were necessary, but those unchecked boxes are really not intended to be used unless you have very acute knowledge of the what and why behind each.