Product Type Book (by moku)

[hrm]

I am using an adapted version of the V2 Book Type and am having trouble with the way the Author (in my case Artist) line displays when a product has more than one Author.

Here are two of my products for an example:

A single artist (this is how it should be)
Multiple artists (the attributes/add to cart box drops down the page)

If someone could take a look at it and at least help me figure out where to look for the cause, I'd really appreciate it. I'm not great at php and can't figure out if the problem is in the product_display template or CSS.

Thanks so much.

[gxjenkins]

For raunharman and anyone else who gets an sql error message using zencart main search box with either moku or my extended versions, go to the download page and locate update fix labelled may 2007, it may fix the problem.

Otherwise temporarily switch off 'search in books' in admin | ...product types ..book type... edit layout

Its the file in the fix, that addes extra sql to the end of the search sql made by the rest of zencart. There were some 'missing' local prefixes to some of the book tables field names, its commented in the fix file. Not all setups seem to need it though.

http://www.hareslade.com/zc/index.php?main_page=document_general_info&cPath=51&products_id=482

I'm using "BETA1_ML_ZC1_3_7_EXTENDED_BOOK_TYPE_V_3_LANGS". I installed this long ago, but didn't realize the search was giving this error. I've turned off the search in the Book Product Type, but I'd like to make sure Books are going to be found during a customers search.
Is there a fix for this? I'm using cart 1.3.7, single lang, and it's my Thrift Shop if you want to take a look.
Thanks.

[hareslade]

hrm... apologies I've been away...
Both the links you give above now point to product music items not product book, are the links out of date? The book template is normally 'product_book_info' in the querystring, yours says product_music_info i think

The template used by each product type is different..

The css entries that defines that page layout sometimes needs to be adjusted. But of course there could indeed also be a css prob, or a particular browser that gives trouble.

In the book contrib, the css file 'stylesheet_book_prod.css' must be copied into the current template, if it's not 'classic' being used.

Let me know hrm, if you still have a book authors demo to look at

[hareslade]

gxjenkins
Well not all installs give the 'zencart standard search box' search error anyway..

If you can switch on your search temporarily and copy the sql error text, (if its giving trouble), but do send it to me by private message, otherwise it makes the posts here looooooong..

I could then check it out.. V3 books should have had the sql correction transferred from the older V2

[gxjenkins]

