Problem with products and admin

[Akira71]

Team,

 

I have osCommerce on a test server and have run into several problems. The test server is www.cocolove.com/catalog/. You can see that when you try to select one of the demo products the product is not found. However, this setup is the basic setup with some minor changes as I was trying to move this into our billing solution. The admin is even worse. The configuration.php files are all setup correctly and I made the PHP5 change that is required.

 

In the admin for instance you can get into it, but you see the CONSTANT names in all caps instead of what is supposed to be there. I am really flustered over this.

 

Any ideas?

 

Thanks,

 

Akira

[♥Vger]

That web address does not work.

 

Vger

[Akira71]

That web address does not work.

 

Vger

<{POST_SNAPBACK}>

 

 

I am sorry Vger.. It was supposed to be www.cocoluv.com/catalog

love = luv

 

This is a simple testing site, so don't expect much. I notice the categories and the products do not seem right as well as the admin page. The admin is really messesd up.

[♥Vger]

Okay, you'll need to post both of your configure.php files (minus the db user name and password) as there is obviously something wrong. I attempted the path to your admin folder and got a 'could not connect to mysql database server' error.

 

Vger

[Akira71]

Okay, you'll need to post both of your configure.php files (minus the db user name and password) as there is obviously something wrong.  I attempted the path to your admin folder and got a 'could not connect to mysql database server' error.

 

Vger

<{POST_SNAPBACK}>

 

 

I renamec the admin to cocoadmin so that is part of the issue. Let me post the configure files here..

 

Catalog Configure

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com
                                                                                                                                                    
 Copyright (c) 2003 osCommerce
                                                                                                                                                    
 Released under the GNU General Public License
*/
                                                                                                                                                    
// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
 define('HTTP_SERVER', 'http://cocoluv.com'); // eg, http://localhost - should not be empty for productive servers
 define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers
 define('ENABLE_SSL', false); // secure webserver for checkout procedure?
 define('HTTP_COOKIE_DOMAIN', 'cocoluv');
 define('HTTPS_COOKIE_DOMAIN', '');
 define('HTTP_COOKIE_PATH', '/catalog/');
 define('HTTPS_COOKIE_PATH', '');
 define('DIR_WS_HTTP_CATALOG', '/catalog/');
 define('DIR_WS_HTTPS_CATALOG', '');
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
                                                                                                                                                    
 define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/');
// define('DIR_FS_CATALOG', '/var/www/html/cocolove/catalog/');
 define('DIR_FS_CATALOG', '/www/sites/cocolove/catalog/');
 define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
 define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
                                                                                                                                                    
// define our database connection
 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'xxxxxxxxxx');
 define('DB_SERVER_PASSWORD', 'xxxxxxxxxx');
 define('DB_DATABASE', 'oscommerce');
 define('USE_PCONNECT', 'true'); // use persistent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

 

Admin Configure

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com
                                                                                                                                                    
 Copyright (c) 2003 osCommerce
                                                                                                                                                    
 Released under the GNU General Public License
*/
                                                                                                                                                    
// Define the webserver and path parameters
// * DIR_FS_* = Filesystem directories (local/physical)
// * DIR_WS_* = Webserver directories (virtual/URL)
// define('HTTP_SERVER', 'http://localhost'); // eg, http://localhost - should not be empty for productive servers
 define('HTTP_SERVER', 'http://www.cocoluv.com');
 define('HTTP_CATALOG_SERVER', 'http://www.cocoluv.com/catalog/');
 define('HTTPS_CATALOG_SERVER', '');
 define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module
// define('DIR_FS_DOCUMENT_ROOT', '/var/www/html/cocolove/catalog/'); // where the pages are located on the server
 define('DIR_FS_DOCUMENT_ROOT', '/www/sites/cocolove/catalog/'); // where the pages are located on the server
 define('DIR_WS_ADMIN', '/catalog/cocoadmin/'); // absolute path required
 define('DIR_FS_ADMIN', '/www/sites/cocolove/catalog/cocoadmin/'); // absolute pate required
 define('DIR_WS_CATALOG', '/catalog/'); // absolute path required
 define('DIR_FS_CATALOG', '/www/sites/cocolove/catalog/'); // absolute path required
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
 define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
 define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
 define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
                                                                                                                                                    
// define our database connection
 define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
 define('DB_SERVER_USERNAME', 'XXXXXXXXX');
 define('DB_SERVER_PASSWORD', 'XXXXXXXXXXXX');
 define('DB_DATABASE', 'oscommerce');
 define('USE_PCONNECT', 'true'); // use persisstent connections?
 define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

[♥Vger]

catalog

--------

 

define('HTTP_SERVER', 'http://www.cocoluv.com');

 

define('HTTP_COOKIE_DOMAIN', 'www.cocoluv.com');

 

define('USE_PCONNECT', 'false');

 

-----------------------------------------

 

admin

-------

 

define('HTTP_CATALOG_SERVER', 'http://www.cocoluv.com');

 

define('USE_PCONNECT', 'false');

 

That should do it - provided that your 'document root'is correct.

 

Vger

[Akira71]

catalog

--------

 

define('HTTP_SERVER', 'http://www.cocoluv.com');

 

define('HTTP_COOKIE_DOMAIN', 'www.cocoluv.com');

 

define('USE_PCONNECT', 'false');

 

-----------------------------------------

 

admin

-------

 

define('HTTP_CATALOG_SERVER', 'http://www.cocoluv.com');

 

define('USE_PCONNECT', 'false');

 

