OSC issues all of a sudden

[lextech]

2.2-MS2

 

I have so many issues I have simply taken screen shots. The site has ran well for many years and is current and up to date as far as I know. Priorities are getting into my define language area to change some text. The rest is "next" on the list to fix.

 

[urls Removed as per User Request]

 

Any help with these would be greatly appreciated. The site has been up many years and I've had a few fixes here and there, but now I have some things I need your help with. I'm not a coding guy and have to do a lot of reading to understand some of these fixes, so if you guys have some "point me in the right direction, cut and paste" type of fixes that'd help a lot. :)

 

~TIA!

[♥geoffreywalton]

The link in my signature block for solutions to common problems may contain the solution to the -20 20 problem and unknown column error.

[lextech]

Thank you I'll look into that. Anyone please do help with the main issue. I must get into there and change a few files.

[lextech]

Any other takers on my main issue? Really need to solve this and there's certainly someone here that can.

 

Thank you :)

[lextech]

anyone?

 

PS- thanks Geo for the 20/20 fix :) it worked.

[lextech]

For future reference, I had an original OSCommerce store that had been upgraded through the years to MS2.2 in it's final form. I D/L'ed another copy of MS2.2 and when I went to look in configure.php the new configure file was different from the one I had. This apparently was not part of the update and has caused mass grief. Here are the two configure.php files for reference.

 

Had someone had this info handy, this would have been an easy fix rather than a week of grief for my customers and myself, so I am putting it here for others. If you have any issues with the backup directory not finding itself, file manager, define languages, and other errors where directories are not found that should be and you have upgraded your site from an old version...... make sure your configure.php files are the new ones.

 

Old one:

 

 

<?php

/*

$Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

 

// define our webserver variables

// FS = Filesystem (physical)

// WS = Webserver (virtual)

define('HTTP_SERVER', 'http://xxxxxxxxxxx');

define('HTTP_CATALOG_SERVER', '');

define('HTTPS_CATALOG_SERVER', '');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs)

define('DIR_WS_ADMIN', '/xxxxxxxxxxx/admin/');

define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

define('DIR_WS_CATALOG', '/xxxxxxx/');

define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);

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');

define('DB_SERVER_USERNAME', 'xxxxxx');

define('DB_SERVER_PASSWORD', 'xxxxxxx');

define('DB_DATABASE', 'xxxxxxx');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', '');

?>

 

 

New one:

 

 

<?php

/*

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 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://xxxxxx'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://xxxxxx');

define('HTTPS_CATALOG_SERVER', 'https://xxxxxxx');

define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', '/home/xxxxxx/public_html/xxxxx/'); // where the pages are located on the server

define('DIR_WS_ADMIN', '/xxxxxx/admin/'); // absolute path required

define('DIR_FS_ADMIN', '/home/xxxxxxxxx/public_html/os1/admin/'); // absolute pate required

define('DIR_WS_CATALOG', '/xxxxx/'); // absolute path required

define('DIR_FS_CATALOG', '/home/xxxxxxxx/public_html/xxxxxx/'); // 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', 'xxxxxxxxx');

define('DB_DATABASE', 'xxxxxxxx');

define('USE_PCONNECT', 'false'); // use persisstent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

?>

[lextech]

PS- now that I have regained control of my payment modules and admin panel, the only issue from all this is that it doesn't want to remember shipping. If I go in and set the shipping flat rate it saves it for the next order, but the following order it will not add shipping.

 

The remedy to this was to go into the order totals module and set the free shipping option to an astronomical number to keep it from giving customers free shipping.

 

Hope this helps someone. :)

[♥geoffreywalton]

To edit the text content of your site try using the textmaster contribution.