Ahh, but if you got to the ask a question submit, the rollovers stop working. At least it does on our site. I found that I had to remove the on load statement supplied with the AAQ mod. That fixed it.
Printable View
Ahh, but if you got to the ask a question submit, the rollovers stop working. At least it does on our site. I found that I had to remove the on load statement supplied with the AAQ mod. That fixed it.
The readme content is missing in the most current Version: v3.8
Last Updated: Oct 25 2006. When I tic the links it does nothing.
* Title
* About
* Installation
* Upgrade
* How to Use
* Notes & Demos
* History
Are you sure you have Javascript turned on?Quote:
Originally Posted by philc
Do you see content on the the Title page at least? I just dl'd the file and the read me is working for me.
Did not show in FF but worked fine with IE. FF has java enabled.
This is what I see in FF.
* Title
* About
* Installation
* Upgrade
* How to Use
* Notes & Demos
* History
Tabbed Products Lite
Version: v3.8 (Released October 25th, 2006)
Author: QHome (qhomezone######################)
Designed for: Zen Cart v1.3.0.x Release
Tabs based on: DynamicDrive tabs
License: under the GPL
Support: Given via the www.zen-cart.com forums.
Admin/Database vs Non-admin/File version:
Since v3.6, Tabbed Products Lite has used database entries for configuration and comes with a sql file to create the necessary tables.
After install,you can access this menu at Admin->Configuration->Tabbed Products Config
There should be 12 entries.
However, if you for some reason would rather not use the database/admin configuration setup, you can use the alternative config file found in includes/modules/Non-AdminEdition/tabbed_products_lite.php. Move that file to the root directory of includes/modules/ and replace the existing default admin version. Now you can make all configurations in that file instead of the Admin panel
Both versions have all the features listed in this document.
YOU MUST DELETE ALL FILES FROM VERSION 2.x OF TABBED LITE TO AVOID CONFLICTS
Enjoy!
Qhome
hmmQuote:
Originally Posted by philc
works the same for me in IE6, IE7, FF 1.5, FF2.0, and Opera 9.1. Maybe reinstall FF or try FF on another PC.
Besides checking to ensure JavaScript is enabled in Firefox, do you have any Firefox add-ons installed? Maybe NoScript or similar?Quote:
Originally Posted by philc
Also try flushing your Firefox cache.
Woody
I've got the same problem with too much space up top. I love the tabs for entering information. Great. But empty up top. Just the image and it looks wrong. Even centering it may help. http://www.estore.haskellgraphics.co...roducts_id=188
I used the code changes below. But now I'm not really sure where I add the content to go next to the main image?
And Can restrict these changes to only one category?
Would a new product type help?
Thanks.
Code:Code:
<!--eof Product details list -->
<br class="clearBoth" />
REMOVE this:
Code:
<br class="clearBoth" />
FIND in templates/tpl_product_info_display.php
Code:
<!--eof Product details list -->
<br class="clearBoth" />
REMOVE this:
Code:
<br class="clearBoth" />
Hi there,
Im using the latest version of tabbed lite (1.3.8) and im just wondering how do you move the product description beside the product image instead of below it?
I tried changing it by CSS but doesn't help.
Thank you
Berserk use global main image on tab in admin > tabbed config.
Will work.
I tried it but I'm trying to keep it up top and just add some content to the side of it.
I do not want the image to be in a tab. I just want the description to be beside the image.
Berserker & Pablosan -Quote:
Originally Posted by Berserker
Beyond making adjustments in Tools > Tabbed Products Config (if you are using the Admin versin of TPL) there are instructions in the readme (readme_tabbed.html) and other docs included in the Tabbed Products mod package which illustrate techniques on how to position and move around content/objects, above and below the tabs. Also there are a number of posts in this thread describing such techniques (yes it is a long thread... and I see I didn't help much in that department). :wink2:
If you want to move things around from the default settings you will want to become comfortable with editing the structure of your product_info template page (tpl_product_info_display.php) and try out moving content blocks around. The file itself well documents the various code blocks.
I do agree moving different things around on to different tabs can be a bit more complex (but with custom features comes complexity). Understanding the structure of both tpl_tabbed_products_lite.php and tpl_tabbed_products_lite_subtabs.php helps in understanding how and which content/objects are postioned on and within the tabs.
And of course don't forget the CSS (the default is stylesheet_tablitev3_silver.css).
Woody
You want your description besides the image but not on tabs? So for tabs you only want things like additional images and reviews but not any of the description? Or do you want some description up top and some on its own tab?Quote:
Originally Posted by Berserker
If you want all products to have text next to the image, and outside of the tabs, simple disable "Global Products Descrition on Tab" in the admin area. Then the description will be out of the tabs, along with the image.
Alternatively, you can do it for individual products by using the
<!--@IgnoreGlobals@--> tag and leave some text ahead of the first custom tab tag like this:
Product Description:
This product is cool.. you can buy this product cuz u are cool. This text is not on a tab but actually next to the main picture.
<!--%First Tab%-->
This is extra stuff on a tab
<!--%Second Tab%-->
This is extra stuff on another tab
<!--#AdditionalImages#-->
<!--#CustomersAlsoPurchased#-->
<!--#Reviews#-->
That will give u 5 tabs (if u have additional images and customers also purchased set up) and the first part of the text will not be on the tabs.
But if u want the same for all products then just do it the first way.
hi qhome,
if possible, i would like the description to be next to the main image but still on tabs. all the buttons such as add to cart, ask a question, write a review etc will then be below the image.
In a previous post you said you didn't want the main image on the tabs. You can't have text on the right if the tabs are below and u want the product description on a tab as that is an impossible feat in our world. Unless you want it in both places? Or perhaps Quantum tabs where it can be there and not there simultaneously in a fuzzy state :P But this isn't the Matrix! :)Quote:
Originally Posted by Berserker
The best you could do would be like this:
On tabs:
http://www.unbannable.com/zen/index....&products_id=1
or like this:
Off tabs:
http://www.unbannable.com/zen/index....&products_id=6
What i want is for the main image to be in the left side (not on tabs) and the description in the right side and on tabs if possible. Since this can't be done, i decided to stick with the description below and move all buttons beside the image instead to take out some of the white space.
Thanks for all the help.
How could you have tabs on right and on the bottom? Is the picture below what you are trying to decribe? If so then no it's not possibleQuote:
Originally Posted by Berserker
LOL nice drawing dude! :)
The attached image below is what i was trying to do. I only need the tabs on the right.
LOL OHHh .. i misread your earlier post then.Quote:
Originally Posted by Berserker
yea it is possible to do what you want if u edit some of the code. However, I'm kinda working on a new version to allow it to be done from the css files.
I think i'll wait for your new version. When it's ready, just let me know and i'll be happy to test it out.Quote:
Originally Posted by qhome
Thanks!!!
You bug, a new version...lol
Ok, but before I go and have a tizzy, can I ask you how I would make the image show to the right of the text inside the tab like I have rather then the left?
Beerrrrrrrrrr, time
Ya thats the layout I would like to have too. It would solve the whitespace issue too. The whitespace sucks and the description rolling next to it ain't so hot either.Quote:
Originally Posted by Berserker
Your layout is perfect.:yes:
Description next to it is the zen-cart default :PQuote:
Originally Posted by Pablosan
oh mighty Q, if I understand you right, the tab code is pulling off the default config of ZC in relation to image and text placement?
Forget that, Ryk showed me how to do this and yes it makes a big difference towards the visual of the tabs.
add this to your css
#productMainImage, #productDescription3 img {float:right; padding-left:2em;}
and bingo:lamo:
I got the whitespace filled BUT in firefox it's still under main image:wacko:
Looks OK in in IE7 except for the top margin or padding.
Just can't figure out why its not working in firefox?
Take a peek http://www.estore.haskellgraphics.co...ral-p-188.html
I took out the clearboths's, added the ignoreglobals and it worked like you said except for FF.
I fixed all but one position issues with tabbed lite ( gotta move store to root so that link is no good estore. subdomain is being moved )
Anyway I think I know how to get the gap fixed too.
Firebug saysThats the culprit making the gap. Just don't where to remove it quite yet.Code:<h1 class="productGeneral" id="productName">Ceramic Tiled Mural</h1>
Thanks for your MOD it really helped my sad store:yes:
I might make a bunch of Zen mugs for some of you when I get done:wink2:
When displaying additional images there the model number with an additional ">" show up along side each additional image. This only occurs when the additional images are not given their own tab but rather allowed to display in their natural position, at the bottom of the page.
See it here (scroll to bottom of page to see additional images: http://1wristwatch.com/zen3/g9000mc-...tch-p-301.html
PS. I've searched the forums and have tried to find the problem myself by following the trail of files which might contain this error, no luck so far.
Hmm This appears to be part of the additional images file, which I don't change, I only load it. Perhaps something was modified in your tpl_modules_additional_images file when you added the lightbox contrib? Are you using the default additional images template file?Quote:
Originally Posted by hbtrading
I'm using the light box version of the file.
Thanks qhome, I did a quick search in the lightbox thread and found that it's a bug in light box. So far no fix has been found.
Thanks for the great MOD :)
This is one fabulous contribution! Quick question - when I go to install the SQL it gives me this error. (XXXX has replaced database name)
The database is up and running fine, but I've got no experience with sql and so this makes no sense. :( This is a complete fresh install from today, no other mods. During setup I set it to use a prefix of 'zen_'.Quote:
1146 Table 'XXXX.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 non-admin one works fine, but I'd like to have access to it if possible. Any thoughts?
Anticoles
Sorry if this has already been asked and answered...
I'm trying to use images for my tabs like at:
http://www.tigerdirect.ca/applicatio...Tab=0&NoMapp=0
Is there a way to do this that makes sense?
Take a look at page 86 of this threadQuote:
Originally Posted by Antiocles
That seems to be the fix for people with this problem. I have tried setting up a database with a prefix on 1.3.7 zencart and I still don't have this problem with the default file, but page 86 should help you.
Awesome. I knew someone had probably seen that before, but after searching and browsing the thread for an hour I still hadn't seen it. Thanks again!
Antiocles
Q-Quote:
Originally Posted by qhome
It can be observed in various contribution threads many posts related to issues patchiing the database, very often related to table prefix issues.
It has been repeatedly recommended that when patching via Tools > Install SQL Patches, to avoid "uploading" the SQL patch file, and instead copy & paste the SQL code into the query form text box and click the send button. Apparently related to an issue with magicquotes function incorrectly stripping symbols from when uploading. Issue was posted to bug reports board not too long ago. Or other workaround is to patch via phpmyadmin. Hope this helps when responding to repeated SQL table prefix issues.
Woody
Ah thanks for the tip Woody. Oddly enough tho I removed all the magic quotes because of the problems they cause. But no matter how I use my sql file:Quote:
Originally Posted by Woodymon
1. Non-prefix database, copy text into textarea and click send
2. Non-prefix database, use the file upload method
3. Prefix'd database, copy text into textarea and click send
4. Prefix'd database, use the file upload method
All of them work for me, and have always worked for me with the sql file I've included with TPL... but somehow for some people it doesn't seem to work and its just baffling. Maybe its the way their server uploads certain bits, but I don't know enough about why it happens. Even when I tell people to use the copy/paste method it doesn't seem to work all the time.
I have installed the Tabbed Products "LITE" successfully, but I don't get tabs. Mine are text links... how do I get the tabs as in the demo?
http://www.unbannable.com/zen/index....products_id=14
Sounds like you didn't upload the css file. Got a link I can see?Quote:
Originally Posted by caspar
http://www.moochiemoo.com/store/inde...&products_id=8Quote:
Originally Posted by qhome
Looks like you are missing the css file. should be stylesheet_tablitev3_silver.css or any one of the additional ones I've includedQuote:
Originally Posted by caspar
tabbed products lite is very usefull. ok. but how can i customize it so that instead of showing text to show images buttons? images that are defined for every tab.
Well the design of it was to use customizable css buttons, as opposed to one-button-fits-all.Quote:
Originally Posted by ionnnnutz
However it does work both ways. :)
If you want every product to use the same image per tab, you can edit the
languages/english/extra_definitions/tabbed_products_lite.php
change all the text to image code:
example:
Change:
To:Code:define('TEXT_TAB_TITLE_PROD_DESC', 'Product Description');
Or if you have only certain items you want the images on you can do it inline inside the actual product description using:Code:define('TEXT_TAB_TITLE_PROD_DESC', '<img src="http://www.mysite.com/images/proddesc.jpg" />');
Code:<!--%<img src="http://www.mysite.com/images/proddesc.jpg" />%-->
Have I missed something in the thread about SQL patch problems with v 3.8? I have installed it both on live site on remote server and several fresh-install test sites on local server, both live and test are 1.3.7.
I'm installing the SQL patch through the admin panel and I keep getting the same errors no matter what:
1146 Table 'globaldr_zc1.configuration_group' doesn't exist
in:
[SELECT @gid := configuration_group_id FROM configuration_group where configuration_group_title LIKE 'Tabbed Products Config';]
Where am I going wrong?
Thanks!
Matt
Config > Install SQL Patches has well documented issues. Note you have a prefix on your DB tables "globaldr_zc1'. Sometimes Install SQL Patches" figures that out, often it does not. If you tried uploading the patch (which is often the problem), instead try copying and pasting the SQL into the SQL patcher and see if that works (for many it does, for some it does not). If it doesn't work I suggest you edit the SQL file and pre-append any table references with your prefix, and then copy that into SQL patches or process the patch via phpmyadmin.Quote:
Originally Posted by lankeeyankee
Woody
Hi Woody,Quote:
Originally Posted by Woodymon
Thanks for the reply. I got the answer by going backwards through the thread, I started at the beginning before and with my extremely slow dial up I got fried at about pg 30. :smile: So I loaded the new SQL patch and it works fine. Now I'll have to go back through the thread so I can figure out why it only showing text tabs and no graphics. It's gotta be something noob-ish..... :D
Matt
Well, text is the default because they are meant to be dynamic for a each product. but if you want graphical ones, you can set the language file to an html <img src=xxxx.gif> code. Or you can use the manual tab method and use html in place of the text name.Quote:
Originally Posted by lankeeyankee
I am zen 1.3.7 and tab lite 3.8. I changed my template and for some reason in IE7 when you click on a product and on the and tab other then Product Description, Like if you click review or features anyway the price, title, and ask aquestion link disapear you can see what i am talking about here
http://www.lextechs.com/index.php?ma...oducts_id=4431
However it works fine in FF. Any ideas?
Hmm thats really strange. I'll see if I can figure out why.Quote:
Originally Posted by lextechs
Quote:
Originally Posted by qhome
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.
I have NO clue what to do with tables, where to find them, other than I own one to eat on. :(
I know this was working on my other 1.3.5 store, and I can't for the life of me figure out how I did it. That one is prefixed also. This store is 1.3.7 though.
(ACK I ran out of time to edit my prior post.)
I read backwards from here. I tried what was suggested by Woodymon in #945, but I don't have a clue how to make a new SQL file like the guy did in response in #946. I have it open in dreamweaver, but what do I append my HODLLC_ to?? anything starting with zencart.configuration?
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.Quote:
Originally Posted by ladysaat
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:
change the "FROM configuration_group" that you see in red to "FROM xxx_configuration_group"Code: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'),");
replace xxx with your prefix.
Qhome~
I actually have done all three. I found my phpMyAdmin in my cpanel of my host also. Okay I copied the code you put up there, will change that part in red to have HODLLC_zencart. added to the front of it. then I'm going to run it in my zencart by c&p'ing to the box and hitting send. I'll let you know if it works
Just as a side note, I have had numerous problems with SQL and running it with different mods and previous versions of zencart. So maybe it has something to do with where I host or something. But this certainly isn't the first. In fact when SQL patches do go through without a hitch I am shocked. :P
ETA: got this error
1146 Table 'HODLLC_zencart.configuration_group' doesn't exist
in:
[SELECT @gid := configuration_group_id FROM HODLLC_zencart.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.
Looking my phpMyadmin... I see the table configuration_group and also configuration_group_id They are there. The database is HODLLC_zencart. So I'm not really sure here LOL!
I just thought of something.. This whole time I've put HODLLC_zencart.configuration..... because that's what the error mssg said wasn't there. But I just noticed you put xxx_configuration_group. I wonder if the "_" is what I did wrong?
NM I ran it that way while typing this and it still gave me this error.
Error
SQL query:
DELETE FROM configuration_group WHERE configuration_group_title LIKE '%Tabbed Products Config%';
MySQL said: Documentation
#1146 - Table 'HODLLC_zencart.configuration_group' doesn't exist
Quote:
Originally Posted by ladysaat
HODLLC_zencart is your database name.. not your prefix. Your prefix would have been set up during the zen-cart install.. and is usually zen_
hmm I think when I initially installed zen cart (ages ago, i've just been upgrading since) that I thought I had to put what was already in my hosting cpanel. So I would've put HODLLC. I think. LOL.
@Ladysaat-Quote:
Originally Posted by ladysaat
I was incorrect above. The error was not a DB preifx issue.
Everything up to the period (.) is the DATABASE name, not the TABLEPREFIX.
I observed the underscore (_) and auto thought prefix issue. mea culpa.
The format would be:
DBACCOUNT_DBNAME.TABLEPREFIX_TABLENAME
You do not have a table prefix. so as qhome stated pasting the SQL patch code into Install > SQL Patches or via phpmyadmin (SQL tab) should work.
You may want to contact your web host support on this one.
Woody
I was thinking the same thing, as tried running the out-of-the-box one in my phpMyadmin, got same wierd error. qhome wanted to take a look at it, that was yesterday. I haven't heard anything yet, but in my configure there is a thing at the top (in my zen cart admin, I mean) that says Tabbed Lite something. But when I click on it only the top black bar shows. No fields or anything. So maybe he was able to partially fix something. I am going to submit a trouble ticket to my host, or maybe call them, and wait for him to PM me or something also.
holy crap I just thought of something.
so HODLLC_zencart is obviously the database prefix/name but when I look at phpMyadmin... I click on that specific database, all the tables show up as HODLLC_configuration_group etc.
Could this be it????
ETA#2: LMAO @ me using the term "obviously" :D :D
Yep.. I got it to work by adding the prefix in that red area that I posted at #952Quote:
Originally Posted by ladysaat
For some reason, it doesn't auto-prefix this line
Oddly tho, it will automagically figure it out for a line like:Code:SELECT @gid := configuration_group_id FROM xxx_configuration_group where configuration_group_title LIKE '%Tabbed Products Config%';
notice that I didn't have to add the xxx_ after the FROM in that line.Code:DELETE FROM configuration_group WHERE configuration_group_title LIKE '%Tabbed Products Config%';
Not sure why some systems work and others don't. I assume that the MYSQL version is what figures out the code, unless perhaps the zen-cart install_sql_patches window auto-adds the prefix, but then I would assume it would work the same for everyone.
But Ladysaat, you should be able to see the tabbed configuration now. Thanks for your help with the admin panel access to give me a chance to play with the values and track down where the problem is.
Enjoy!
Good detective work Q.Quote:
Originally Posted by qhome
If my memory serves me well, someone reported the varied success of Tools > Install SQL Patches has to do with how magicquotes is configured/supported on the host.
Similar issues plague the patch install process for other mods. I don't recall observing these kinds of issues on 1.2x. Only on 1.3x. I'm hoping an expert could chime in and explain the issue and suggest best practice workarounds.
Woody
Oddly, I thought I remember removing the magic quotes back in version 3.1 because they allegedly aren't needed. But I dl'd v3.8 today from the zen-cart downloads area, and the magic quotes were still there. But even when i did remove them and try it again, it still errored until I manually added the prefix.Quote:
Originally Posted by Woodymon
I guess the best way would be to just make an installer.php file like Easy Populate has. Then it can do logic checks for what database stuff is there or not and populate it the more stable way.
qhome you're awesome! pls excuse the akward typng, my system is being reprd and I'm on my ppc. but had to mk sure 8 said thanks. donation lnk? :p
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,Quote:
Originally Posted by 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:
But was only apparent after looking at the source, the page stopped rendering after this point; this was the end of the page...Code:<!-- 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>
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:
Here's the url of a sample page on the site before I set up Tabbed Products LITEPHP Code:
// ===> 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++;
}
}
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...
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.Quote:
Originally Posted by 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:
toPHP Code:$bCrossSell_Exists = CROSS_SELL_IS_INSTALLED;
and that seems to have fixed it. :clap:PHP Code:$bCrossSell_Exists = FALSE;
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?Quote:
Originally Posted by Jo3y
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 tabQuote:
Originally Posted by jonisolis
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.
It appears that you are using a prefix on your database. Edit that sql file and add the part in red:Quote:
Originally Posted by jonisolis
change the red xxx_ to your prefix and try the file again.Code:SELECT @gid := configuration_group_id FROM xxx_configuration_group where configuration_group_title LIKE 'Tabbed Products Config';
>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....&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...-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?
Quote:
Originally Posted by jonisolis
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...-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
Quote:
Originally Posted by wasana
read about 5 posts back
Hmm that could be a bug. Ill take a look at it later when I get a chance, but when the attribs is called to another tab, it is supposed to remove them from the original tab.Quote:
Originally Posted by jonisolis
Hi - sorry for not spotting that...
BUT, I followed your instruction to add the prefix and still getting errors. This is running on a xampp localhost setup...
After using the install TabbedProducts_v3.8_Full file as is:
(zenprop is DB name and prop is prefix)
1146 Table 'zenprop.configuration_group' doesn't exist
in:
[SELECT @gid := configuration_group_id FROM configuration_group where configuration_group_title LIKE 'Tabbed Products Config';]
after adding prefix 'prop' to txt:
SELECT @gid := configuration_group_id FROM `prop_configuration_group` where `configuration_group_title` LIKE 'Tabbed Products Config';
1146 Table 'zenprop.prop_configuration_group' doesn't exist
in:
[SELECT @gid := configuration_group_id FROM prop_configuration_group where configuration_group_title LIKE 'Tabbed Products Config';]
I even tried propconfiguration_group after looking at table names - different error but still error..
hope you can help, thanks -- its a great looking contribution and I want it badly...:blush:
clarification:
my tables don't use the underscore separator - I've got a propconfiguration_group so I edited the sql update to be
SELECT @gid := configuration_group_id FROM `propconfiguration_group` where `configuration_group_title` LIKE 'Tabbed Products Config';
this is the error message:
1062 Duplicate entry 'GLOBAL_PROD_DESC_ON_TAB' for key 2
in:
[INSERT INTO propconfiguration 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'),");]
seems like the prefix addition worked only to produce a different problem...?
uhhh.... nevermind.....
I was compelled to keep trying and by eliminating the underscore it did process the query after a couple tries ...
looks fine THANKS :flex:
Did you get a chance to check and see if this is a bug or not? Thanks!Quote:
Originally Posted by qhome
Havent had a chance to look into it. I will try today
Dear qhome, any luck with getting the attribs to show up just on the attribs tab?
Doesn't work in Safari
Sorry, nevermind, it works now in Safari. I fixed the problem :lookaroun
Dear all,
I am preparing a new module based on Tabbed Products LITE and I need help.
You can check my post :
http://www.zen-cart.com/forum/showthread.php?t=65616
Today I managed to make the first steps.
I named this module "Auto Menu Pages".
I created a new table :
and a new page in admin, am_pages.php to administrate the table.Quote:
CREATE TABLE `am_pages` (
`am_page_id` int(11) NOT NULL auto_increment,
`am_page_status_id` int(1) NOT NULL default '1',
`am_page_button_title` varchar(64) NOT NULL default '',
`am_page_html_text` text,
`am_page_menu_group` int(11) NOT NULL default '0',
PRIMARY KEY (`am_page_id`)
) TYPE=MyISAM AUTO_INCREMENT=23 ;
The page am_pages.php is based on ezpages.php.
Because of the reason that I am new in PHP , I am searching for some help from anyone, Zen Cart Team or any other developer, especialy from those who worked on Ez Pages mod and Tabbed Products LITE mod.
In combination with my modifications there could be made a new FANTASTIC new feature for Zen Cart.
Contact me directly : info_at_lebrand_dot_gr
I'm trying to create an auto tab (ie. Book Details) using the Moku book module. I read the document on how you created the Cross sell tab, but it's a little over my head. Can someone give me some guidance/direction?? I attached a screenshot of the problem page.
I see this error after install Sql file !
:wacko:Quote:
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 'configuration_group WHERE configuration_group_title LIKE 'Tabbed Products Config' at line 1
in:
[DELETE FROM handicrahandicra_shop.handicra_shop.configuration_group WHERE configuration_group_title LIKE 'Tabbed Products Config' LIMIT 1;]
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.
Anyone can help me ? :hug:
Thanks you
Dear qhome, any luck with getting the attribs to show up just on the attribs tab?
What do you need from me to help you figure it out?
Quote:
Originally Posted by qhome
I recently moved and don't have internet access at home yet. I will try to test some stuff on my local server until tomorrow when i get internet. Sorry for the lack of support.
Hey Q:
Hope your move went well and were able to get all hooked up with broadband. Hope the withdrawal was not too bad while without it. Not sure what's worse, having a home without broadband, or having broadband but being homeless. :wink2:
I have a question thats been lurking in the back of mind for awhile and not sure if it has been previously discussed here, regarding the nuances of loading page specific CSS. When loading "stylesheet_tablitev3_silver.css" (or whichever CSS one decides to install with for you mod), would it be beneficial to only load the CSS you provide in your package, whenever the the templates you provide are also called, but not at any other times? For instance I know I would want the CSS to load when tpl_product_info_display.php is loaded, but not sure which other templates you provide I would also want your CSS loaded. Possibly tpl_tabbed_products_lite,php and tpl_tabbed_products_lite_subtabs,php ? I don't think I ever use the other three template files you provide in your v3.8 mod package (released in October).
Is it possible to not load your CSS to load when most other ZC pages are accessed? Agreed the CSS is only 2K but every bit helps. Maybe you have some comments or ideas on how to best implement such a scheme? Or let me know if I'm nuts dwelling on this idea.
Woody
I finally managed to make it work.
But this first version need to be developed as for queries, as I am new to PHP and MySQL.
So, in admin area you can use the new feature Auto Menu Pages under Admin->Tools.
There you can specify a button title and page content. It works like ezpages.
Then with some queries, an automatic menu with tabs is created based on Tabbed Products Lite.
Well, it is better than ezpages because once the menu load, all contents show directly when you press any button, like Tabbed Products Lite tabs, so it is very very fast.
Anyone interested in developing this new feature, please contact me at [email protected].