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 81 to 100 of 647
30 Aug 2006, 5:56 PM
#81
teva avatar

teva

Zen Follower

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

Product Type Book (by moku)

Hey!

I can't get book type to work properly. I see book and all the data, but when i want to check the author, or i click on other genres i get redirected to /?book_genre_id=5&typefilter=book_genre which puts me on the first page. This happens with author (?typefilter=book_authors&book_authors_id=2) and all others.

Any idea?

Tnx

2 Sep 2006, 6:25 AM
#82
oceano avatar

oceano

New Zenner

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

Re: Product Type Book (by moku)

I've done a new ZC install of 1.3

I've imported the old database in from a 1.2.0.4 vintage ZC

I've done the install for moku's book_products instead of figuring updates to the good old 1.2/4 version - all seemed okay for a minute of course, but there is a snag

1146 Table 'garchen_zc2006.TABLE_PRODUCT_BOOK_EXTRA' doesn't exist
in:
[select * from TABLE_PRODUCT_BOOK_EXTRA where products_id = '446']

  • now I asume from my searching that there is no easy way to import the old book data into the new db structure - I'm accepting the idea of reloading everything, but how can I get past this error message ABOVE when I click on a newly created book product I just made?

This table does exist of course...

any ZCwizards out there tonight -

2 Sep 2006, 6:48 AM
#83
tekram avatar

tekram

Zen Follower

Join Date:
Feb 2006
Posts:
111
Plugin Contributions:
0

Re: Product Type Book (by moku)

when i click on a given author to see all books by that author, not all of the books show up by that author. anyoe else get this prob?

2 Sep 2006, 5:33 PM
#84
oceano avatar

oceano

New Zenner

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

Re: Product Type Book (by moku)

:frusty:

Well this test is not going to well. Still can't determine why the prefix TABLE_ is being added onto
TABLE_PRODUCT_BOOK_EXTRA
Clarify, this is the error message seen when I click on a book product of old, or try even viewing the new book product listing created under Moku's

Also...
What should I do with the old tables from the previous book product type?- (Since I assume there is no easy way to drop their product data into the new table structure.)

help...

2 Sep 2006, 11:39 PM
#85
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

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

Re: Product Type Book (by moku)

I just installed this Zen Cart 5-in-One Product Feeds and their seems to be some kind of conflict between this mod and yours. This is the error message I am getting:

Fatal error: Cannot redeclare zen_draw_pull_down_menu_multiple() (previously declared in /home/sonny1/public_html/test/admin/includes/functions/extra_functions/product_book_functions.php:8) in /home/sonny1/public_html/test/includes/m1_export_main.php on line 300

What could be causing this?

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

4 Sep 2006, 6:43 PM
#86
oceano avatar

oceano

New Zenner

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

Re: Product Type Book (by moku)

Well still stuck with this last detail on this test site.

I've done the install correctly, several times now...same error message when I create a new product under this product type book.

What I've got -----------

The table exists, I see it in phpMyAdmin,

I know which file is calling this [select * from TABLE_PRODUCT_BOOK_EXTRA where products_id = '446'], but no typos that I see.


Question:
My tables have a zc_ prefix that is not showing this error message, is this a clue, or just normal?


Plea:
I'd love some help as I'm just a carpenter/web-designer trying to give some volunteer support to a non-profit church. This database error message just has me stuck cold, everything else is finished for them but their book product type...anyone?:down:

5 Sep 2006, 1:27 PM
#87
teva avatar

teva

Zen Follower

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

Re: Product Type Book (by moku)

teva:

Hey!

I can't get book type to work properly. I see book and all the data, but when i want to check the author, or i click on other genres i get redirected to /?book_genre_id=5&typefilter=book_genre which puts me on the first page. This happens with author (?typefilter=book_authors&book_authors_id=2) and all others.

Any idea?

Tnx

i don't want to be impatient, but any idea how to solve my problem. I have just entered many books, but i can't get author or book type page to work. I get redirected to first page.

Thank You

7 Sep 2006, 8:11 AM
#88
joking avatar

joking

New Zenner

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

Re: Product Type Book (by moku)

Hi Moku,

I've just installed product_book version 1.02 and it works great. You have asked people to comment and offer suggestions so here I go:

Firstly, a very valuable contribution, and thank you for sharing it with us.

Things I'd love to see. (Some have been mentioned before)

Product Listing

  1. Authors names to appear below title instead of above.
  2. Add the word "Author(s) before authors names.

I've done both by changing code in class.productBookLiisting.php but this may be difficult for some people.