That should do it - provided that your 'document root'is correct.

 

Vger

<{POST_SNAPBACK}>

 

Well I made the changes and that does not seem to do it. Although I can see where those changes are better. That is unless something is still stuck in my cache or something to keep it.

 

I really appreaciate the help so late on this holiday. I should be having a good time too, but instead I am pushed working hard to get this running at all cost.. *sigh*

[♥Vger]

Look to see if you have a folder called 'local' on your site, with an alternative configure.php inside it. If you find an alternative file, download it to its own folder (as a backup), and then delete it on the server. Unless your document root is wrong those files should now work.

 

Vger

[Akira71]

Look to see if you have a folder called 'local' on your site, with an alternative configure.php inside it.  If you find an alternative file, download it to its own folder (as a backup), and then delete it on the server.  Unless your document root is wrong those files should now work.

 

Vger

<{POST_SNAPBACK}>

 

Well I have a few directories names local in the catalog and admin areas, but they only have a README file in them. Nothing else.

 

I am perplexed.. But at least I feel like we are making progress. Thank you.

[♥Vger]

If you have a.htaccess file in your catalog or root directory, and especially in your 'admin' directory, back them up and then delete them.

 

Vger

[Akira71]

If you have a.htaccess file in your catalog or root directory, and especially in your 'admin' directory, back them up and then delete them.

 

Vger

<{POST_SNAPBACK}>

 

Nothing of the sort yet.

[♥Vger]

They are hidden files. If you ftp to your site then type -la into the empty box below MkDir, navigate out of the folder, then back to it, you should see any hidden files.

 

vger

[Akira71]

They are hidden files.  If you ftp to your site then type -la into the empty box below MkDir, navigate out of the folder, then back to it, you should see any hidden files.

 

vger

<{POST_SNAPBACK}>

 

Done with the same result. Nothing there.

[♥Vger]

Check your 'admin' control panel, under Configuration --> Sessions. I think you have 'Force Cookie Use' turned on.

 

Also check to see under Configuration if you have 'Use Search Engine Friendly URL's' on. If either of these are set to 'true' reset them to 'false.

 

Vger

[bobg7]

Have you by chance reloaded the database? If so, try reloading the items, they may be out of synch.

[Akira71]

Check your 'admin' control panel, under Configuration --> Sessions.  I think you have 'Force Cookie Use' turned on.

 

Also check to see under Configuration if you have 'Use Search Engine Friendly URL's' on.  If either of these are set to 'true' reset them to 'false.

 

Vger

<{POST_SNAPBACK}>

 

 

VGer,

 

When I click that link it does not show up. I think you go go to the admin area and try it yourself at the moment. You are proabbyl right, so how Might I change those values without the admin console?

[Akira71]

Have you by chance reloaded the database? If so, try reloading the items, they may be out of synch.

<{POST_SNAPBACK}>

 

Just did a fresh reload and the same thing. Thank you for your help though.

[♥Vger]

Okay, took a look, and there are lots of things wrong here. You don't have a 'backups' directory in 'admin', and your 'images' directory is not writeable and needs to be set to chmod 755. I am also getting lots of errors stating 'Unable to determine the page link'.

 

As this is a new default install I suggest that you overwrite all files except for the two configure.php files (which are now correct) with files taken from an unzipped version of MS2.2 (basically everything in the 'catalog' folder except for the two config files).

 

Don't use the files in your local install for this.

 

Vger

[Akira71]

Okay, took a look, and there are lots of things wrong here.  You don't have a 'backups' directory in 'admin', and your 'images' directory is not writeable and needs to be set to chmod 755.  I am also getting lots of errors stating 'Unable to determine the page link'.

 

As this is a new default install I suggest that you overwrite all files except for the two configure.php files (which are now correct) with files taken from an unzipped version of MS2.2 (basically everything in the 'catalog' folder except for the two config files).

 

Don't use the files in your local install for this.

 

Vger

<{POST_SNAPBACK}>

 

 

OK VGER having done this, the result is exaclty the same. I have everything backedup and setup. I should think that it would work. I can even run queries from the database without any problems directly. I just seems as if something is not right somewhere. I do note there is sometihng fairly majorly wrong.

 

Any other ideas? I do have this gun sitting here next to me if all fails (j/k) but it is pretty dern unerving.

 

BTW on another server I followed all the same steps I have here and it works well. Unfortunately I cannot put that server out in the public eye. I have to work with this one.

 

I also thought perhaps the issue is the PHP version since it is 5, but having made the change in the upload.php seemed to fix that althouhg what is out there now is base without the change as you stated. I can make it easy enough though. So, any other ideas?

 

Thanks,

 

Akira

[♥Vger]

Make the change again in upload.php, and if that doesn't work then it's obvious that there is something not right with the setup of the server you're using. It may be that there are restrictions in effect which prevent you from successfully running osCommerce. In which case you'll need to move the site to a different host.

 

Vger

[Akira71]

Make the change again in upload.php, and if that doesn't work then it's obvious that there is something not right with the setup of the server you're using.  It may be that there are restrictions in effect which prevent you from successfully running osCommerce.  In which case you'll need to move the site to a different host.

 

Vger

<{POST_SNAPBACK}>

 

Just rebuilt the server from scratch thinking something is not right since it runs everywhere else. So in a little bit I am going to have the most basic of all installs running on the server I hope. Then I will be working on it again from there.

 

I will keep you informed as this whole thread may help someone else later as well as me :-)

 

Akira