Tabbed Products ''LITE'' version - Delimiter based

Jo3y:

I had problems getting this to work. :frusty: I'm using Zen Cart v1.3.7 on a server with PHP 4.4.4 and MySQL 4.1.21-standard. I followed the directions provided in the zip, however when I finished and went back to the product listing, there was a PHP error and the bottom half of the site failed to render. I'm about to recreate the error so that I may provide more details regarding my problem, but is anyone aware of a problem with my version of Zen Cart and this release?

By the way, when I get this to work it will be perfect for what I want it to do, and I will donate for it. I also heard about some kind of CSS problem in the current package, which I would be happy to fix to give back to the project.

Any and all input is appreciated...

HI Jo3y,

This contrib is fully compatible with 1.3.7. What error did you get? usually if the page doesn't render it is due to the database stuff not being installed yet and it can't find the settings it needs.

The only CSS problem I know of is with IE6 when you click the main image to pop up the bigger image, then close that and click another tab. I'm not sure which "hack" needs to be there to fix it.

I had been thinking about doing a new version but was waiting to see what the zen-cart team was planning with the use of product type layouts. I was asked by the zc team not to build code around the existing product type code because they might be changing how that works. But for now, this contrib should be able to do what you need and maybe you might be able to understand what the ie6 problem is.

The error I received was:

<!-- bof: Tabbed Product Lite Modifications -->
<!-- Tabbed Products Lite v3.8 :: 25-Oct-2006 :: (tpl_tabbed_products_lite.php) -->
<div id="slidetabsmenu" style="display:none;">
<ul>
<li><a href="javascript:void(0)" onclick="expandcontent('sc1', this)"><span>Product Description</span></a></li>
<div class="systemError">1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX_DISPLAY_XSELL' at line 8<br />in:<br />[select distinct p.products_id, p.products_image, pd.products_name
                         from TABLE_PRODUCTS_XSELL xp, zen_products p, zen_products_description pd
                         where xp.products_id = '1'
                          and xp.xsell_id = p.products_id
                          and p.products_id = pd.products_id
                          and pd.language_id = '1'
                          and p.products_status = 1
                         order by xp.sort_order asc limit MAX_DISPLAY_XSELL]<br /></div>
```But was only apparent after looking at the source, the page stopped rendering after this point; this was the end of the page...

After comparing the error in the source and the corresponding file containing the offending SQL query, I commented out this block of PHP, starting at line 119:
```php
// ===> Check if Cross Sell should be a tab or not (tabstrip)
if ($bCrossSell_Tab != false) {
 $xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
                         from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                         where xp.products_id = '" . $_GET['products_id'] . "'
                          and xp.xsell_id = p.products_id
                          and p.products_id = pd.products_id
                          and pd.language_id = '" . $_SESSION['languages_id'] . "'
                          and p.products_status = 1
                         order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL);
  $num_products_xsell = $xsell_query->RecordCount();
  if ($num_products_xsell != 0) {
    echo '<li><a href="javascript:void(0)" onclick="expandcontent(\'sc'.$g.'\', this)"><span>'.$cross_sell_tab_name.'</span></a></li>' . "\n";
    $g++;
  }
}
```Here's the url of a sample page on the site before I set up Tabbed Products LITE
<http://tinyurl.com/3yeuuu>

Anddd here's a link to the b0rked page:
<http://tinyurl.com/2eqzb5>

Even though /dev is a fresh install with my template, I'm perfectly willing to concede it's an error on my part, and my solution is lame and hacky, definitely not long term. I just want to understand what happened.. I have a sneaking suspicion it has something to do with the naming of the tables and the naming conventions in the version of Zen Cart I have installed.

Oh and, criticism on the template/design is very much appreciated, but go easy! I'm pretty much going one step at a time and adding a few items here and there; it's still very much in development...

Jo3y:

<div class="systemError">1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX_DISPLAY_XSELL' at line 8<br />in:<br />[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL xp, zen_products p, zen_products_description pd where xp.products_id = '1' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit MAX_DISPLAY_XSELL]<br /></div>\[/code]

This usually means that you set "Cross Sell Is Installed" to true, but it isn't really installed. Try setting that to false in your admin area.

Welllll I was unable to find that setting in the admin area, but i opened includes/modules/tabbed_products_lite.php and changed line 28 from:

$bCrossSell_Exists =            CROSS_SELL_IS_INSTALLED;

to

$bCrossSell_Exists =           FALSE;

and that seems to have fixed it. :clap:
Your contribution is a little bit of awesome, qhome, and you're to be commended for providing such fast service for a mod that is free. Please feel free to hit me up the next time CSS gives you a hard time. :D

By the way, I didn't manually change any settings with regard to that Cross Sell constant, or any other setting for that matter. One of those things, I guess.. I'll have to change that back when I install the Cross Sell mod. I have cart_upsellcrosssell_on_shoppingcart_page_1.4. Is this the one your script is geared to work with?

Jo3y:

Welllll I was unable to find that setting in the admin area, but i opened includes/modules/tabbed_products_lite.php and changed line 28 from:

$bCrossSell_Exists = CROSS_SELL_IS_INSTALLED;

> 
> to
> 
> ```php
$bCrossSell_Exists =           FALSE;

