database connection

[simpatico]

Hello everybody

I'm migrating this website from a dedciated server with Plesk and localhost mysql database to a shared hosting with a different host (not localhost) mysql database and I get this error:

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/13/12345/html/xxx/includes/functions/database.php on line 17

Unable to connect to database server!

 

In the databse.php line 17 I have:

if (USE_PCONNECT == 'true') {

$$link = mysql_connect($server, $username, $password);

} else {

$$link = mysql_connect($server, $username, $password);

}

 

if ($$link) mysql_select_db($database);

 

return $$link;

 

Can anybody help??

[webpark]

You need to check the following places for database connection:

admin /includes / configure.php

catalog / includes / configure.php

[amirand926]

I have this  problem after a new client of mine changed their host. I have checked the two paths mentioned by webpark and they have the same info. The login doesnt even seem to accept the new user I added onto the database. Now when I try to log in, it just pops up again implying the password is wrong where before it would go through and tell me it could not connect to the database. VERY confusing. Any help would be appreciated. Thanks!!

[Jack_mcs]

When the host is changed, the login for the database is usually changed as well as the path to the .htpasswd file. Try renaming the .htaccess in the admin directory to something else to see if you can get past that. If you can, then you have to change the path in it, or just create a new one.

[amirand926]

Hey Jack,
Thanks for your response. I checked the .htaccess and the path is correct. I even went so far as to renter recreate the user/password to same info to make sure. But since I am NOT being asked for the password again it is obviously correct. The issue is just the database connection. I am not sure I want to mess with the .htaccess file during this time of day since the site is live but if you still think I should check into it, I will later on tonight. Just FYI. I included some info below. I saw that the GoDaddy made a backup of the file before they attempted a fix while speaking with my client and I see in the original admin/includes/configure.php that DB_SERVER is blank and the database is 'catalog'. Weird. 

 

Thanks in advance!

 

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

FROM SITE BEFORE HOST CHANGE: public_html/admin/includes/configure-ORIGINAL.php:

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

  define('DB_SERVER', '');

  define('DB_SERVER_USERNAME', 'mysql');

  define('DB_SERVER_PASSWORD', '');

  define('DB_DATABASE', 'catalog');

  define('USE_PCONNECT', 'false');

  define('STORE_SESSIONS', '');

 

 

Here is the content of the files CURRENTLY USED. I removed the username, password which I assure you are the same in each file.

 

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

public_html/admin/includes/configure.php:

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

<?php

/*

  $Id: configure.php,v 1.13 2002/07/20 09:08:31 project3000 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', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers

  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', '/admin/');

  define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);

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

  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', 'REMOVED FOR THIS POST');

  define('DB_SERVER_PASSWORD', 'REMOVED FOR THIS POST');

  define('DB_DATABASE', 'parlab');

  define('USE_PCONNECT', 'false');

  define('STORE_SESSIONS', '');

 

 

 

 

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

public_html/catalog/includes/configure.php:

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

 

 

<?php

/*

  $Id: configure.php,v 1.13 2003/02/10 22:30:51 hpdl Exp $

 

  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', ''); // 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('DIR_WS_CATALOG', '/catalog/'); // absolute path required

  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', DIR_WS_CATALOG . 'pub/');

  define('DIR_FS_DOCUMENT_ROOT', $HTTP_SERVER_VARS['/home/parlab/public_html/catalog/']);

  //define('DIR_FS_DOCUMENT_ROOT', $HTTP_SERVER_VARS['/home/parlab/public_html/']); // 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_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_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', 'REMOVED FOR THIS POST');

  define('DB_SERVER_PASSWORD', 'REMOVED FOR THIS POST');

  define('DB_DATABASE', 'parlab');

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

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

?>

 

 

 

 

[♥geoffreywalton]

If you are using GoDaddy your dbservername is wrong.

 

define('DB_SERVER', 'localhost'

 

The GD help says

 

Locating Your Database Connection Strings

 

Database-driven applications, such as WordPress, use connection strings to connect to your hosting account's database.

To Locate Your Database Connection Strings

1. Log in to your Account Manager.
2. Click Web Hosting.

Click one of the following, based on the type of hosting you have. You can tell this by the second word in your hosting's description beneath your hosting account's domain name, e.g. Deluxe Web correlates to Web/Classic (Hosting Control Panel).

 

1. Next to the hosting account you want to use, click Launch.
2. In the Databases section of the Hosting Control Panel, click the MySQL or SQL Server icon.
3. From your list of databases, click Actions next to the database you want to use, and then click Details.
4. Click Code Sample.

HTH

 

G

Edited November 17, 2014 by burt
remove external links

[amirand926]

Hey Geoffrey,

Thanks for your reply. However, I did take a look at what you had mentioned but along that path it does say to enter 'localhost' since the server is on Linux (cPanel). So for our connection, localhost is correct. Again, thanks for your insight and if you can find another hole please let me know.

 

The only thing I can think of at this point is that there might be some kind of permissions error somewhere or the PATH to the db is wrong, such as in the DOCUMENT_ROOT. I believe the 'settings' are all correct. I've eliminated the user and pw as a problem so it is clearly just the db communication somewhere long the path after login.

 

Thanks again,

:) A

[Jack_mcs]

@@amirand926 I guess I'm lost at this point. You said the failure was a popup, which implies a .htaccess file is being used but then you said it's "issue is just the database connection" which is a different issue. As for temporarily removing the .htaccess file (assuming you mean the one in admin), that is fine to do for a quick test since the most it should be disabled is a minute or two. I suggest you try to pinpoint where the problem is at. Not being clear about it just makes everyone guess at possible solutions.

[amirand926]

Hey Jack,

Sorry if I was unclear. The problem is that when I try to access the /admin/, I do get the login pop up and enter the correct username and password stored in both of the configure.php files correctly. However, I just get "Unable to connect to database server!". That's really all there is to it right now.

 

(The previous mixup was happening because I had messsed up the password in the files so the 'popup to login' kept appearing for me to re enter the pw. This did however help me understand that it IS seeing my correct passwords and IS logging in now but is not connecting to the database at some point thereafter)

 

I was looking around and found somewhere where someone said to hardcode "define('DB_SERVER', 'localhost');" in the /admin/includes/application_top.php and also to check the Register Globals bit (no idea where that is). Keep in mind that there are TWO application_top.php's just like configure.php's. this might matter only because they might have been/be using a version of OSC old enough for it to matter 

 

 

Thanks again guys. Sorry for the confusion.

 

(relevant sections highlighted in red. Successful login shows the die() msg in red on bottom)

 

Here is the entire /admin/includes/application_top.php. 

 

<?php

/*

  $Id: application_top.php,v 1.155 2003/02/17 16:54:11 hpdl Exp $

 

  osCommerce, Open Source E-Commerce Solutions

  http://www.oscommerce.com

 

  Copyright © 2003 osCommerce

 

  Released under the GNU General Public License

*/

 

date_default_timezone_set('America/Denver');

$register_global_variables = array();

include('includes/functions/register_globals.php');

 

 

if (!isset($HTTP_GET_VARS)){

$HTTP_SERVER_VARS = &$_SERVER;

$PHP_SELF = $_SERVER['PHP_SELF'];

$HTTP_GET_VARS = &$_GET;

$HTTP_POST_VARS = &$_POST;

$HTTP_ENV_VARS = &$_ENV;

$HTTP_COOKIE_VARS = &$_COOKIE;

$_REQUEST = array_merge($_GET, $_POST, $_COOKIE);

}

 

my_register_globals('egpcs');

// Start the clock for the page parse time log

  define('PAGE_PARSE_START_TIME', microtime());

 

// Set the level of error reporting

  error_reporting(E_ALL & ~E_NOTICE);

 

// Check if register_globals is enabled.

// Since this is a temporary measure this message is hardcoded. The requirement will be removed before 2.2 is finalized.

/*

  if (function_exists('ini_get')) {

    ini_get('register_globals') or exit('FATAL ERROR: register_globals is disabled in php.ini, please enable it!');

  }

*/

if (function_exists('ini_get') && (ini_get('register_globals') == false) && (PHP_VERSION < 4.3) ) {

    exit('Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory. Please use PHP 4.3+ if register_globals cannot be enabled on the server.');

  }

 

// Disable use_trans_sid as tep_href_link() does this manually

  if (function_exists('ini_set')) {

    ini_set('session.use_trans_sid', 0);

  }

 

