Can't get past this error;

[ecjr72]

I'm trying to install a new copy of oscommerce but I cant figure out how to get past this error;

 

The following error has occurred:

 

SQL file does not exist: /usr/local/psa/home/vhosts/install/oscommerce.sql

 

The oscommerce.sql file is in the install folder but it cant seem to find it. Please help thank you.

[♥Vger]

You are probably trying to install on a Windows server.

If they were people - they wouldn't be able to find their own way home.

You need to edit install/templates/pages/install_3.php and where you see:

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

 

Edit it to (change /path_to_root/ to real path):

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

 

You will need to know the path to the root of your website.

Check with your hosting company if you don't know.

 

Vger

[ecjr72]

My path to the root was correct I checked with my server. Ive tried changing the path to root with no luck. Is there any other reason why I can't get past this step?

[♥Vger]

To double check your path do this:

 

1. Create a text file on your desktop and rename it to cwd.php (ignore the warning about changing the file extension)

2. Put this code in it:

<?php
$p = getcwd();
echo $p;
?>

3. Upload cwd.php to the root of your website

4. Go to the root of your website in your browser and add the filename to it e.g. http://www.yourdomain.com/cwd.php - and this will print out the pathway on the screen.

5. Make a note of the pathway for future use, and then delete the file from your site.

 

Vger

[ecjr72]

This is the path to root I got ;

/usr/local/psa/home/vhosts/mysite.com/httpdocs

 

I tried plugging this in but still no go.

[ecjr72]

Got it! thanks for all your help Vger. :thumbsup: