Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

site proble


realhotstuff

Recommended Posts

My web site turned to blank page. I restored from backup, then happened again after few hours. It happened few times in the last few days. I found out it was caused by the configuration table. I've listed the contents here to see if anyone can help me with it (SQL dumped from phpadmin).

 

INSERT INTO `configuration` VALUES (1, 'Store Name', 'STORE_NAME', 'Real Hot Stuff', 'The name of my store', 1, 1, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (2, 'Store Owner', 'STORE_OWNER', 'Real Hot Stuff', 'The name of my store owner', 1, 2, '2005-02-24 12:16:22', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (3, 'E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', '[email protected]', 'The e-mail address of my store owner', 1, 3, '2005-02-23 14:31:49', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (4, 'E-Mail From', 'EMAIL_FROM', 'real hot stuff <[email protected]>', 'The e-mail address used in (sent) e-mails', 1, 4, '2005-02-24 13:00:26', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (5, 'Country', 'STORE_COUNTRY', '223', 'The country my store is located in <br><br><b>Note: Please remember to update the store zone.</b>', 1, 6, NULL, '2003-07-19 00:52:14', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(');

INSERT INTO `configuration` VALUES (6, 'Zone', 'STORE_ZONE', '41', 'The zone my store is located in', 1, 7, '2005-02-19 15:41:14', '2003-07-19 00:52:14', 'tep_cfg_get_zone_name', 'tep_cfg_pull_down_zone_list(');

INSERT INTO `configuration` VALUES (7, 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', 1, 8, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''asc'', ''desc''),');

INSERT INTO `configuration` VALUES (8, 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', 1, 9, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''products_name'', ''date_expected''),');

INSERT INTO `configuration` VALUES (9, 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language''s currency when it is changed', 1, 10, '2006-02-08 04:29:36', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (10, 'Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', 'ecash<[email protected]>,realhot<[email protected]>', 'Send extra order emails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>', 1, 11, '2006-02-13 13:42:00', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (11, 'Use Search-Engine Safe URLs (still in development)', 'SEARCH_ENGINE_FRIENDLY_URLS', 'true', 'Use search-engine safe urls for all site links', 1, 12, '2006-03-15 07:26:12', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (12, 'Display Cart After Adding Product', 'DISPLAY_CART', 'true', 'Display the shopping cart after adding a product (or return back to their origin)', 1, 14, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (13, 'Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'true', 'Allow guests to tell a friend about a product', 1, 15, '2005-02-19 15:41:34', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (14, 'Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', 1, 17, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''and'', ''or''),');

INSERT INTO `configuration` VALUES (15, 'Store Address and Phone', 'STORE_NAME_ADDRESS', 'Real Hot Stuff\r\nPO BOX 551, PLAINSBORO, NJ 08536\r\nUSA\r\n888-242-6489', 'This is the Store Name, Address and Phone used on printable documents and displayed online', 1, 18, '2005-03-03 20:21:21', '2003-07-19 00:52:14', NULL, 'tep_cfg_textarea(');

INSERT INTO `configuration` VALUES (16, 'Show Category Counts', 'SHOW_COUNTS', 'false', 'Count recursively how many products are in each category', 1, 19, '2005-02-22 16:56:46', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (17, 'Tax Decimal Places', 'TAX_DECIMAL_PLACES', '0', 'Pad the tax value this amount of decimal places', 1, 20, '2005-02-20 21:34:10', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (18, 'Display Prices with Tax', 'DISPLAY_PRICE_WITH_TAX', 'false', 'Display prices with tax included (true) or add the tax at the end (false)', 1, 21, '2005-02-24 12:21:35', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (19, 'First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', 'Minimum length of first name', 2, 1, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (20, 'Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', 'Minimum length of last name', 2, 2, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (21, 'Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '10', 'Minimum length of date of birth', 2, 3, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (22, 'E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', 2, 4, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (23, 'Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', 'Minimum length of street address', 2, 5, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (24, 'Company', 'ENTRY_COMPANY_MIN_LENGTH', '2', 'Minimum length of company name', 2, 6, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (25, 'Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '4', 'Minimum length of post code', 2, 7, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (26, 'City', 'ENTRY_CITY_MIN_LENGTH', '3', 'Minimum length of city', 2, 8, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (27, 'State', 'ENTRY_STATE_MIN_LENGTH', '2', 'Minimum length of state', 2, 9, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (28, 'Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '3', 'Minimum length of telephone number', 2, 10, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (29, 'Password', 'ENTRY_PASSWORD_MIN_LENGTH', '5', 'Minimum length of password', 2, 11, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (30, 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', 2, 12, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (31, 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', 2, 13, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (32, 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', 2, 14, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (33, 'Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', 2, 15, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (34, 'Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the ''This Customer Also Purchased'' box', 2, 16, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (35, 'Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', 3, 1, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (36, 'Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list', 3, 2, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (37, 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of ''number'' links use for page-sets', 3, 3, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (38, 'Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', 3, 4, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (39, 'New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '9', 'Maximum number of new products to display in a category', 3, 5, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (40, 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', 3, 6, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (41, 'Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', 3, 7, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (42, 'Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is ''1'' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', 3, 7, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (43, 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', 3, 8, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (44, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', 3, 9, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (45, 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', 3, 10, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (46, 'Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', 3, 11, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (47, 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', 3, 12, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (48, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', 3, 13, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (49, 'New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display in new products page', 3, 14, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (50, 'Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '10', 'Maximum number of best sellers to display', 3, 15, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (51, 'Also Purchased', 'MAX_DISPLAY_ALSO_PURCHASED', '6', 'Maximum number of products to display in the ''This Customer Also Purchased'' box', 3, 16, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (52, 'Customer Order History Box', 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX', '6', 'Maximum number of products to display in the customer order history box', 3, 17, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (53, 'Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', 3, 18, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (54, 'Small Image Width', 'SMALL_IMAGE_WIDTH', '100', 'The pixel width of small images', 4, 1, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (55, 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '80', 'The pixel height of small images', 4, 2, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (56, 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '57', 'The pixel width of heading images', 4, 3, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (57, 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '40', 'The pixel height of heading images', 4, 4, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (58, 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', 4, 5, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (59, 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '57', 'The pixel height of subcategory images', 4, 6, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (60, 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'true', 'Calculate the size of images?', 4, 7, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (61, 'Image Required', 'IMAGE_REQUIRED', 'true', 'Enable to display broken images. Good for development.', 4, 8, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (62, 'Gender', 'ACCOUNT_GENDER', 'false', 'Display gender in the customers account', 5, 1, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (63, 'Date of Birth', 'ACCOUNT_DOB', 'false', 'Display date of birth in the customers account', 5, 2, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (64, 'Company', 'ACCOUNT_COMPANY', 'false', 'Display company in the customers account', 5, 3, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (65, 'Suburb', 'ACCOUNT_SUBURB', 'false', 'Display suburb in the customers account', 5, 4, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (66, 'State', 'ACCOUNT_STATE', 'true', 'Display state in the customers account', 5, 5, '2005-02-24 12:50:41', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (67, 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', 'cc.php;paypal.php;moneyorder.php', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', 6, 0, '2006-06-16 08:58:24', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (68, 'Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_discount_coupon.php;ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.p

hp', 'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)', 6, 0, '2006-06-12 10:01:17', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (69, 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', 'flat.php;usps.php;zones.php', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', 6, 0, '2005-03-14 13:15:36', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (160, 'Set Order Status', 'MODULE_PAYMENT_MONEYORDER_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', 6, 0, NULL, '2005-02-23 12:56:59', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(');

INSERT INTO `configuration` VALUES (193, 'Enable USPS Shipping', 'MODULE_SHIPPING_USPS_STATUS', 'True', 'Do you want to offer USPS shipping?', 6, 0, NULL, '2005-03-14 13:15:35', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (158, 'Sort order of display.', 'MODULE_PAYMENT_MONEYORDER_SORT_ORDER', '3', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, '2005-02-23 12:56:59', NULL, NULL);

INSERT INTO `configuration` VALUES (159, 'Payment Zone', 'MODULE_PAYMENT_MONEYORDER_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 2, NULL, '2005-02-23 12:56:59', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');

INSERT INTO `configuration` VALUES (157, 'Make Payable to:', 'MODULE_PAYMENT_MONEYORDER_PAYTO', 'Top Design Services, Inc.', 'Who should payments be made payable to?', 6, 1, NULL, '2005-02-23 12:56:59', NULL, NULL);

INSERT INTO `configuration` VALUES (156, 'Enable Check/Money Order Module', 'MODULE_PAYMENT_MONEYORDER_STATUS', 'True', 'Do you want to accept Check/Money Order payments?', 6, 1, NULL, '2005-02-23 12:56:59', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (185, 'Shipping Zone', 'MODULE_SHIPPING_FLAT_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', 6, 0, NULL, '2005-03-14 12:17:33', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');

INSERT INTO `configuration` VALUES (184, 'Tax Class', 'MODULE_SHIPPING_FLAT_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2005-03-14 12:17:33', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');

INSERT INTO `configuration` VALUES (183, 'Shipping Cost', 'MODULE_SHIPPING_FLAT_COST', '10', 'The shipping cost for all orders using this shipping method.', 6, 0, NULL, '2005-03-14 12:17:33', NULL, NULL);

INSERT INTO `configuration` VALUES (182, 'Enable Flat Shipping', 'MODULE_SHIPPING_FLAT_STATUS', 'False', 'Do you want to offer flat rate shipping?', 6, 0, NULL, '2005-03-14 12:17:33', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (84, 'Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', 6, 0, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (85, 'Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', 6, 0, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (86, 'Default Order Status For New Orders', 'DEFAULT_ORDERS_STATUS_ID', '1', 'When a new order is created, this order status will be assigned to it.', 6, 0, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (87, 'Display Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_STATUS', 'true', 'Do you want to display the order shipping cost?', 6, 1, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (88, 'Sort Order', 'MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER', '3', 'Sort order of display.', 6, 2, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (89, 'Allow Free Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING', 'false', 'Do you want to allow free shipping?', 6, 3, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (90, 'Free Shipping For Orders Over', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER', '50', 'Provide free shipping for orders over the set amount.', 6, 4, NULL, '2003-07-19 00:52:14', 'currencies->format', NULL);

INSERT INTO `configuration` VALUES (91, 'Provide Free Shipping For Orders Made', 'MODULE_ORDER_TOTAL_SHIPPING_DESTINATION', 'national', 'Provide free shipping for orders sent to the set destination.', 6, 5, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''national'', ''international'', ''both''),');

INSERT INTO `configuration` VALUES (92, 'Display Sub-Total', 'MODULE_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'Do you want to display the order sub-total cost?', 6, 1, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (93, 'Sort Order', 'MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '2', 'Sort order of display.', 6, 2, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (94, 'Display Tax', 'MODULE_ORDER_TOTAL_TAX_STATUS', 'true', 'Do you want to display the order tax value?', 6, 1, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (95, 'Sort Order', 'MODULE_ORDER_TOTAL_TAX_SORT_ORDER', '4', 'Sort order of display.', 6, 2, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (96, 'Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value?', 6, 1, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (97, 'Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '5', 'Sort order of display.', 6, 2, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (98, 'Country of Origin', 'SHIPPING_ORIGIN_COUNTRY', '223', 'Select the country of origin to be used in shipping quotes.', 7, 1, NULL, '2003-07-19 00:52:14', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(');

INSERT INTO `configuration` VALUES (99, 'Postal Code', 'SHIPPING_ORIGIN_ZIP', '08536', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', 7, 2, '2005-02-21 15:23:18', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (100, 'Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', 7, 3, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (101, 'Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '0', 'What is the weight of typical packaging of small to medium packages?', 7, 4, '2005-03-14 14:46:24', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (102, 'Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', 7, 5, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (103, 'Display Product Image', 'PRODUCT_LIST_IMAGE', '1', 'Do you want to display the Product Image?', 8, 1, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (104, 'Display Product Manufaturer Name', 'PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', 8, 2, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (105, 'Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', 8, 3, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (106, 'Display Product Name', 'PRODUCT_LIST_NAME', '2', 'Do you want to display the Product Name?', 8, 4, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (107, 'Display Product Price', 'PRODUCT_LIST_PRICE', '3', 'Do you want to display the Product Price', 8, 5, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (108, 'Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', 8, 6, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (109, 'Display Product Weight', 'PRODUCT_LIST_WEIGHT', '4', 'Do you want to display the Product Weight?', 8, 7, '2005-03-14 14:18:52', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (110, 'Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '5', 'Do you want to display the Buy Now column?', 8, 8, '2005-03-14 13:58:25', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (111, 'Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', 8, 9, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (112, 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 8, 10, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (113, 'Check stock level', 'STOCK_CHECK', 'true', 'Check to see if sufficent stock is available', 9, 1, '2006-05-30 15:16:06', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (114, 'Subtract stock', 'STOCK_LIMITED', 'false', 'Subtract product in stock by product orders', 9, 2, '2005-02-19 15:45:53', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (115, 'Allow Checkout', 'STOCK_ALLOW_CHECKOUT', 'true', 'Allow customer to checkout even if there is insufficient stock', 9, 3, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (116, 'Mark product out of stock', 'STOCK_MARK_PRODUCT_OUT_OF_STOCK', 'Out Of Stock', 'Display something on screen so customer can see which product has insufficient stock', 9, 4, '2006-05-30 15:14:28', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (117, 'Stock Re-order level', 'STOCK_REORDER_LEVEL', '5', 'Define when stock needs to be re-ordered', 9, 5, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (118, 'Store Page Parse Time', 'STORE_PAGE_PARSE_TIME', 'false', 'Store the time it takes to parse a page', 10, 1, '2006-03-11 17:44:20', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (119, 'Log Destination', 'STORE_PAGE_PARSE_TIME_LOG', '/home/realhots/public_html/log/page_parse_time.log', 'Directory and filename of the page parse time log', 10, 2, '2005-02-22 17:04:17', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (120, 'Log Date Format', 'STORE_PARSE_DATE_TIME_FORMAT', '%d/%m/%Y %H:%M:%S', 'The date format', 10, 3, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (121, 'Display The Page Parse Time', 'DISPLAY_PAGE_PARSE_TIME', 'false', 'Display the page parse time (store page parse time must be enabled)', 10, 4, '2005-03-03 20:22:03', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (122, 'Store Database Queries', 'STORE_DB_TRANSACTIONS', 'true', 'Store the database queries in the page parse time log (PHP4 only)', 10, 5, '2005-02-22 16:58:24', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (123, 'Use Cache', 'USE_CACHE', 'false', 'Use caching features', 11, 1, '2006-03-11 17:43:49', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (124, 'Cache Directory', 'DIR_FS_CACHE', '/cache/', 'The directory where the cached files are saved', 11, 2, '2006-02-17 11:06:03', '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (125, 'E-Mail Transport Method', 'EMAIL_TRANSPORT', 'sendmail', 'Defines if this server uses a local connection to sendmail or uses an SMTP connection via TCP/IP. Servers running on Windows and MacOS should change this setting to SMTP.', 12, 1, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''sendmail'', ''smtp''),');

INSERT INTO `configuration` VALUES (126, 'E-Mail Linefeeds', 'EMAIL_LINEFEED', 'LF', 'Defines the character sequence used to separate mail headers.', 12, 2, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''LF'', ''CRLF''),');

INSERT INTO `configuration` VALUES (127, 'Use MIME HTML When Sending Emails', 'EMAIL_USE_HTML', 'false', 'Send e-mails in HTML format', 12, 3, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (128, 'Verify E-Mail Addresses Through DNS', 'ENTRY_EMAIL_ADDRESS_CHECK', 'false', 'Verify e-mail address through a DNS server', 12, 4, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (129, 'Send E-Mails', 'SEND_EMAILS', 'true', 'Send out e-mails', 12, 5, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (130, 'Enable download', 'DOWNLOAD_ENABLED', 'true', 'Enable the products download functions.', 13, 1, '2005-03-05 22:04:41', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (131, 'Download by redirect', 'DOWNLOAD_BY_REDIRECT', 'true', 'Use browser redirection for download. Disable on non-Unix systems.', 13, 2, '2005-03-05 22:05:10', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (132, 'Expiry delay (days)', 'DOWNLOAD_MAX_DAYS', '0', 'Set number of days before the download link expires. 0 means no limit.', 13, 3, '2005-03-05 22:05:22', '2003-07-19 00:52:14', NULL, '');

INSERT INTO `configuration` VALUES (133, 'Maximum number of downloads', 'DOWNLOAD_MAX_COUNT', '5', 'Set the maximum number of downloads. 0 means no download authorized.', 13, 4, NULL, '2003-07-19 00:52:14', NULL, '');

INSERT INTO `configuration` VALUES (134, 'Enable GZip Compression', 'GZIP_COMPRESSION', 'false', 'Enable HTTP GZip compression.', 14, 1, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (135, 'Compression Level', 'GZIP_LEVEL', '5', 'Use this compression level 0-9 (0 = minimum, 9 = maximum).', 14, 2, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (136, 'Session Directory', 'SESSION_WRITE_DIRECTORY', '/tmp', 'If sessions are file based, store them in this directory.', 15, 1, NULL, '2003-07-19 00:52:14', NULL, NULL);

INSERT INTO `configuration` VALUES (137, 'Force Cookie Use', 'SESSION_FORCE_COOKIE_USE', 'True', 'Force the use of sessions when cookies are only enabled.', 15, 2, '2006-02-16 15:52:55', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (138, 'Check SSL Session ID', 'SESSION_CHECK_SSL_SESSION_ID', 'False', 'Validate the SSL_SESSION_ID on every secure HTTPS page request.', 15, 3, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (139, 'Check User Agent', 'SESSION_CHECK_USER_AGENT', 'False', 'Validate the clients browser user agent on every page request.', 15, 4, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (140, 'Check IP Address', 'SESSION_CHECK_IP_ADDRESS', 'True', 'Validate the clients IP address on every page request.', 15, 5, '2005-02-19 15:47:21', '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (141, 'Prevent Spider Sessions', 'SESSION_BLOCK_SPIDERS', 'False', 'Prevent known spiders from starting a session.', 15, 6, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (142, 'Recreate Session', 'SESSION_RECREATE', 'False', 'Recreate the session to generate a new session ID when the customer logs on or creates an account (PHP >=4.1 needed).', 15, 7, NULL, '2003-07-19 00:52:14', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (143, 'Enable PayPal Module', 'MODULE_PAYMENT_PAYPAL_STATUS', 'True', 'Do you want to accept PayPal payments?', 6, 3, NULL, '2005-02-19 16:23:10', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (144, 'E-Mail Address', 'MODULE_PAYMENT_PAYPAL_ID', '[email protected]', 'The e-mail address to use for the PayPal service', 6, 4, NULL, '2005-02-19 16:23:10', NULL, NULL);

INSERT INTO `configuration` VALUES (145, 'Transaction Currency', 'MODULE_PAYMENT_PAYPAL_CURRENCY', 'Only USD', 'The currency to use for credit card transactions', 6, 6, NULL, '2005-02-19 16:23:10', NULL, 'tep_cfg_select_option(array(''Selected Currency'',''Only USD'',''Only CAD'',''Only EUR'',''Only GBP'',''Only JPY''),');

INSERT INTO `configuration` VALUES (146, 'Sort order of display.', 'MODULE_PAYMENT_PAYPAL_SORT_ORDER', '2', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, '2005-02-19 16:23:10', NULL, NULL);

INSERT INTO `configuration` VALUES (147, 'Payment Zone', 'MODULE_PAYMENT_PAYPAL_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 2, NULL, '2005-02-19 16:23:10', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');

INSERT INTO `configuration` VALUES (148, 'Set Order Status', 'MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', 6, 0, NULL, '2005-02-19 16:23:10', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(');

INSERT INTO `configuration` VALUES (191, 'Zone 1 Shipping Table', 'MODULE_SHIPPING_ZONES_COST_1', '3:8.50,7:10.50,99:20.00', 'Shipping rates to Zone 1 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 1 destinations.', 6, 0, NULL, '2005-03-14 12:18:42', NULL, NULL);

INSERT INTO `configuration` VALUES (189, 'Sort Order', 'MODULE_SHIPPING_ZONES_SORT_ORDER', '0', 'Sort order of display.', 6, 0, NULL, '2005-03-14 12:18:42', NULL, NULL);

INSERT INTO `configuration` VALUES (190, 'Zone 1 Countries', 'MODULE_SHIPPING_ZONES_COUNTRIES_1', 'US,CA', 'Comma separated list of two character ISO country codes that are part of Zone 1.', 6, 0, NULL, '2005-03-14 12:18:42', NULL, NULL);

INSERT INTO `configuration` VALUES (192, 'Zone 1 Handling Fee', 'MODULE_SHIPPING_ZONES_HANDLING_1', '0', 'Handling Fee for this shipping zone', 6, 0, NULL, '2005-03-14 12:18:42', NULL, NULL);

INSERT INTO `configuration` VALUES (188, 'Tax Class', 'MODULE_SHIPPING_ZONES_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2005-03-14 12:18:42', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');

INSERT INTO `configuration` VALUES (187, 'Enable Zones Method', 'MODULE_SHIPPING_ZONES_STATUS', 'False', 'Do you want to offer zone rate shipping?', 6, 0, NULL, '2005-03-14 12:18:42', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (186, 'Sort Order', 'MODULE_SHIPPING_FLAT_SORT_ORDER', '0', 'Sort order of display.', 6, 0, NULL, '2005-03-14 12:17:33', NULL, NULL);

INSERT INTO `configuration` VALUES (194, 'Enter the USPS User ID', 'MODULE_SHIPPING_USPS_USERID', '491TOPDE0879', 'Enter the USPS USERID assigned to you.', 6, 0, NULL, '2005-03-14 13:15:35', NULL, NULL);

INSERT INTO `configuration` VALUES (195, 'Enter the USPS Password', 'MODULE_SHIPPING_USPS_PASSWORD', '541IY61DF591', 'See USERID, above.', 6, 0, NULL, '2005-03-14 13:15:35', NULL, NULL);

INSERT INTO `configuration` VALUES (196, 'Which server to use', 'MODULE_SHIPPING_USPS_SERVER', 'production', 'An account at USPS is needed to use the Production server', 6, 0, NULL, '2005-03-14 13:15:35', NULL, 'tep_cfg_select_option(array(''test'', ''production''),');

INSERT INTO `configuration` VALUES (197, 'Handling Fee', 'MODULE_SHIPPING_USPS_HANDLING', '3.50', 'Handling fee for this shipping method.', 6, 0, NULL, '2005-03-14 13:15:35', NULL, NULL);

INSERT INTO `configuration` VALUES (198, 'Tax Class', 'MODULE_SHIPPING_USPS_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2005-03-14 13:15:35', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');

INSERT INTO `configuration` VALUES (199, 'Shipping Zone', 'MODULE_SHIPPING_USPS_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', 6, 0, NULL, '2005-03-14 13:15:35', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');

INSERT INTO `configuration` VALUES (200, 'Sort Order', 'MODULE_SHIPPING_USPS_SORT_ORDER', '0', 'Sort order of display.', 6, 0, NULL, '2005-03-14 13:15:35', NULL, NULL);

 

INSERT INTO `configuration` VALUES (210, 'Set Order Status', 'MODULE_PAYMENT_CC_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', 6, 0, NULL, '2005-04-19 10:35:52', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(');

INSERT INTO `configuration` VALUES (208, 'Sort order of display.', 'MODULE_PAYMENT_CC_SORT_ORDER', '1', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, '2005-04-19 10:35:52', NULL, NULL);

INSERT INTO `configuration` VALUES (209, 'Payment Zone', 'MODULE_PAYMENT_CC_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 2, NULL, '2005-04-19 10:35:52', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');

INSERT INTO `configuration` VALUES (207, 'Split Credit Card E-Mail Address', 'MODULE_PAYMENT_CC_EMAIL', '', 'If an e-mail address is entered, the middle digits of the credit card number will be sent to the e-mail address (the outside digits are stored in the database with the middle digits censored)', 6, 0, NULL, '2005-04-19 10:35:52', NULL, NULL);

INSERT INTO `configuration` VALUES (206, 'Enable Credit Card Module', 'MODULE_PAYMENT_CC_STATUS', 'True', 'Do you want to accept credit card payments?', 6, 0, NULL, '2005-04-19 10:35:52', NULL, 'tep_cfg_select_option(array(''True'', ''False''),');

INSERT INTO `configuration` VALUES (211, 'Enable SEO URLs?', 'SEO_ENABLED', 'true', 'Enable the SEO URLs? This is a global setting and will turn them off completely.', 16, 0, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (212, 'Add cPath to product URLs?', 'SEO_ADD_CPATH_TO_PRODUCT_URLS', 'false', 'This setting will append the cPath to the end of product URLs (i.e. - some-product-p-1.html?cPath=xx).', 16, 1, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (213, 'Add category parent to begining of URLs?', 'SEO_ADD_CAT_PARENT', 'true', 'This setting will add the category parent name to the beginning of the category URLs (i.e. - parent-category-c-1.html).', 16, 2, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (214, 'Filter Short Words', 'SEO_URLS_FILTER_SHORT_WORDS', '3', 'This setting will filter words less than or equal to the value from the URL.', 16, 3, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, NULL);

INSERT INTO `configuration` VALUES (215, 'Enable SEO cache to save queries?', 'USE_SEO_CACHE_GLOBAL', 'true', 'This is a global setting and will turn off caching completely.', 16, 4, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (216, 'Enable product cache?', 'USE_SEO_CACHE_PRODUCTS', 'true', 'This will turn off caching for the products.', 16, 5, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (217, 'Enable categories cache?', 'USE_SEO_CACHE_CATEGORIES', 'true', 'This will turn off caching for the categories.', 16, 6, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (218, 'Enable manufacturers cache?', 'USE_SEO_CACHE_MANUFACTURERS', 'true', 'This will turn off caching for the manufacturers.', 16, 7, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (219, 'Enable articles cache?', 'USE_SEO_CACHE_ARTICLES', 'true', 'This will turn off caching for the articles.', 16, 8, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (220, 'Enable topics cache?', 'USE_SEO_CACHE_TOPICS', 'true', 'This will turn off caching for the article topics.', 16, 9, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (221, 'Enable information cache?', 'USE_SEO_CACHE_INFO_PAGES', 'true', 'This will turn off caching for the information pages.', 16, 10, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (222, 'Enable automatic redirects?', 'USE_SEO_REDIRECT', 'true', 'This will activate the automatic redirect code and send 301 headers for old to new URLs.', 16, 11, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (223, 'Choose URL Rewrite Type', 'SEO_REWRITE_TYPE', 'Rewrite', 'Choose which SEO URL format to use.', 16, 12, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''Rewrite''),');

INSERT INTO `configuration` VALUES (224, 'Enter special character conversions', 'SEO_CHAR_CONVERT_SET', '', 'This setting will convert characters.<br><br>The format <b>MUST</b> be in the form: <b>char=>conv,char2=>conv2</b>', 16, 13, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, NULL);

INSERT INTO `configuration` VALUES (225, 'Remove all non-alphanumeric characters?', 'SEO_REMOVE_ALL_SPEC_CHARS', 'false', 'This will remove all non-letters and non-numbers. This should be handy to remove all special characters with 1 setting.', 16, 14, '2006-02-23 16:44:27', '2006-02-23 16:44:27', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (226, 'Reset SEO URLs Cache', 'SEO_URLS_CACHE_RESET', 'false', 'This will reset the cache data for SEO', 16, 15, '2006-02-23 16:44:27', '2006-02-23 16:44:27', 'tep_reset_cache_data_seo_urls', 'tep_cfg_select_option(array(''reset'', ''false''),');

INSERT INTO `configuration` VALUES (227, 'Display Discount Coupon', 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS', 'true', 'Do you want to display the discount coupon value?', 615, 1, NULL, '2006-06-11 12:10:39', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (228, 'Sort Order', 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_SORT_ORDER', '1', 'Sort order of display.', 615, 2, NULL, '2006-06-11 12:10:39', NULL, NULL);

INSERT INTO `configuration` VALUES (229, 'Display Discount with Minus (-) Sign', 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_TYPE', 'true', '<b>true</b> - the discount will be displayed with a minus sign<br><b>false</b> - the discount will be displayed without a minus sign', 615, 3, NULL, '2006-06-11 12:10:39', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (230, 'Display Subtotal with Applied Discount', 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_SUBTOTAL', 'true', '<b>true</b> - the order subtotal will be displayed with the discount applied<br><b>false</b> - the order subtotal will be displayed without the discount applied<br><br>(If you have prices set to display with taxes, then the order subtotal will always be d', 615, 4, NULL, '2006-06-11 12:10:39', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

INSERT INTO `configuration` VALUES (231, 'Random Code Length', 'MODULE_ORDER_TOTAL_DISCOUNT_COUPON_RANDOM_CODE_LENGTH', '6', 'Length for randomly generated coupon codes.', 615, 5, NULL, '2006-06-11 12:10:39', NULL, NULL);

Link to comment
Share on other sites

Check your server's error log as the problem should be listed there. ;)

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Check your server's error log as the problem should be listed there. ;)

 

It only shows paga not found.

 

It happened again. Here is what I did:

 

1. Used the SQL that I exported from a clen brand new installed to drop and re-create the configuration table, then inserted the rows (default values from osCommerce installation).

2. Went back to admin configuration, added the modules that I needed, reset the values.

 

This is pain in the neck to do it, but I am hoping this can solve the problem. The problem happened 4 days in a row. I had to restore from the backup in the last few days. This time, it is a quick fix for me. I hope this will not happen again.

 

I am hoping someone had the same experience can share some info with me.

 

BTW, my store address is: http://www.realhotstuff.com/

Link to comment
Share on other sites

The error log will also show what the requested url is, which may provide an indication of what the problem is.

 

You could also add

php_flag display_errors on

to your .htaccess file in the hopes of seeing an error message. Be sure to remove that when you are done though.

 

Does your store work from the backup before the payment modules are added?

 

Perhaps one of the payment modules is the cause of your problem.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

The error log will also show what the requested url is, which may provide an indication of what the problem is.

 

You could also add

php_flag display_errors on

to your .htaccess file in the hopes of seeing an error message. Be sure to remove that when you are done though.

 

Does your store work from the backup before the payment modules are added?

 

Perhaps one of the payment modules is the cause of your problem.

 

It started happening after I added Discount Coupon contribution. If did not happen right away thougl. I am not quote sure if this had anything to do with it.

 

Another note, I could not just insert the rows back from the back up SQL I had for configuration table. The problem still happened if I did that. I had to insert the defaults ones (from brand new install), then go to admin and change the setting manually. Is there any easier way that I can add the rows from the backup instead of doing it manually?

 

I also noticed there is an AUTO_INCREMENT statement at the end of CREATE TABLE. Here is the syntax:

CREATE TABLE `configuration` (

`configuration_id` int(11) NOT NULL auto_increment,

`configuration_title` varchar(64) NOT NULL default '',

`configuration_key` varchar(64) NOT NULL default '',

`configuration_value` varchar(255) NOT NULL default '',

`configuration_description` varchar(255) NOT NULL default '',

`configuration_group_id` int(11) NOT NULL default '0',

`sort_order` int(5) default NULL,

`last_modified` datetime default NULL,

`date_added` datetime NOT NULL default '0000-00-00 00:00:00',

`use_function` varchar(255) default NULL,

`set_function` varchar(255) default NULL,

PRIMARY KEY (`configuration_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=190 ;

 

 

Can I remove the AUTO_INCREMENT and do the insert?

Link to comment
Share on other sites

Removal of the auto_increment statement at the end of the table definition can be performed and not affect the import.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Removal of the auto_increment statement at the end of the table definition can be performed and not affect the import.

 

The error happened again, I tried to just insert the rows that I backed up, but did not work. I had to insert the rows from the brand new installation and modify the configuration manually. It happens every day and I have to change that every day. It is very frustrating.

 

I am hoping someone can give me some suggestion to resolve the problem.

Link to comment
Share on other sites

What error are you receiving when you attempt to upload the rows?

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

What error are you receiving when you attempt to upload the rows?

 

No errors, I never had errors from the database. I only got blank screen when I tried to access the site. Any page, including the admin pages.

 

When I loaded the installed default rows, everything worked fine. If I loaded the one I backup after I modified the configuration, it will fail.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...