Stuck on step 3...says SQL file does not exist

[jtmoney77]

On step 3, it says

 

The following error has occurred:

SQL file does not exist: /install/oscommerce.sql

 

It read test connection to database was successful. After I hit continue it says SQL file cant be found. Not sure why it would say that, any ideas?

[Destra]

I don't want to state the obvious but if you check catalog/install is oscommerce.sql file in that directory. osCommerce needs this file to create the default database. FTP into that directory and check to see if present and that the attributes are set so that you can access it.

[AlanR]

Apparently the fix in this thread helps on some servers.

 

http://www.oscommerce.com/forums/index.php?showtopic=89561

 

If you don't succeed post back.

[jtmoney77]

This seems like this would fix the problem. Do you think that my host can change their settings to solve my issue?

 

In short look through the files under /install and replace any "getenv" Apache variables with the PHP equivalent variable and you will be in luck

 

I am really not sure how to change these variables like it says above. If my host can adjust to my needs it will help me out alot.

 

Please advise.....

[Destra]

Basically what he is saying is search through all the files in your install directory for

getenv(SCRIPT_FILENAME)

and change to

$_SERVER["SCRIPT_FILENAME"]

 

When I searched a clean osCommerce there are only 10 instances all in

catalog/install/templates/pages and in the three files install2.php, install3.php and install4.php. This should make changing the getenv to $_SERVER much easier. I don't know if this is the same for you but it should be. :D