Product Type Book (by moku)

I am trying to install the Extended Product Type Book mod on a fresh 1.3.7 installation running MySQL ver. 5.0.27. I've encountered a couple of sql errors that I've been able to resolve, thanks to this thread, but I don't know what to do with this one:

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')), ', now())' at line 1
in:
[INSERT INTO febproduct_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());]

Any help would be appreciated.

Thanks

Well, I solved the previous problem by pasting the sql into the box rather than loading the whole file.

Now things seem to be working until I try to insert a new product. When I click 'preview', all I get is the title. No other info and no 'insert/cancel' buttons.

Any ideas? Thanks.

I was able to fix the problem in the previous post by removing the UK pricing section from preview_info.php.

I have changed all book => music_single and author => artist. The tables and fields are renamed and everything appears to me as it should be until I get the the product_info page in the cart. I'm getting this SQL error:

1146 Table 'feb_mods.TABLE_MUSIC_SINGLE_ARTISTS' doesn't exist
in:
[select a.music_single_artists_name from TABLE_MUSIC_SINGLE_ARTISTS a, TABLE_MUSIC_SINGLE_ARTISTS_INFO ad, TABLE_MUSIC_SINGLE_TO_ARTISTS b where b.products_id = '181' and b.music_single_artists_id = a.music_single_artists_id and a.music_single_artists_id = ad.music_single_artists_id and ad.language_id = '1' order by music_single_artists_name]

The table is there and contains artist info. I was able to add the artist to the product in admin without any trouble. I've searched until I'm cross-eyed and can't find where this error is coming from.

Anybody have any idea where I could look? :unsure: Thanks

An update on the last post:

I've now turned on the Artists (Authors) sidebox and in place of the box, it shows the error mentioned above.

Problem solved. I found one that the authors table name definition had not been changed to artists. Sorry for all the posts.

Hi
Here's my extended book product type version V2, specifically for zencart 1.3.7, some bugs removed compared to the beta 136 version. Hopefully no new bugs created.. copy/paste the sql patch, it seems more reliable.

Moku might have gone away..but I saw him looking the other day :)

Info/download at:
http://www.hareslade.com/zc/index.ph...roducts_id=482

(hareslade.com/zc/index.php?main_page=document_general_info&cPath=51&products_id=482)

It incorprates the 3 improved book search filters, and category / alpha search operations. I added the off-site webpage url option (as on other product types) to the book info template.

If you're running a beta 136 extended version, compare the new fileset and use anything that looks better, remembering there are now some 137 zc files used in this V2 fileset.

I don't have mysql 5 to test on, so any specific probs on that maybe you could p.m me.

biscayne? let me know if you succeed in advanced search mods?

...and
I share a tentative accessory for the above 137 extended book version, that selects some keywords from a list you provide, and also adds another set of constant keywords you also provide.

This works on books only, (and only where no existing keywords are present for a book) and gets rid of those zc standard keywords - which usually don't relate to books very accurately.

Currently mystery books in my site (higher in the listing) are activating this add on, as I did not do keywords yet for them. Check out the change-ing html metatag keywords content on
http://www.hareslade.com/zc/index.ph...roducts_id=215

A side effect is that crawlers will get 'flavour of the day' keywords which might interest them more than the constant default zencart list.

download/info at:
http://www.hareslade.com/zc/index.ph...roducts_id=483

It probably also works on moku's original version, as it only replaces the metatags.php file and metatags.php defines.

Our book search is finished. But during testing we get an error on advanced search results.
It's something in the original "from" statement that gives the following 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 'FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufact' at line 1
in:
[ 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 ) 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 = 2, 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 = 2 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 = 2 ) ) limit 0, 9]


The statement was not modified, just added a condition to check if new book search called the function or the standard.

Hi biscayne
sql a pain, isn't it, I'll pm you in a minute

Quote:

---

Originally Posted by biscayne

Our book search is finished.

---

I'm working too on this product type (Hareslade version), it seems really what I was searching for. So thanks Hareslade! =)
For now I've got no problems on getting it working but a lot of problems on making Zen Cart do what i want...
Maybe because I'm not a programmer.

My request is for biscayne.
Can you share your advanced search modification?
I'd really like to use it.
Thanks in advance,
Colosimo