Okay, I finally figured out the problem, at least I think I did. I compared the live store database which is an upgrade and a clean install of 1.3.0.1 database.
The following are missing in my life database configuration and I have a feeling it might be related.
Code:
INSERT INTO `configuration` VALUES (336, 'Meta Tags Generated Description Maximum Length?', 'MAX_META_TAG_DESCRIPTION_LENGTH', '50', 'Set Generated Meta Tag Description Maximum Length to (words) Default 50:', 18, 71, NULL, '2006-06-05 14:07:04', '', '');
Code:
INSERT INTO `configuration` VALUES (338, 'Site Map - include My Account Links?', 'SHOW_ACCOUNT_LINKS_ON_SITE_MAP', 'No', 'Should the links to My Account show up on the site-map?<br />Note: Spiders will try to index this page, and likely should not be sent to secure pages, since there is no benefit in indexing a login page.<br /><br />Default: false', 18, 73, NULL, '2006-06-05 14:07:04', NULL, 'zen_cfg_select_option(array(''Yes'', ''No''), ');
I tried to insert these two missing configuration into the DB but got an error for duplicate key. I believe it's because 336/338 are already in use by another configuration option.
How do I get this into the database without the error?
Thanks!!!
Bookmarks