Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Receiving error 1017 - Can't find file:


nla

Recommended Posts

Receiving error 1017 - Can't find file: './ssdb/configuration.frm' (errno: 13) select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

System was working just fine. I believe I may have changed the configure.php in /catalog/includes, however, everything in the file looks right.

 

Could this be something to do with Mysql not loading or something?

 

The name of mysql database is ssdb.

 

Please help.. Thanks in advance.

Link to comment
Share on other sites

Here is the configure.php

Database info/password not disclosed.

 

************************************

 

<?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://www.silverstyles.net'); // eg, http://localhost - should not be empty for productive

 

servers

define('HTTP_CATALOG_SERVER', 'http://www.silverstyles.net');

define('HTTPS_CATALOG_SERVER', 'https://www.silverstyles.net');

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

define('DIR_FS_DOCUMENT_ROOT', '/home/sites/site3/web/catalog/'); // where the pages are located on the server

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

define('DIR_FS_ADMIN', '/home/sites/site3/web/catalog/admin/'); // absolute pate required

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

define('DIR_FS_CATALOG', '/home/sites/site3/web/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', 'NOTDISCLOSED'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'NOTDISCLOSED');

define('DB_SERVER_PASSWORD', 'NOTDISCLOSED');

define('DB_DATABASE', 'NOTDISCLOSED');

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

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

?>

 

***************************************************

When I go to the site it appears DB_SERVER_USERNAME does not have rights to the database. Is there something I should do in MYSQL so shoppers can access the database by going to the website and shopping for products?

Link to comment
Share on other sites

Additional Information added to previous post:

 

Going into mysql and using database shows the following:

 

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

 

Didn't find any fields in table 'address_book'

Didn't find any fields in table 'address_format'

Didn't find any fields in table 'banners'

Didn't find any fields in table 'banners_history'

Didn't find any fields in table 'categories'

Didn't find any fields in table 'categories_description'

Didn't find any fields in table 'configuration'

Didn't find any fields in table 'configuration_group'

Didn't find any fields in table 'counter'

Didn't find any fields in table 'counter_history'

Didn't find any fields in table 'countries'

Didn't find any fields in table 'currencies'

Didn't find any fields in table 'customers'

Didn't find any fields in table 'customers_basket'

Didn't find any fields in table 'customers_basket_attributes'

Didn't find any fields in table 'customers_info'

Didn't find any fields in table 'geo_zones'

Didn't find any fields in table 'languages'

Didn't find any fields in table 'manufacturers'

Didn't find any fields in table 'manufacturers_info'

Didn't find any fields in table 'newsletters'

Didn't find any fields in table 'orders'

Didn't find any fields in table 'orders_products'

Didn't find any fields in table 'orders_products_attributes'

Didn't find any fields in table 'orders_products_download'

Didn't find any fields in table 'orders_status'

Didn't find any fields in table 'orders_status_history'

Didn't find any fields in table 'orders_total'

Didn't find any fields in table 'products'

Didn't find any fields in table 'products_attributes'

Didn't find any fields in table 'products_attributes_download'

Didn't find any fields in table 'products_description'

Didn't find any fields in table 'products_notifications'

Didn't find any fields in table 'products_options'

Didn't find any fields in table 'products_options_values'

Didn't find any fields in table 'products_options_values_to_products_options'

Didn't find any fields in table 'products_to_categories'

Didn't find any fields in table 'reviews'

Didn't find any fields in table 'reviews_description'

Didn't find any fields in table 'sessions'

Didn't find any fields in table 'specials'

Didn't find any fields in table 'tax_class'

Didn't find any fields in table 'tax_rates'

Didn't find any fields in table 'whos_online'

Didn't find any fields in table 'zones'

Didn't find any fields in table 'zones_to_geo_zones'

Database changed

mysql>

 

Tried also to do a REPAIR TABLE "tablename" and there was an error on each table. Does this mean the database has been corrupted?

 

If so, what is my next step? I had a lot of data in there and almost ready to go live with the site after only a few more modifications.

 

Thanks for any help you can give.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...