Product Type Book (by moku)

[Darkwander]

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

[hareslade]

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.

[tekram]

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)

[Darkwander]

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

[audiobookdealer]

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.

[Darkwander]

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.

[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:

#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

[Darkwander]

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.

[jbuchli]

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

[Darkwander]

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.