Book Info Display

  1. Author: When a person clicks on the author's name, your code takes the shopper to all books by the same author. I believe this is not a good idea. What the shopper would expect here is a popup showing information about the author along with his/her photo. You have already made provision for this information to be stored in the Admin "Authors" section and this is an ideal place to display it. A similar popup to the one used as a help screen in the shopping cart would be perfect.

A link to books by the same authors could then appear as the last item in the "Genre" section:

Genre: History
Size 9 x 3
etc.
Books by same authors: Smith, Joe & Smith, Joan

ISBN & Publisher (book info display)

I believe these items should appear immeadiately below the title and Author:

A HISTORY OF INDIA
Authors: Smith, Joe, Smith, Joan
Publisher: Art Press
ISBN 1234 5678 9123

(All nicely formatted of course.) I've already made these changes in product_info_display.php and it does look very good.

Authors

Most people search for an author's last name so when entering authors details in the Authors section, we really should enter:

"Smith, Joan" and not Joan Smith

Unfortunately this presentation doesn't look so good when viewing the book list or book info page (see History of India above).

A better presentation would be:

A HISTORY OF INDIA
Authors: Joe Smith, Joan Smith
Publisher: Art Press
ISBN 1234 5678 9123

Can you write a string/sub-string algorythmn to convert "Smith, Joan" to "Joan Smith" for display purposes? I did this many years ago with dbase II but don't have a clue how to do it with php.

Keep up the good work, you have many admirers.

John

(P.S. I don't have the internet connected at home so I won't see any posts to my comments for at least a week.

8 Sep 2006, 4:58 AM
#89
tekram avatar

tekram

Zen Follower

Join Date:
Feb 2006
Posts:
111
Plugin Contributions:
0

Re: Product Type Book (by moku)

anyone know how to control which features are displayed? for ex i dont want ot display isb numbers.

8 Sep 2006, 6:41 AM
#90
marw avatar

marw

New Zenner

Join Date:
Feb 2006
Location:
Hungary
Posts:
39
Plugin Contributions:
0

Re: Product Type Book (by moku)

Hi!

  1. Select "Catalog/Product types"
  2. Click TWICE on "Product - book"
  3. Click "edit layout"

On that page you have "Show ISBN on product listings" and "Show Model Number", try these.

Good luck!

9 Sep 2006, 9:33 AM
#91
darkwander avatar

darkwander

Zen Follower

Join Date:
May 2005
Location:
Australia
Posts:
321
Plugin Contributions:
0

Re: Product Type Book (by moku)

moku :-

I am currently using your product type to make a new Product type called "DVD" I was wondering if i could get your help with the SQL part, i don't understand it and it seems that is what allows the site to search the new product sections like "Author" and "Condition".

9 Sep 2006, 4:43 PM
#92
darkwander avatar

darkwander

Zen Follower

Join Date:
May 2005
Location:
Australia
Posts:
321
Plugin Contributions:
0

Re: Product Type Book (by moku)

Everytime i edit your Product type there seems to be less and less information displayed on the site, atm all that is left is Name and Subtitle and cost. :)

I believe it is in the Layout, when i click on the Product type "Product - DVD" and click on Edit Layout nothing is coming up like the rest of the product types, i was wondering if you new where the control for this are or what files i have to edit to get the layout working once again.

9 Sep 2006, 5:39 PM
#93
darkwander avatar

darkwander

Zen Follower

Join Date:
May 2005
Location:
Australia
Posts:
321
Plugin Contributions:
0

Re: Product Type Book (by moku)

I have it so that the options are showing up under the edit layout, in the the Admin section, but the details are still not showing up when it comes to the customer view on the shop. All that is showing up is the Title and Sub title and not the rest of the details that i have changed, does anyone have any idea where this might be fixed or what might be wrong ?

10 Sep 2006, 4:37 PM
#94
darkwander avatar

darkwander

Zen Follower

Join Date:
May 2005
Location:
Australia
Posts:
321
Plugin Contributions:
0

Re: Product Type Book (by moku)

OKey, the DVD model is finished.... Yea....

However there is only one thing left to do, i am trying to make it so that the "Starring" list of actoress is searchable, like Category and Studio is on mine, i have tried this and it didnt work too well, i was wondering if i can get your help with the last step.

Please........

10 Sep 2006, 6:36 PM
#95
darkwander avatar

darkwander

Zen Follower

Join Date:
May 2005
Location:
Australia
Posts:
321
Plugin Contributions:
0

Re: Product Type Book (by moku)

ctcentralinfo:

I just installed this Zen Cart 5-in-One Product Feeds and their seems to be some kind of conflict between this mod and yours. This is the error message I am getting:

