I don't have this path /usr/local/psa/home/vhosts/

[Somps]

I don't have this path /usr/local/psa/home/vhosts/install/oscommerce.sql

 

I have setup a DB and all the configuration.php files are set to 777. My host has set up a list of folders for me and has specified that all my uploads should go into the httpdocs/httpsdocs folder(s). I uploaded the "catalog" folder to the httpdocs folder and then went to my browser and typed www.mysite.com/catalog/index.php which gave me the "Install" screen. I went through the first few steps successfully, but when it starts to do the database import, I get this error:

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

 

here is my folder structure:

 

 

//anon_ftp

//bin

//cert (hidden)

//cgi-bin

//conf

//error_docs

//httpdocs

//httpsdocs

//pd

//tmp (hidden)

//web_users

 

so my catalog folder is in httpdocs which has an install folder which contains the sql file.

 

What am I doing wrong? HELLLLPPPP!

[mi_jaiten]

I don't have this path /usr/local/psa/home/vhosts/install/oscommerce.sql

 

I have setup a DB and all the configuration.php files are set to 777.  My host has set up a list of folders for me and has specified that all my uploads should go into the httpdocs/httpsdocs folder(s). I uploaded the "catalog" folder to the httpdocs folder and then went to my browser and typed www.mysite.com/catalog/index.php which gave me the "Install" screen. I went through the first few steps successfully, but when it starts to do the database import, I get this error:

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

 

here is my folder structure:

//anon_ftp

//bin

//cert (hidden)

//cgi-bin

//conf

//error_docs

//httpdocs

//httpsdocs

//pd

//tmp (hidden)

//web_users

 

so my catalog folder is in httpdocs which has an install folder which contains the sql file.

 

What am I doing wrong? HELLLLPPPP!

<{POST_SNAPBACK}>

 

You've double posted goto this one

 

http://www.oscommerce.com/forums/index.php?showtopic=161656

[Guest]

It really does help if you can work within PHPmyAdmin on these things. OK it's another thing to learn (to trust actually) but it does work.

 

I have exactly the same file structure as you. Don't worry.

 

I think you want to update your database. Or even install it for the first time. You will probably want to do this in future. You can skip that part of the basic installation. And apply the db afterwards. Here is how.

 

In my case I log into my web site provider and end up in PHPmyadmin. (By doing this we are not using the install feature of OSC, which is debatabley faulty. We are populating the database directly into the server using the web site providers interface).

 

In my case I find a page that says run SQL queries. The query is nothing more complicated than a file named oscommerce.sql. (which you have) or any other file that you have made a backup of in the admin section of OScommerce. I simply browse and select the file in "Or location of text file" from my hardisk and push the button. Both the data and the structure of the db is updated.

 

In the first instance your default db will be oscommerce.sql, and will be loaded with videos. But if you alter the db, back it up in the admin section of OSC, your products will thankfully appear if you upload it using the PHPadmin section of your internet host.

 

Feel free to ask more.

 

To get you kicked off however I suggest that the path is this. In configure.php (under includes) and can be used in the installation process.

 

define('HTTP_SERVER', 'http://YOUR_WEB'); // eg, http://localhost - should not be empty for productive servers

 

define('HTTPS_SERVER', 'https://YOUR_PROVIDOR/~YOUR_WEB.com'); // eg, https://localhost - should not be empty for productive servers

define('DIR_FS_CATALOG', '/usr/local/psa/home/vhosts/YOUR_WEB.com/httpdocs/YOUR_DIRECTORY/');

 

Therefore your paths are

 

usr/local/psa/home/vhosts/YOUR_WEB.com/httpdocs/YOUR_DIRECTORY/

 

 

 

This should work - at least I hope so. You should be able to install with the installation procedures of OSC. When updating your website, leave configure.php alone (assuming your online site works without errors) . This is where the paths are recorded, and if you design locally and upload you will appreciate this tip enormously.

 

If you send me configure .php to [email protected] (with confidential information substituted) I can probably help you out if the above fails.

 

 

 

Charlie in Brazil.

[Guest]

The usual mammoth blunder.

 

 

I meant MySqlAdmin. Wherever you read MYPHPAdmin, think mySQLAdmin.

 

 

Sorry.

 

Ch

[Somps]

Thank you so much Charlie! Sorry for the double post.

 

Charlie. I will send you an email.

 

Thanx so much!

[♥Vger]

MySQLAdmin is phpMyAdmin. It's just called MySQL Admin in your web hosting control panel.

 

The install feature of osCommerce works fine, provided the server is set up correctly and folder permissions are also set correctly to 755 or 777, and also the two configure.php files need to be set to 777 for the install procedure. But all this information is in the Installation Guide in the Knowledge Base.

 

Vger