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 141 to 160 of 647
22 Nov 2006, 10:32 AM
#141
teva avatar

teva

Zen Follower

Join Date:
Sep 2004
Posts:
101
Plugin Contributions:
0

Product Type Book (by moku)

Adding manufacturer helped my problem also. I was also using sefu and it seems that it doesn't work with product type book. Any idea if this can be fixed?

Can anyone please tell me where can i change CSS for book genres sidebox? I want to remove borders and increase fonts and color.
And if it is possible to change break word in dropdown menu. It cuts most of the words now, even thou there is enough space.

tnx

24 Nov 2006, 3:26 PM
#142
dcschan avatar

dcschan

New Zenner

Join Date:
Nov 2006
Posts:
26
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi,

I just added this plugin, works great!

Is there any way I can change the "Genre" or "Type" option to something else, since I don't use it but need a pull down menu kind of option that can be sorted for "book awards"?

Thanks!

25 Nov 2006, 11:21 AM
#143
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
Moku is probably still busy earning a living, he said way back he'd be back in November sometime..

Here is an extended BETA version of the moku book product for zc 136, I liked his layout so much I gave up on the old style book type files from way back, and created loads of extra fields so people can use them or not, they are settable in the book type admin. Moku knows I'm playing around..

You will have a choice of having 'grid' product listing, or row (standard), grid is obtained by setting a category to 'all book type' in admin. Its assumed you have all books in that category of course.

I will answer the obvoius questions now,

  1. No I don't know yet how to make this overlay an existing ordinary moku book installation - but someone could take the sql I've provided (which creates all tables) and modify it to an 'update sql only' to populate the existing tables with extra fields - but there are new tables too.

Use this beta version on a (non-moku book) test cart so you see what changes I made.

  1. Yes it does appear to work ok, let me know by P.M if any probs, as otherwise this thread will get confusing.

3)Yes I used the moku files as a base, I added extra database fields throughout but only changed coding where necessary.

Most of the moku files remain intact but product_listing.php gets a facelift, because it is the Dr.Byte 'grid' version modified further by me.

4)Yes there is some documentation in the pack

5)It's working at hareslade.com in a slightly previous version with my books, I will upgrade mine there soon.

Temporary 'extended book type' download at
http://www.hareslade.com/zc125/downloads/test_zips/BETA_ZC1_3_6_EXTENDED_MOKU_BOOK_TYPE_JPH_V_1.zip

AND just for good measure, I created a BETA new 'picture gallery' product type, a clone of the book type, which can use Image Handler 2 to create the large main gallery picture images.

This one's intended to look like singapore gallery, but the gallery product type is 'similar to' other zencart products, not the inserted 'cuckoo' that my singapore add on is. It seems ok to have both book and gallery types installed.

I will start a thread on this gallery product type later, in the meantime p.m me, don't post here, with any probs PLEASE. You'll enjoy playing with this one..

Temporary download of 'gallery product type' at
http://www.hareslade.com/zc125/downloads/test_zips/BETA_ZC1_3_6_GALLERY_JPH_V2.zip
And of course, anything can happen with these new ideas, so don't risk your live site with them just now, and gallery needs a bit of testing.

This gallery product I'm not using publicly just yet, and would appreciate feedback on whether people can successfully get the slightly modified IH2 version I supply in the zip, to work ok with gallery type.

Just to wet your appetite, the IH2 version I came up with works with an 'off web' cache folder, a minor downside is that zoom facility is affected. Its explained in the zip docs.

30 Nov 2006, 10:46 PM
#144
yacatl avatar

yacatl

New Zenner

Join Date:
Nov 2006
Posts:
4
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hey dudes, I really need help.

I followed these steps:

  1. 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
  2. Four files have to be copied from core-files, even if they are unmodified. It's this three files: includes/modules/pages/product_book_info/header_php.php includes/modules/pages/product_book_info/jscript_main.php includes/modules/pages/product_book_info/jscript_textarea_counter.js Wich are copies of sames files in: includes/modules/pages/product_info/ And the stylesheet for custom template ("my_template") wich also have to be copied from template_default's one: includes/templates/my_template/css/stylesheet_books.css Wich is copied from: includes/templates/template_default/css/stylesheet_books.css
  3. Made copy and paste of the code in add_to_mysql
  4. Drop the rest of files in zencart tree.

Then I Logged into the admin area and I had the book product type, but when I try to Create a ver new book element, the system say to me.

1146 Table 'libreria.TABLE_BOOK_AUTHORS' doesn't exist
in:
[select a.book_authors_id, book_authors_name, book_authors_nickname from TABLE_BOOK_AUTHORS a, TABLE_BOOK_AUTHORS_INFO b where a.book_authors_id = b.book_authors_id and b.language_id = '2' order by book_authors_name]

