Installation: stuck on oscommerce.sql file

[paul t]

I have been wading through the forums trying to find an applicable solution to what seems like a relatively common problem. During installation I encounter the error:

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

Prior to that I do get a successful test connection with the note:

 

The file to import must be located and named at:

 

C:/install/oscommerce.sql

 

Clearly the problem is that installation is using an absolute path rather than a relative path. Some background on the installation: osCommerce is being installed on a shared Windows 2003 Server with IIS and running PHP 5.0. All files were FTP'd to the server; I FTP'd the /catalog/ and /extras/ folders into the website's "root" path available to me. I had to install a contribution patch into osCommerce to turn register_globals off (register_globals_patch_2005-01-05_1.zip). I then modified files install_2.php, install_3.php, and install_4.php in the install/templates/pages/ directory according to another post to get setup to recognize the Windows server and make a test connection to the database. I have only FTP access to the web server, not admin rights (the ISP hosting company does).

 

This is evidently a relatively common problem and yet the only solution is apparently using phpMyAdmin to execute the oscommerce.sql file on the MySQL server. I do not have direct access to the MySQL server to run phpMyAdmin. I am looking for any suggestions at all. I am very willing to have someone expert finish the installation for me (please contact me if interested in helping). I am not familiar with PHP (nor any other scripting/programming languages) or MySQL, just HTML, CSS, a little JavaScript, etc. I am trying to set this website up for a charity cause for the upcoming holidays, so any assistance would be VERY much appreciated. Thank you in advance.

[♥Vger]

Problems summary:

 

1. It's a Windows server

2. It uses php5

3. It has Register Globals 'off'

4. You don't have phpMyAdmin access

 

Solution:

 

1. Move to an Apache server which uses php4, has Register Globals 'on' and where the host gives you phpMyAdmin access.

 

With the setup you currently have you're going to get nothing but grief ....sorry!

 

Vger

[paul t]

Problems summary:

 

1. It's a Windows server

2. It uses php5

3. It has Register Globals 'off'

4. You don't have phpMyAdmin access

 

Solution:

 

1. Move to an Apache server which uses php4, has Register Globals 'on' and where the host gives you phpMyAdmin access.

 

With the setup you currently have you're going to get nothing but grief ....sorry!

 

Vger

I appreciate the quick response. Is there no way to edit any of the files to get the installation to look for and find the oscommerce.sql file where it belongs/resides, e.g., the /install/ directory?

 

For instance, in the install/templates/pages/install_3.php file, there is a line:

 

$sql_file = $dir_fs_www_root . 'install/oscommerce.sql';

 

Is this what is telling installation where to look? If yes, is there rewrite to make it relative?

 

I have made edits to this and two other files in response to a previous error; in order to get the installation to correctly identify the Windows server, I changed all instances of:

 

$script_filename = getenv('PATH_TRANSLATED');

and

$script_filename = getenv('SCRIPT_FILENAME');

 

to:

 

$script_filename = $_SERVER["PATH_TRANSLATED"];

and

$script_filename = $_SERVER["SCRIPT_FILENAME"];

 

Would this have an effect on the path installation is looking in for oscommerce.sql?

 

For political reasons I'm trying to stay with this ISP since they are giving the charity free hosting. So my struggles are worth it if they can be overcome.

 

BTW, my mistake, but when I mentioned that I had installed the contribution patch for register_globals, that was to null the need for them to be on. I noticed that you also created a contribution patch for just such an issue.

 

Again, thanks in advance for any help or insight.