ladysaat:
I clicked on what you linked and LOL it brought me to the top of the page your post is on. I've been searching for a bit and can't find where to fix or get the SQL to run right.
this is the error I get also when copy and pasting it (I open it in Dreamweaver BTW)
1146 Table 'HODLLC_zencart.configuration_group' doesn't exist
in:
[SELECT @gid := configuration_group_id FROM configuration_group where configuration_group_title LIKE 'Tabbed Products Config';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
How are you running the sql? are you using Admin->install sql patches and using the "choose file" button or are you copying and pasting the sql code into the window. I've tried both methods with both of my stores and I've never had a problem so I'm still stunned as to why it doesn't work.
The best way I could suggest would be to paste the code in your cpanel->mysql databases->phpmyadmin... but that might be a bit more confusing.
I think if you try this code it might work for you through the install sql patches area:
DELETE FROM configuration_group WHERE configuration_group_title LIKE '%Tabbed Products Config%';
DELETE FROM configuration WHERE configuration_description LIKE 'Set this to 1%' LIMIT 12;
INSERT INTO configuration_group VALUES ('', 'Tabbed Products Config', 'Tabbed Products Lite Config', '1', '1');
SELECT @gid := configuration_group_id FROM configuration_group where configuration_group_title LIKE '%Tabbed Products Config%';
UPDATE configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;
INSERT INTO configuration VALUES ('', 'Global Product Description Tab', 'GLOBAL_PROD_DESC_ON_TAB', '1', 'Set this to 1 if you want all products to have the Main Product Description on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Global Main Image On Tab', 'GLOBAL_MAIN_IMAGE_ON_TAB', '0', 'Set this to 1 if you want the product main image on the first tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Global Add To Cart Tab', 'GLOBAL_ADD_TO_CART_ON_TAB', '0', 'Set this to 1 if you want the add to cart button on a tab. Note this includes Add To Cart, Qty Discounts, and Option Attributes. The add to cart option will add itself to the first tab if using any custom tabs, otherwise it will make its own tab, which will be the first tab. This keeps the Add to cart button in view at all times no matter the configuration', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Global Additional Images Tab', 'GLOBAL_ADDL_IMAGES_ON_TAB', '1', 'Set this to 1 if you want the additional images for a product on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Global Customers Also Purchased Tab', 'GLOBAL_CUST_ALSO_PURCH_ON_TAB', '1', 'Set this to 1 if you want the Customers Also Purchased module on its own tab', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Global Media Collection Tab', 'GLOBAL_MEDIA_COLLECTION_ON_TAB', '0', 'Set this to 1 if you want the Media Collection module on its own tab. (MUSIC PRODUCT TYPE ONLY)', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Cross Sell Is Installed', 'CROSS_SELL_IS_INSTALLED', '0', 'Set this to 1 ONLY if you have the Cross Sell contrib installed as per the Cross Sell contribs instructions. This will give an error if you enable this to true without already having it installed', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Global Cross Sell Tab', 'GLOBAL_CROSS_SELL_ON_TAB', '0', 'Set this to 1 if you want the Cross Sell module on its own tab. This will only work if the setting \"Cross Sell Is Installed\" above is set to 1', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Show Tab Headers', 'SHOW_TAB_HEADERS', '1', 'Set this to 1 if you want a header bar to appear under the tabs, above the tab content', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Show Tab Headers when Javascript is Off', 'SHOW_TAB_HEADERS_NO_JSCRIPT', '1', 'Set this to 1 if you want the header to appear under the tabs when javascript is off. This makes it look nicer and more organized if the customer has javascript off and separates each section with a header bar. Can be used even if the normal Show Tab Header is set to false.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Global Reviews Tab', 'GLOBAL_REVIEWS_ON_TAB', '1', 'Set this to 1 if you want the Product Reviews to show up on its own tab.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),"),
('', 'Global Use Sub Tags', 'GLOBAL_USE_SUB_TAGS', '1', 'Set this to 1 to allow the use of sub tags to allow more than one core module to appear on the same tab.', @gid, '11', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
change the "FROM configuration_group" that you see in red to "FROM xxx_configuration_group"
replace xxx with your prefix.
