Product Type Book (by moku)

Has anyone had any luck with the Side boxes for Authors working with their site ?, it is showing the list of Authors, however when you click on one, it isnt finding the results for that Author...

tekram .. the sql in the original moku sql patch in the fileset, is missing those extra table/field values, so your database will be missing them too.. I had to work out what extra was required in the sql, by comparing with the product music entries.....

darkwander my authors search works ok,
this is an example partial url of the requested page when I click on a sidebox author,
you can check if its doing a similar querystring layout

... /index.php?book_authors_id=7&typefilter=book_authors&main_page=index

If thats ok, then the filter file in /includes/index_filters/book_authors_filter.php is not working for some reason..

Also for something else, moku says about mods...

'one file have to be override to make this contribution possible.

It's the module file "product_listing.php":
includes/modules/my_template/product_listing.php
Wich overrides this core-file:
includes/modules/product_listing.php

If you want to modify your own file, just add a new Observer/Notifier around
line 123: (use a diff tool to see this single difference between both files)
$zco_notifier->notify('MY_NOTIFY_GOT_PRODUCT_LIST_NAME')'

I think the sample product_listing.php file moku supplies (now) has two minor problems, firstly there appears to be a code block repetion under the notifier line

secondly, the file he supplies is a 1.3.0/2 one, so for 1.3.5 get the actual includes/modules/product_listing.php file and insert the notifier line in that 1.3.5 one, as the code elsewhere in the file I thought had changed slightly from 1.3.2

Whether you re-insert product_listing.php say in
includes/modules/classic/ (if you use the classic template)
or
includes/modules/ to replace the actual one,
is up to you.

'my_template' is just the generic folder name, you need to rename that 'my_template' folder in the moku fileset with your current template name, or remember to copy it into the correct folder later.

Similarly the moku css file for the book template is in a my_template folder.

harlesdale,
are you saying that entries for only hd one value too not just the opnes related to moku's book type. that is my table consisted of single vaslues for each entry even ones not from moku like manufacturers_id, music_genre_id, and record_company_id. (that is my table did not have get_term_table and get_term_name_field to begin with)

hareslade:

darkwander my authors search works ok,
this is an example partial url of the requested page when I click on a sidebox author,
you can check if its doing a similar querystring layout

... /index.php?book_authors_id=7&typefilter=book_authors&main_page=index

> If thats ok, then the filter file in /includes/index_filters/book_authors_filter.php is not working for some reason..

The weburl that i bring up when it tries to do a search is the following;

... /index.php?book_authors_id=1&typefilter=book_authors&main_page=index

Darkwander, I had this same problem. The book_author_filter code generates a SQL select statement that seems to require a match on manufacturer_id with the products table. Once I entered a manufacturer for all of my products everything worked fine. Hope that helps.

Kool, that worked well, however now i have to change 546 products to a Publisher of DVDs.

Also i little site note for anyone that wants to know, you can turn off the "Show Publisher" and it won't show the publisher under product types.

Finally, I've gotten round to upgrading my to version 1.3.5 and that seems to work fine.

Then I tried to install the new Book contrib, but it seems something is going wrong. Running the sql-script in phpMyAdmin results in this error:

#1062 - Duplicate entry 'DEFAULT_PRODUCT_BOOK_PRODUCTS_IS_ALWAYS_FREE_SHIPPING' for key 2

I've tried to experiment with changing product_type_id, but the error keeps coming up. Now, when I go to a product in the ZenCart admin, it says:

The requested URL /admin/pubs_product_book.php was not found on this server.

Any ideas?

Thanks!

Jeroen

jbuchli:

Finally, I've gotten round to upgrading my to version 1.3.5 and that seems to work fine.

Then I tried to install the new Book contrib, but it seems something is going wrong. Running the sql-script in phpMyAdmin results in this error:

I've tried to experiment with changing product_type_id, but the error keeps coming up. Now, when I go to a product in the ZenCart admin, it says:

Any ideas?

Thanks!

Jeroen

Did you install a new version or run the Update.

Darkwander:

Did you install a new version or run the Update.

Well, I'd used ZenCart before and made a bit of a mess of my files, so I actually reinstalled the software, but only upgraded the database.

Jeroen

I think you would find that in your MYSQL you would have the option

'DEFAULT_PRODUCT_BOOK_PRODUCTS_IS_ALWAYS_FREE_SHIP PING'

in the one table twice, most likely left over from the previous version.

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

Thanks again!

jbuchli:

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

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

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

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

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)

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

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

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

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.

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.

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