Fatal error: Cannot redeclare zen_draw_pull_down_menu_multiple() (previously declared in /home/sonny1/public_html/test/admin/includes/functions/extra_functions/product_book_functions.php:8) in /home/sonny1/public_html/test/includes/m1_export_main.php on line 300

What could be causing this?

I am getting the same error...

11 Sep 2006, 5:43 PM
#96
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
Looking at my moku sql, at the end it says

INSERT INTO get_terms_to_filter VALUES ('book_genre_id');

... my older mysql won't process this,
but in the zencart main sql to create a 1.3 database it say (for instance)

INSERT INTO get_terms_to_filter VALUES ('manufacturers_id', 'TABLE_MANUFACTURERS', 'manufacturers_name');

Does anyone know if the other two (equivalent) field terms should be in there inside the brackets,
in the moku version, and if this in any way will affect the search results?


Also, re the ```
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

my older mysql (in a windows server) objects to this, I found just remove the items coming after 'MyISAM' clears the prob.
17 Sep 2006, 3:16 PM
#97
tekram avatar

tekram

Zen Follower

Join Date:
Feb 2006
Posts:
111
Plugin Contributions:
0

Re: Product Type Book (by moku)

i upgraded to the newest version of zc and now when i click on the authors name i get 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 where book_authors_id = 98' at line 2
in:
[select from where book_authors_id = 98]

18 Sep 2006, 11:28 PM
#98
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)

Yes its because init_add_crumbs.php has very different code in 1.3.5 compared to 1.3.0

moku's sql had blank field entries for the get_terms_to_filter table, so use the sql below in zc admin sql patch, -- having removed the three moku book-based entries in the get_terms_to_filter table with phpmyadmin..

I used sql here which creates the three recods from scratch, so you may need to create your own 'update/insert' or 'delete first' variant, if you cannot delete the records with phpmyadmin..:

for admin sql patch...

INSERT INTO get_terms_to_filter (get_term_name, get_term_table, get_term_name_field) 
	VALUES ('book_genre_id','TABLE_BOOK_GENRE_DESCRIPTION','book_genre_name');
INSERT INTO get_terms_to_filter (get_term_name, get_term_table, get_term_name_field)
	VALUES ('book_type_id','TABLE_BOOK_TYPE_DESCRIPTION','book_type_name');
INSERT INTO get_terms_to_filter (get_term_name, get_term_table, get_term_name_field)
	VALUES ('book_authors_id','TABLE_BOOK_AUTHORS','book_authors_name');

It clears the php error, someone needs to test it, I've only got one book in my database, searches mean nothing, with only one book available :)

19 Sep 2006, 10:49 AM
#99
tekram avatar

tekram

Zen Follower

Join Date:
Feb 2006
Posts:
111
Plugin Contributions:
0

Re: Product Type Book (by moku)

is strange because my table does not have tjse other two values yu are talkin about. here is the dump from my table:

CREATE TABLE get_terms_to_filter (
get_term_name varchar(255) NOT NULL default '',
PRIMARY KEY (get_term_name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table get_terms_to_filter

INSERT INTO get_terms_to_filter VALUES ('manufacturers_id');
INSERT INTO get_terms_to_filter VALUES ('music_genre_id');
INSERT INTO get_terms_to_filter VALUES ('record_company_id');

19 Sep 2006, 10:59 AM
#100
tekram avatar

tekram

Zen Follower

Join Date:
Feb 2006
Posts:
111
Plugin Contributions:
0

Re: Product Type Book (by moku)

changed my table so it looks like what is below and it works. thanks hareslade. any clue why my table was not updated?

CREATE TABLE get_terms_to_filter (
get_term_name varchar(255) NOT NULL default '',
get_term_table varchar(255) NOT NULL,
get_term_name_field varchar(255) NOT NULL,
PRIMARY KEY (get_term_name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table get_terms_to_filter

INSERT INTO get_terms_to_filter VALUES ('manufacturers_id', 'TABLE_MANUFACTURERS', 'manufacturers_name');
INSERT INTO get_terms_to_filter VALUES ('music_genre_id', 'TABLE_MUSIC_GENRE', 'music_genre_name');
INSERT INTO get_terms_to_filter VALUES ('record_company_id', 'TABLE_RECORD_COMPANY', 'record_company_name');
INSERT INTO get_terms_to_filter VALUES ('book_genre_id', 'TABLE_BOOK_GENRE_DESCRIPTION', 'book_genre_name');
INSERT INTO get_terms_to_filter VALUES ('book_type_id', 'TABLE_BOOK_TYPE_DESCRIPTION', 'book_type_name');
INSERT INTO get_terms_to_filter VALUES ('book_authors_id', 'TABLE_BOOK_AUTHORS', 'book_authors_name');