server path for database/mysql??

[Carder]

our new server is not recognizing our databases from our osC store. Our new hosting company had me find the "path" to their server for the databases (using and info.php file). However, now that I have their info they did not know where to insert it into osCommerce so that it can be read and followed correctly. Presently, I am getting an error message saying "No input file specified." when clicking onto our products/items.

 

Question:

Where (what files) would I insert the short script into osCommerce so that the correct path to the new server is recognized to pull up our data? He also said that it is sometimes referred to as the "path to perl". I appear to have it now but do not know where in osCommerce to insert it.

 

THank you.

Carder

[bill110]

catelog/includes/configure.php

and

catelog/admin/includes/configure.php

[Carder]

Thank you.

 

In the section of the configure.php

 

// define our database connection

 

I had already changed the DB_SERVER to the new server and had changed the username, password and DB_DATABASE to show the new information.

 

But I am not sure where to put this additional script. Do I put it in one of these:

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

 

or do I insert in one of these:

define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');

define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']));

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');

define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

 

My overall question (or problem) is that the front page of my store shows up but I cannot click through to any of the products. I can access them through my Admin page so I feel that they are there and are accessible but I cannot get them to be accessible to the public.

 

Thank you,

[bill110]

Actually further down the code

// define our database connection
 define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers(path to server, no http)
 define('DB_SERVER_USERNAME', ');
 define('DB_SERVER_PASSWORD', '');
 define('DB_DATABASE', '');//the database name
 define('USE_PCONNECT', 'false'); // use persisstent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

[Carder]

Actually further down the code

// define our database connection
 define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers(path to server, no http)
 define('DB_SERVER_USERNAME', ');
 define('DB_SERVER_PASSWORD', '');
 define('DB_DATABASE', '');//the database name
 define('USE_PCONNECT', 'false'); // use persisstent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

 

Those had all been updated with my new server info when I first transferred to this server. But I am still receiving a "No input file specified" message when trying to go from the storefront to an item page. The browser address that shows up ends with "...../index.php/cPath/ ..."

 

Would the "cPath" be the problem?? Is cPath particular to using a server with cPanel - the host/server where I was used cPanel, however, the new host/server does not.

 

I can access the database when I login through my Admin window.

 

Is appears that there is one more php file that needs adjusting. But which one? Help!

[kgt]

Make sure Use Search-Engine Safe URLs (still in development) in your admin section under Configuration > My Store is false.

[Carder]

Make sure Use Search-Engine Safe URLs (still in development) in your admin section under Configuration > My Store is false.

 

unfortunately, still no success.

 

Any programmers out there who are wizzes with osCommerce? It looks like I need to hire someone to get me through this. (If that is allowed through these forums).

[kgt]

Then you've probably got another SEO contribution that uses mod_rewrite. Check your .htaccess.

[Carder]

Then you've probably got another SEO contribution that uses mod_rewrite. Check your .htaccess.

 

 

THank you. I am in the .htaccess file now. What am I looking for and what should I change to?

[kgt]

It depends on what's in there. ;) If you see something like

 

RewriteBase /shop/

 

and your URL is actually

 

mydomain.com/catalog

 

Then that's what you need to fix.

 

Basically, "No input file specified" happens when a request is passed to the PHP CGI application for a file that doesn't exist. This can happen if you have URL rewriting that's rewriting URLs to a non-existent file.

[Carder]

It depends on what's in there. ;) If you see something like

 

RewriteBase /shop/

 

and your URL is actually

 

mydomain.com/catalog

 

Then that's what you need to fix.

 

Basically, "No input file specified" happens when a request is passed to the PHP CGI application for a file that doesn't exist. This can happen if you have URL rewriting that's rewriting URLs to a non-existent file.

 

I have looked in admin/.htaccess and in includes/.htaccess but cannot seem to find something to that effect. The admin/.htaccess says that it is used with Apache Webservers. We are on a UNIX platform now - would that cause the problem?

[kgt]

Apache is commonly used with Unix-based platforms. There are other webservers, but it would be highly unlikely you have a different webserver than Apache.

 

Can you identify which SEO contribution you have installed? It's difficult to fix the problem without knowing where it is caused.

[Carder]

Apache is commonly used with Unix-based platforms. There are other webservers, but it would be highly unlikely you have a different webserver than Apache.

 

Can you identify which SEO contribution you have installed? It's difficult to fix the problem without knowing where it is caused.

 

I am mostly a novice at this since I do this aspect of my website extremely infrequently. So please bear with me - but what is SEO and where would I find that info?

[kgt]

Search Engine Optimization.

 

You would have installed a contribution like one of these:

 

http://www.oscommerce.com/community/contributions,2823

http://www.oscommerce.com/community/contributions,2796