Suddenly Customer Login gets Internal Server Error 500 addtnly 404 not found

[bumba000]

Hello All,
This is 1.5.1 and all has been working great for the past two weeks. I get an email from a customer late last night explaining that when they try to log in they get Internal Server Error: 500.

So after a bit of poking (nothing in logs) I find that a failed login results in an expected message -> account not found / wrong pass...
However, what should be a successful login gives up the ISE:500.

This problem does not exist on our DEV site so I changed the DEV config to point at the live DB. Now it gives the same runaround when trying to log in.

I started by slimming down all customer and order tables. No good. so I started slimming down all product tables as I had earlier yesterday been working with products in the admin.

When I emptied the table product_type_layout the login works normally. Replacing the table's data I get the same ISE:500. I begin removing product_type_layout records one at a time until login works.

Apparently it's one of the last couple of records in the table that is at least contributing to the problem. I'm not sure what could have caused an issue in this table as I've not made any changes there since bringing the new site live.

I have since removed the last two entries from the ptl table and it's now working for logins.

[bumba000]

INSERT  INTO `product_type_layout` (`configuration_id`, `configuration_title`,  `configuration_key`, `configuration_value`, `configuration_description`,  `product_type_id`, `sort_order`, `last_modified`, `date_added`,  `use_function`, `set_function`) VALUES
(1, 'Show Model Number',  'SHOW_PRODUCT_INFO_MODEL', '1', 'Display Model Number on Product Info 0=  off 1= on', 1, 1, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(2, 'Show Weight',  'SHOW_PRODUCT_INFO_WEIGHT', '0', 'Display Weight on Product Info 0= off  1= on', 1, 2, '2007-12-19 18:11:06', '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(3, 'Show Attribute Weight',  'SHOW_PRODUCT_INFO_WEIGHT_ATTRIBUTES', '0', 'Display Attribute Weight on  Product Info 0= off 1= on', 1, 3, '2010-05-14 10:41:41', '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(4, 'Show Manufacturer',  'SHOW_PRODUCT_INFO_MANUFACTURER', '1', 'Display Manufacturer Name on  Product Info 0= off 1= on', 1, 4, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(5, 'Show Quantity in Shopping Cart',  'SHOW_PRODUCT_INFO_IN_CART_QTY', '1', 'Display Quantity in Current  Shopping Cart on Product Info 0= off 1= on', 1, 5, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(6, 'Show Quantity in Stock',  'SHOW_PRODUCT_INFO_QUANTITY', '0', 'Display Quantity in Stock on Product  Info 0= off 1= on', 1, 6, '2007-12-17 17:06:36', '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(7, 'Show Product Reviews Count',  'SHOW_PRODUCT_INFO_REVIEWS_COUNT', '0', 'Display Product Reviews Count  on Product Info 0= off 1= on', 1, 7, '2008-12-29 21:35:55', '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(8, 'Show Product Reviews Button',  'SHOW_PRODUCT_INFO_REVIEWS', '1', 'Display Product Reviews Button on  Product Info 0= off 1= on', 1, 8, '2009-01-31 18:05:30', '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(9, 'Show Date Available',  'SHOW_PRODUCT_INFO_DATE_AVAILABLE', '0', 'Display Date Available on  Product Info 0= off 1= on', 1, 9, '2007-12-17 17:07:07', '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(10, 'Show Date Added',  'SHOW_PRODUCT_INFO_DATE_ADDED', '0', 'Display Date Added on Product Info  0= off 1= on', 1, 10, '2007-12-17 17:07:12', '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(11, 'Show Product URL',  'SHOW_PRODUCT_INFO_URL', '1', 'Display URL on Product Info 0= off 1=  on', 1, 11, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(12, 'Show Product Additional Images',  'SHOW_PRODUCT_INFO_ADDITIONAL_IMAGES', '1', 'Display Additional Images  on Product Info 0= off 1= on', 1, 13, '2008-05-20 12:01:50', '2007-12-16  20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(13, 'Show Starting At text on Price',  'SHOW_PRODUCT_INFO_STARTING_AT', '0', 'Display Starting At text on  products with attributes Product Info 0= off 1= on', 1, 12, '2009-11-02  09:09:06', '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(14, 'Show Product Tell a Friend  button', 'SHOW_PRODUCT_INFO_TELL_A_FRIEND', '1', 'Display the Tell a  Friend button on Product Info<br /><br />Note: Turning this  setting off does not affect the Tell a Friend box in the columns and  turning off the Tell a Friend box does not affect the button<br  />0= off 1= on', 1, 15, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(15, 'Product Free Shipping Image  Status - Catalog',  'SHOW_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH', '1', 'Show the  Free Shipping image/text in the catalog?', 1, 16, '2008-05-16 17:07:25',  '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),  '),
(16, 'Product Price Tax Class Default - When adding new  products?', 'DEFAULT_PRODUCT_TAX_CLASS_ID', '0', 'What should the  Product Price Tax Class Default ID be when adding new products?', 1,  100, NULL, '2007-12-16 20:33:35', '', ''),
(17, 'Product Virtual  Default Status - Skip Shipping Address - When adding new products?',  'DEFAULT_PRODUCT_PRODUCTS_VIRTUAL', '0', 'Default Virtual Product status  to be ON when adding new products?', 1, 101, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(18, 'Product Free Shipping Default  Status - Normal Shipping Rules - When adding new products?',  'DEFAULT_PRODUCT_PRODUCTS_IS_ALWAYS_FREE_SHIPPING', '0', 'What should  the Default Free Shipping status be when adding new products?<br  />Yes, Always Free Shipping ON<br />No, Always Free Shipping  OFF<br />Special, Product/Download Requires Shipping', 1, 102,  NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''Yes, Always ON''), array(''id''=>''0'',  ''text''=>''No, Always OFF''), array(''id''=>''2'',  ''text''=>''Special'')), '),
(19, 'Show Model Number',  'SHOW_PRODUCT_MUSIC_INFO_MODEL', '1', 'Display Model Number on Product  Info 0= off 1= on', 2, 1, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(20, 'Show Weight',  'SHOW_PRODUCT_MUSIC_INFO_WEIGHT', '0', 'Display Weight on Product Info  0= off 1= on', 2, 2, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(21, 'Show Attribute Weight',  'SHOW_PRODUCT_MUSIC_INFO_WEIGHT_ATTRIBUTES', '1', 'Display Attribute  Weight on Product Info 0= off 1= on', 2, 3, NULL, '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(22, 'Show Artist',  'SHOW_PRODUCT_MUSIC_INFO_ARTIST', '1', 'Display Artists Name on Product  Info 0= off 1= on', 2, 4, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(23, 'Show Music Genre',  'SHOW_PRODUCT_MUSIC_INFO_GENRE', '1', 'Display Music Genre on Product  Info 0= off 1= on', 2, 4, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(24, 'Show Record Company',  'SHOW_PRODUCT_MUSIC_INFO_RECORD_COMPANY', '1', 'Display Record Company  on Product Info 0= off 1= on', 2, 4, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(25, 'Show Quantity in Shopping Cart',  'SHOW_PRODUCT_MUSIC_INFO_IN_CART_QTY', '1', 'Display Quantity in Current  Shopping Cart on Product Info 0= off 1= on', 2, 5, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(26, 'Show Quantity in Stock',  'SHOW_PRODUCT_MUSIC_INFO_QUANTITY', '0', 'Display Quantity in Stock on  Product Info 0= off 1= on', 2, 6, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(27, 'Show Product Reviews Count',  'SHOW_PRODUCT_MUSIC_INFO_REVIEWS_COUNT', '1', 'Display Product Reviews  Count on Product Info 0= off 1= on', 2, 7, NULL, '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(28, 'Show Product Reviews Button',  'SHOW_PRODUCT_MUSIC_INFO_REVIEWS', '1', 'Display Product Reviews Button  on Product Info 0= off 1= on', 2, 8, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(29, 'Show Date Available',  'SHOW_PRODUCT_MUSIC_INFO_DATE_AVAILABLE', '1', 'Display Date Available  on Product Info 0= off 1= on', 2, 9, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(30, 'Show Date Added',  'SHOW_PRODUCT_MUSIC_INFO_DATE_ADDED', '1', 'Display Date Added on  Product Info 0= off 1= on', 2, 10, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(31, 'Show Starting At text on Price',  'SHOW_PRODUCT_MUSIC_INFO_STARTING_AT', '1', 'Display Starting At text on  products with attributes Product Info 0= off 1= on', 2, 12, NULL,  '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(32, 'Show Product Additional Images',  'SHOW_PRODUCT_MUSIC_INFO_ADDITIONAL_IMAGES', '1', 'Display Additional  Images on Product Info 0= off 1= on', 2, 13, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(33, 'Show Product Tell a Friend  button', 'SHOW_PRODUCT_MUSIC_INFO_TELL_A_FRIEND', '1', 'Display the Tell  a Friend button on Product Info<br /><br />Note: Turning  this setting off does not affect the Tell a Friend box in the columns  and turning off the Tell a Friend box does not affect the button<br  />0= off 1= on', 2, 15, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(34, 'Product Free Shipping Image  Status - Catalog',  'SHOW_PRODUCT_MUSIC_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH', '0', 'Show  the Free Shipping image/text in the catalog?', 2, 16, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),  '),
(35, 'Product Price Tax Class Default - When adding new  products?', 'DEFAULT_PRODUCT_MUSIC_TAX_CLASS_ID', '0', 'What should the  Product Price Tax Class Default ID be when adding new products?', 2,  100, NULL, '2007-12-16 20:33:35', '', ''),
(36, 'Product Virtual  Default Status - Skip Shipping Address - When adding new products?',  'DEFAULT_PRODUCT_MUSIC_PRODUCTS_VIRTUAL', '0', 'Default Virtual Product  status to be ON when adding new products?', 2, 101, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(37, 'Product Free Shipping Default  Status - Normal Shipping Rules - When adding new products?',  'DEFAULT_PRODUCT_MUSIC_PRODUCTS_IS_ALWAYS_FREE_SHIPPING', '0', 'What  should the Default Free Shipping status be when adding new  products?<br />Yes, Always Free Shipping ON<br />No, Always  Free Shipping OFF<br />Special, Product/Download Requires  Shipping', 2, 102, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''Yes, Always ON''), array(''id''=>''0'',  ''text''=>''No, Always OFF''), array(''id''=>''2'',  ''text''=>''Special'')), '),
(38, 'Show Product Reviews Count',  'SHOW_DOCUMENT_GENERAL_INFO_REVIEWS_COUNT', '1', 'Display Product  Reviews Count on Product Info 0= off 1= on', 3, 7, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(39, 'Show Product Reviews Button',  'SHOW_DOCUMENT_GENERAL_INFO_REVIEWS', '1', 'Display Product Reviews  Button on Product Info 0= off 1= on', 3, 8, NULL, '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(40, 'Show Date Available',  'SHOW_DOCUMENT_GENERAL_INFO_DATE_AVAILABLE', '1', 'Display Date  Available on Product Info 0= off 1= on', 3, 9, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(41, 'Show Date Added',  'SHOW_DOCUMENT_GENERAL_INFO_DATE_ADDED', '1', 'Display Date Added on  Product Info 0= off 1= on', 3, 10, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(42, 'Show Product Tell a Friend  button', 'SHOW_DOCUMENT_GENERAL_INFO_TELL_A_FRIEND', '1', 'Display the  Tell a Friend button on Product Info<br /><br />Note:  Turning this setting off does not affect the Tell a Friend box in the  columns and turning off the Tell a Friend box does not affect the  button<br />0= off 1= on', 3, 15, NULL, '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(43, 'Show Product URL',  'SHOW_DOCUMENT_GENERAL_INFO_URL', '1', 'Display URL on Product Info 0=  off 1= on', 3, 11, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(44, 'Show Product Additional Images',  'SHOW_DOCUMENT_GENERAL_INFO_ADDITIONAL_IMAGES', '1', 'Display Additional  Images on Product Info 0= off 1= on', 3, 13, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(45, 'Show Model Number',  'SHOW_DOCUMENT_PRODUCT_INFO_MODEL', '1', 'Display Model Number on  Product Info 0= off 1= on', 4, 1, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(46, 'Show Weight',  'SHOW_DOCUMENT_PRODUCT_INFO_WEIGHT', '0', 'Display Weight on Product  Info 0= off 1= on', 4, 2, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(47, 'Show Attribute Weight',  'SHOW_DOCUMENT_PRODUCT_INFO_WEIGHT_ATTRIBUTES', '1', 'Display Attribute  Weight on Product Info 0= off 1= on', 4, 3, NULL, '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(48, 'Show Manufacturer',  'SHOW_DOCUMENT_PRODUCT_INFO_MANUFACTURER', '1', 'Display Manufacturer  Name on Product Info 0= off 1= on', 4, 4, NULL, '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(49, 'Show Quantity in Shopping Cart',  'SHOW_DOCUMENT_PRODUCT_INFO_IN_CART_QTY', '1', 'Display Quantity in  Current Shopping Cart on Product Info 0= off 1= on', 4, 5, NULL,  '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(50, 'Show Quantity in Stock',  'SHOW_DOCUMENT_PRODUCT_INFO_QUANTITY', '0', 'Display Quantity in Stock  on Product Info 0= off 1= on', 4, 6, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(51, 'Show Product Reviews Count',  'SHOW_DOCUMENT_PRODUCT_INFO_REVIEWS_COUNT', '1', 'Display Product  Reviews Count on Product Info 0= off 1= on', 4, 7, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(52, 'Show Product Reviews Button',  'SHOW_DOCUMENT_PRODUCT_INFO_REVIEWS', '1', 'Display Product Reviews  Button on Product Info 0= off 1= on', 4, 8, NULL, '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(53, 'Show Date Available',  'SHOW_DOCUMENT_PRODUCT_INFO_DATE_AVAILABLE', '1', 'Display Date  Available on Product Info 0= off 1= on', 4, 9, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(54, 'Show Date Added',  'SHOW_DOCUMENT_PRODUCT_INFO_DATE_ADDED', '1', 'Display Date Added on  Product Info 0= off 1= on', 4, 10, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(55, 'Show Product URL',  'SHOW_DOCUMENT_PRODUCT_INFO_URL', '1', 'Display URL on Product Info 0=  off 1= on', 4, 11, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(56, 'Show Product Additional Images',  'SHOW_DOCUMENT_PRODUCT_INFO_ADDITIONAL_IMAGES', '1', 'Display Additional  Images on Product Info 0= off 1= on', 4, 13, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(57, 'Show Starting At text on Price',  'SHOW_DOCUMENT_PRODUCT_INFO_STARTING_AT', '1', 'Display Starting At text  on products with attributes Product Info 0= off 1= on', 4, 12, NULL,  '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(58, 'Show Product Tell a Friend  button', 'SHOW_DOCUMENT_PRODUCT_INFO_TELL_A_FRIEND', '1', 'Display the  Tell a Friend button on Product Info<br /><br />Note:  Turning this setting off does not affect the Tell a Friend box in the  columns and turning off the Tell a Friend box does not affect the  button<br />0= off 1= on', 4, 15, NULL, '2007-12-16 20:33:35',  NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(59, 'Product Free Shipping Image  Status - Catalog',  'SHOW_DOCUMENT_PRODUCT_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH', '0',  'Show the Free Shipping image/text in the catalog?', 4, 16, NULL,  '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),  '),
(60, 'Product Price Tax Class Default - When adding new  products?', 'DEFAULT_DOCUMENT_PRODUCT_TAX_CLASS_ID', '0', 'What should  the Product Price Tax Class Default ID be when adding new products?', 4,  100, NULL, '2007-12-16 20:33:35', '', ''),
(61, 'Product Virtual  Default Status - Skip Shipping Address - When adding new products?',  'DEFAULT_DOCUMENT_PRODUCT_PRODUCTS_VIRTUAL', '0', 'Default Virtual  Product status to be ON when adding new products?', 4, 101, NULL,  '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(62, 'Product Free Shipping Default  Status - Normal Shipping Rules - When adding new products?',  'DEFAULT_DOCUMENT_PRODUCT_PRODUCTS_IS_ALWAYS_FREE_SHIPPING', '0', 'What  should the Default Free Shipping status be when adding new  products?<br />Yes, Always Free Shipping ON<br />No, Always  Free Shipping OFF<br />Special, Product/Download Requires  Shipping', 4, 102, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''Yes, Always ON''), array(''id''=>''0'',  ''text''=>''No, Always OFF''), array(''id''=>''2'',  ''text''=>''Special'')), '),
(63, 'Show Model Number',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_MODEL', '1', 'Display Model Number on  Product Info 0= off 1= on', 5, 1, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(64, 'Show Weight',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_WEIGHT', '0', 'Display Weight on  Product Info 0= off 1= on', 5, 2, NULL, '2007-12-16 20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(65, 'Show Attribute Weight',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_WEIGHT_ATTRIBUTES', '1', 'Display  Attribute Weight on Product Info 0= off 1= on', 5, 3, NULL, '2007-12-16  20:33:35', NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),
(66, 'Show Manufacturer',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_MANUFACTURER', '1', 'Display  Manufacturer Name on Product Info 0= off 1= on', 5, 4, NULL, '2007-12-16  20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',  ''text''=>''True''), array(''id''=>''0'',  ''text''=>''False'')), '),);

[bumba000]

INSERT  
(68, 'Show Quantity in Stock',   'SHOW_PRODUCT_FREE_SHIPPING_INFO_QUANTITY', '1', 'Display Quantity in   Stock on Product Info 0= off 1= on', 5, 6, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(69, 'Show Product Reviews Count',   'SHOW_PRODUCT_FREE_SHIPPING_INFO_REVIEWS_COUNT', '1', 'Display Product   Reviews Count on Product Info 0= off 1= on', 5, 7, NULL, '2007-12-16   20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(70, 'Show Product Reviews Button',   'SHOW_PRODUCT_FREE_SHIPPING_INFO_REVIEWS', '1', 'Display Product  Reviews  Button on Product Info 0= off 1= on', 5, 8, NULL, '2007-12-16   20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(71, 'Show Date Available',   'SHOW_PRODUCT_FREE_SHIPPING_INFO_DATE_AVAILABLE', '0', 'Display Date   Available on Product Info 0= off 1= on', 5, 9, NULL, '2007-12-16   20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(72, 'Show Date Added',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_DATE_ADDED',  '1', 'Display Date Added  on Product Info 0= off 1= on', 5, 10, NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(73, 'Show Product URL',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_URL', '1',  'Display URL on Product Info  0= off 1= on', 5, 11, NULL, '2007-12-16  20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(74, 'Show Product Additional Images',   'SHOW_PRODUCT_FREE_SHIPPING_INFO_ADDITIONAL_IMAGES', '1', 'Display   Additional Images on Product Info 0= off 1= on', 5, 13, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(75, 'Show Starting At text on Price',   'SHOW_PRODUCT_FREE_SHIPPING_INFO_STARTING_AT', '1', 'Display Starting  At  text on products with attributes Product Info 0= off 1= on', 5, 12,   NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(76, 'Show Product Tell a Friend  button',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_TELL_A_FRIEND', '1', 'Display  the Tell  a Friend button on Product Info<br /><br />Note:  Turning  this setting off does not affect the Tell a Friend box in the  columns  and turning off the Tell a Friend box does not affect the  button<br  />0= off 1= on', 5, 15, NULL, '2007-12-16 20:33:35',  NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(77, 'Product Free Shipping Image  Status - Catalog',   'SHOW_PRODUCT_FREE_SHIPPING_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH',   '1', 'Show the Free Shipping image/text in the catalog?', 5, 16, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(78, 'Product Price Tax Class Default - When adding new  products?',  'DEFAULT_PRODUCT_FREE_SHIPPING_TAX_CLASS_ID', '0', 'What  should the  Product Price Tax Class Default ID be when adding new  products?', 5,  100, NULL, '2007-12-16 20:33:35', '', ''),
(79,  'Product Virtual Default Status - Skip Shipping Address - When  adding  new products?',  'DEFAULT_PRODUCT_FREE_SHIPPING_PRODUCTS_VIRTUAL', '0',  'Default Virtual  Product status to be ON when adding new products?', 5,  101, NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(80, 'Product Free Shipping Default  Status - Normal Shipping Rules -  When adding new products?',   'DEFAULT_PRODUCT_FREE_SHIPPING_PRODUCTS_IS_ALWAYS_FREE_SHIPPING', '1',   'What should the Default Free Shipping status be when adding new   products?<br />Yes, Always Free Shipping ON<br />No, Always   Free Shipping OFF<br />Special, Product/Download Requires   Shipping', 5, 102, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes, Always ON''), array(''id''=>''0'',   ''text''=>''No, Always OFF''), array(''id''=>''2'',   ''text''=>''Special'')), '),
(81, 'Show Metatags Title Default -  Product Title',  'SHOW_PRODUCT_INFO_METATAGS_TITLE_STATUS', '1', 'Display  Product Title  in Meta Tags Title 0= off 1= on', 1, 50, NULL,  '2007-12-16 20:33:35',  NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(82, 'Show Metatags Title Default -  Product Name',  'SHOW_PRODUCT_INFO_METATAGS_PRODUCTS_NAME_STATUS', '1',  'Display  Product Name in Meta Tags Title 0= off 1= on', 1, 51, NULL,  '2007-12-16  20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(83, 'Show Metatags Title Default -  Product Model',  'SHOW_PRODUCT_INFO_METATAGS_MODEL_STATUS', '1', 'Display  Product Model  in Meta Tags Title 0= off 1= on', 1, 52, NULL,  '2007-12-16 20:33:35',  NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(84, 'Show Metatags Title Default -  Product Price',  'SHOW_PRODUCT_INFO_METATAGS_PRICE_STATUS', '1', 'Display  Product Price  in Meta Tags Title 0= off 1= on', 1, 53, NULL,  '2007-12-16 20:33:35',  NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(85, 'Show Metatags Title Default -  Product Tagline',  'SHOW_PRODUCT_INFO_METATAGS_TITLE_TAGLINE_STATUS',  '1', 'Display  Product Tagline in Meta Tags Title 0= off 1= on', 1, 54,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(86, 'Show Metatags Title Default -  Product Title',  'SHOW_PRODUCT_MUSIC_INFO_METATAGS_TITLE_STATUS', '1',  'Display Product  Title in Meta Tags Title 0= off 1= on', 2, 50, NULL,  '2007-12-16  20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(87, 'Show Metatags Title Default -  Product Name',  'SHOW_PRODUCT_MUSIC_INFO_METATAGS_PRODUCTS_NAME_STATUS',  '1', 'Display  Product Name in Meta Tags Title 0= off 1= on', 2, 51,  NULL, '2007-12-16  20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(88, 'Show Metatags Title Default -  Product Model',  'SHOW_PRODUCT_MUSIC_INFO_METATAGS_MODEL_STATUS', '1',  'Display Product  Model in Meta Tags Title 0= off 1= on', 2, 52, NULL,  '2007-12-16  20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(89, 'Show Metatags Title Default -  Product Price',  'SHOW_PRODUCT_MUSIC_INFO_METATAGS_PRICE_STATUS', '1',  'Display Product  Price in Meta Tags Title 0= off 1= on', 2, 53, NULL,  '2007-12-16  20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(90, 'Show Metatags Title Default -  Product Tagline',   'SHOW_PRODUCT_MUSIC_INFO_METATAGS_TITLE_TAGLINE_STATUS', '1', 'Display   Product Tagline in Meta Tags Title 0= off 1= on', 2, 54, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(91, 'Show Metatags Title Default -  Document Title',  'SHOW_DOCUMENT_GENERAL_INFO_METATAGS_TITLE_STATUS',  '1', 'Display  Document Title in Meta Tags Title 0= off 1= on', 3, 50,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(92, 'Show Metatags Title Default -  Document Name',   'SHOW_DOCUMENT_GENERAL_INFO_METATAGS_PRODUCTS_NAME_STATUS', '1',   'Display Document Name in Meta Tags Title 0= off 1= on', 3, 51, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(93, 'Show Metatags Title Default -  Document Tagline',   'SHOW_DOCUMENT_GENERAL_INFO_METATAGS_TITLE_TAGLINE_STATUS', '1',   'Display Document Tagline in Meta Tags Title 0= off 1= on', 3, 54,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(94, 'Show Metatags Title Default -  Document Title',  'SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_TITLE_STATUS',  '1', 'Display  Document Title in Meta Tags Title 0= off 1= on', 4, 50,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(95, 'Show Metatags Title Default -  Document Name',   'SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_PRODUCTS_NAME_STATUS', '1',   'Display Document Name in Meta Tags Title 0= off 1= on', 4, 51, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(96, 'Show Metatags Title Default -  Document Model',  'SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_MODEL_STATUS',  '1', 'Display  Document Model in Meta Tags Title 0= off 1= on', 4, 52,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(97, 'Show Metatags Title Default -  Document Price',  'SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_PRICE_STATUS',  '1', 'Display  Document Price in Meta Tags Title 0= off 1= on', 4, 53,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(98, 'Show Metatags Title Default -  Document Tagline',   'SHOW_DOCUMENT_PRODUCT_INFO_METATAGS_TITLE_TAGLINE_STATUS', '1',   'Display Document Tagline in Meta Tags Title 0= off 1= on', 4, 54,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(99, 'Show Metatags Title Default -  Product Title',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_TITLE_STATUS',  '1', 'Display  Product Title in Meta Tags Title 0= off 1= on', 5, 50,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), ') ');

[bumba000]

(100, 'Show Metatags Title Default -  Product Name',   'SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_PRODUCTS_NAME_STATUS', '1',   'Display Product Name in Meta Tags Title 0= off 1= on', 5, 51, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(101, 'Show Metatags Title Default -  Product Model',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_MODEL_STATUS',  '1', 'Display  Product Model in Meta Tags Title 0= off 1= on', 5, 52,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(102, 'Show Metatags Title Default -  Product Price',  'SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_PRICE_STATUS',  '1', 'Display  Product Price in Meta Tags Title 0= off 1= on', 5, 53,  NULL,  '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(103, 'Show Metatags Title Default -  Product Tagline',   'SHOW_PRODUCT_FREE_SHIPPING_INFO_METATAGS_TITLE_TAGLINE_STATUS', '1',   'Display Product Tagline in Meta Tags Title 0= off 1= on', 5, 54, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''True''), array(''id''=>''0'',   ''text''=>''False'')), '),
(104, 'PRODUCT Attribute is Display  Only - Default',  'DEFAULT_PRODUCT_ATTRIBUTES_DISPLAY_ONLY', '0',  'PRODUCT Attribute is  Display Only<br />Used For Display Purposes  Only<br />0= No  1= Yes', 1, 200, NULL, '2007-12-16 20:33:35',  NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(105, 'PRODUCT Attribute is Free - Default',   'DEFAULT_PRODUCT_ATTRIBUTE_IS_FREE', '1', 'PRODUCT Attribute is   Free<br />Attribute is Free When Product is Free<br />0= No   1= Yes', 1, 201, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(106, 'PRODUCT Attribute is Default - Default',   'DEFAULT_PRODUCT_ATTRIBUTES_DEFAULT', '0', 'PRODUCT Attribute is   Default<br />Default Attribute to be Marked Selected<br  />0=  No 1= Yes', 1, 202, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(107, 'PRODUCT Attribute is Discounted - Default',   'DEFAULT_PRODUCT_ATTRIBUTES_DISCOUNTED', '1', 'PRODUCT Attribute is   Discounted<br />Apply Discounts Used by Product  Special/Sale<br  />0= No 1= Yes', 1, 203, NULL, '2007-12-16  20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(108, 'PRODUCT Attribute is Included in Base Price - Default',   'DEFAULT_PRODUCT_ATTRIBUTES_PRICE_BASE_INCLUDED', '1', 'PRODUCT   Attribute is Included in Base Price<br />Include in Base Price   When Priced by Attributes<br />0= No 1= Yes', 1, 204, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(109, 'PRODUCT Attribute is Required - Default',   'DEFAULT_PRODUCT_ATTRIBUTES_REQUIRED', '0', 'PRODUCT Attribute is   Required<br />Attribute Required for Text<br />0= No 1=   Yes', 1, 205, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(110, 'PRODUCT Attribute Price Prefix - Default',   'DEFAULT_PRODUCT_PRICE_PREFIX', '1', 'PRODUCT Attribute Price   Prefix<br />Default Attribute Price Prefix for Adding<br   />Blank, + or -', 1, 206, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), '),
(111, 'PRODUCT  Attribute Weight Prefix - Default',   'DEFAULT_PRODUCT_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX', '1', 'PRODUCT   Attribute Weight Prefix<br />Default Attribute Weight  Prefix<br  />Blank, + or -', 1, 207, NULL, '2007-12-16 20:33:35',  NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), '),
(112, 'MUSIC  Attribute is Display Only - Default',   'DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_DISPLAY_ONLY', '0', 'MUSIC Attribute   is Display Only<br />Used For Display Purposes Only<br />0=   No 1= Yes', 2, 200, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(113, 'MUSIC Attribute is Free - Default',   'DEFAULT_PRODUCT_MUSIC_ATTRIBUTE_IS_FREE', '1', 'MUSIC Attribute is   Free<br />Attribute is Free When Product is Free<br />0= No   1= Yes', 2, 201, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(114, 'MUSIC Attribute is Default - Default',   'DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_DEFAULT', '0', 'MUSIC Attribute is   Default<br />Default Attribute to be Marked Selected<br  />0=  No 1= Yes', 2, 202, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(115, 'MUSIC Attribute is Discounted - Default',   'DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_DISCOUNTED', '1', 'MUSIC Attribute is   Discounted<br />Apply Discounts Used by Product  Special/Sale<br  />0= No 1= Yes', 2, 203, NULL, '2007-12-16  20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(116, 'MUSIC Attribute is Included in Base Price - Default',   'DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_PRICE_BASE_INCLUDED', '1', 'MUSIC   Attribute is Included in Base Price<br />Include in Base Price   When Priced by Attributes<br />0= No 1= Yes', 2, 204, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(117, 'MUSIC Attribute is Required - Default',   'DEFAULT_PRODUCT_MUSIC_ATTRIBUTES_REQUIRED', '0', 'MUSIC Attribute is   Required<br />Attribute Required for Text<br />0= No 1=   Yes', 2, 205, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(118, 'MUSIC Attribute Price Prefix - Default',   'DEFAULT_PRODUCT_MUSIC_PRICE_PREFIX', '1', 'MUSIC Attribute Price   Prefix<br />Default Attribute Price Prefix for Adding<br   />Blank, + or -', 2, 206, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), '),
(119, 'MUSIC  Attribute Weight Prefix - Default',   'DEFAULT_PRODUCT_MUSIC_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX', '1', 'MUSIC   Attribute Weight Prefix<br />Default Attribute Weight  Prefix<br  />Blank, + or -', 2, 207, NULL, '2007-12-16 20:33:35',  NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), '),
(120, 'DOCUMENT  GENERAL Attribute is Display Only - Default',   'DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_DISPLAY_ONLY', '0', 'DOCUMENT   GENERAL Attribute is Display Only<br />Used For Display Purposes   Only<br />0= No 1= Yes', 3, 200, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(121, 'DOCUMENT GENERAL Attribute is Free - Default',   'DEFAULT_DOCUMENT_GENERAL_ATTRIBUTE_IS_FREE', '1', 'DOCUMENT GENERAL   Attribute is Free<br />Attribute is Free When Product is   Free<br />0= No 1= Yes', 3, 201, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(122, 'DOCUMENT GENERAL Attribute is Default - Default',   'DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_DEFAULT', '0', 'DOCUMENT GENERAL   Attribute is Default<br />Default Attribute to be Marked   Selected<br />0= No 1= Yes', 3, 202, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(123, 'DOCUMENT GENERAL Attribute is Discounted - Default',   'DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_DISCOUNTED', '1', 'DOCUMENT  GENERAL  Attribute is Discounted<br />Apply Discounts Used by  Product  Special/Sale<br />0= No 1= Yes', 3, 203, NULL,  '2007-12-16  20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(124, 'DOCUMENT GENERAL Attribute is Included in Base Price -  Default',  'DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_PRICE_BASE_INCLUDED',  '1',  'DOCUMENT GENERAL Attribute is Included in Base Price<br   />Include in Base Price When Priced by Attributes<br />0= No  1=  Yes', 3, 204, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(125, 'DOCUMENT GENERAL Attribute is Required - Default',   'DEFAULT_DOCUMENT_GENERAL_ATTRIBUTES_REQUIRED', '0', 'DOCUMENT GENERAL   Attribute is Required<br />Attribute Required for Text<br   />0= No 1= Yes', 3, 205, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(126, 'DOCUMENT GENERAL Attribute Price Prefix - Default',   'DEFAULT_DOCUMENT_GENERAL_PRICE_PREFIX', '1', 'DOCUMENT GENERAL   Attribute Price Prefix<br />Default Attribute Price Prefix for   Adding<br />Blank, + or -', 3, 206, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), '),
(127, 'DOCUMENT  GENERAL Attribute Weight Prefix - Default',   'DEFAULT_DOCUMENT_GENERAL_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX', '1',   'DOCUMENT GENERAL Attribute Weight Prefix<br />Default Attribute   Weight Prefix<br />Blank, + or -', 3, 207, NULL, '2007-12-16   20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), '),
(128, 'DOCUMENT  PRODUCT Attribute is Display Only - Default',   'DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_DISPLAY_ONLY', '0', 'DOCUMENT   PRODUCT Attribute is Display Only<br />Used For Display Purposes   Only<br />0= No 1= Yes', 4, 200, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(129, 'DOCUMENT PRODUCT Attribute is Free - Default',   'DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTE_IS_FREE', '1', 'DOCUMENT PRODUCT   Attribute is Free<br />Attribute is Free When Product is   Free<br />0= No 1= Yes', 4, 201, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(130, 'DOCUMENT PRODUCT Attribute is Default - Default',   'DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_DEFAULT', '0', 'DOCUMENT PRODUCT   Attribute is Default<br />Default Attribute to be Marked   Selected<br />0= No 1= Yes', 4, 202, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(131, 'DOCUMENT PRODUCT Attribute is Discounted - Default',   'DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_DISCOUNTED', '1', 'DOCUMENT  PRODUCT  Attribute is Discounted<br />Apply Discounts Used by  Product  Special/Sale<br />0= No 1= Yes', 4, 203, NULL,  '2007-12-16  20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(132, 'DOCUMENT PRODUCT Attribute is Included in Base Price -  Default',  'DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_PRICE_BASE_INCLUDED',  '1',  'DOCUMENT PRODUCT Attribute is Included in Base Price<br   />Include in Base Price When Priced by Attributes<br />0= No  1=  Yes', 4, 204, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(133, 'DOCUMENT PRODUCT Attribute is Required - Default',   'DEFAULT_DOCUMENT_PRODUCT_ATTRIBUTES_REQUIRED', '0', 'DOCUMENT PRODUCT   Attribute is Required<br />Attribute Required for Text<br   />0= No 1= Yes', 4, 205, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(134, 'DOCUMENT PRODUCT Attribute Price Prefix - Default',   'DEFAULT_DOCUMENT_PRODUCT_PRICE_PREFIX', '1', 'DOCUMENT PRODUCT   Attribute Price Prefix<br />Default Attribute Price Prefix for   Adding<br />Blank, + or -', 4, 206, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), '),
(135, 'DOCUMENT  PRODUCT Attribute Weight Prefix - Default',   'DEFAULT_DOCUMENT_PRODUCT_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX', '1',   'DOCUMENT PRODUCT Attribute Weight Prefix<br />Default Attribute   Weight Prefix<br />Blank, + or -', 4, 207, NULL, '2007-12-16   20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), '),
(136, 'PRODUCT FREE  SHIPPING Attribute is Display Only - Default',   'DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_DISPLAY_ONLY', '0', 'PRODUCT   FREE SHIPPING Attribute is Display Only<br />Used For Display   Purposes Only<br />0= No 1= Yes', 5, 201, NULL, '2007-12-16   20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(137, 'PRODUCT FREE SHIPPING Attribute is Free - Default',   'DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTE_IS_FREE', '1', 'PRODUCT FREE   SHIPPING Attribute is Free<br />Attribute is Free When Product is   Free<br />0= No 1= Yes', 5, 201, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(138, 'PRODUCT FREE SHIPPING Attribute is Default - Default',   'DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_DEFAULT', '0', 'PRODUCT FREE   SHIPPING Attribute is Default<br />Default Attribute to be Marked   Selected<br />0= No 1= Yes', 5, 202, NULL, '2007-12-16  20:33:35',  NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(139, 'PRODUCT FREE SHIPPING Attribute is Discounted - Default',   'DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_DISCOUNTED', '1', 'PRODUCT   FREE SHIPPING Attribute is Discounted<br />Apply Discounts Used  by  Product Special/Sale<br />0= No 1= Yes', 5, 203, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(140, 'PRODUCT FREE SHIPPING Attribute is Included in Base Price -   Default',   'DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_PRICE_BASE_INCLUDED', '1',   'PRODUCT FREE SHIPPING Attribute is Included in Base Price<br   />Include in Base Price When Priced by Attributes<br />0= No  1=  Yes', 5, 204, NULL, '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(141, 'PRODUCT FREE SHIPPING Attribute is Required - Default',   'DEFAULT_PRODUCT_FREE_SHIPPING_ATTRIBUTES_REQUIRED', '0', 'PRODUCT FREE   SHIPPING Attribute is Required<br />Attribute Required for   Text<br />0= No 1= Yes', 5, 205, NULL, '2007-12-16 20:33:35',   NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'',   ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')),   '),
(142, 'PRODUCT FREE SHIPPING Attribute Price Prefix - Default',   'DEFAULT_PRODUCT_FREE_SHIPPING_PRICE_PREFIX', '1', 'PRODUCT FREE   SHIPPING Attribute Price Prefix<br />Default Attribute Price   Prefix for Adding<br />Blank, + or -', 5, 206, NULL, '2007-12-16   20:33:35', NULL,  'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), '),
(143, 'PRODUCT FREE  SHIPPING Attribute Weight Prefix - Default',   'DEFAULT_PRODUCT_FREE_SHIPPING_PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX', '1',   'PRODUCT FREE SHIPPING Attribute Weight Prefix<br />Default   Attribute Weight Prefix<br />Blank, + or -', 5, 207, NULL,   '2007-12-16 20:33:35', NULL,   'zen_cfg_select_drop_down(array(array(''id''=>''0'',   ''text''=>''Blank''), array(''id''=>''1'', ''text''=>''+''),   array(''id''=>''2'', ''text''=>''-'')), ');

[bumba000]

Well I still can't figure this out. Nothing else seems to fix the problem. Removing those last couple of records in the product_type_layout table lets customers log in. How ? How is that possible? Anyone?

Thanks,
John

[bumba000]

Okay. so now I've replaced the seemingly broken table into the dev site and can not recreate the fatal result. What gives? I really don't understand how the product_type_layout table could work into the problem in the first place.

I'm really very uncomfortable with "well it works now"! Any feedback/input on this matter is greatly appreciated.

Thank again,
John

[bumba000]

... and I have been able to recreate this ... The problem still exists. The "fix" has been to remove the last two entries/records and re-insert them from the zcinstall/mysql file..

[DrByte]

How many entries are in your configuration and product_type_layout tables? Are they the same between dev and prod servers?
I'm wondering whether your session cache/storage limits are being maxed out and that's leaving insufficient buffer memory for something it's doing later with login actions?

Or are you suggesting the data in those 2 records is actually corrupt somehow?

[bumba000]

In creating the new site I of course started from a copy of the live db with a new files set and patched up the db. there are 143 entries in my product_type_layout.

Something else you might like to look at, at least I'd like some explaining on is...

INSERT INTO product_type_layout (configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, set_function, date_added) VALUES ('Show Model Number', 'SHOW_PRODUCT_INFO_MODEL', '1', 'Display Model Number on Product Info 0= off 1= on', '1', '1', 'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), ', now());

is the zen_cfg_select_drop_down missing a closing round brace? Looks like the values or the function are missing it's round brace, mysql complains when it is there though.

I notice the same code since at least 1.3.8 so it's either intentional or a seriously overlooked mistake. If it's a mistake though, how does the system function. If it's not a mistake, please explain how an uneven count of open and close () can work without breaking.

Thank You,
John

[DrByte]

In creating the new site I of course started from a copy of the live db with a new files set and patched up the db. there are 143 entries in my product_type_layout.

My point was in relation to an observation from prior versions where some odd symptoms could occur when the number of entries in both the "configuration" and "product_type_layout" tables used up more than the allotted space in the db_sessions storage fields.
I guess I could have offered another research approach: What happens if you delete several configuration-table entries? What if you delete the first 5 product-type-layout table entries? How do those affect your symptoms.

Something else you might like to look at, at least I'd like some explaining on is...

INSERT INTO product_type_layout (configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, set_function, date_added) VALUES ('Show Model Number', 'SHOW_PRODUCT_INFO_MODEL', '1', 'Display Model Number on Product Info 0= off 1= on', '1', '1', 'zen_cfg_select_drop_down(array(array(\'id\'=>\'1\', \'text\'=>\'True\'), array(\'id\'=>\'0\', \'text\'=>\'False\')), ', now());

is the zen_cfg_select_drop_down missing a closing round brace? Looks like the values or the function are missing it's round brace, mysql complains when it is there though.

I notice the same code since at least 1.3.8 so it's either intentional or a seriously overlooked mistake. If it's a mistake though, how does the system function. If it's not a mistake, please explain how an uneven count of open and close () can work without breaking.

Not a bug, and not related at all.
ZC reads the text in that field, checks to see whether there is a defined function to match it, and then applies its own closing brackets and calls the function. I agree that it looks odd, and it's tripped me up a couple times, and I think I'd rather those things were done differently, but it's actually been that way since osC days and something we never changed.