Product Type Book (by moku)

Quote:

---

Originally Posted by ctcentralinfo

I get this error message when I click on author:

[select from where manufacturers_id = 2]

... how can I fix this?

---

The form of a select statement in SQL is typically

select from (table name)
where manufacturers_id = 2

or possibly

select from *
where manufacturers_id = 2

where the "*" is a wildcard.
It appears that you're not stating where you're selecting FROM.

Hope that helps. I've only just started looking into the product book type for possible rebuild of an online bookstore, so I'm not at all familiar with the files.

So has their been an a fix for the authors link for this mod yet?

I don't know why? Maku can you help me?
There are no products to list in this category.

amopro wrote:

"I don't know why? Maku can you help me?
There are no products to list in this category."

Moku (not "Maku") hasn't been around this forum in many months.

Perhaps if you were a bit more specific with your question, someone could help. For instance, what have you done, and what is it doing or not doing? The more specific you can get, the easier it'll be for someone to help you. Nobody here is clairvoiant yet (at least, not to my knowledge).

Hi,
After heavy reflexion, I launch benippon.com, direct export from Japan, featured by OsCommerce, not ZC. That's why I don't update this ZC contribution anymore. But I left my files accessibles, as I explained on this post: http://www.zen-cart.com/forum/showth...89&page=15#145
So if you want to enhance/update/fix this contribution, you can!

That's messed up man especially after I got this mod to work. Good luck though.

Hi
The issue of why books with no 'manufacturer' (publisher) entry do not appear in an authors search is hopefully solved by this modified filter,

http://hareslade.com/zc125/downloads...36_137beta.zip

Replace the existing authors file, 'book_authors_filter.php' in your existing 136 (moku, or my version) installation, and for any 137's, in index_filters folder.

You should find the 'alpha filter' dropdown (A to Z) also now works, and the category dropdown correctly appears if an author search has obtained books from more than one category.

Let me know by private message, of any probs, its up and working today, it might need further adjustments as there are 6 sets of sql's inside, not just one.

In the mean time I'll look at the 2 other book search sideboxes, see if they need similar correction.

For tecchies: I removed all references to the manufacturers table, in the sql in the above file. The up side is that books with 'no publisher entry' now appear in an authors search. The minor downside is that I had to prevent this filter being asked for the manufacturers name, since its now not called. But the worst that happens is a blank space where manufacturer name should be, only if you have the manufacturer column present on the product listings.

btw when i've sorted the search filters, after a bit more testing I'll have the 137 book moku-jph version, to update the 136 one thats on my website at harelade.com.

Hareslade,Are you working on an update to advanced search as well ?
I'm looking for advanced search on Book Title, Author, Publisher and ISBN,
not a dropdown menu but by entering a search string.
This should be advanced search in Amazon.com style.

Hi biscayne,
I don't use advanced search so maybe someone else can battle with it?

One can search book titles by main searchbox, the only one you're missing in moku-style sideboxes is the isbn.. but that comes up also with a main searchbox search, because its really 'model'..

maybe an advanced search can search for model?

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

I have improved the original moku 'authors' search filter mentioned a day or so back, and added the other 2 filters, so there is now a replacement set for the index filters that moku originally supplied.

More info, and zip download with the 3 index filters, at:
http://www.hareslade.com/zc/index.ph...roducts_id=480

do test it out, see what happens..

Hi Hareslade,
Thanks for your reply and for the new filters.
Since nobody else seems to have come up with
a specific advanced search for a book store
(search with a given string in either book title or
author name of publisher name or ISBN) I started
writing it myself.
Thanks again.