HUGE PROBLEM

[SPG Music]

okay so i was trying to add the featured products hack did not work. now i cant use my backup.

 

 

www.buycdsanddvds.com/catalog/admin

 

i cant even get back onto my admin

 

 

someone PLEASEEEEE HELP!!!!!!!!!!!!!!!!1

 

and it wont even let me log in to my ftp server

[SPG Music]

1146 - Table 'buycdsanddvds_com.TABLE_CONFIGURATION' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from TABLE_CONFIGURATION

 

[TEP STOP]

[Jack_mcs]

Capital letters as in TABLE_CONFIGURATION means there is a missing definition. In this case in the includes/database_tables.php file. You must have overwritten yours during the installation. Restore that from your backup and it should be OK (unless you overwrote other files that shouldn't have been overwritten too).

 

Jack

[SPG Music]

but i cant even get into my admin

 

www.buycdsanddvds.com/catalog/admin

[SPG Music]

how do i restore my backup?

[ozcsys]

but i cant even get into my admin

 

www.buycdsanddvds.com/catalog/admin

 

 

Access your database via phpmyadmin or whatever tool is provided by your hosting company and re-populate the database using your last backup.

[SPG Music]

<?php

/*

$Id: database_tables.php,v 1.1 2003/06/20 00:18:30 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

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

 

?>

 

 

seems to be there?

[SPG Music]

http://sq14.webhosting.com/ < is my PHPADMIN and wont even work (the page)

[SPG Music]

*http://sq14.wedohosting.com/

[SPG Music]

ok i logged on , but i dont see any backup files? anyone

[ozcsys]

ok i logged on , but i dont see any backup files? anyone

 

 

If you did your backups to the server then they will be found at

 

admin/backups/

 

If you have more than one chose the latest one ( the date is part of the file name)

 

Download the file to your computer then browse to it from phpmyadmin and re-populate the database.

[SPG Music]

fewf i downloaded my back *btw thank u for being so patient im a total newbie*

 

can you tell me step by step how to install my back up. i cant seem to find the BROWSE

[user99999999]

You need the file includes/database_tables.php not the mysql database backup. You should keep a offline copy of your catalog folder along with the database backups.

[SPG Music]

but i wanna put everything back to normal do u know how i can just fix my problem by restoring?