Product Type Book (by moku)

[chabbu]

When I run the SQL patch for a new installation on v1.3.7, i receive the following error message:

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 product_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());]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I assume that it is because of this error message that I see nothing in if i go "product type" and choose "Procuct general" and then click the "Edit Layout" button?

[chabbu]

Don't worry - I managed to fix it.

The problem was when I tried to upload the SQL file. Instead I copied and pasted the contents of the SQL file directly into the SQL Query Executor from the admin and the statements executed without problems. I think it's something to do with the backslash preceding the apostrophes.

Faz

[dansicle]

Where can you download the latest version of this? Can't find it in the add-ons section, and the link in the first post is dead dead dead. Thanks!

[dansicle]

I found it if it's this: http://www.jphuk.co.uk/zc/index.php?...roducts_id=490

But, first of all, is that right? (I'm running 1.3.8.) And, secondly, could we get this into the add-on area? Would sure help it's findability.

(Secondary question: Is this 'the Zen cart thread' that the page linked above means?)

[chabbu]

I found it if it's this: http://www.jphuk.co.uk/zc/index.php?...roducts_id=490

But, first of all, is that right? (I'm running 1.3.8.) And, secondly, could we get this into the add-on area? Would sure help it's findability.

(Secondary question: Is this 'the Zen cart thread' that the page linked above means?)

Hi

That seems to be the correct, and only, link for v1.3.8. If you mean to ask if this is the support thread for the book type contribution, then yes, it's certainly where I've been posting questions to.

[chabbu]

Hi

Is there a way of switching the concatanation of fields off in the product info page? Ideally I'd like the fields to be listed individually, like the ISBN, Publisher fields.

Any ideas where I should be looking (I saw some references in one of the files in the templates folder, but it all looked pretty scary!)?

Thanks

Faz

[kburner]

I found it if it's this: http://www.jphuk.co.uk/zc/index.php?...roducts_id=490

But, first of all, is that right? (I'm running 1.3.8.) And, secondly, could we get this into the add-on area? Would sure help it's findability.

(Secondary question: Is this 'the Zen cart thread' that the page linked above means?)

Does anyone know if this will change/effect products I already have loaded?

Thanks, Kim

[jstric15]

I have installed the book type on my Zen Cart 1.3.8 and am looking for a way to mass upload products. I have tried Easy Populate and while it does upload products (some information anyway) it will not allow you to create the book product type (a lot of posts on this issue). My question is can you change the product type in the database directly and have the information show up properly in the product configure template. (I have hacked around and found you cannot just change the products_type in the products table and have it work).

Any thoughts or experiences?

Thanks

[rbryn]

I've installed the ML_ZC1_3_8_EXTENDED_BOOK_TYPE_V_4_LANGS_ISS2

English works, but the other languages have a problem with the sidebar multibox.

The header to the sidebox states: BOX_HEADING_BOOK_SEARCH
And the first three drop-downs are empty, the last two state:

PULL_DOWN_BOOK_PUBLISHERS

PULL_DOWN_BOOK_ISBN

I thought that maybe it was just the Spanish page I am trying to get up, but later realized it was also a problem in the Finnish page that came with ML_ZC1_3_8_EXTENDED_BOOK_TYPE_V_4_LANGS_ISS2


Presumably I need to edit the header ID's or something? Do I need to replicate a folder and files for each language? If so, surely someone has already done this for Spanish, French, Portuguese (and I wish there was Korean).



Lookin for bones!

RBryn

[chabbu]

My question is can you change the product type in the database directly and have the information show up properly in the product configure template. (I have hacked around and found you cannot just change the products_type in the products table and have it work).

Any thoughts or experiences?

Thanks

Hi

I'm looking into this again, and so far have found that you need to change the product type in the database and then insert the product ID into the product_book_extra table.

This at least gets the exisitng product title and description into a book type format.

Faz