// Set the local configuration parameters - mainly for developers

  if (file_exists('includes/local/configure.php')) include('includes/local/configure.php');

 

// Include application configuration parameters

  require('includes/configure.php');

 

// Define the project version

  define('PROJECT_VERSION', 'Preview Release 2.2-MS1');

 

// Used in the "Backup Manager" to compress backups

  define('LOCAL_EXE_GZIP', '/usr/bin/gzip');

  define('LOCAL_EXE_GUNZIP', '/usr/bin/gunzip');

  define('LOCAL_EXE_ZIP', '/usr/local/bin/zip');

  define('LOCAL_EXE_UNZIP', '/usr/local/bin/unzip');

 

// define the filenames used in the project

  define('FILENAME_BACKUP', 'backup.php');

  define('FILENAME_BANNER_MANAGER', 'banner_manager.php');

  define('FILENAME_BANNER_STATISTICS', 'banner_statistics.php');

  define('FILENAME_CACHE', 'cache.php');

  define('FILENAME_CATALOG_ACCOUNT_HISTORY_INFO', 'account_history_info.php');

  define('FILENAME_CATEGORIES', 'categories.php');

  define('FILENAME_CONFIGURATION', 'configuration.php');

  define('FILENAME_COUNTRIES', 'countries.php');

  define('FILENAME_CURRENCIES', 'currencies.php');

  define('FILENAME_CUSTOMERS', 'customers.php');

  define('FILENAME_DEFAULT', 'index.php');

  define('FILENAME_DEFINE_LANGUAGE', 'define_language.php');

  define('FILENAME_FILE_MANAGER', 'file_manager.php');

  define('FILENAME_GEO_ZONES', 'geo_zones.php');

  define('FILENAME_LANGUAGES', 'languages.php');

  define('FILENAME_MAIL', 'mail.php');

  define('FILENAME_MANUFACTURERS', 'manufacturers.php');

  define('FILENAME_MODULES', 'modules.php');

  define('FILENAME_NEWSLETTERS', 'newsletters.php');

  define('FILENAME_ORDERS', 'orders.php');

  define('FILENAME_ORDERS_INVOICE', 'invoice.php');

  define('FILENAME_ORDERS_PACKINGSLIP', 'packingslip.php');

  define('FILENAME_ORDERS_STATUS', 'orders_status.php');

  define('FILENAME_POPUP_IMAGE', 'popup_image.php');

  define('FILENAME_PRODUCTS_ATTRIBUTES', 'products_attributes.php');

  define('FILENAME_PRODUCTS_EXPECTED', 'products_expected.php');

  define('FILENAME_REVIEWS', 'reviews.php');

  define('FILENAME_SERVER_INFO', 'server_info.php');

  define('FILENAME_SHIPPING_MODULES', 'shipping_modules.php');

  define('FILENAME_SPECIALS', 'specials.php');

  define('FILENAME_STATS_CUSTOMERS', 'stats_customers.php');

  define('FILENAME_STATS_PRODUCTS_PURCHASED', 'stats_products_purchased.php');

  define('FILENAME_STATS_PRODUCTS_VIEWED', 'stats_products_viewed.php');

  define('FILENAME_TAX_CLASSES', 'tax_classes.php');

  define('FILENAME_TAX_RATES', 'tax_rates.php');

  define('FILENAME_WHOS_ONLINE', 'whos_online.php');

  define('FILENAME_ZONES', 'zones.php');

// define_mainpage

define('FILENAME_DEFINE_MAINPAGE', 'define_mainpage.php');

// define_mainpage 

 

define('FILENAME_MENU', 'menu.php');

define('TABLE_MENU', 'menu');

 

