Installation Step 3 oscommerce.sql path wrong

[cyclonut]

Hi all!

I am in Step 3 of the database installation on my server, but get a message "SQL file does not exist: /install/oscommerce.sql". I looked at the server with my FTP program, and found the said file, burried one more level, under initially a Catalog folder, that is at the path catalog//install/oscommerce.sql .

Am I the first one to encounter this, or did I upload the catalog file in the wrong place (root directory of my previously made web site www.nakorro.com, which I would like to amend by adding the on-line shopping program of OsCommerce). I would imagine that I need somehow to change some file in the installation procedure, to recognize this deeper location of the oscommerce.sql file?

 

And, as a second question, could anyone tell me if I need to add some other directory to the server, to store the oscommerce database and the on-line store, separate from my "static" home page web site?

 

Thank you very much for any responses!

[♥Vger]

On line 44 of install_3.php (in the install folder), change it from:

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

 

to this:

 

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

 

Vger

[cyclonut]

Thanks Vger for your help. I thought your solution would work also, and I made change to the path as suggested. I ensured there were no spelling errors, and saved this file install_3.php, with the right PHP extension, and uploaded the file into the subdirectory Nakorro/catalog/install/templates/pages.

Re-running the Installation, I got the upgraded message: "SQL file does not exist: /catalog/install/oscommerce.sql" . ... what a bummer!

 

I checked with my FTP that the oscommerce.sql is indeed there, and now am thinking that it may have something to do with the original web site that is still there, referred to as main directory Nakorro. I read in the threads something about not just uploading the catalog folder, but it's contents, but I did not want to polute my server, so I uploaded the catalog folder from my desktop. So, the actual path for everything has "Nakorro" as a pre-fix, do I need to add this to the install_3.php file, and any other one, or should I upload to some other path?

 

Would this help to diagnose my problem? And as also asked last time, could these two entities, my original web site, and this installation, be able to co-exist?

 

Thanks for any help, Tibor(cyclonut).

[MaBiSmAd]

Thanks Vger for your help. I thought your solution would work also, and I made change to the path as suggested. I ensured there were no spelling errors, and saved this file install_3.php, with the right PHP extension, and uploaded the file into the subdirectory Nakorro/catalog/install/templates/pages.

Re-running the Installation, I got the upgraded message: "SQL file does not exist: /catalog/install/oscommerce.sql" . ... what a bummer!

 

I checked with my FTP that the oscommerce.sql is indeed there, and now am thinking that it may have something to do with the original web site that is still there, referred to as main directory Nakorro. I read in the threads something about not just uploading the catalog folder, but it's contents, but I did not want to polute my server, so I uploaded the catalog folder from my desktop. So, the actual path for everything has "Nakorro" as a pre-fix, do I need to add this to the install_3.php file, and any other one, or should I upload to some other path?

 

Would this help to diagnose my problem? And as also asked last time, could these two entities, my original web site, and this installation, be able to co-exist?

 

Thanks for any help, Tibor(cyclonut).

 

The - $dir_fs_www_root portion of the assignemt statment is is not being set correctly (I am guessing that this is on a Windows operating system.)

 

The easiest way to work around this is to change this whole line to an absolute path (I also saw a recent post on this where the recommendation was to make a change to the code that sets $dir_fs_www_root but I think that the result did not work as well.)

 

Change the original -

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

 

To -

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

 

You will need to determine and fill in the correct path information.

 

The coexistance of two copies, one in the root and one in the catalog folder does not matter. The install folder you browse to will be the one that is installed and where the configure files will be placed.

[cyclonut]

Thanks MaBiSmAd for your idea!

 

I tried various paths, such as the following, not really knowing which way it should be done, but still get the same warning, quoting each time the tried path:

$sql_file = 'http://64.202.163.208/catalog/install/oscommerce.sql';

$sql_file = 'http://www.nakorro.com/catalog/install/oscommerce.sql';

$sql_file = 'nakorro/catalog/install/oscommerce.sql';

$sql_file = 'http://nakorro.com/catalog/install/oscommerce.sql';

 

Yes, the server by GoDaddy uses Windows, according to their site, and the hosting manager is at the following address, if this helps any:

https://hostingmanager.secureserver.net/ControlPanel.aspx. I did not try this address in my install_3.php file, should I?

Also, I set Yes, to install/use DSN for the database, to establish the seed database on the server. I am hoping that this installation procedure will complete the installation of the database, complete with the sampla data. I am using the latest version of the osCommerce 2.2 Milestone 2 Update 051113, and confirmed that the server already has on it the MySQL database, and phpMyAdmin. What else do I need to provide, or try??

Thanks in advance, Tibor.

[cyclonut]

Also tried the following versions of this line in install_3.php:

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

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

$sql_file = 'install/oscommerce.sql';

...but get the same error message.

[cyclonut]

Thanks MaBiSmAd for your idea!

 

I tried various paths, such as the following, not really knowing which way it should be done, but still get the same warning, quoting each time the tried path:

$sql_file = 'http://64.202.163.208/catalog/install/oscommerce.sql';

$sql_file = 'http://www.nakorro.com/catalog/install/oscommerce.sql';

$sql_file = 'nakorro/catalog/install/oscommerce.sql';

$sql_file = 'http://nakorro.com/catalog/install/oscommerce.sql';

 

Yes, the server by GoDaddy uses Windows, according to their site, and the hosting manager is at the following address, if this helps any:

https://hostingmanager.secureserver.net/ControlPanel.aspx. I did not try this address in my install_3.php file, should I?

Also, I set Yes, to install/use DNS (used to say DSN, sorry, corrected) for the database, to establish the seed database on the server. I am hoping that this installation procedure will complete the installation of the database, complete with the sampla data. I am using the latest version of the osCommerce 2.2 Milestone 2 Update 051113, and confirmed that the server already has on it the MySQL database, and phpMyAdmin. What else do I need to provide, or try??

Thanks in advance, Tibor.

 

Above, I meant to say DNS (Domain Name Server) - whould this be causing all this havoc, as the definition of DNS is, that it acts as a phone book to paths, but I just thought that it translates a name like www.nakorro.com to where the site is, at 64.202.163.208, what do you think?

[MaBiSmAd]

Thanks MaBiSmAd for your idea!

 

I tried various paths, such as the following, not really knowing which way it should be done, but still get the same warning, quoting each time the tried path:

$sql_file = 'http://64.202.163.208/catalog/install/oscommerce.sql';

$sql_file = 'http://www.nakorro.com/catalog/install/oscommerce.sql';

$sql_file = 'nakorro/catalog/install/oscommerce.sql';

$sql_file = 'http://nakorro.com/catalog/install/oscommerce.sql';

 

Yes, the server by GoDaddy uses Windows, according to their site, and the hosting manager is at the following address, if this helps any:

https://hostingmanager.secureserver.net/ControlPanel.aspx. I did not try this address in my install_3.php file, should I?

Also, I set Yes, to install/use DSN for the database, to establish the seed database on the server. I am hoping that this installation procedure will complete the installation of the database, complete with the sampla data. I am using the latest version of the osCommerce 2.2 Milestone 2 Update 051113, and confirmed that the server already has on it the MySQL database, and phpMyAdmin. What else do I need to provide, or try??

Thanks in advance, Tibor.

 

You might be able to determine the physical path on your server through your control panel (probably in the file manager section.) It will be something like - c:/domains/your_domain/

 

Then if you have oscommerce in the /catalog/ folder (One of your posts indicates that this might be in nakorro/catalog/) this would become - c:/domains/your_domain/catalog/ (or c:/domains/your_domain/nakorro/catalog/)

 

The line in the file will end up looking something like this -

$sql_file = 'c:/domains/your_domain/catalog/install/oscommerce.sql';

or

$sql_file = 'c:/domains/your_domain/nakorro/catalog/install/oscommerce.sql';

depending on where you put the catalog folder...

[cyclonut]

:D Yes, I can use a smiley now, it worked! THANKS! This should end this question.

 

I found the path by first installing a simple file called info.php in the root directory, that when located with my browser, and executed, reported long list of stuff, including a table called ISAP, in which service variable APPL_PHYSICAL_PATH was reported as d:\hosting\nakorro, so I knew I was on the track. Then, I simply followed your instrtuctions, and typed in on line 44 of install_3.php this direct address line:

$sql_file = 'd:/hosting/nakorro/catalog/install/oscommerce.sql';

uploaded with my FTP Voyager, and voila, it worked!

So, thank you all very much for thinking about my problem and solving it, onto the next problem, I am sure I will be back!

Tibor.

 

...so this should end my question, but I don't know what to click to end it, unless someone else wants to continue this thread with their own issue...

[MaBiSmAd]

:D Yes, I can use a smiley now, it worked! THANKS! This should end this question.

 

I found the path by first installing a simple file called info.php in the root directory, that when located with my browser, and executed, reported long list of stuff, including a table called ISAP, in which service variable APPL_PHYSICAL_PATH was reported as d:\hosting\nakorro, so I knew I was on the track. Then, I simply followed your instrtuctions, and typed in on line 44 of install_3.php this direct address line:

$sql_file = 'd:/hosting/nakorro/catalog/install/oscommerce.sql';

uploaded with my FTP Voyager, and voila, it worked!

So, thank you all very much for thinking about my problem and solving it, onto the next problem, I am sure I will be back!

Tibor.

 

...so this should end my question, but I don't know what to click to end it, unless someone else wants to continue this thread with their own issue...

 

It is nice to "win one" once in a while. Thanks. You don't do anything to close a thread, they just die when no one has anything more to write.

[low80elco]

THANK YOU SOOO MUCH!!!! This has been a huge problem for me. Chalk up another win!!! :)

[Guest]

Hello, can you tell me where I can get the info.php so that can find out my path too? Please help! I am having the same problem!

 

:D Yes, I can use a smiley now, it worked! THANKS! This should end this question.

 

I found the path by first installing a simple file called info.php in the root directory, that when located with my browser, and executed, reported long list of stuff, including a table called ISAP, in which service variable APPL_PHYSICAL_PATH was reported as d:\hosting\nakorro, so I knew I was on the track. Then, I simply followed your instrtuctions, and typed in on line 44 of install_3.php this direct address line:

$sql_file = 'd:/hosting/nakorro/catalog/install/oscommerce.sql';

uploaded with my FTP Voyager, and voila, it worked!

So, thank you all very much for thinking about my problem and solving it, onto the next problem, I am sure I will be back!

Tibor.

 

...so this should end my question, but I don't know what to click to end it, unless someone else wants to continue this thread with their own issue...

[AlanR]

Hello, can you tell me where I can get the info.php so that can find out my path too? Please help! I am having the same problem!

You can use this script:

 

Just save it to your server as myroot.php or something

<?php
  echo '<br>$DOCUMENT_ROOT = ' . "$DOCUMENT_ROOT";
  echo '<br>getenv(\'DOCUMENT_ROOT\') = ' . getenv('DOCUMENT_ROOT');
?>

 

Both responses should be the same but some servers (usually MS) don't recognize one or the other.

 

You'll also find this info in your server control panel somewhere.

[cyclonut]

I used the following:

 

<html>

<head>

<title>PHP Information</title>

</head>

<body>

<?php phpinfo(); ?>

</body>

</html>

 

Copy and past this using your text editor, like Word pad, (not Word), save it as a php extension, and upload into your host server where you have your web site. Then access it using your browser, typing in www.your_website\info.php

Good luck, let me know how you made out, and if you get through Step 4, maybe you can tell me how you did it, as I am not getting any help on this from the moderators here.

Tibor.

[tommymadison]

Hi. Same problem, however, I am not even able to change what the install program is looking for. Any ideas?

 

Thanks much.

[Guest]

Thanks guys - it worked! However, after completing the installation and trying to access my catalog. It brings back to the install screen. Do you know why that is?

[tommymadison]

Hi. Same problem, however, I am not even able to change what the install program is looking for. Any ideas?

 

Thanks much.

 

 

Got it. Thanks again to all in this thread.

[zag]

I have the same problem with the installation of 'osCommerce 2.2 Milestone 2 Update 051113'.

I tried to change the path information to:

catalog/... and to home/breadcrumbs.de/public_html/catalog/... with no effect.

The Server is having Linux installed. Webserver is Apache. The oscommerce.sql file is in its correct place.

 

Does anyone know what to do?