Tabbed Products ''LITE'' version - Delimiter based

[qhome]

Okay, I got the script to run after a lot of trial and error from the ZC Install SQL patch page.

I was thinking that the table prefixes had to be added to all the statements, come to find out it only needed to be added to one of them.

Anyway, I got it installed, I can see my products again, but I have a problem with the Configuration > Tabbed Products Config link again. I show three of them on the menu, and none of them show anything on the page. I had this issue with the last upgrade, but one of the links worked, this time none of them do.

Any suggestions on what I should do? The gids are as shown below for the three links.

gID=900
gID=901
gID=905

Should I just reload the database with my latest back up and then reapply the 3.8 Sql patch now that the table prefixes are set correctly?

That shouldnt affect any of the files that were uploaded for 3.8, correct?

You DO have to change it on all Insert commands.
Try this:

DELETE FROM stormstr_zcstore.configuration_group WHERE `configuration_group_title` LIKE 'Tabbed Products Config' LIMIT 3;
DELETE FROM stormstr_zcstore.configuration WHERE `configuration_description` LIKE 'Set this to 1%' LIMIT 12;
INSERT INTO stormstr_zcstore.configuration_group VALUES ('', 'Tabbed Products Config', 'Tabbed Products Lite Config', '1', '1');
SELECT @gid := configuration_group_id 
FROM stormstr_zcstore.configuration_group where `configuration_group_title` LIKE 'Tabbed Products Config';
UPDATE stormstr_zcstore.configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;
INSERT INTO stormstr_zcstore.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'),");

I've updated the 6 spots that need the prefix for your prefix. Miles needs to do the same with his prefix instead of "stormstr_zcstore."

[SyntheticShield]

Okay. I tried that and it flopped. So to make things easy, I just uploaded the latest back up I have of the database and then re-uploaded the sql patch from 3.8 that I had added my table prefix to. It was the 4th line in the code:

SELECT @gid := configuration_group_id

I think I may have over complicated this because I didnt check the table prefixes on the sql patch to begin with and then all the correction and troubleshooting attemps just snowballed it all.

Reverting back to my previous back up and then installed the corrected sql patch for 3.8 everything went like clockwork. I lost a product category that I had added and a couple layout changes but I had no products in the category and I remember what the layout changes were. So I'll get those added back and make a new back up.

Thanks again qhome for an AWESOME contrib and your wonderful and timely help.

[miles]

Qhome,

i have already change my SQL the way you pointed. after upload it, i still got this error.

1142 DELETE command denied to user 'mensdesi_zc1'@'localhost' for table 'configuration_group'
in:
[DELETE FROM zen_mensdesi_zc1.configuration_group WHERE configuration_group_title LIKE 'Tabbed Products Config' LIMIT 3;]
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.

could you please take a look at my SQL file..?

DELETE FROM mensdesi_zc1.configuration_group WHERE `configuration_group_title` LIKE 'Tabbed Products Config' LIMIT 3;
DELETE FROM mensdesi_zc1.configuration WHERE `configuration_description` LIKE 'Set this to 1%' LIMIT 12;
INSERT INTO mensdesi_zc1.configuration_group VALUES ('', 'Tabbed Products Config', 'Tabbed Products Lite Config', '1', '1');
SELECT @gid := configuration_group_id
FROM mensdesi_zc1.configuration_group where `configuration_group_title` LIKE 'Tabbed Products Config';
UPDATE mensdesi_zc1.configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;
INSERT INTO mensdesi_zc1.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'),");

[qhome]

Qhome,

i have already change my SQL the way you pointed. after upload it, i still got this error.
could you please take a look at my SQL file..?

Your error is because the database user/pass information you are using in your configure.php file does not hav full rights to your mysql database. You can try removing the lines with DELETE but I would suggest you get the proper rights to the database instead so that you can properly clean out any erroneous entries.

[miles]

Your error is because the database user/pass information you are using in your configure.php file does not hav full rights to your mysql database.

i still dont get it. its still not clear why is the error keep appear. i try remove the lines with DELETE but it still error. and dont know wht to do with my database.. wish i could solve it.

[qhome]

i still dont get it. its still not clear why is the error keep appear. i try remove the lines with DELETE but it still error. and dont know wht to do with my database.. wish i could solve it.

Who set up your database for your store? when they added you as a user, they did not give you full rights to the database so that error means that you do not have permission to Delete things, you can only add things. But since you added some things that errored, you need to delete those errorneous entries first. But since you do not have DELETE rights to your database, you cannot delete those fields.

This would likely be a problem in later zen-cart upgrades as well if they remove any columns.

The Delete here isn't totally necessary, so you might be able to skip it. But if you have the same problem that SyntheticShield had, where he/she had 3 of the Tabbed Product Config menus in the Admin->Configuration menu, then you will need the power to Delete.

Contact your webhost for assistance in getting your mysql username/password setup to allow DELETE.

In the mean time, try running the sql code again but remove the first two lines that do the deleting process. What error do you get when you don't add the first two lines?

[SyntheticShield]

But if you have the same problem that SyntheticShield had, where he/she had 3 of the Tabbed Product Config menus in the Admin->Configuration menu, then you will need the power to Delete.

For the record, He. :-)

[qhome]

For now, it might be easier for you to use the non-database version that I included. Included with 3.8 there was an alternative file in:
\includes\modules\Non-AdminEdition\tabbed_products_lite.php

copy that file over the other file that is in the main modules folder:
\includes\modules\tabbed_products_lite.php


Now you can make changes by editing that file instead of using the database.

Once you get the database part working, then you can re-copy the normal version of this file out there again and use the admin panel.

This will at least let you get up and running.

For the record, He. :-)

:) just trying to be Politically Correct . With my luck I would have said he and you would have been a she

[muaz]

Hello,

is Tabbed Products ''LITE'' compatible with version 1.3.6?

Thanks

[qhome]

Hello,

is Tabbed Products ''LITE'' compatible with version 1.3.6?

Thanks

Yes it is. :)