// define the database table names used in the project

  define('TABLE_ADDRESS_BOOK', 'address_book');

  define('TABLE_ADDRESS_FORMAT', 'address_format');

  define('TABLE_BANNERS', 'banners');

  define('TABLE_BANNERS_HISTORY', 'banners_history');

  define('TABLE_CATEGORIES', 'categories');

  define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description');

  define('TABLE_CONFIGURATION', 'configuration');

  define('TABLE_CONFIGURATION_GROUP', 'configuration_group');

  define('TABLE_COUNTRIES', 'countries');

  define('TABLE_CURRENCIES', 'currencies');

  define('TABLE_CUSTOMERS', 'customers');

  define('TABLE_CUSTOMERS_BASKET', 'customers_basket');

  define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes');

  define('TABLE_CUSTOMERS_INFO', 'customers_info');

  define('TABLE_LANGUAGES', 'languages');

  define('TABLE_MANUFACTURERS', 'manufacturers');

  define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info');

  define('TABLE_NEWSLETTERS', 'newsletters');

  define('TABLE_ORDERS', 'orders');

  define('TABLE_ORDERS_PRODUCTS', 'orders_products');

  define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes');

  define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download');

  define('TABLE_ORDERS_STATUS', 'orders_status');

  define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history');

  define('TABLE_ORDERS_TOTAL', 'orders_total');

  define('TABLE_PRODUCTS', 'products');

  define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes');

  define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download');

  define('TABLE_PRODUCTS_DESCRIPTION', 'products_description');

  define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications');

  define('TABLE_PRODUCTS_OPTIONS', 'products_options');

  define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values');

  define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options');

  define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories');

  define('TABLE_REVIEWS', 'reviews');

  define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description');

  define('TABLE_SESSIONS', 'sessions');

  define('TABLE_SPECIALS', 'specials');

  define('TABLE_TAX_CLASS', 'tax_class');

  define('TABLE_TAX_RATES', 'tax_rates');

  define('TABLE_GEO_ZONES', 'geo_zones');

  define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');

  define('TABLE_WHOS_ONLINE', 'whos_online');

  define('TABLE_ZONES', 'zones');

 

// customization for the design layout

  define('BOX_WIDTH', 125); // how wide the boxes should be in pixels (default: 125)

 

// Define how do we update currency exchange rates

// Possible values are 'oanda' 'xe' or ''

  define('CURRENCY_SERVER_PRIMARY', 'oanda');

  define('CURRENCY_SERVER_BACKUP', 'xe');

 

// include the database functions

  require(DIR_WS_FUNCTIONS . 'database.php');

 

// make a connection to the database... now

  tep_db_connect() or die('Unable to connect to database server!');

 

