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

[pat185]

Hi,

 

Am doing a first time install .....

 

1) I browse to http://pcstart/catalog/install/

2) Enter in the database name etc etc etc ....

3) Get a message saying it can connect to the database then at the next stage ...

 

Database Import

 

The following error has occurred:

 

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

 

The thing is that the file DOES exist .... for example if I go to:

 

http://pcstart/catalog/install/oscommerce.sql

 

I can see the file in my browser ... so it IS there ... !

 

The things you do at midnite on a Saturday nite eh ... can anyone explain this :D

 

Many thanks.

 

Patrick

[clive]

Hi

 

I'm new to this so I apologise if I have read your problem wrong.

 

It appears that you have not set up a database in mysql for the programme to read.

 

Your first step should be to create a database in mysql with permissions and password.

 

Then run the install programme entering the database name and password and any other information. The install programme will then read the http://pcstart/catalog/install/oscommerce.sql file and export to your database within mysql.

 

Please read the install instructions to set permissions for the relevant files and create .htaccess for your admin.

 

I hope this helps

[pat185]

Well ... in step 2 the install screen tells me that it can connect to the database so there is a database there. Am using IIS - IUSR_localhost does have permissions to read the folder of files ...

 

Mmmm ... will ponder.

 

Patrick

[pat185]

ps as the error is :

 

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

 

 

and not a full path i.e. //localhost/catalog/ etc etc

 

is there something funny about my path here?

 

Patrick

[Scizod]

I've been having the exact same problem. I thought maybe I had interrupted the upload and my file had become corrupt so I re-installed it. Nothing has worked so far, very frustrating.

[♥Vger]

The problem is that you are using Windows servers, and if Windows servers were people they wouldn't be able to find their own way home in the dark.

 

Try this:

 

In install/templates/pages/install_3.php on line 35, where you see this:

 

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

 

change it to something like this (example pathway only):

 

$sql_file = $dir_fs_www_root . '/var/www/html/install/readycart.sql';

 

You do need to know the pathway to the root of your web (check with your hosting company).

 

Vger

[pat185]

I've been having the exact same problem. I thought maybe I had interrupted the upload and my file had become corrupt so I re-installed it. Nothing has worked so far, very frustrating.

 

Nice to know it is not only me .. !

 

Patrick

[pat185]

Many many thanks ....

 

This worked for me on line 44 ->

 

 

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

 

I assumed there was some sort of permissions problem myself.

 

Thanks for your help.

 

Patrick

[Scizod]

I ended up just switching to a linux server, and everything installed with no problems. Now, i'm just learning how to get the store set up.

 

scizod