CAN'T INSTALL

[Guest]

please help. I have been trying to do a new installation and I am getting this error:

 

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

 

 

The only thing that I can see is wrong with it is that it should say:

 

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

 

 

but I can't seem to find out where to change it. please help

[peterr]

Hi,

 

The install path would all be relative, so it depends where you placed the '/catalog' path.

 

By the error message, the install path was in the same path as 'catalog', whereas a normal osC directory path structure, the install path is below /catalog

 

Peter

[Guest]

I placed the catalog path here:

 

www.mydomainname.com/catalog

 

the intall is in

 

www.mydomainname.com/catalog/install

[peterr]

Hi,

 

The install gets the location of the SQL file at line 44 of /catalog/install/templates/pages/install_3.php

 

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

 

so can you run a phpinfo() on the ../install path and see what the values for this is:

 

PATH_TRANSLATED

 

Peter

[Guest]

PATH_TRANSLATED shows up as

 

/usr/local/psa/home/vhosts/mydomainname.com/httpdocs/catalog/install/install.php

[peterr]

Hi,

 

Based on .........

 

I placed the catalog path here:

 

www.mydomainname.com/catalog

 

the intall is in

 

www.mydomainname.com/catalog/install

 

and this ..........

 

PATH_TRANSLATED shows up as

 

/usr/local/psa/home/vhosts/mydomainname.com/httpdocs/catalog/install/install.php

<{POST_SNAPBACK}>

 

something I can't quite figure out ?? I would have thought the path translated would be ...........

 

.........../mydomainname.com/catalog/install/install.php ??

 

Considering the path given for the first error msg, something is amiss ??

 

Lines 29 to 31 of /catalog/install/templates/pages/install_3.php are:

 

<p class="pageTitle">New Installation</p>

<p><b>Database Import</b></p>

 

please add a line in between ........

 

<p class="pageTitle">New Installation</p>
<?php echo 'dir_fs_www_root = ' . $dir_fs_www_root. '<br>'; ?>
<p><b>Database Import</b></p>

 

and then run the install, we should see what the PHP code thinks the path is.

 

Peter

[Guest]

dir_fs_www_root = /usr/local/psa/home/vhosts/

[peterr]

Hi,

 

dir_fs_www_root = /usr/local/psa/home/vhosts/

<{POST_SNAPBACK}>

 

Shouldn't it be:

 

dir_fs_www_root = /usr/local/psa/home/vhosts/mydomainname.com/catalog/

 

I'd contact your hosting company, something is not right with the path names.

 

Peter

[Guest]

that's what I thought too. how do I ask that? how can I prove that it's something wrong with it?

[peterr]

Hi,

 

that's what I thought too.  how do I ask that?  how can I prove that it's something wrong with it?

<{POST_SNAPBACK}>

 

Just create a small phpinfo like ........

 

<?php
phpinfo();
?>

 

upload it to your 'webroot' path, that is, wherever 'mydomainname.com' is, then run the script, and show them what the PATH_TRANSLATED is, I'm sure that '/httpdocs' will be in there, it shouldn't be, but I'm no *nix expert.

 

Peter

[Guest]

alright thanks

[Guest]

actually that path is right

 

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

[peterr]

Hi,

 

actually that path is right

 

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

<{POST_SNAPBACK}>

 

Well I don't know, you still need to approach your hosts about it, it is only a problem they can sort out, for example, if the above path _is_ really the web root path, then the 'install' would be looking here:

 

/usr/local/psa/home/vhosts/mydomainname.com/httpdocs/catalog/install/oscommerce.sql

 

for the SQL file, wouldn't it ?

 

You may even need a simple:

 

Options FollowSymLinks

 

placed in the .htaccess file in the 'web root' path.

 

Peter

[Guest]

I got it. thanks. I just maually put in the path to the file.

[Guest]

if it ain't one thing, it's another. now I cannot connect to the database in my admin folder. shouldn't everything be the same as what is in the config.php file? while installing, it did a test to make sure that it could connect to the database and that test was successful. any suggestions?

[peterr]

Hi,

 

If you can connect to the osCommerce site okay, but cannot connect to the db via admin, then check the configure.php in /admin/includes, the db connection should be exactly the same as it is for /catalog/includes/configure.php

 

Peter

[Guest]

oh. I'm stupid. thanks. I thought it would be the same config.php file.