¿Where and when these constants were created and how can I modify them?

My tables are book_authors and book_authors_info

Also when I go to the extra menu, no book extra exists.

Thanks in advance

5 Dec 2006, 4:07 AM
#145
moku avatar

moku

New Zenner

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

Re: Product Type Book (by moku)

Hi all,

First of all, sorry. Double sorry.
For two reasons: for not being here for a so long time and, unfortunately, for not being able to work on this anymore.

Hareslade, thanks for using my files as a base for making it better.

Before leaving, I uploaded all my last files, not released yet. It contains an interresting "Products Persons" contribution (just like the "Products Languages") wich could be very useful, not only for books but for any kind of products, if it was finished by someone.

Here are the three contributions I worked on, in the last state I leave them in June 2006: (understand that it's only for developers, as it's much more raw files, not releases!)

Product Book
Products Languages
Products Persons

I hope Hareslade you will find this files useful for your own contribution. Sorry for not being able to work on it any more.

Good luck! :)

7 Dec 2006, 5:14 AM
#146
joking avatar

joking

New Zenner

Join Date:
Sep 2006
Posts:
3
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi Moku,

What a shame you can't continue. Your effort has been greatly appreciated.

John

7 Dec 2006, 5:16 AM
#147
joking avatar

joking

New Zenner

Join Date:
Sep 2006
Posts:
3
Plugin Contributions:
0

Re: Product Type Book (by moku)

To my knowledge I'm running the latest versions of PHP and MySQL (Version 5.0.17) on my test machine with a program called "Uniform Server". ZenCart works perfectly out of the box, but when I installed Hareslade's Product Type Book, I ran into trouble when trying to update the databases. MySQL kept coming up with an error whenever I tried to install the patch: ADMIN_PATCH_SQL_EXTENDED_BOOK_TYPE.txt. Around line 552, Hareslade uses a KEY called "condition". For some reason my version of MySQL refuses to accept this key and I can only assume that it's a MySQL reserved word. Maybe older versions of MySQL aren't effected, but my version certainly is.

To get Hareslade's Extended Book Type working I simply made the changes below:

Open ADMIN_PATCH_SQL_EXTENDED_BOOK_TYPE.txt. and go to lines 549 to 553. Alternatively, do a search for (book_condition_id) until you see the lines
shown below.

#=================
PRIMARY KEY (products_id),
KEY color (book_color_id),
KEY condition (book_condition_id),
#=================

Change

KEY condition (book_condition_id),

To read

KEY cond (book_condition_id),

MySQL should now accept the altered patch. Unfortunately the "Condition" dropdown won't work properly in the Admin section, but everything else will. If you like Hareslade's contribution, you will have to search the rest of the book code to change the "condition" key to "cond" whenever it's called. I haven't bothered to do this because I'm only evaluating the contribution at this stage.

I have no idea why my version of MySQL is coming up with the error, so if anyone out there does knoiw, please share it with us.

John

8 Dec 2006, 6:07 PM
#148
gluckfs avatar

gluckfs

New Zenner

Join Date:
Nov 2006
Posts:
21
Plugin Contributions:
0

Re: Product Type Book (by moku)

Will this mod support 13 and/14 digits ISBN Numbers??

Thanks

8 Dec 2006, 8:09 PM
#149
mylibros_com avatar

mylibros_com

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Product Type Book (by moku)

Yes. I have installed this on my store and all you have to do is use one of the additonal fields for the ISBN-13 or EAN number. However, I don't believe the standard search in ZC will search these fields.

You can check out my install at www . my libros . com (take out the spaces of course).

8 Dec 2006, 8:39 PM
#150
gluckfs avatar

gluckfs

New Zenner

Join Date:
Nov 2006
Posts:
21
Plugin Contributions:
0

Re: Product Type Book (by moku)

Thank you...

An absolutely beautiful well designed site too!!

15 Dec 2006, 2:36 AM
#151
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

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

Re: Product Type Book (by moku)

I get this error message when I click on author:

Warning: constant() [function.constant]: Couldn't find constant in /home/sonny1/public_html/includes/init_includes/init_add_crumbs.php on line 45
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 where book_authors_id = 25' at line 2
in:
[select from where book_authors_id = 25]

and publisher:

Warning: constant() [function.constant]: Couldn't find constant in /home/sonny1/public_html/includes/init_includes/init_add_crumbs.php on line 45
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 where manufacturers_id = 2' at line 2
in:
[select from where manufacturers_id = 2]

I am using ultimate SEO urls how can I fix this?

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

15 Dec 2006, 2:40 AM
#152
mylibros_com avatar

mylibros_com

New Zenner

Join Date:
Aug 2006
Posts:
37
Plugin Contributions:
0

Re: Product Type Book (by moku)

I just had this problem the other day... My Ukrainian developer said that it was a problem in one of my database tables, in rough English he said, "There is problem with database content. Missing values in table 'get_terms_to_filter.'"

That's all I know, he fixed it without telling me what he did. :yes: I can ask if you want.

15 Dec 2006, 2:50 AM
#153
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

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

Re: Product Type Book (by moku)

MyLibros.com:

I just had this problem the other day... My Ukrainian developer said that it was a problem in one of my database tables, in rough English he said, "There is problem with database content. Missing values in table 'get_terms_to_filter.'"

That's all I know, he fixed it without telling me what he did. :yes: I can ask if you want.

Thank you, I would apprecaite any help you could provide.

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

16 Dec 2006, 9:33 PM
#154
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

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

Re: Product Type Book (by moku)

Anyone know waht could be causing the issue I described above?

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

19 Dec 2006, 10:04 PM
#155
wildeep avatar

wildeep

New Zenner

Join Date:
Mar 2006
Location:
Rochester, NY
Posts:
20
Plugin Contributions:
0

Re: Product Type Book (by moku)

I don't know if I have the syntax correct, but the problem was that while the 'get_term_name' was filled in for 'book_genre_id' 'book_type_id' and 'book_authors_id', none of the other two fields were filled in.

After a bit of stumbling, I was able to figure out what the values needed to be.

get_term_name	get_term_table	get_term_name_field
manufacturers_id	TABLE_MANUFACTURERS	manufacturers_name
music_genre_id	TABLE_MUSIC_GENRE	music_genre_name
record_company_id	TABLE_RECORD_COMPANY	record_company_name
book_genre_id	TABLE_BOOK_GENRE	book_genre_id
book_type_id	TABLE_BOOK_TYPE	book_type_id
book_authors_id	TABLE_BOOK_AUTHORS	book_authors_name

Here are some (untested) SQL statements that should populate those empty fields:

UPDATE zen_get_terms_to_filter SET get_term_table="TABLE_BOOK_GENRE", get_term_name_field="book_genre_id" WHERE get_term_name="book_genre_id";

UPDATE zen_get_terms_to_filter SET get_term_table="TABLE_BOOK_TYPE", get_term_name_field="book_type_id" WHERE get_term_name="book_type_id";

UPDATE zen_get_terms_to_filter SET get_term_table="TABLE_BOOK_AUTHOR", get_term_name_field="book_authors_id" WHERE get_term_name="book_authors_id";

27 Dec 2006, 10:56 PM
#156
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

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

Re: Product Type Book (by moku)

Thanks for the assist, but that did not help. If you click on the author link here:

http://www.books-japan-online.com/product_book_info.html?products_id=448

You get this error message:

Warning: constant() [function.constant]: Couldn't find constant book_authors in /home/sonny1/public_html/includes/init_includes/init_add_crumbs.php on line 45
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 'where book_authors_id = 30' at line 3
in:
[select book_authors_id from where book_authors_id = 30]

Is Moku still around?

Please if anyone could help I would apprciate it.

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

28 Dec 2006, 1:02 PM
#157
mlindi avatar

mlindi

New Zenner

Join Date:
Sep 2006
Location:
earth
Posts:
50
Plugin Contributions:
0

Re: Product Type Book (by moku)

Your version of MySQL needs to be >4.1.x.

I had all sorts of issues when running 4.0.27 - as soon as I upgraded all problems went away.

Don't know how MySQL 5.x behaves.

HTH

cheers

--
So Zenned That I Don't Need Shoes

28 Dec 2006, 3:28 PM
#158
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

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

Re: Product Type Book (by moku)

mlindi:

Your version of MySQL needs to be >4.1.x.

I had all sorts of issues when running 4.0.27 - as soon as I upgraded all problems went away.

Don't know how MySQL 5.x behaves.

HTH

cheers

My version of MySQL is 4.1.10

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

10 Jan 2007, 2:59 PM
#159
scottydvt avatar

scottydvt

New Zenner

Join Date:
Dec 2006
Posts:
5
Plugin Contributions:
0

Re: Product Type Book (by moku)

From what I can tell, this mod does not include a page to display author info (bio, pic), although it is entered in admin.

Has anyone created an author page they would be willing to share?

Thanks,
Scott

15 Jan 2007, 5:41 AM
#160
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

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

Re: Product Type Book (by moku)

This mod would be perfect if the authors section would work, I mean I followed the instructions to the letter, and it isn't my fault that this mod is not working properly. It would be great if moku was around to look iinto it and fix it, but he hasn't be around in sometime. If I find the solution to this issue I will pass it on.

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com