Tabbed Products ''LITE'' version - Delimiter based

Happen to have a link that I could see?

Paging President qhome....

I finally got around to upgrading to 3.8. All seemed to go well until I tried to apply the sql file and now I have nothing on the product pages. I got the following error message when I tried to upload the sql file:

1146 Table 'stormstr_zcstore.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.

Any ideas qhome? I made a back up of the files and database just a couple days ago so all isnt lost if its bad. The store is essentially down since you cant see any products, but I can deal with that for now if it can be fixed.

Oh, I just noticed as well, that my Tabbed Products Config on the admin side isnt showing anything if that helps any....

where did you run the sql file, in phpmyadmin or in the ZC install sql patches admin link? if you ran it in phpmyadmin, you need to put your prefix on all the tables created by the sql file. if you're running it in the ZC SQL Patch thing.. well.. idk lol. qhome would probably know better in that case :)

Qhome,, you mean i should replace the whole configuration_group & configuration with mensdesi_zc1.configuration_group & mensdesi_zc1.configuration in my SQL file..?

miles:

Qhome,, you mean i should replace the whole configuration_group & configuration with mensdesi_zc1.configuration_group & mensdesi_zc1.configuration in my SQL file..?

Yes. Same goes for you SyntheticShield. Replace with your prefix. I didnt think of prefixes when i created the file. sorry.

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?

SyntheticShield:

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."

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.

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'),");

miles:

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.

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.

miles:

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?

qhome:

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. :-)

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.

SyntheticShield:

For the record, He. :-)

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

Hello,

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

Thanks

muaz:

Hello,

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

Thanks

Yes it is. :)

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?Ok, this is the error tht i still got..after deleted the first two lines :

1146 Table 'mensdesi_zc1.configuration_group' doesn't exist
in:
[SELECT @gid := configuration_group_id FROM configuration_group where configuration_group_title LIKE 'Tabbed Products Config';]

i still have no luck with it..but as you say, the easier way is to use the non-admin version. so i guess its the only way i have at this moment. even though i still wishing tht i could use the admin version. thx for your help btw. its a great contribution.

p/s: used to have no problem with the previous version (TabbedLite-v3.7-AdminEdition). wondering why?

miles:

Ok, this is the error tht i still got..after deleted the first two lines :

1146 Table 'mensdesi_zc1.configuration_group' doesn't exist
in:
[SELECT @gid := configuration_group_id FROM configuration_group where configuration_group_title LIKE 'Tabbed Products Config';]

i still have no luck with it..but as you say, the easier way is to use the non-admin version. so i guess its the only way i have at this moment. even though i still wishing tht i could use the admin version. thx for your help btw. its a great contribution.

p/s: used to have no problem with the previous version (TabbedLite-v3.7-AdminEdition). wondering why?

Hmm are you sure you have a prefix on your database. From your first error it sounds like you did but now it is saying you don't have a table by that name. If you got 3.7 to run then you shouldn't really have a problem here unless it was the delete commands that were causing the error instead of the prefix.

You could try removing the prefix and the DELETE lines and see if that works. but that will just cause more problems because the old 3.7 admin code is probably still there. you really need to have DELETE access to run a store properly. How do you delete products? Does it allow you to do that?

Hi Folks,

I have the same problem with sql-base as Miles, but then i
run the sql-lines direct under sql-base om the server I did not
get any errors.

After I have copy files from contrib and I look in the product info
page it's empty, it's not show anything at all on the page.
And when I try merge my "tpl_product_info_display.php"
with the file from contrib
it's give me a error:

Parse error: parse error, unexpected $ in
includes/templates/template_default/templates/tpl_product_info_display.php on line 310

And in admin is Tabbed Products Config empty

I have not use override in this case..

on:

Apache-version 1.3.36 (Unix)
MySQL-version 4.1.21-standard
PHP-version 5.0.4

And I use ZC-1.3.6