// set application wide parameters

  $configuration_query = tep_db_query('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION . '');

  while ($configuration = tep_db_fetch_array($configuration_query)) {

    define($configuration['cfgKey'], $configuration['cfgValue']);

  }

 

// initialize the logger class

  require(DIR_WS_CLASSES . 'logger.php');

 

// include shopping cart class

  require(DIR_WS_CLASSES . 'shopping_cart.php');

 

// some code to solve compatibility issues

  require(DIR_WS_FUNCTIONS . 'compatibility.php');

 

// check to see if php implemented session management functions - if not, include php3/php4 compatible session class

  if (!function_exists('session_start')) {

    define('PHP_SESSION_NAME', 'sID');

    define('PHP_SESSION_SAVE_PATH', '/tmp');

 

    include(DIR_WS_CLASSES . 'sessions.php');

  }

 

// define how the session functions will be used

  require(DIR_WS_FUNCTIONS . 'sessions.php');

  tep_session_name('osCAdminsID');

 

// lets start our session

  tep_session_start();

  if (function_exists('session_set_cookie_params')) {

    session_set_cookie_params(0, substr(DIR_WS_ADMIN, 0, -1));

  }

 

my_register_globals('x');

 

 

// language

  require(DIR_WS_FUNCTIONS . 'languages.php');

  if ( (!$language) || ($HTTP_GET_VARS['language']) ) {

    if (!$language) {

      tep_session_register('language');

      tep_session_register('languages_id');

    }

 

    $language = tep_get_languages_directory($HTTP_GET_VARS['language']);

    if (!$language) $language = tep_get_languages_directory(DEFAULT_LANGUAGE);

  }

 

// include the language translations

  require(DIR_WS_LANGUAGES . $language . '.php');

  //$current_page = split('\?', basename($PHP_SELF)); $current_page = $current_page[0]; // for BadBlue(Win32) webserver compatibility

$current_page = explode('\?', basename($PHP_SELF)); $current_page = $current_page[0]; // for BadBlue(Win32) webserver compatibility

  if (file_exists(DIR_WS_LANGUAGES . $language . '/' . $current_page)) {

    include(DIR_WS_LANGUAGES . $language . '/' . $current_page);

  }

 

// define our general functions used application-wide

  require(DIR_WS_FUNCTIONS . 'general.php');

  require(DIR_WS_FUNCTIONS . 'html_output.php');

 

// define our localization functions

  require(DIR_WS_FUNCTIONS . 'localization.php');

 

// setup our boxes

  require(DIR_WS_CLASSES . 'table_block.php');

  require(DIR_WS_CLASSES . 'box.php');

 

// initialize the message stack for output messages

  require(DIR_WS_CLASSES . 'message_stack.php');

  $messageStack = new messageStack;

 

// split-page-results

  require(DIR_WS_CLASSES . 'split_page_results.php');

 

// entry/item info classes

  require(DIR_WS_CLASSES . 'object_info.php');

 

// email classes

  require(DIR_WS_CLASSES . 'mime.php');

  require(DIR_WS_CLASSES . 'email.php');

 

// calculate category path

  $cPath = $HTTP_GET_VARS['cPath'];

  if (strlen($cPath) > 0) {

    $cPath_array = explode('_', $cPath);

    $current_category_id = $cPath_array[(sizeof($cPath_array)-1)];

  } else {

    $current_category_id = 0;

  }

 

// default open navigation box

  if (!tep_session_is_registered('selected_box')) {

    tep_session_register('selected_box');

    $selected_box = 'configuration';

  }

 

  if ($HTTP_GET_VARS['selected_box']) {

    $selected_box = $HTTP_GET_VARS['selected_box'];

  }

 

//print '\n\nselected box after:: '.$selected_box; exit;

 

// the following cache blocks are used in the Tools->Cache section

// ('language' in the filename is automatically replaced by available languages)

  $cache_blocks = array(array('title' => TEXT_CACHE_CATEGORIES, 'code' => 'categories', 'file' => 'categories_box-language.cache', 'multiple' => true),

                        array('title' => TEXT_CACHE_MANUFACTURERS, 'code' => 'manufacturers', 'file' => 'manufacturers_box-language.cache', 'multiple' => true),

                        array('title' => TEXT_CACHE_ALSO_PURCHASED, 'code' => 'also_purchased', 'file' => 'also_purchased-language.cache', 'multiple' => true)

                       );

 

// check if a default currency is set

  if (!defined('DEFAULT_CURRENCY')) {

    $messageStack->add(ERROR_NO_DEFAULT_CURRENCY_DEFINED, 'error');

  }

 

// check if a default language is set

  if (!defined('DEFAULT_LANGUAGE')) {

    $messageStack->add(ERROR_NO_DEFAULT_LANGUAGE_DEFINED, 'error');

  }

?>

[Jack_mcs]

Are you sure the login is the same as what's in the configure files? It shouldn't be, in my opinion, and rarely is, in my experience. Again, remove that file should help isolate that problem.

 

I don't suggest changing the application_top file. There is no need to do that and is bad advice, again, in my opinion.

[amirand926]

Hey Jack,

I temporarily renamed the file .htaccess file and it had no effect. I have not changed the application_top file either bc I think that is a bad idea as well.

[Jack_mcs]

So with the .htaccess file disabled, do you see the connection message right away or are you seeing the login page with a box for the username and password?

[amirand926]

I should also note that there are a bunch of other RENAMED .htaccess files in the /admin folder:

.htaccess.bk           (Last modified Nov 8 2014)

.htaccess.bk.CT_original_bak       Last modified Sept 8 2013)

.htaccess.CT_Original_bak      Last modified Oct 4 2013)

 

They seem to be backups created by others in the past. I included last modified dates.

 

 

In /catalog/ there is also a .htaccess.bak.

 

Seems the previous 'admin' was all about backups! wow. 

 

I was not involved with the transfer to new host goDaddy but I do know that it was on the date of Nov 7/8 which is the date of one of the backups.

 

The .htaccess.bk (date of host change) is:

 

#AuthUserFile /home/parlab/public_html/admin/.htpasswd
#AuthGroupFile /dev/null
#AuthName "Protected Area"
#AuthType Basic

#<Limit GET POST>
#require valid-user
#</Limit>
# Enable PHP 5.4 support for .php files on this domain only
AddType application/x-httpd-php54 .php

 

 