and that seems to have fixed it. :clap:
Your contribution is a little bit of awesome, qhome, and you're to be commended for providing such fast service for a mod that is free. Please feel free to hit me up the next time CSS gives you a hard time. :D

By the way, I didn't manually change any settings with regard to that Cross Sell constant, or any other setting for that matter. One of those things, I guess.. I'll have to change that back when I install the Cross Sell mod. I have cart_upsellcrosssell_on_shoppingcart_page_1.4. Is this the one your script is geared to work with?

Well, it sounds like the sql stuff didn't work for you. You should have a section under your Admin->Configuration menu called Tabbed Products Config and there should be about 10 or so settings. Do you have any tabbed products menu options in the configuration menu?

Many of my products will have a lot of Attributes added. Would adding the Tabbed Products ''LITE'' help my products listings look better? Or easier for people to understand and read? Can you put the Attributes into the tabs? Zen cart here: http://www.horse-logos.com/

jonisolis:

Many of my products will have a lot of Attributes added. Would adding the Tabbed Products ''LITE'' help my products listings look better? Or easier for people to understand and read? Can you put the Attributes into the tabs? Zen cart here: http://www.horse-logos.com/

Yes. You can use the sub tags. <!--*sub_AttributeOptions(#)*--> will put the attribs on the tab you put in place of the "#" sign. If you want them on their own tab, just make a custom tab called "Options" or something like that and put the number of that tab

EXAMPLE 1:

<!--%Product Description%-->

This is the stuff on the 1st tab. It also has Add To Cart button on it.

<!--*sub_AttributeOptions(1)*-->

EXAMPLE 1

<!--%Custom Tab 2%-->

This is the 2nd tab and has Add to cart & Attribute Options on it as noted by the sub tabs below.

<!--*sub_AddToCart(2)*--> <!--*sub_AttributeOptions(2)*-->

I am getting the following message when I upload the "TabbedProducts_v3.8_Full.sql" file...

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

I do believe that I uploaded all the other files OK.

jonisolis:

I am getting the following message when I upload the "TabbedProducts_v3.8_Full.sql" file...

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

I do believe that I uploaded all the other files OK.

It appears that you are using a prefix on your database. Edit that sql file and add the part in red:

SELECT @gid := configuration_group_id FROM xxx_configuration_group where configuration_group_title LIKE 'Tabbed Products Config';

change the red xxx_ to your prefix and try the file again.

It appears that you are using a prefix on your database. Edit that sql file and add the part in red:

Where would I look for the file with the prefix? I had someone install the zen cart for me?

Never mind the message above. I found it and now I have Tabbed Products ''LITE'' version installed! Yea!

I was checking out your Tabbed Products ''LITE'' demo site and on this page (http://www.unbannable.com/zen/index.php?main_page=product_info&cPath=1&products_id=1) at the bottom is this message:

Fatal error: Unknown function: zen_update_user_tracking() in /home/unban/public_html/zen/includes/templates/tvc/common/tpl_footer.php on line 69

---

Just thought you would like to know this.

OK, I am lost again. Here is what I am adding below my product description:

<br /> <!--%Options%--> <p><strong>Not for resale in digital format. Please read the <a href="http://www.horse-logos.com/index.php?main_page=conditions">Conditions of Use</a> page.</strong> </p><p>All horse art images are copyrighted by Joni Solis - Horse-Logos.com</p> <!--*sub_AddToCart(Options)*--><br /> <!--*sub_AttributeOptions(Options)*--><br /> --- But I do not see any 'Options' tab. What is a sub tab? Do you have a demo of sub tabs? I am confused.

OK, now I have found my custom tag; silly me I was viewing the wrong product. BUT the Attributes are not showing up under the new custom tag, "Options". But in the first tab, "Product Description".

Here is my page coding for this product:

<!--%Product Description%--> <p>Arabian horse clip art set. Arab horse graphic in two different colors with matching web background images. Clip art images have a white background and should be displayed on white. NOTE: No watermark text on delivered files.</p><p>Click on image to view set and actual size of web quality images.</p> <p><strong>Instant Delivery:</strong> After purchase you will be able to download the horse clipart zip file directly to your computer.</p><p>Web quality equine clip art images can be displayed in your outgoing emails or web pages. Print quailty image files can be inserted into Microsoft Word, PhotoShop, or any other art or page layout word program you have for designs, like - newsletters, stationery, fliers, gift cards, scrapbooking, etc...</p><br /> <!--%Options%--> <p><strong>Not for resale in digital format. Please read the <a href="http://www.horse-logos.com/index.php?main_page=conditions">Conditions of Use</a> page.</strong> </p><p>All horse art images are copyrighted by Joni Solis - Horse-Logos.com</p> <!--*sub_AddToCart(Options)*--><br /> <!--*sub_AttributeOptions(Options)*--><br /> <!--@EndTabs@-->

Opps, forgot to give you the product page to view: http://www.horse-logos.com/arab-flag-arabian-horse-clip-p-6.html

My Tabbed Products Config is set like this...
Title Value Action
Global Product Description Tab 1
Global Main Image On Tab 1
Global Add To Cart Tab 1
Global Additional Images Tab 1
Global Customers Also Purchased Tab 1

Do I need to change anything to get the options to show up in the Options tab?

jonisolis:

Here is my page coding for this product:

<!--%Product Description%--> <p>Arabian horse clip art set. Arab horse graphic in two different colors with matching web background images. Clip art images have a white background and should be displayed on white. NOTE: No watermark text on delivered files.</p><p>Click on image to view set and actual size of web quality images.</p> <p><strong>Instant Delivery:</strong> After purchase you will be able to download the horse clipart zip file directly to your computer.</p><p>Web quality equine clip art images can be displayed in your outgoing emails or web pages. Print quailty image files can be inserted into Microsoft Word, PhotoShop, or any other art or page layout word program you have for designs, like - newsletters, stationery, fliers, gift cards, scrapbooking, etc...</p><br /> <!--%Options%--> <p><strong>Not for resale in digital format. Please read the <a href="http://www.horse-logos.com/index.php?main_page=conditions">Conditions of Use</a> page.</strong> </p><p>All horse art images are copyrighted by Joni Solis - Horse-Logos.com</p> <!--*sub_AddToCart(**Options**)*--><br /> <!--*sub_AttributeOptions(**Options**)*--><br /> <!--@EndTabs@-->

You need to use the number of the tab, not the name. So it looks like Options is your second tab. so put 2 in where I've highlighted the red parts.

Also, FYI you dont need <!--@EndTabs@--> unless you plan on adding text under the tabs. But maybe you do have text under there that you just didn't paste

I getting closer. I now have the Attribute showing up on the 'Options' tab but they are also still on the Product Description tab too.
http://www.horse-logos.com/arab-flag-arabian-horse-clip-p-6.html

Here is my product coding:

<p>Arabian horse clip art set. Arab horse graphic in two different colors with matching web background images. Clip art images have a white background and should be displayed on white. NOTE: No watermark text on delivered files.</p><p>Click on image to view set and actual size of web quality images.</p> <p><strong>Instant Delivery:</strong> After purchase you will be able to download the horse clipart zip file directly to your computer.</p><p>Web quality equine clip art images can be displayed in your outgoing emails or web pages. Print quailty image files can be inserted into Microsoft Word, PhotoShop, or any other art or page layout word program you have for designs, like - newsletters, stationery, fliers, gift cards, scrapbooking, etc...</p> <!--%Options%--> <p><strong>Not for resale in digital format. Please read the <a href="http://www.horse-logos.com/index.php?main_page=conditions">Conditions of Use</a> page.</strong> </p><p>All horse art images are copyrighted by Joni Solis - Horse-Logos.com</p> <!--*sub_AddToCart(2)*--> <!--*sub_AttributeOptions(2)*-->

Trying to install SQL patch from installation files but getting this error message:

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

the xxxxx being my database name.

Any guidance available? detailed instructions appreciated I'm a challenged user

Thanks

wasana:

Trying to install SQL patch from installation files but getting this error message:

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

the xxxxx being my database name.

Any guidance available? detailed instructions appreciated I'm a challenged user

Thanks

read about 5 posts back