Forums / Setting Up Categories, Products, Attributes / Product Type Book (by moku)

Product Type Book (by moku)

Started by moku on 12 May 2006, 6:37 AM · Views: 203,732

Results 161 to 180 of 647
17 Jan 2007, 5:29 AM
#161
billc108 avatar

billc108

Zen Follower

Join Date:
Apr 2005
Location:
ATX
Posts:
108
Plugin Contributions:
0

Product Type Book (by moku)

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.

Member since 4/05.

30 Jan 2007, 12:34 AM
#162
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

Join Date:
Apr 2005
Posts:
853
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

21 Feb 2007, 5:35 AM
#163
amopro avatar

amopro

New Zenner

Join Date:
Jan 2007
Posts:
35
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

2 Mar 2007, 5:11 AM
#164
billc108 avatar

billc108

Zen Follower

Join Date:
Apr 2005
Location:
ATX
Posts:
108
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

Member since 4/05.

2 Mar 2007, 5:45 AM
#165
moku avatar

moku

New Zenner

Join Date:
Mar 2006
Location:
Japan
Posts:
49
Plugin Contributions:
0

Re: Product Type Book (by moku)

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/showthread.php?t=35389&page=15#145
So if you want to enhance/update/fix this contribution, you can!

2 Mar 2007, 7:25 PM
#166
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

Join Date:
Apr 2005
Posts:
853
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

6 Mar 2007, 12:19 AM
#167
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

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/test_zips/book_authors_filter_136_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.

6 Mar 2007, 1:21 PM
#168
biscayne avatar

biscayne

New Zenner

Join Date:
Oct 2006
Location:
the Netherlands
Posts:
32
Plugin Contributions:
0

Re: Product Type Book (by moku)

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.

7 Mar 2007, 11:37 PM
#169
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

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.php?main_page=document_general_info&cPath=50&products_id=480

do test it out, see what happens..

8 Mar 2007, 9:57 AM
#170
biscayne avatar

biscayne

New Zenner

Join Date:
Oct 2006
Location:
the Netherlands
Posts:
32
Plugin Contributions:
0

Re: Product Type Book (by moku)

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.

9 Mar 2007, 3:46 PM
#171
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

9 Mar 2007, 5:18 PM
#172
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Re: Product Type Book (by moku)

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.

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

14 Mar 2007, 6:50 PM
#173
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

16 Mar 2007, 4:05 PM
#174
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Re: Product Type Book (by moku)

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.

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

16 Mar 2007, 7:04 PM
#175
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

20 Mar 2007, 3:08 PM
#176
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

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.php?main_page=document_general_info&cPath=51&products_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?

20 Mar 2007, 11:42 PM
#177
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

...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.php?main_page=product_book_info&cPath=3&products_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.php?main_page=document_general_info&cPath=51&products_id=483

It probably also works on moku's original version, as it only replaces the metatags.php file and metatags.php defines.

21 Mar 2007, 1:40 PM
#178
biscayne avatar

biscayne

New Zenner

Join Date:
Oct 2006
Location:
the Netherlands
Posts:
32
Plugin Contributions:
0

Re: Product Type Book (by moku)

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.

21 Mar 2007, 2:24 PM
#179
hareslade avatar

hareslade

Totally Zenned

Join Date:
Nov 2004
Location:
U.K. South Wales
Posts:
442
Plugin Contributions:
0

Re: Product Type Book (by moku)

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

27 Mar 2007, 4:32 PM
#180
colosimo avatar

colosimo

New Zenner

Join Date:
Mar 2007
Posts:
7
Plugin Contributions:
0

Re: Product Type Book (by moku)

biscayne:

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