The CURRENT .htaccess is :

 

AuthUserFile /home/parlab/public_html/admin/.htpasswd
AuthGroupFile /dev/null
AuthName "Protected Area"
AuthType Basic

<Limit GET POST>
require valid-user
</Limit>

 

 

 

 

What sucks about all this the most is that this whole site is going to be changed to Wordpress/Woocommerce in a few weeks and this is all just to make accessible by my client for changes until then. 

 

Thanks again for the help and I hope we are somewhat closer to narrowing it down.

[amirand926]

with the .htacces disabled it did the same thing. the /admin/ page pops open a login box, i log in, and cannot connect to database message

[amirand926]

I opened the page in Firefox, instead of Chrome, while it was disabled to avoid any cache issues.

[Jack_mcs]

It sounds like you are using a non-standard version of oscommerce. Please attach an image of the login box you are using.

 

None of the .htaccess files with changed names are not used so they can be ignored or deleted.

[amirand926]

Yeah i figured the same with the other .htaccess files, thanks. I have the login bookmarked so when I click it here is what happens: not sure how otinsert image here.. you can check the link though http://www.parlabel.com/admin/

[amirand926]

Here is an attached file of the login box screen shot as well.

[Jack_mcs]

The link you provided is to a non-standard login option, at least for an oscommerce shop. That makes it difficult to get by since login methods vary with the code being used. Are you sure this is an oscommerce shop and not an offshoot like CRE or oscMax? If you can identify the code being used to provide the login, then I could tell you what change is needed. But as it is, there are too many versions to try to guess at. Maybe someone else will recognize it and be able to provide an answer.

[amirand926]

the /admin/index.php calls the /catalog/default.php file which is listed below:

 

<?php
/*
  $Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright © 2003 osCommerce

  Released under the GNU General Public License
*/
    require('includes/application_top.php');
    
// the following cPath references come from application_top.php
  $category_depth = 'top';
  if (isset($cPath) && tep_not_null($cPath)) {
    $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
    $cateqories_products = tep_db_fetch_array($categories_products_query);
    if ($cateqories_products['total'] > 0) {
      $category_depth = 'products'; // display products
    } else {
      $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");
      $category_parent = tep_db_fetch_array($category_parent_query);
      if ($category_parent['total'] > 0) {
        $category_depth = 'nested'; // navigate through the categories
      } else {
        $category_depth = 'products'; // category has no products, but display the 'no products' message
      }
    }
  }

  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title>Thermal Transfer Labels, Direct Thermal Labels, Thermal Transfer Ribbons, Laser Labels</title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<script language="JavaScript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="menu.css">
<!--[if IE]>
    <link rel="stylesheet" type="text/css" href="menu_ie.css">
<![endif]-->
<script language="JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
//-->
</script>


<script language="JavaScript" type="text/javascript">
$(document).ready(function(){
  $("#navmenu-h li,#navmenu-v li").hover(
    function() { $(this).addClass("iehover"); },
    function() { $(this).removeClass("iehover"); }
  );
});
</script>

</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" onLoad="MM_preloadImages('nav/elec_f2.gif','../images/n_direct_transfer_labels_f2.gif','nav/pinfeed_f2.gif','nav/colored_f2.gif','../images/n_direct_thermal_labels_f2.gif','nav/nav_r4_c1_f2.gif','../images/n_thermal_ribbons_f2.gif','../images/n_thermal_label_printers_f2.gif','nav/nav_r9_c1_f2.gif','nav/nav_r10_c1_f2.gif','nav/nav_r11_c1_f2.gif','../images/n_photo_id_ribbons_f2.gif','nav/nav_r13_c1_f2.gif','nav/nav_r16_c1_f2.gif','nav/nav_r19_c1_f2.gif','nav/nav_r20_c1_f2.gif')">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
  <tr>
    <td width="1%" valign="top">
          <!-- Left Menu Start //-->
         <?php include("leftmenu.inc.php"); ?>
    <!-- Left Menu End //-->
      <table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
</table>
<!-- left_navigation_eof //-->    </td>
<!-- body_text //-->
<?php
  if ($category_depth == 'nested') {
    $category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $current_category_id . "' and cd.categories_id = '" . $current_category_id . "' and cd.language_id = '" . $languages_id . "'");
    $category = tep_db_fetch_array($category_query);
