Product Type Book (by moku)

[jbuchli]

Sorry, I'm not really proficient with this whole thing: which table/mysql?

Thanks again!

[mlindi]

Sorry, I'm not really proficient with this whole thing: which table/mysql?

Thanks again!

In the admin panel:

tools>developer tool kit

do a search of all files for
DEFAULT_PRODUCT_BOOK_PRODUCTS_IS_ALWAYS_FREE_SHIPPING

It will report:

/path/to/zencart/admin/includes/modules/product_book/collect_info.php

Line #29 : 'product_is_always_free_shipping' => DEFAULT_PRODUCT_BOOK_PRODUCTS_IS_ALWAYS_FREE_SHIPPING,

Line #267 : if (!isset($pInfo->product_is_always_free_shipping)) $pInfo->product_is_always_free_shipping = DEFAULT_PRODUCT_BOOK_PRODUCTS_IS_ALWAYS_FREE_SHIPPING;

Hope that helps

[jbuchli]

Yep, that's correct. But what do I actually do about it?

Is it supposed to be there only once? If so, which one do I remove?

Or do I have to change something in the sql patch code?

Thanks,

Jeroen

[mlindi]

Yep, that's correct. But what do I actually do about it?

Is it supposed to be there only once? If so, which one do I remove?

Or do I have to change something in the sql patch code?

Thanks,

Jeroen

Ahh - I think I understand what's going on here. Methinks you forgot to DROP the get_terms_to_filter table before adding it.

try this:

-- 
-- Table structure for table `zc_get_terms_to_filter`
-- 

DROP TABLE IF EXISTS `zc_get_terms_to_filter`;
CREATE TABLE `zc_get_terms_to_filter` (
  `get_term_name` varchar(255) NOT NULL default '',
  `get_term_table` varchar(64) NOT NULL default '',
  `get_term_name_field` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`get_term_name`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `zc_get_terms_to_filter`
-- 

INSERT INTO `zc_get_terms_to_filter` VALUES ('manufacturers_id', 'TABLE_MANUFACTURERS', 'manufacturers_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('music_genre_id', 'TABLE_MUSIC_GENRE', 'music_genre_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('record_company_id', 'TABLE_RECORD_COMPANY', 'record_company_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('book_genre_id', 'TABLE_BOOK_GENRE_DESCRIPTION', 'book_genre_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('book_type_id', 'TABLE_BOOK_TYPE_DESCRIPTION', 'book_type_name');
INSERT INTO `zc_get_terms_to_filter` VALUES ('book_authors_id', 'TABLE_BOOK_AUTHORS', 'book_authors_name');

-- --------------------------------------------------------

(don' t forget to replace the 'zc_' with your actual prefix)

HTH

[mlindi]

Oh - and ...

I have noticed that the search function is broken in older MySQL versions, and it is related to this book module. I have identical setups on 4.0.27 and 4.1.21 respectively. Search is broken in 4.0.27 (and I'm not bothering to fix it, I'm just going to upgrade 4.0.27 to 4.1.21)

[mlindi]

Has anyone gotten either of the EZPopulate versions to work properly with this little beastie?

[lbrown]

Where can I find the most recent version of Product Type Book (by Moku)? I am running Zen Cart 1.3.5

Thank you,

lbrown

[mlindi]

Where can I find the most recent version of Product Type Book (by Moku)? I am running Zen Cart 1.3.5

Thank you,

lbrown

The link to download is in the very first post in this thread. You'll want the files dated May 12.

Keep in mind - EZPopulate does not work with this module.

[starslab]

Is the Metadata page supposed to do anything?

I've got a fresh 1.3.5 install, with product-books 1.2 installed as per the installation instructions.

I'm going to be mangling the product_type for use with DVDs (I'm going to change all text reading "pages" to read "runtime" instead, for instance, but this is in the future.

I've created a product of type product_book, and when I click to edit the metadata for that product, i just get a blank page.


I also seem to have aquired a third "Free Shipping" option, TEXT_PRODUCT_SPECIAL_ALWAYS_FREE_SHIPPING

Btw, THANK YOU moku for this awesome contribution.

[starslab]

UPDATE,

The other search methods aren't working either. I click an author's name and rather than information about that author or links to other "books" with that author, I end up at a screen that says "There are no products to list in this category".

Anyone have any idea where I screwed up?

The only thing that comes to mind is my admin/languages.php seems to be a newer one than the documention refers to. So my big patch into it was about 50 lines off from where it should have been. (Documentation says patch begins at line 175, after "create additonal coupons_description records" block. My patch began at Line 210, after a large block of coupon stuffs).

I swear, sometimes it feels like this is happening to me when I do web-development stuff......