Switching on Book Search I get this error:
"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 'SELECT DISTINCT
in:
[select count(distinct p.products_id) as total FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ) , zen_products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND ( p.products_id IN ( SELECT DISTINCT p.products_id FROM (zen_products p LEFT JOIN zen_manufacturers m USING(manufacturers_id), zen_products_description pd, zen_categories c, zen_products_to_categories p2c ) LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%sheldon%' OR p.products_model LIKE '%sheldon%' OR m.manufacturers_name LIKE '%sheldon%' OR (mtpd.metatags_keywords LIKE '%sheldon%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%sheldon%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%sheldon%') and (pd.products_name LIKE '%cheney%' OR p.products_model LIKE '%cheney%' OR m.manufacturers_name LIKE '%cheney%' OR (mtpd.metatags_keywords LIKE '%cheney%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%cheney%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%cheney%') )) ) OR p.products_id IN ( SELECT DISTINCT p.products_id FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id = p2c.products_id AND mtpd.language_id = 1, zen_product_book_extra pbe, zen_books_to_authors bta, zen_book_authors ba, zen_book_authors_info bai WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND pbe.products_id = p.products_id AND bta.products_id = p.products_id AND bta.book_authors_id = ba.book_authors_id AND ba.book_authors_id = bai.book_authors_id AND bai.language_id = 1 AND ((pd.products_name LIKE '%sheldon%' OR p.products_model LIKE '%sheldon%' OR m.manufacturers_name LIKE '%sheldon%' OR pd.products_description LIKE '%sheldon%'OR book_authors_name LIKE '%sheldon%'OR book_authors_nickname LIKE '%sheldon%'OR subtitle LIKE '%sheldon%') and (pd.products_name LIKE '%cheney%' OR p.products_model LIKE '%cheney%' OR m.manufacturers_name LIKE '%cheney%' OR pd.products_description LIKE '%cheney%'OR book_authors_name LIKE '%cheney%'OR book_authors_nickname LIKE '%cheney%'OR subtitle LIKE '%cheney%') ) ) OR p.products_id IN ( SELECT DISTINCT p.products_id FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id = p2c.products_id AND mtpd.language_id = 1, zen_books_to_genres btg, zen_book_genre bg, zen_book_genre_description bgd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND btg.products_id = p.products_id AND btg.book_genre_id = bg.book_genre_id AND bg.book_genre_id = bgd.book_genre_id AND bgd.language_id = 1 AND ((pd.products_name LIKE '%sheldon%' OR p.products_model LIKE '%sheldon%' OR m.manufacturers_name LIKE '%sheldon%' OR pd.products_description LIKE '%sheldon%' OR book_genre_name LIKE '%sheldon%') and (pd.products_name LIKE '%cheney%' OR p.products_model LIKE '%cheney%' OR m.manufacturers_name LIKE '%cheney%' OR pd.products_description LIKE '%cheney%' OR book_genre_name LIKE '%cheney%') ) ) OR p.products_id IN ( SELECT DISTINCT p.products_id FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id = p2c.products_id AND mtpd.language_id = 1, zen_books_to_types btt, zen_book_type bt, zen_book_type_description btd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND btt.products_id = p.products_id AND btt.book_type_id = bt.book_type_id AND bt.book_type_id = btd.book_type_id AND btd.language_id = 1 AND ((pd.products_name LIKE '%sheldon%' OR p.products_model LIKE '%sheldon%' OR m.manufacturers_name LIKE '%sheldon%' OR pd.products_description LIKE '%sheldon%' OR book_type_name LIKE '%sheldon%') and (pd.products_name LIKE '%cheney%' OR p.products_model LIKE '%cheney%' OR m.manufacturers_name LIKE '%cheney%' OR pd.products_description LIKE '%cheney%' OR book_type_name LIKE '%cheney%') ) ) ) ]"

After turning off the Book Search I can find books by searching for words in the title. That will be O.K. if I have to leave it that way.
I'd like to be able to search on Author, and the other search items. I feel like I've got a piece of this version, and a piece of that version. I installed this awhile ago, and then left it to work on another store, so I'm not sure if I left something out, or what.

Is there one install that brings everything up to the same version including any patches?

[hareslade]

hi gxjenkins

The V3 beta does indeed include my fix for the search box.. but your sql shows there's still a bug... this part of code (excuses!) is moku's original design, so I need to look at it with intensity to see what it's supposed to do

There is obviously a small fault in the code (in the 'if' section on line 32 onwards in file class.productBookSearch.php..) where an 'AND' gets added into the construction of the query.

I will pm you now, asking for some more easy to get info.

Incidentally, to 'private message' someone just click on the user's name in top left of the post, it should give the option to p.m that person. Myself I prefer not to see the longer sql's in the thread, because unless one is a sql genius (which I'm not) reading sql is not fun..

[jazeem]

The calender control next to the 'Date Available:' field on the add new book screen is not working for me. On the bottom of the browser it 'shows error on page'. Attaching the error message screen shot. But I am able to manually key in the date. Is it a known issue?

[hareslade]

The calender control next to the 'Date Available:' field on the add new book screen is not working for me. ... Is it a known issue?

Hi Jazeem
It is now! I'll look into it

[hareslade]

Hi Jazeem
I racked my brains looking as to why the spiffy calendar fails on the book collect info page 'available date', but I could not see what's different from the standard product collect info page (which works ok).

I put a temporary very minor fix in the javascript file that creates the calendar, (around line 72, marked jph), the modified file (zipped) is at
http://www.hareslade.com/zc125/downl..._1_jscript.zip

Upload to replace /admin/includes/javascript/spiffyCal/spiffyCal_v2_1.js

The original already there is the standard zencart file.

(If anyone wants to try locate the real prob, let us know. Using firefox enables you to look at the exact javascipt fault, using javascript console in 'tools'.

The fix I did does not seem to affect the calendar anyway, the 'inhibited' part says it just locks the 'get calendar' button down when a calendar is showing.. but it seems to do that, even with the fix!)

[berrybatens]

Hi, first of all congratulations with this fabulous multilanguage product type book!
I made a V3 Beta 2 installation and everything works fine.
My question: There is one ISBN field. I need one ISBN10, one ISBN13 and a NUR field. All needed fields are similar to the ISBN field. How can I add these fields to my ZenCart?