Product Type Book (by moku)

[Darkwander]

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

[Darkwander]

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.

[Darkwander]

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 ?

[Darkwander]

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

[Darkwander]

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

[hareslade]

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.

[tekram]

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]

[hareslade]

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

[tekram]

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');

[tekram]

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');