Product Type Book (by moku)

[hrm]

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

[hrm]

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.

[hrm]

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? Thanks

[hrm]

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.

[hrm]

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

[hareslade]

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?

[hareslade]

...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.

[biscayne]

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.

[hareslade]

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

[colosimo]

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