?>
    <td width="21%" valign="top">  </td>
<?php
  } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {
// create column list
    $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
                         'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
                         'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
                         'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
                         'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
                         'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
                         'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,
                         'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

    asort($define_list);

    $column_list = array();
    reset($define_list);
    while (list($key, $value) = each($define_list)) {
      if ($value > 0) $column_list[] = $key;
    }

    $select_column_list = '';

    for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
      switch ($column_list[$i]) {
        case 'PRODUCT_LIST_MODEL':
          $select_column_list .= 'p.products_model, ';
          break;
        case 'PRODUCT_LIST_NAME':
          $select_column_list .= 'pd.products_name, ';
          break;
        case 'PRODUCT_LIST_MANUFACTURER':
          $select_column_list .= 'm.manufacturers_name, ';
          break;
        case 'PRODUCT_LIST_QUANTITY':
          $select_column_list .= 'p.products_quantity, ';
          break;
        case 'PRODUCT_LIST_IMAGE':
          $select_column_list .= 'p.products_image, ';
          break;
        case 'PRODUCT_LIST_WEIGHT':
          $select_column_list .= 'p.products_weight, ';
          break;
      }
    }

// show the products of a specified manufacturer
    if (isset($HTTP_GET_VARS['manufacturers_id'])) {
      if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only a specific category
        $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on (p.products_id = s.products_id) where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
      } else {
// We show them all
        $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on (p.products_id = s.products_id) where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
      }
    } else {
// show the products in a given categorie
      if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only specific catgeory
        $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on (p.products_id = s.products_id) where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
    } else {
// We show them all
        $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id) left join " . TABLE_SPECIALS . " s on (p.products_id = s.products_id), " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
      }
    }

    //if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
        if ( (!isset($HTTP_GET_VARS['sort'])) || (!preg_match('/[1-8][ad]/', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
      for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
        if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
          $HTTP_GET_VARS['sort'] = $i+1 . 'a';
          $listing_sql .= " order by pd.products_name";
          break;
        }
      }
    } else {
      $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);
      $sort_order = substr($HTTP_GET_VARS['sort'], 1);
      $listing_sql .= ' order by ';
      switch ($column_list[$sort_col-1]) {
        case 'PRODUCT_LIST_MODEL':
          $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
          break;
        case 'PRODUCT_LIST_NAME':
          $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');
          break;
        case 'PRODUCT_LIST_MANUFACTURER':
          $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
          break;
        case 'PRODUCT_LIST_QUANTITY':
          $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
          break;
        case 'PRODUCT_LIST_IMAGE':
          $listing_sql .= "pd.products_name";
          break;
        case 'PRODUCT_LIST_WEIGHT':
          $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
          break;
        case 'PRODUCT_LIST_PRICE':
          $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
          break;
      }
    }
?>
    <td width="49%" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <form>
          <tr>
            <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
<?php
// optional Product List Filter
    if (PRODUCT_LIST_FILTER > 0) {
      if (isset($HTTP_GET_VARS['manufacturers_id'])) {
        $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";
      } else {
        $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";
      }
      $filterlist_query = tep_db_query($filterlist_sql);
      if (tep_db_num_rows($filterlist_query) > 1) {
        echo '            <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';
        if (isset($HTTP_GET_VARS['manufacturers_id'])) {
          echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);
          $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));
        } else {
          echo tep_draw_hidden_field('cPath', $cPath);
          $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));
        }
        echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);
        while ($filterlist = tep_db_fetch_array($filterlist_query)) {
          $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);
        }
        echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');
        echo '</form></td>' . "\n";
      }
    }

// Get the right image for the top-right
    $image = DIR_WS_IMAGES . 'table_background_list.gif';
    if (isset($HTTP_GET_VARS['manufacturers_id'])) {
      $image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
      $image = tep_db_fetch_array($image);
      $image = $image['manufacturers_image'];
    } elseif ($current_category_id) {
      $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
      $image = tep_db_fetch_array($image);
      $image = $image['categories_image'];
    }
?>
            <td align="right"><?php echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
          </form>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
          <td>
            <?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?>
          </td>
      </tr>
    </table>
    </td>
