Printable View
Hi,
Can someone help me out with the following:
The prices of my books are shown as follows.
Book price $ 8,63 ($9,95 Incl tax)
How can I show only the price including tax (without the ($.,.. Incl tax)and the red color) and not show the price excl tax.
Thanx...
Hi Berrybattens
Yes I use a U.K oriented display for price,
this should work... if you locate line 283 in file
(your current template)/tpl_product_book_info_display.php
or close to where it says '//uses uk price function jph'mod
change the function that is called here...
toCode:zen_get_products_display_price_uk((int)$_GET['products_id']);
Note this line above, is part of a longer line of code..Code:zen_get_products_display_price((int)$_GET['products_id']);
This is the 'normal zencart price display, you can show tax or not, with an admin setting separately.
Thank you very much.
I was already looking at this for ages...
Now I am going to break my head on how to add the extra fields to the search function.
Regards,
Berry...
I have used this module on two sites and the results have been good.
My client needs one more thing. For every purchase of a particular amount , he wants to give another book free worth a particular price.
As the purchase goes higher, the gift gets costlier. For e.g.
With purchase worth 500$, he wants to give 75$ worth book free. There will be a list of books for selection for the gift.
How is it possible
Hi Everyone
I don't know if I am in the right thread but I am going to ask anyway.
Does anyone know why you cannot have a Document General as a Featured Product or as a Special Product or is it me???
Thanks in advance
Kind Regards
Franco
I have successfully installed the book store using Zen. But authors name is nor getting displayed under the book. All the tables are correct.
If I select the author's name, then a list of books by that author is showna nd it shows the author name also, but not viewing the category products normally.
Please help
Hi,
I am really breaking my head here over the search function. When I enter a search command I always get all the books double in the results. Does anyone knows how to solve this?
Thanx!
Berry...
berrybatens
doubling up of books in search results usually needs 'select distinct ..' in the search sql, you're just getting the same 'rows' repeated at present.
btw there will hopefully be an isbn search adaptation for combined sidebox in the near future
raunharman
do the authors appear on each book display correctly?
Unsure about your book gifts situation, maybe someone else knows if this bonus free item can be arranged. Zencart tends only to do what it does, if you see what I mean.
francocauter
doc general, is it actually a product? I thought there was a doc product type as well..
this query should be a new subject really, in the forum threads, you would get more attention
Any options of free gifts. A buys books worth 500$, he is shown a drop down list of books, each worth 75$, to select as free.
Same with high purchases.
Also how do I setup the option of Book search, like it is on http://www.hareslade.com/zc/index.php
Your help is reqd.
Thanks in advance
raunharman
my site's book search is the 'combined' sidebox, in the add-on's fileset, look inside '1_BOOK_MAIN_FILES' folder, for folder 'OPTIONAL_COMBINED_BOOK_SEARCH_SIDEBOX'
The /catalog folder in there contains the files for the combined sidebox, upload those... and you should apply the sql patch as well via admin, using add_to_mysql_multibox_by_admin_patch.txt..
The sidebox will need to be switched on in admin, its called a multibox.
The authors name length (for the sidebox's authors dropdown list) may need setting to 20 characters or so in admin (in maximums section).
Thanks, I was able to do it
Can I use any other template for changing the looks.
Any option for:
Any options of free gifts. A buys books worth 500$, he is shown a drop down list of books, each worth 75$, to select as free.
Same with high purchases.
Double search results fixed!
When searching for a book on my site, the search results always presented each book twice in the results. The first with image, title and description, the second only image and description.
At first I was checking the code and SQL, I have installed more modules than producttype book, who knows somewhere there is a double entry. But I couldn't find anything. The strange thing is, after installing a clean Zen Cart with product type book, the search results are ok.
Then when I installed the Dutch language next to the English the problem was back.
I am using the Zen Cart in Dutch language only. The producttype book is a multi language module. If you add a book and only fill out the Dutch fields title, subtitle, description and leave the English blank. Zen automaticly takes the description field from the Dutch table to present it in de English language (only in the search results!).
Since my site only uses the Dutch language. But it presents the Dutch and English search results. I deleted the English language and : Problem solved!:clap:
Yes I can well believe the multilanguage version does odd things on occasion
Double result entries sometimes mean a lack of a '..and language_id = (current language)' term somewhere in the search sql.
But certainly removing any unused language will help, provided it removes those entries of that language i.d from the db's book entries.
wish I had a team of 8 to debug these things!
I am getting this error when i goto add a new book to the site, any one have this mod working with the latest version or is this a bug..Quote:
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\Program Files\EasyPHP 2.0b1\www\store\admin\includes\modules\product_book\collect_info.php on line 1714
darkwander
no idea why easyphp is mentioned..what are you up to (explain..)
Note I haven't looked at 1.3.8 yet, will do in the coming weeks..
Your prob error is due to the server reading this commented out bit (lines 1706 to 1719) which I didn't want it to, in the book file you mention (collect_info.php), and its being picky, buts its right, technically there is a code layout error,
Its a coding glitch, I misplaced the block comment 'close' */ , change the last line of the above code, (1719) and split into two lines so it looks likeCode:<? /* used as pub nmonth above, single value dropdown select
//====== dd1
if($fg_show_product_book_info_misc_dd1 == 1){?>
<tr class="main5">
<td class="main5" width="15%"><?php echo TEXT_PRODUCTS_BOOK_MISC_DD1; ?>
</td>
<td class="main5">
<?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . ' ' .
zen_draw_pull_down_menu_multiple('book_dd1_id' . $i . '[]'', $book_dd1_array[$i], $book_dd1_default_array[$i], 'multiple="multiple"',20)
?>
</td>
</tr>
<? }
//=========end dd1 */
Code://=========end dd1
*/
I have easyphp installed so that i can test the mods on my local system before uploading the mods to a live site, just incase the mod dosnt work and causes problems.Quote:
Originally Posted by hareslade
Still getting the error.Quote:
Note I haven't looked at 1.3.8 yet, will do in the coming weeks..
Your prob error is due to the server reading this commented out bit (lines 1706 to 1719) which I didn't want it to, in the book file you mention (collect_info.php), and its being picky, buts its right, technically there is a code layout error,
Its a coding glitch, I misplaced the block comment 'close' */ , change the last line of the above code, (1719) and split into two lines so it looks likeCode:<? /* used as pub nmonth above, single value dropdown select
//====== dd1
if($fg_show_product_book_info_misc_dd1 == 1){?>
<tr class="main5">
<td class="main5" width="15%"><?php echo TEXT_PRODUCTS_BOOK_MISC_DD1; ?>
</td>
<td class="main5">
<?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . ' ' .
zen_draw_pull_down_menu_multiple('book_dd1_id' . $i . '[]'', $book_dd1_array[$i], $book_dd1_default_array[$i], 'multiple="multiple"',20)
?>
</td>
</tr>
<? }
//=========end dd1 */
Code://=========end dd1
*/
Hi darkwander
perhaps you will have to remove the whole commented out section I mention.. if your php is vague p.m me, I can send you the modded file.
I have encountered a strange problem.
I did nothing on the CSS file, but by itself, the display of the web site got distorted.
The font size increased (both Firefox and IE)and the site started getting displayed on left of screen by itself (internet Explorer).
The web site is
www.saibookstore.com
Please help.
Thanks in advance
If you don't mind me asking, what version of Zencart are you using ?Quote:
Originally Posted by raunharman
It seems to be only the first page, if you click on products the view goes back to normal, however the main page is still all screwed up.Quote:
Originally Posted by raunharman
I uploaded the files to the site that is running live and it worked fine, maybe the files didnt extract right the first time or something..Quote:
Originally Posted by hareslade
Just a question in the section "Admin-Product Type-Info Page Layout options :: Product - Book"
Is there suppose to be options like in Product-General, i have nothing in the list.
My initial guess is that one of your files - most likely your CSS file - didn't upload fully, so you're only getting the first portion of your styles. Try uploading the files in question again.Quote:
Originally Posted by raunharman
Websites typically don't change "by themselves". Either a file got corrupted (in which case you should replace it with a good copy) or someone made a change somewhere that had unintended consequences.
It's possible that a change was made somewhere in your CSS or elsewhere that accidentally threw everything after it off.
Hi hareslade,
I've been Internet deprived for the past year, but i'm so happy to see that you've kept this thread open both with your code contributions and advice. With 33,000 views, it's certainly an active thread with many thanks having to go to you.
I downloaded your little package today (for 1.3.7) and it seems to work fine. I am however, raising a question I asked way back in this thread. So far back in fact, I couldn't find it!
The Author's listing in Admin has a very large space to write a lovely Author profile with photo. I am unable to find out how the general public can access that profile. It's so important. it's like the sleeve, or back cover of a good book. The authors are as important as the book(s) themselves, and I really do want my visitors to be able to see their profiles.
I notice that when I click on "Author" in the product listing, it shows all books by the same author. That's fantastic, but how can I get my visitors to also read about the author?
Kindest regards and thanks once again for continuing to keep this thread well and truely alive.
John
johnk yes you are right... click on an author in the left sidebox..
http://hareslade.com/zc137_t4bk/inde...k_authors_id=1
Right hand sidebox.. but I can't for the life of remember if its in the books fileset.
It's in that demo site there though for the multilanguage (V3) book....
if its in your sidebox list in admin, its probably called 'Authors info' have a look..
I know this has probably been in here before, but I must have missed it in all of the pages somewhere.
I have installed this mod and it is working great but for one problem.
I have the author and genre sideboxes set to show only when in the books category and they usually work great. The problem I am having is that if there is more than 1 item listed in the same category I do not get a list of them, but instead get sent back to the home page. Right now there are only 6 books listed and the only genre with more than 1 is the classics.
Has anyone seen this or have any idea how to fix it?
Thanks,
Joe
Greetings:
Once the mod is installed, the following line is added to every product that is listed including product that are not under "Product - book"
ISBN: <Model Number>
This comes up when you click on a category. for example;
Is there anyway to remove the line "ISBN: AT0040" from that listing page..Quote:
9 Inches of Pure Pleasure
Powerful vibrating 9" beaded ######## plug.
ISBN: AT0040
Below is a link to what i mean, keep in mind that you must be 18+ to view..
http://www.delightsoftheflesh.com/st...ndex&cPath=214
jhauser...
let's hope it is not a bug..
when there is more than one product in the list, it uses a product listing template.
Guessing a most likely cause..there is a 'redirect' of the listing page, so if you were php testing using 'echo' to show debug texts in the listing file, then if an echo you used, is still live in the listing file, that effect is exactly what you get, it returns to home page because the final page redirect fails.
Let me know if thats a wrong guess
darkwander
yes I noticed extra ISBN/publisher in ordinary products, here is a fix
http://www.hareslade.com/zc125/downl...ST_JAN2008.zip
I will add to the fix list on the V3 download at my site
Note, this fix incorporates the V4 system for getting book product type i.d
What...V4?
I'm issuing book V4 specifically for zencart 1.3.8a 'shortly', I'm still testing it on my demo sites. If anyone ** desperately ** needs V4 p.m me, I can only zip the main files folder though, I haven't done the 'grid' option mods for 1.3.8 just yet.
V4 is just undergoing multilanguage test now, single language mode looks ok.
Quote:
Originally Posted by hareslade
Thanks for trying to help. Unfortunately, I am fairly new to this and do not have a great knowledge of php. I really don't understand what this means. I am using this books mod as it was written. The only other thing that may be affecting it is that I am using the column layout grid contribution. Beyond that I am not sure, so I guess I will have to learn more php and just keep troubleshooting and turn those items off for now.
Thanks again,
Joe
hi jhauser42
my condolences for the grid part not working, did you try re-uploading just the files.. sometimes transfer can get interrupted
Incidentally I am still working on V4, the htmlarea textual editor open source project is I notice now defunct?
And I'm having probs getting htmlarea to work in a multi language environment, **even in the normal product type** collect info page. In fact, thats not uncommon, I see other posts with those problems as from zencart V1.3.5.
So I'm trying FckEditor and TinyMCE, to see if they work better.
I've tried that, yes. What I intend to do is to upload and install a brand-new v138a install of zen-cart. Then I will install the book product type and make sure it is working properly. Then I can install the other mods I am using 1 at a time and see where it breaks. At least this way I can narrow down where I am getting this problem.
Thanks again,
Joe
hey jhauser42 hold your horses...
V3 book is only for up to V1.3.7 zencart, if you try V3 on 1.3.8a it is untested by me in that situation. Thats why I'm slaving away here doing V4 for 1.3.8a :)
Quote:
Originally Posted by hareslade
OH. I did not realize it was not tested on v1.3.8a. Maybe that is why I am having problems. Oh well, not gonna hurt to try it in a new test database....
Joe
Oh well... this stands in for the final V4 book add-on, while I battle with my host over poor website sql performance..
I have zipped a BETA of PART OF (note, part of) V4 for v1.3.8a for those in a hurry
The zip has the sql (slightly added to relative to V3) and the main files catalog folder for upload. Refer to the V3 docs mostly.. be aware this zip has the book multi sidebox with a new ISBN search dropdown.
http://www.hareslade.com/zc125/downl..._V_4_LANGS.zip
This beta DOES NOT run totally correctly for multilanguage, please wait for the full V4 if you are setting up more than one language, or just use one language for now. tthis Beta does NOT have the grid option extras.
Any silly bugs in this zip let me know pronto, otherwise they don't get fixed...
I just searched the forum, but I found nothing under broad search terms, so I thought I'd ask... Is there a way to display the subtitle in the book listings after, say, clicking on a category?
the ocerina..
No its not standard, subtitle isn't shown in listings
Maybe you could just add any subtitle to the title entry text
You need to do programming in php to put subtitle in listings, it could be done.
If it's possible, could you tell me exactly which files I need to program into? I will probably go the long way around and just hard code the PHP into the files, but I'm not sure which file is the one that I want. If it's not too much trouble, how can I make sure that the subtitle for each listing is printed underneath the title?
ocarina..
wait for v4 full kit for 1.3.8, i'll have it beta-finished in a day or two.
I have put subtitle in the main product book listings, not 'just' for you, but it shows others how to copy it for other book 'extra' fields.
perhaps you'd like to be my beta tester no.1 (they are difficult to find ;)
btw you just don't want to know 'how' the thing works, its observers and notifiers.. I just built on what moku did.
Hareslade,Quote:
Originally Posted by hareslade
I'll volunteer for beta testing. I have just set up a test site with the latest version of ZC and was about to put in this mod when I saw that you've got a new version coming. The only other thing I'm going to have on this install is the multiple site mod (which we've been using for quite some time now on our live site). I actually set up this test site to work out any possible problems before updating our live store(s)...so testing is what I had in mind!
Let me know if that works for you!
Hareslade, that's great news. I would love to test out the new beta.
Here we go then... V4 Books, Issue1
Anyone please try it.. it runs single or multilanguage, specifically for V138a zencart, do not use it on 1.3.7.
A few items are new, such as ISBN search, which was done 'to order'.
And Book subtitle under main listing titles, just for books. Put all isbn's in as straight, no gaps or dashes, it enables easier searches.
The zip is 2.7Mb because there are some language packs copies in there.
I suggest you use FCKEditor in admin, specially if running in multilanguage.
The multi-sidebox search is now in the fileset, and can be collapsed down to just use ISBN if becessary. ISBN search can be textual or dropdown. Note there are an awful lot of admin settings in product type | books | edit layout. a few are in maximums section.
Beta testers please try out and give feedback, specially in the admin side for books. Its too complicated for me to test everything again for V4, but its basics work fine.
http://www.hareslade.com/zc125/downl...LANGS_ISS1.zip
Demo sites (later they will have more books in them!):
Single language mode
http://www.hareslade.com/zc138a_t1/
Multi language mode
http://www.hareslade.com/zc138a_t2/
Single language with grid display for books, text input ISBN search.
note that the right hand column is blanked when books grid layout is used. It can be unblanked, (uncomment a line of code) but really it needs the extra width.
http://www.hareslade.com/zc138a_t3/
As you might know, the book add-on is complex, so I won't be too surprised if there are a few minor bugs. Its taken far longer to do than I thought. In the future I would really like some other programmers to come on board, because it takes so long to do upgrades like these to match zencart.
You are welcome to private message me with any complex issues (to save forum space) but simple queries are fine here. I'm now going to catch up with the other things I back-burnered!
Enjoy..
I get this error when I look at the product listings:
Fatal error: Call to undefined function: zen_get_generated_category_path_rev() in [removed]/includes/modules/product_listing.php on line 467
Hi ocy
That function 'zen_get_generated_category_path_rev' is inside zc138a includes\functions\functions_categories.php file
Maybe you're not truly using a full v138a fileset. Get that functions_categories.php file and re-upload it..?
???
Hareslade - that was my error. Thank you!
I like the subtitle in the product listing a lot. Same for the Author and ISBN fields.
Thanks Hareslade! V4 rock!!
Everything going smooth so far.
Though minor problems occur:
1. No where to set product language (cannot find the link to create a new one). Am I miss a handling file?
2. Setting for "Show Book Condition" under the book-type layout has no effect. It shows up on the product info page all the time.
3. "Show Book Type" field cannot be removed from the create-new-product page when it was turned off.
These are the problems I found so far.
Thanks.
Hi 24star
I'll look into the bugs
The book type itself doesn't initiate languages.. its a case of following the 'adding languages' to zencart itself. Did I understand you correctly?
The demo multilanguage site has 3 or 4 languages added in zencart. Once you do that correctly, you get multiple areas in the book collect info pages and extras lists give birth to extra textarea blocks, per language.
btw I've copied the demo's to a new domain, the original hareslade.com might cease soon. Remeber V4 is for 1.3.8a zencart
Books multi V4
http://www.jphuk.co.uk/zc138a_t2/
Single language V4
http://www.jphuk.co.uk/zc138a_t1/
Single language with text input isbn search option, and grid listings fileset added
http://www.jphuk.co.uk/zc138a_t3/
Note there is indeed the Ultimate SEO mods folder in V4, I aready noticed 2 minor link bugs, but the basic mods enable use in 1.3.8a, and give correct links for book products url's. If you fix any bugs in the SEO let me know, its nearly working.
And finally, the links in this thread to my hareslade site can be updated to jphuk site..(see my signature in a bit..) but I'm not transferring all the older zencart versions demo's as it would take ages.
I'm switching to bluehost now, existhost gave me site pain recently.
Thanks for your reply!
For the 'product language' I mean the language field for a book, which indicates the book is written in, say English and/or Chinese. Or maybe I missunderstand the purpose of this field (admin->Catalog->Product Types->Product-Book->Edit Layout->Show Book Language)?
Anyway, I can use a customised field very easily but a default one make it more convenience.
BWT, I did not use any SEO mod as my server is running Windows IIS. I wish I can write one, but my knowledge to PHP coding is quite limited:smartalec:
Hi 24 star
you'll have to forget the 'language' field as such, it was part of a complex moku table system, which he didn't explain his intent about, and so i disabled sections of code which did it..
you found something hiding in there thats not implemented...
Instead I agree, use a custom text field and just type it in per book. Incidentally if the field you use misbehaves, try another one. Let me know though, if one is faulty.
You can even set up a dropdown if you want, using the spare DD things.
But setting it up might not be easy for you. I can't remember exactly the process, without doing it.. the DD dropdown gives the values to select from, which then appear in a book field dropdown for value selection, in the collect info page.
you need to identify/switch on that appropriate field in the book collect info page, from admin books edit layout. The DD values themselves are populated once by you, after selecting the correct DD, in the 'extras' admin menu.
and as for IIS, I got fed up with it, because some of the server variables or functions, don't get set up, whereas they do in Linux.. it used to prevent some softwares running properly in IIS/php.. but presumably if IIS can use htaccess files, Ultimate SEO might run ok. Depends if mod_rewrite or whatever, is operational? The htaccess uses that for SEO.
Hi Hareslade,
Iv done it with a custom field for the "Book Language" using DD2, which provides a similar functionality as the "Subject" and "Author(s)" selection fields. And its not that hard to set it up (I show it here for someone who may need it):
1. Change the definition text to show up from the info page:
..\includes\languages\english\extra_definitions\more_product_book_info.php
(definition for DD2: TEXT_PRODUCT_BOOK_MISC_DD2)
2. Change the definition texts show up under menu admin\extras
..\admin\includes\languages\english\book_dd2.php
3. Change the text appearance in the 'create-new-book' page
..\admin\includes\languages\english\extra_definitions\more_product_book.php
(look up for TEXT_PRODUCTS_BOOK_MISC_DD2 and change the definition)
4. Go to Book-type layout setting and turn on "Show misc_dd2 on product Info"
Done!
You actually reserved so much flexibilities that make customisation so easy. Thanks!
BTW, how can I set a field with a default selected value, e.g. default "Products Quantity"? (Hopely that need not much work, if does then forget about it.)
Upon previous question, Iv got the answer.
Look up the file:
..\admin\includes\modules\product_book\collect_info.php
From the "$parameters = array" list, some values canbe reset.
Authors name is not getting displayed on Product Book Info, but it is getting displayed on the product listing.
I want the authors name to be dispalyed on both product listing and product book infor page.
Please help
Sorry raunharman didn't see your post.. did you fix it.. if not, is it V3 or V4 book?
---------
I've been advised the book admin preview page has a bug, but only when using 'product pricing by attributes'. Here is a preview_info.php update fix zip, should work on V3 or V4 book. I forgot to update it..
http://www.jphuk.co.uk/zc125/downloa..._file_fix1.zip
Anyone please try it.. it runs single or multilanguage, specifically for V138a zencart, do not use it on 1.3.7.
Tried to - all files passworded so couldn't unzip
Hi!
I've installed a Zen-Cart System (Zen Cart v1.3.7.1) to create my book shop: http://libreria.klinamen.org.
Also I've installed the Product Type Book (the last version) but I have a problem. All work correctly except when I try to view the author information:
http://libreria.klinamen.org/index.p...ain_page=index
1054 Unknown column 'book_type_authors' in 'field list'
in:
[select book_type_authors from k_shop_books_to_authors where book_authors_id = 7]
Can anyone help me? Thx!
Bob.. I just p.m'd you.. if anyone else has the 'password' prob, be assured I did **not password the zip file! send me your computer O.S and unzipper type, maybe its specific.
---
ghawar.. btw, for 137 use the book zip for 1.3.7, not the latest 1.3.8 one.
But it errors because there is no field 'book_type_authors' in the book authors table.. I searched in all the files of the books zips in 136, 137 and 138 versions, there apparently is no 'book_type_authors' phrase in the code anywhere. I searched using Dreamweaver, so it should pick up any obvious entry.
If you still have the error, you can p.m me describing what you do, when your error occurs, so I can try to replicate it.
I downloaded this to do a pure install, and am following instructions. the 1_README_for_BOOK_MAIN_FILES_install.txt file tells me to upload the files, yet the folder called 1_BOOK_MAIN_FILES is empty.
am i missing something?
thx in advance...
Never mind - those files are there, but the permissions on them were set so that they were not visible on a desktop, I found 'em through terminal. it's all good.
Hmm... It's a problem :(.Quote:
ghawar.. btw, for 137 use the book zip for 1.3.7, not the latest 1.3.8 one.
But it errors because there is no field 'book_type_authors' in the book authors table.. I searched in all the files of the books zips in 136, 137 and 138 versions, there apparently is no 'book_type_authors' phrase in the code anywhere. I searched using Dreamweaver, so it should pick up any obvious entry.
If you still have the error, you can p.m me describing what you do, when your error occurs, so I can try to replicate it.
If you are viewing a book, for example:
http://libreria.klinamen.org/index.p...roducts_id=561
And your click in Autor:
Autor: Samuel Toledano (http://libreria.klinamen.org/index.p...r=book_authors)
I get the error...
What can I do?
ghawar
Thanks for the site links. I see it's the authors search
Wait for me to check my own sites, I will get back to you in a day or so!
Also please advise, which language packs are you using? These will be listed in the site's zencart language section, in admin.
ghawar
You could try the standard book fileset (unchanged) on a test cart, see if you get the same fault there.
I cannot locate a reason to see 'book_type_authors' anywhere in the operation of the book files (1.3.7).
This phrase is a mixture of 'type' and 'authors', I see you made new defines labels for your site, I suggest you search your own fileset for that phrase 'book_type_authors' in case something got changed in error.
I would expect to find it in /index_filters/book_authors_filter.php, as that's the file responding to authors search clicks.
The sql fault is not one anyone else has had, as far as I know, - and I just can't see anywhere it could creep in.
i have started a new product type, based on the book. i understand how the filtering system is used, but have a quick question about adding a text based search.
I have several fields which are in the product_XXXX_extra table, and I would like to be able to add all of these fields to the search so that I can
1. get results when typing in the general search. i don't want a drop down, I want to type any combination of keywords, and search:
a. the basic product table
b. the product description table
c. the new product_XXX_Extras table and all the fields in it ***
I also want to extend this search capacity to:
2. get results when I do a more advanced search
so i am guessing i need to create an override for the includes/modules/pages/pages/advanced_search_result/header_php.php
any suggestions?
Many thanks to SteveCollins for reporting this problem to me. It is appreciated.
In the book search boxes (Authors and Subjects - Publishers is ok for now) I'm seeing the following problem. If you filter by author or subject then click on 'reset' you get the following message (this one from 'authors'):
Taking the first query and running it via phpMyAdmin returns 27,054,450 rows. Perhaps it's missing a join somewhere, or is my database missing an index or two? :blink:Quote:
2008 MySQL client ran out of memory
in:
[select p.products_id, p.products_type, a.book_authors_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order from swift_products_description pd, swift_products p, swift_book_authors a, swift_book_authors_info ad, swift_books_to_authors bta, swift_product_book_extra pme, swift_products_to_categories p2c left join swift_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pme.products_id = p.products_id and p.products_id = pd.products_id and a.book_authors_id = ad.book_authors_id and a.book_authors_id = bta.book_authors_id and ad.language_id = '1' and pd.language_id = '1']
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from swift_sessions where sesskey = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx']
I'm still running 1.3.7 with an upgrade to 1.3.8a delayed by a hickup during which I finally moved my site to another host.
If this has been addressed already in 1.3.8a I'll let it slide and push the upgrade through faster. If it hasn't been addressed it's likely to become an issue for other users.
gsis
well its faintly exciting seeing the book product explode
but seriously, any experts please have a look at the sql code for the filter.. I did alter the reset recently I think. I'm a bit tied up with other thigs just now but i will check it out later
otherwise just remove reset from the dropdown list, its probably got a value that upsets the filter
elastic
the sql searches are quite code-complicated, the nearest I did was the isbn search section in the multi sidebox, but thats a zencart field in the main database, not in the book tables. You need to learn php, or find a friend that'll do it for you!
hi hareslade, don't take this the wrong way, because it's easy to misread text.
You should not assume i don't know Php, i happen to be good at php programming. I am just trying to get a feel for the specific core files in zen I am going to have to create overrides for.
elastic
I didn't know if you knew php or not.. now I do.. you do.. :)
reminds me of 'now I know kung foo'..
I think I found this bug, the sort routine is missing an if {} statement.Quote:
Originally Posted by 24star
Navigate to the 'templates' directory and edit the following file;
Then search for this line;Code:tpl_product_book_info_display.php
Add an if at the start and replace the ; at the end of the line with an {Code:(($products_book_condition_description != '' and $products_book_condition_description != ' ') ? $show_desc = 1 : $show_desc = 0);
Like so;
Don't forget to close this by adding an } after the last line;Code:if (($products_book_condition_description != '' and $products_book_condition_description != ' ') ? $show_desc = 1 : $show_desc = 0) {
Code:echo '</div>' . "\n";
}
}
?>
The code may or may not need another if to control the output of the
echo '</div>' . "\n";
but the line you refer to is not incorrectly written. It is a "ternary operator" which is an implied if statement that can be embedded inside a line of PHP.
The "?" says to evaluate the code before it, and if true execute the next bit of code until the ":"; if not true, execute the code after the colon.
This would have to be examined in context to know whether a new "if" is required.
My guess is that it is not, because the line as written will do the whole job of showing the description or not, and making the </div> conditional is probably a bad thing.
Hello, I've looked everywhere (forum and the download section) for the current download for the book module can someone point me to the link? Thanks:smile:
Paul Hailey (hareslade) now maintains this excellent product. Go here for the Version 3 download. Don't forget to deownload the patch too.
http://www.jphuk.co.uk/zc/index.php?...roducts_id=482
hello,
I'm getting the following error when applying a the patch for version 1.37.
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 'id'=>'1', 'text'=>'True'), array('id'=>'0', 'text'=>'False')), '
in:
[INSERT INTO product_type_layout (configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, set_function, date_added) VALUES ('Enable the Book Search', 'SEARCH_PRODUCT_BOOK_ENABLED', '1', 'Add the books to the search engine 0= off 1= on', '7', '0', 'zen_cfg_select_drop_down(array(array('id'=>'1', 'text'=>'True'), array('id'=>'0', 'text'=>'False')), ', now());]
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.
Can someone tell me what I need to do to fix this.
inmac:smile:
Hi Paul (Hareslade),
Would it be possible for you to post what tables get created and what new fields get created by your fine mod?
I'm trying to use Easy Populate Advanced to upload a pile of book data and this info would be very handy.
Thanks for a great mod!
Bearaman
inmac, sorry I didn't get notication from the forum innards that you posted,
that section
'INSERT INTO product_type_layout '
is only inserting a switch for book search, in admin | edit layout for books..
In general, you can take out a specific entry from the sql in the patch, the text can be edited with notepad. Since its an upgrade sql, if the config table entry is already in your database, it would give an sql error.
Since the patch might have complete the items 'up to' where its errorred, then you just try applying the remainder of the patch, just after the line it errored at. Just do a zc backup using their add-on, before going too far! In fact, backing up the db before doing any sort of upgrade is essntial..
its essential really, to know about phpmyadmin. in your site control panel, because you can search for an entry e.g 'SEARCH_PRODUCT_BOOK_ENABLED' in the database, which if you find it, means you don't need that bit of the patch!
Haven't got space here obviously to explain it all, but using phpmyadmin is very useful for checking if an sql errored. But don't apply the patches designed for zencart patch page, in phpmyadmin, because the zc patches don't have the table prefix in the sql. The zc add on patches only work inside zencart.
Please add the contrib to the downloads section. Thanks.
bearaman
there are a couple of word docs in folder 5_other_stuff in the book fileset, which roughly tell you the extra fields. Examining the add-on sql will tell you the exact tables created new for book product. there are quite a few...
To be honest, I never continued trying to get an auto-upload system working, the time to design it meant my 200 books could have been put in manually! (which they were..)
One of the problems is, the authors are kept in a specific table, so if you upload a book, you need to add the author to the authors table first, (as you would in admin)... then upload the rest of a books data, .. but you need to know the i.d that the new author got, (or search it) **before** you can link the rest of the new book data to it.
So its not just a case of uploading data.. I think it needs a bespoke php system to do it, which takes the book data in, processes it in the website, doing the separate table updates in a sequence. Thats vastly different from dumping a set of 'ordinary' zencart product data into single table or two.
Anyone want to spend 6 weeks programming php?
But do let us know how you get on with existing methods..
Thanks Kim,
If you say please, I must do it.. will do..
Only thing is, I'm unable currently to give the support it really needs, in terms of coding time..
I did discuss with a few others about wiki, forum, or project creation for book... any suggestions in context of zencart? I don't want to have to admin a project as well!
Hello,
Thank you for working on this product type. We are selling books and this looks like the ideal way for us to present the special info about books on our site (using 1.3.8a).
On to my questions:
First, I rather circuitously found the link by explicitly putting this in my browser:
http://www.jphuk.co.uk/zc125/downloa...LANGS_ISS1.zip
It appears that there is no link to this on the homepage of your site
Next, I could not open this Zip files (using winxp sp2, built in extraction) b/c it asked for a password on some of the files.
Last, it appears that this will not work (or only partially) with EZ populate as I saw in another post. If it does work partially, what fields are used in the standard zc database and what are not? I figure if I only use the standard zc fields then maybe I can still use EZ Pop?
Thanks!
Eli
hi! chinesebks4children
I forgot to do the formal entry in my website for the 1.3.8 book version! I was waiting for all those beta testers to decide if it works ok..
Note I only do the multilanguage version now.. it will run in single language..
Try this page for the add-ons link
http://www.jphuk.co.uk/zc/index.php?...roducts_id=490
Thats issue 2, almost identical to issue 1.
Some people do get password request for opening my zips, maybe its the xp internal unzipper. I used powerzip to zip up. There is always an extra empty file inside of the unzipped file, don't worry about it. There is no password protection.
The EZ populate I reckon would only work on the 'top level' book data, that is, Title, description, ISBN, etc see the link texts. All the rest of book data is in an extra table, and the authors and so on are difficult to upload by EZ-style add-ons.
Advise if the zip still gives trouble. btw I haven't fixed the minor bugs with search sideboxes, thats a todo..
thank you so much for your answers. I will try it tonight, must be about 6am where you are now. (btw I have some family in wales, need to go there someday)
regards...
p.s. link to site is www.chinesebooksforchildren.com/index.php , not quite ready yet but getting there...
Hareslade,
I'm really new to zencart and php so the learning curve for me is pretty steep (I'm a VB.NET developer). Having said that, your work on this book product type has been really helpful with my project.
I'm working with the zencart 1.3.8a and v4 of the book product type.
Everything is hanging together fairly well and I've spent the day today working on getting easypopulate to start adding and deleting correctly (still got most of the extra tables to do!!)
I've just taken a little breather and decided to try and put some authors in manually... but alas I've found that I cannot...
The SQL tables are being updated but the name and nickname fields are just not being populated? I've scanned through this thread but not found anyone else with this problem. Any ideas?
Thanks
Mike
Hi Mike
Sorry you're having probs..
I can have a look at it later on, didn't notice that on V4 issue1, thats still at
http://www.jphuk.co.uk/zc125/downloa...LANGS_ISS1.zip
youcould compare files..
What might have happened is easypopulate use might have altered something?
Try installing the original database that was just after you added the book types sql patch, when you hadn't used easypopulate.. If you haven't got that, try a new install of zencart 1.3.8 separately and start again, and make sure you get backups at various stages.. trying to trace non existent bugs is painful..
I'm not saying its 'not' a bug, just that I didn't notice it with issue 1, issue2 is hardly changed.
If it is the php coding, its quite difficult to trace as the hidden field values are often passed behind pages as arrays, due to the multi-language setup. You can trace them in the view source 'form' html, of some pages.. author and nickname are the simpler ones as you'll only be in the authors tables.. they are separate from the book product, database entries..
Hello Hareslade and Mike,
I am very interested in your discussion regarding ez-populate. We were planning to use that to import all our products (approx. 250) and had been testing it successfully.
Now I have installed the book product type we definitely would like to use that too even if only to change the display from model to ISBN, etc...
However, I've noticed that I can not change the products already setup in zc from Product - General to Product - Book anywhere. That's not too big a deal since there are only a few test items so far.
But my more important question is, I can't see any way that Ez-populate will let me upload a host of books with any setting that indicated that it is Product - Book. There seems to be no field for that in the Ez-populate csv file.
(I realize that is thread is supposed to be about the book product type and not ez-pop or general zc use, so I really appreciate any help)
Thanks!
I managed to change my general products to book products by changing the product_type in the products table from 1 to 7. This is only part of the answer though... as the fields you want to populate for books are stored in the extra tables so you have to fill these in manually.Quote:
Originally Posted by chinesebks4children
Regarding easypopulate, as this product type makes use of extra tables there is a significant amount of work to get the right data into the right tables. As a real beginner to all this stuff I am using this as a self training exercise and progress is really slow.
The two files that need to be amended as far as I can see are the admin/easypopulate.php file to add the data and admin/includes/functions/general.php which contains a function that deletes products 'simply' ensure the extra tables are added to/deleted from correctly with links via the correct ids for each of the tables.
Another important change is to either allow product_type to be uploaded/downloaded or (as I did for now - but not recommended) hard code the product-type in the easypopulate.php to always update product_type 7 (or whatever you are using for books.
So far I have successfully uploaded, downloaded, added and deleted the products table combined with the fields in product_book_extra table and changed the version of easypopulate I have so that it automatically removes the category if no further products exist within it.
If I get a measure of success with this I will post my mods - it may take a while though!!
Mike
Hareslade,
Thanks, I will take a look at files in the link you provided and see if there are any problems...
Mike
Hareslade,
I did the comparison thanks. I am not sure how, but I appeared to have a pre-corrected version of the book_authors.php (at the top of both Issue 1 and 2 there is the word 'corrected' - my version did not have this also:
'book_authors_name' => $book_authors_name[$i],
'book_authors_nickname' => $book_authors_nickname[$i],
in the corrected version is:
'book_authors_name' => $book_authors_name_array[$i],
'book_authors_nickname' => $book_authors_nickname_array[$i],
Making this change has fixed it.
Thanks for your help.
Mike
This may have been covered elsewhere in this thread, but I haven't been able to find the answer so here goes.
I have a fresh copy 1.3.8a, no changes made, installed on my test server. I installed the Book Main Files and sql, followed the directions, etc. When trying to add a new product with a product type Book I am getting an error
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in ***\admin\includes\modules\product_book\collect_info.php on line 1766
Any input would be helpful. Thanks!
Heather
Mike.. yes I remember vaguely now, the arrays were missing for multilanguages author and nickname.. so you are correct..
---------------
hdonald, your server is extra-awake, its reading some poor 'commenting out' structure (which it was intended to ignore) as a php code. Most servers don't do that..
You can remove unused lines 1758 to 1773 in that file,
or just remove 1765-7, i.e this offending bit
Or you could just separate above, the first ? from the < and 'php', and the last ? from the >, so the server doesn't see php start and finish codes.Code:<?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . ' ' .
zen_draw_pull_down_menu_multiple('book_dd1_id' . $i . '[]'', $book_dd1_array[$i], $book_dd1_default_array[$i], 'multiple="multiple"',20)
?>
Quote:
Originally Posted by hareslade
I tried your suggestions, but I am still getting the same error, different line numbers with each one, but still an error. I don't know if I am doing something wrong, I'm not too sure of php, I probably know enough to get myself into real trouble here. :smile:
Hi hdonald
there's more than 1 comment block I saw would need removing..
try this 'comment blocks removed' collect_info file to replace the one in admin\includes\modules\product_book\collect_info.php
http://www.jphuk.co.uk/zc125/downloa...menting_v1.zip
If it still faults please p.m me with line number.. I didn't actually use the file on a site..
Tried it, no luck. I PM'd you. Thanks!
Hareslade,
I've just discovered that I have an error when I try to do a ISBN search...
When I type in a textual ISBN it comes up with:
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 'where book_isbn = 123456654' at line 3
in:
[select special from where book_isbn = 123456654]
I've probably messed up something but not sure where... do you know where this code would be coming from?
btw I've now got Authors and Genres automatically updating from an easypopulate upload. I've still got some work to do to get 'redundant' authors removed when products are deleted, and I am only pupulating the minimum fields to get the authors and genre searches working (so I don't allow for genre description or author url for example) but that would be quite easy to include... if required.
Mike
Hi Mike,
I'll p.m you, the ISBN search is too complex to comment on here!
Mike and Hareslade,
I've mostly got what I want working and I wanted to thank you for your help.
Mike, if you get more of EasyPopulate working I'd like to know about that if you have a moment to pm me...
thanks again!
...so I had an error of duplicate entry many times, but everything seems to be just fine, that's weird... perhaps information on checking your product type book installation would be useful...
anyway I was wondering has easy populate tab delimited file usage to bulk upload book listings been discussed?
I get that the easy populate mandatory "model" attribute is supposed to be used for ISBNs, but what about other book-specific info, something tells me that I should name the columns like the corresponding tables/rows or something in SQL, but perhaps that has already been discussed...
i was wondering if it was possible to have more than one author appear on two different lines.
what i'm hoping to do is this:
many of the books i'll be listing are works in translation. i would like to have the translator's name appear beneath the author's name, & be searchable as well.
or, how would i go about having a 'translator' field function in the same way as the author field?
thanks!
zcusrQuote:
Originally Posted by zcusr
There's more to it than just adding the specific fields. The easypopulate.php needs to be modified also to populate the necessary tables. I have been working on this myself and also deleting using product status 9 but I am a busy guy on my day-job so work on it is a little hit-and-miss.
I've just PM'd you on this topic - check your mail :)Quote:
Originally Posted by chinesebks4children
If you promise not to buy anything... (I have no books for you - but can and will take the money!!) Feel free to visit my book store... it's not too shabby to view now - although I have some way to go before it opens officially - The finished store will have around 500 products - books, cds and dvds
Special thanks to Hareslade :smartalec: for his help
I welcome any constructive comments...
http://www.branchchristianbooks.co.uk/shop/index.php
Thanks,
Mike
I have just installed this Mod. And had a very good search of this thread and others.
Currently the mod shows the ISBN and the author on the product listing page.
Is there any way I can show other fields on the product listing page?
I was hoping to display three or four other fields e.g. format, subject, size.
AND THANK YOU THIS IS A GREAT MOD! :smile:
Hi! I'm new here and am having fun implementing this software for an online bookstore we hope to set up.
I have two questions related to the search facility:
1) How can I make the keyword search search the additional book fields (author, subject, etc.) as well as the title and description? I paid a visit to MikeFarrant's online store and he appears to have got it to include the subject field in the keyword search, though not the author.
2) Where do I go to find the code that generates the ouput from the keyword search? I'd like to add some text to make it more obvious that clicking on the book's image will take the user to further details about the book.