<?php
  } else { // default page
?>
    <td width="28%" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td class="main">
                      <table width="100%" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                                          <td>
                            <?php include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFINE_MAINPAGE); ?>
                          </td>
                                        </tr>
                                        <tr>
                                          <td>
                            <table width="100%" border="0" cellspacing="0" cellpadding="5">
               <tr>
            <td class="main"><?php echo tep_customer_greeting(); ?></td>
          </tr>
              <tr>
                <td><font size="2" face="Arial, Helvetica, sans-serif">Par Label
                  Company is a 100% total customer satisfaction oriented
                  company. We realize that our customers are the reason that we
                  are
                  in business and we will strive continually to meet their needs,
                  expectations, and gain their loyalty. </font>
                  <p><font size="2" face="Arial, Helvetica, sans-serif">We provide
                    our customers with quality products at the most
                    competitive prices. Most orders for stock products ship the
                    same day.
                    We can make virtually any size label that you need. There
                    are thousands
                    of label sizes to choose from and ribbons for all thermal
                    printers. Labels
                    can be produced in several types of materials such as paper,
                    for general purpose labeling and synthetic materials such as  polyester and polypropylene for electronics and more durable labeling.  Need pre-printed labels with your logo or other information?  We do that too.
                    </font></p>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table></td>
          </tr>
          <tr>
            <td><br>
                </td>
          </tr>
<?php
    include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);
?>
        </table></td>
      </tr>
    </table></td>
<?php
  }
?>
<!-- body_text_eof //-->
    <td width="1%" valign="top">
<table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
    </table></td>
  </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</table>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

[Jack_mcs]

That file is on the shop side. I thought the problem was in admin?

[amirand926]

well, because the link we go to is ../admin/, where we are asked to log in, i checked the index.php in that directory which just loads/calls the ../catalog/default.php (post #20) that I listed previously. the first thing that the default.php does is require('includes/application_top.php'); which is also posted previously (post #9).

[Jack_mcs]

Yes, the application_top file is called first in all files in the root, shop and admin. The catalog.php file is not part of oscommerce so I think your shop has been changed too much to get it fixed in a support thread, unless someone has the time to walk you through it. I think the final solution will be to change the login for whatever method you are using. Figuring out that method is the hard part in a thread like this.

 

I should add, if the file you posted is in the admin, then there is a good chance that the wrong files are in the admin altogether so no matter what you do will work. You may want to make sure the correct files are in the admin. One way to tell is if there is a column_left.php file and not a column_right.php in the includes directory.

Edited November 17, 2014 by Jack_mcs

[amirand926]

The only file that I have previously mentioned that is in the ../admin/ directory is the configure.php, which is correct. However, I did check

 

 ../admin/includes/ directory:

There is a column_left.php and NOT a comumn_right.php. I am not sure what that means exactly since I am unfamiliar with OSC structure, let alone the way the previous user set this up.

 

../catalog/includes/ directory:

there is both a column_left.php, column_left2.php and a column_right.php.

 

There is no catalog.php (that I have prevously mentioned), just a catalog directory. 

 

I did a serach for a catalog.php and there is one in /public_html/admin/includes/boxes/catalog.php.

 

Thanks a lot for your help and if you want to look elsewhere to solve this I will try. And you said that if they are setup incorrectly than no matter what I do will work... do you mean as far as defining the DB_SERVER in another location (e.g. application_top.php)?

[Jack_mcs]

I'm sorry but I don't have an answer for you.  Here are a few things to consider while trying to figure this out:

 

1 - The admin and the shop are completely separate as far as loading is concerned. You can delete the shop side completely and the admin will still load, once properly setup, although there would be a few errors on some pages but none that would stop it from loading. So stay out of the shop side looking at files. You're just causing yourself confusion, or so it seems to me.

 

2 - If the shop side is working, then the database login is correct for the shop side. That same login should be the same in the admin. This is the database login. Not the admin login. I think you are getting them confused.

 

3 - Once you figure out what kind of shop you are using, or what addon you are using for the admin login, you can edit the database to change the login, which is what the problem is, in my opinion, based on what you posted here. Without knowing that, there's no way to make this change, other than wild guesses, of course.