Creating an add-on "product type book" for ZC 1.5

Hi DML,

possibly the install URL is not correctly formed. I will make a note to myself to check the instructions on that.

Here is how it works:

Let's say your shop is called bookxshop.com and you have renamed your "admin" folder to something else like you should for security reasons, let's say "mysecureadmin" so that you log into admin with the following URL: http://bookxshop.com/mysecureadmin

After you log in, then you should get to http://bookxshop.com/mysecureadmin/index.php
Now you add the bit "?action=bookx_install" so that the entire URL reads http://bookxshop.com/mysecureadmin/i...=bookx_install

Here are a couple of other scenarios:
You have not renamed your "admin" folder, so the URL would be http://bookxshop.com/admin/index.php...=bookx_install
You are developing on your local machine and the URL to your admin page is different, so it could be http://localhost/bookxshop/mysecurea...=bookx_install

even if you don't see the index.php part it should work if you put http://bookxshop.com/mysecureadmin/?...=bookx_install

Hope that works.
p.

I have no clue what you did differently than the original directions, but that worked. Thanks.

So, my only remaining question is... I saw in the information on the software that you should be able to change existing products to BookX, but I don't see how to do that without deleting the old products and entering them again.

Thanks again.
DML

Hi DML,

if it works, that's the good news. You are right that the manual is not very wordy about the conversion of existing products. I will make a note to also be clearer on that in the instructions. In the meantime, you find the conversion here Admin -> Tools –> BookX Installation & Tools. There is some description there of how it works. To be safe ABSOLUTELY make a backup of your database before you convert the products ! ;)

Regards,
p.

Also, when making a product BookX, it seems to lose what I save in several of the areas. It displays things like page count, release date, price on the sale page...and the cover image, but it seems to lose the author name and book size (they turn blank inside the product build page, when I try to save changes). and it won't display the information from product name, subtitle, and book description on the sale page.

DML

Hi DML,

are you using the latest version 0.9.3Beta of the plugin found on Sourceforge, yes? http://sourceforge.net/projects/zencartbookx/

Please try to be a s specific as you can, when describing what you are doing and what is not working. If it is an issue of how to call a page, you can always paste the part of the url after your "admin", so for the "preview page" it would be for example: "product.php?cPath=1_56&product_type=1&pID=455&action=new_product_preview&page=1 "
Then I know exactly where you are having the problem.

Are you telling me that you don't see all the BookX info on the "preview" page between editing and saving a product? If so, please try to go ahead and save the product and see if the fields are indeed empty when you open the product again.
With "sale page" you mean the shopping cart contents or the "product info" page?

Regards,
p.

Quote:

---

Originally Posted by philou

Are you telling me that you don't see all the BookX info on the "preview" page between editing and saving a product? If so, please try to go ahead and save the product and see if the fields are indeed empty when you open the product again.
With "sale page" you mean the shopping cart contents or the "product info" page?

Regards,
p.

---

Okay, I've managed to fix some of it myself, but here's what I see...

http://firebornpublishing.com/store/...products_id=10

Now, when I look at the preview, ALL the information I've entered shows correctly, including everything entered in my description area. When the main page loads, I am missing...

Title
Subtitle
Series
and the stuff from the Description block

But Title, Subtitle, and Description show up on the preview, so I have no idea why they are not translating to the sale page, as they were before I put in BookX (for that matter...testing products that are still in General, they display fine).

No clue what is going wrong in between, but again...thanks for your help.

DML

Hi DML,

just to be sure: everything you enter on the admin side like title / description etc. is being saved, so that when you navigate to another product in admin and then back to the previous one, all info you entered is there. Is that correct?

I assume all this works fine, so question is why the title is not being displayed. Have you made any changes yourself to the template file tpl_product_bookx_info_display.php which comes with the BookX distribution?
I ask, because on your website the HTML code displaying the title looks like this (with an empty title for some reason):

Code:

---

<!--bof Product Name-->
<h1 id="productName" class="docProduct"></h1>
<!--eof Product Name-->

---

The PHP code in BookX 0.9.3Beta for the product title looks like this:

Code:

---

<!--bof Product Name-->
<h1 id="productName" class="docProduct"><?php echo '<span class="bookxTitle">' . $products_name . '</span>'
                                                                                                  . (($flag_show_product_bookx_info_volume && !empty($products_volume)) ? " <span class='bookxProdVolume'>" . sprintf(LABEL_BOOKX_VOLUME, $products_volume) . "</span>" : '') .
                                                                                                  (($flag_show_product_bookx_info_volume && !empty($products_subtitle)) ? " - <span class='bookxProdSubtitle'>$products_subtitle</span>" : ''); ?></h1>
<!--eof Product Name-->

---

which should at least create this HTML code, even if the title variable is empty for some reason:

Code:

---

<!--bof Product Name-->
<h1 id="productName" class="docProduct"><span class="bookxTitle"></span></h1>
<!--eof Product Name-->

---

You said you are using the latest BookX version from Sourceforge. Can you verify that the PHP code in tpl_product_bookx_info_display.php looks like above? It should be around line 488.
If you have made changes to tpl_product_bookx_info_display.php, maybe you can temporarily replace it with the original file from the plugin and see if that works.

Regards,
p.

Quote:

---

Originally Posted by philou

Hi DML,

just to be sure: everything you enter on the admin side like title / description etc. is being saved, so that when you navigate to another product in admin and then back to the previous one, all info you entered is there. Is that correct?

I assume all this works fine, so question is why the title is not being displayed. Have you made any changes yourself to the template file tpl_product_bookx_info_display.php which comes with the BookX distribution?
I ask, because on your website the HTML code displaying the title looks like this (with an empty title for some reason):
You said you are using the latest BookX version from Sourceforge. Can you verify that the PHP code in tpl_product_bookx_info_display.php looks like above? It should be around line 488.
If you have made changes to tpl_product_bookx_info_display.php, maybe you can temporarily replace it with the original file from the plugin and see if that works.

Regards,
p.

---

Yes, in the Admin, it is now saving everything I enter, from one time looking at the product and the next. I know the information is THERE but is not being displayed. I have made no changes to that file. The only two files I made changes to are the two you specifically tell us to make changes to in the installation directions.

This is a copy/paste of the code in that file.

Sorry it took so long to get back to you. They were working on the lines in this area, and I lost internet for a day. Thanks.

<!--bof Product Name-->
<h1 id="productName" class="docProduct"><?php echo $products_name .
(($flag_show_product_bookx_info_volume && !empty($products_volume)) ? " <div class='bookxProdVolume'>" . sprintf(LABEL_BOOKX_VOLUME, $products_volume) . "</div>" : '') .
(($flag_show_product_bookx_info_volume && !empty($products_subtitle)) ? " - <div class='bookxProdSubtitle'>$products_subtitle</div>" : ''); ?></h1>
<!--eof Product Name-->

DML

Dear DML,

are you 100% certain that you are using the version 0.9.3Beta from Sourceforge? ( http://sourceforge.net/projects/zencartbookx )
I have downloaded the package from there again myself just be sure there is no mistake on my end and these lines are definitely different in the file tpl_product_bookx_info_display.php that comes with 0.9.3 from there?
The version number is also written at the top of each file in the distribution, it should say:

Code:

---

* @version BookX V 0.9.3 BETA
 * @version $Id: [ZC INSTALLATION]/includes/templates/[CURRENT_TEMPLATE]/templates/tpl_product_bookx_info_display.php 2014-02-05 philou

---

In some earlier versions there were indeed problems with the description not showing, so I suspect that you don't have the latest one.

Is this the very first version of BookX you have installed, or did you have one previously? Please note that after 0.9.1 some template files have moved as is written in the "Changelog.rtf" in the distribution package.

Regards,
p.

Thanks philou for your reply, i was travelling so the delay,

my site details are as under
site name backup.sultan-chand.com

configurations
1. Categories, about 12
2. All categories and products are "type books"
3. Used Authors as authors ,
4. One book can have many authors
5. Used Genre as Subjects, One book has only one subject
6. used Series is for classes, currently one book can fall only in one series
7. used Publisher for Boards, Currently one book will fall only for one board


Problem area
Problem 1. The "text_all_music_genre"
select Anil Kr. Sharma, from authors in the book filter box, Anil Kr. Sharma writes books both for maths and mathematics Genre, so this problem occurs only if the author has books in more than one genre


Problem 2. the previous next does not work in listing
select Anita Devraj from Authors in the book filter box, 12 books wil be listed, Click on any one of them, details of the book will be listed with a previous next menu, and will always show, "Books+2" the first category and the count as 5, which is the count of the first category
and teh previous next butoon will not be activated. clicking on the product list button, will list the products under the first category "Books for +2"

Problem 3. Filter by alphabet does not work
Select any option of the filter, means, any author, any genre etc.. the books are then listed, and if you try to apply any filter of "filter result by items starting with", does not work and takes you to home page

I have been using the book version on zen cart 1.3.8 and it is working smoothly except with a few bugs. I wanted to change to Zen cart 1.5.1 and use your bookx, any help that i can provide by rigorous testing, you may let me know

You may check out the sites at backup.sultan-chand.com and teh original at sultan-chand.com
i have loaded two themes on the backup.sultan-chand.com and can give you the admin password if you want, the books are more or less the same as in sultan-chand.com

Look forward to your input

Quote:

---

Originally Posted by Desmat

Thanks philou for your reply, i was travelling so the delay,

my site details are as under
site name backup.sultan-chand.com

configurations
1. Categories, about 12
2. All categories and products are "type books"
3. Used Authors as authors ,
4. One book can have many authors
5. Used Genre as Subjects, One book has only one subject
6. used Series is for classes, currently one book can fall only in one series
7. used Publisher for Boards, Currently one book will fall only for one board


Problem area
Problem 1. The "text_all_music_genre"
select Anil Kr. Sharma, from authors in the book filter box, Anil Kr. Sharma writes books both for maths and mathematics Genre, so this problem occurs only if the author has books in more than one genre

---

I see the problem. Currently BookX has not been written to work with other filters which are not BookX itself, like alphabethical sorting. However the problem is only superficial, because BookX and the other filters both put the filtering in the Url and currently the two Urls are not combined, the replace each other.

Example:
This gives you books by Author "Anil Sharma":
http://backup.sultan-chand.com/index...kx_author_id=3

Using the filter "Mathematics" writes this URL, but loses the author ("&bookx_author_id=3"), so it shows nothing since there is no longer an author selected to filter:
http://backup.sultan-chand.com/index...ha_filter_id=0

This Url gives you the desired result, combining "Anil Sharma" and "Mathematics", but the popup used for filtering is not writing it this way:
http://backup.sultan-chand.com/index...ha_filter_id=0

I will try to fix this in the next version (this will be some weeks). In the meantime you can only remove the filtering option from your site.

The "text_all_music_genre" can be fixed very easily in the language files. You can put it into "english.php" right inside "includes/languages" or whatever language file you want to use.

Code:

---

define('TEXT_ALL_MUSIC_GENRE', 'Whatever you want the text to be');

---

Quote:

---

Problem 2. the previous next does not work in listing
select Anita Devraj from Authors in the book filter box, 12 books wil be listed, Click on any one of them, details of the book will be listed with a previous next menu, and will always show, "Books+2" the first category and the count as 5, which is the count of the first category
and teh previous next butoon will not be activated. clicking on the product list button, will list the products under the first category "Books for +2"

---

Correct. I noticed this in my development here as well. It should be working in the next version of BookX. Until then you can only remove the "Previous / Next" button, so visitors have to go back to the listing to see another book.

Quote:

---

Problem 3. Filter by alphabet does not work
Select any option of the filter, means, any author, any genre etc.. the books are then listed, and if you try to apply any filter of "filter result by items starting with", does not work and takes you to home page

---

In fact the answer to this is written in the answer for problem no. 1
They should bothe be fixed at the same time.

Quote:

---

I have been using the book version on zen cart 1.3.8 and it is working smoothly except with a few bugs. I wanted to change to Zen cart 1.5.1 and use your bookx, any help that i can provide by rigorous testing, you may let me know

You may check out the sites at backup.sultan-chand.com and teh original at sultan-chand.com
i have loaded two themes on the backup.sultan-chand.com and can give you the admin password if you want, the books are more or less the same as in sultan-chand.com

Look forward to your input

---

No need for admin passwords for now :)
It seems that you foudn a way to show the book title and subtitle, which was your problem earlier.
I have not tested the plugin on 1.3.8. It may work, but then again it may not.

Sorry, but for the moment I can not provide better asnwers than to turn off the filters and at least you have a working website...

Regards,
p.

thanks await your newer versions,
and await to offer you some cofee and dougnuts :)

the problem of text_all_musice_genre, is not only of writing the definition in the english file, but also, the list it drops , does not filter, which i presume is that filters again are not incorporated as of now, so the issue, right
anyway cheers, and once again eagerly await your newer versions and wish you luck

The changes should not be too difficult and I am hoping to have some time in Agust to continue work on Bookx.
I will let you know.

Regards,
p.

Quote:

---

Originally Posted by philou

Dear DML,

are you 100% certain that you are using the version 0.9.3Beta from Sourceforge? ( http://sourceforge.net/projects/zencartbookx )
I have downloaded the package from there again myself just be sure there is no mistake on my end and these lines are definitely different in the file tpl_product_bookx_info_display.php that comes with 0.9.3 from there?

Regards,
p.

---

Yes, it's the first installation, but no...apparently, it's NOT 9.3. It's 9.1. Head desk. No wonder I'm having problems. So, I guess the question is... What do I have to do to change from 9.1 to 9.3?

DML

Okay...I've updated. The ONLY problem I still see is down in the bio box and below it, where the author name should be is %s: Honestly, if that's my only issue, I can live with that bit of code, since all the other author name areas are fine. Thanks for your help.

DML

Hi DML,

I'm away from my development setup just now, so I can't check. The "%s" is most certainly the leftover of a string which is supposed to show the authors name, like this: "The name of this author is %s" and then the author name is inserted instead.of placeholder %s. i can't say right now what the problem there is, so if you can live with it for about two more weeks I will check it out. But i will have to know exactly where in the page the problem is...

Regards,
P.

Hi Philou,
I am very happy to install a great addons (New add-on "product type book" for ZC 1.5) on my website. this addon work fine on my website.
But i need to another two feature (1) how can i display list of all publisher in one page? (2) how can is display all category list in one page?
please help me
my site running on:
(1) zen cart version-1.5.1
(2) thi addon is new installed
(3) my server is linux server
(4) my php version is 5.4
(5) my operating system is windows 8

Hi amdad,

I'm happy to hear you like the plugin :)
The feature "publisher list" is planned and will not take very long to implement, but it is not currently finished. I am working on the new version of BookX in these days, and if I find that the "publisher list" can easily be inserted in the current version 0.9.3beta then I will put the "publisher list" files up on sourceforge and let you know. ( If user DESMAT who posted here previously is reading this, I will do the same for you and the "filter" issue which is not implemented in 0.9.3. )

Concerning your problem (2) "display all category list in one page":
If I understand correctly, you wish to have a center page with the same content of the sidebox "category listing", showing the names of categories as a menu on the side. If this is indeed what you want then I would think there must be plugins for this functionality. The way I see it, this view would not display any information coming from the BookX plugin, since it only lists the categories as you created them in the admin backend. Therefore there is nothing the BookX plugin could do..?

Best regards,
p.

Quote:

---

Originally Posted by philou

Hi DML,

I'm away from my development setup just now, so I can't check. The "%s" is most certainly the leftover of a string which is supposed to show the authors name, like this: "The name of this author is %s" and then the author name is inserted instead.of placeholder %s. i can't say right now what the problem there is, so if you can live with it for about two more weeks I will check it out. But i will have to know exactly where in the page the problem is...

Regards,
P.

---

hi Philou
I am anxiously waiting for you implementing the filters, the plugin is working perfectly with just the hiccups of the filters

Hi Desmat,

it's noted and I will move this up in priority, so you have it soon.

Regards,
p.

:smile::smile:
await anxiously

hi philou,
thanks for your reply. dear i need another help from you. my problem is (1) tpl_product_bookx_info_display.php page open correctly but product description content is missing. (2) when view tpl_product_bookx_info_display.php page then sidebox position change, i mean tpl_product_bookx_info_display.php page looking not good it's layout may break . please help me.
now i used zen cart version 1.5.1 and template is cherry_zen

I'm running 1.5.1 and I can't seem to work out a few nits. The book pages and main page look fine, but the category pages have problems. Example?

http://firebornpublishing.com/store/...=index&cPath=4

My three main problems are...

1. The garbage code that shows at the top of the page, below the 1 to 3 (of 3 products) line. I have fixed code like that on other pages, but I can't find the file I'm dealing with to fix this.
2. The fact that the category pages (and ONLY the category pages, as far as I can tell) push the right sideboxes off the edge of the backdrop. All the rest sit nicely on it, as they should.
3. The inconsistency in how the buy button/prices are displayed. I haven't added code that would mess with this, so I don't know why the first, second, and third books all display differently.

Any help would be greatly appreciated.
DML

Hi Desmat,

please check out the archive "Hotfix_BookX_0.9.3_Alpha_Sorter.zip" at sourceforge https://sourceforge.net/projects/zencartbookx/files/

You need to update some files in order to fix the "filters" issue. I hope it won't cause you any problems, because these are files taken from the current work in progress of version 0.9.4 of the plugin.

Let me know if it works for you.

Best,
p.

Quote:

---

Originally Posted by amdad

hi philou,
thanks for your reply. dear i need another help from you. my problem is (1) tpl_product_bookx_info_display.php page open correctly but product description content is missing. (2) when view tpl_product_bookx_info_display.php page then sidebox position change, i mean tpl_product_bookx_info_display.php page looking not good it's layout may break . please help me.
now i used zen cart version 1.5.1 and template is cherry_zen

---

Hi amdad,

are you sure you are using the latest version from sourceforge https://sourceforge.net/projects/zencartbookx/files/
I believe the missing description on tpl_product_bookx_info_display.php is fixed in 0.9.3 ?

If yes, then can you give me either a URL to look at your site, or I would need the HTML source for your page. I think I had a wrong HTML tag in there somewhere, but I thought I fxied it…

Best regards,
p.

Quote:

---

Originally Posted by DMLyons

I'm running 1.5.1 and I can't seem to work out a few nits. The book pages and main page look fine, but the category pages have problems. Example?

http://firebornpublishing.com/store/...=index&cPath=4

My three main problems are...

1. The garbage code that shows at the top of the page, below the 1 to 3 (of 3 products) line. I have fixed code like that on other pages, but I can't find the file I'm dealing with to fix this.

---

It seems the php code

Code:

---

$zco_notifier->notify('NOTIFY_TEMPLATE_PRODUCT_LISTING_TABULAR_DISPLAY_BEGIN');

---

which is supposed to be pasted at the top of file [YOUR-ZEN-CART-FOLDER]/includes/templates/[YOUR-CURRENTLY-ACTIVE-TEMPLATE]/common/tpl_tabular_display.php is being output as text. Please double check that you pasted it in the right place, refer to my instructions: https://sourceforge.net/p/zencartboo...&%20Uninstall/

Quote:

---

2. The fact that the category pages (and ONLY the category pages, as far as I can tell) push the right sideboxes off the edge of the backdrop. All the rest sit nicely on it, as they should.

---

It is related to problem (1). If you don't have the very long "word" $zco_notifier->notify('NOTIFY_TEMPLATE_PRODUCT_LISTING_TABULAR_DISPLAY_BEGIN');which makes the center column wider than it should be, the boxes will be positioned correctly

Quote:

---

3. The inconsistency in how the buy button/prices are displayed. I haven't added code that would mess with this, so I don't know why the first, second, and third books all display differently.

---

Don't see exactly what you mean on your site, can you provide a direct like to the page you are talking about?

Best,
p.

Quote:

---

Originally Posted by philou

It seems the php code

Code:

---

$zco_notifier->notify('NOTIFY_TEMPLATE_PRODUCT_LISTING_TABULAR_DISPLAY_BEGIN');

---

which is supposed to be pasted at the top of file [YOUR-ZEN-CART-FOLDER]/includes/templates/[YOUR-CURRENTLY-ACTIVE-TEMPLATE]/common/tpl_tabular_display.php is being output as text. Please double check that you pasted it in the right place, refer to my instructions: https://sourceforge.net/p/zencartboo...&%20Uninstall/

---

Okay, that is working now that I've moved the line further down the file, and it did fix problem #2 as well. Thank goodness and thank you. I was taking your directions too literally and had the hook line as line 1 of the file. It didn't like that. Grin... But all is well there now.

Quote:

---

Originally Posted by philou

Don't see exactly what you mean on your site, can you provide a direct like to the page you are talking about?

---

I already posted a direct link to the page I'm talking about...
http://firebornpublishing.com/store/...=index&cPath=4

If you look at the coming soon page, you will see...this.

Attachment 14457

Hey, Baby's price and buy link are in the price column.
Poly Sigh's price and buy link are in the item name column instead of in the price column.
Seasons of Change's price is in the item name column, and there's no buy link.
I would have thought all three would be in the price column, but...why aren't they all showing uniformly? :huh:

DML

Hi ,

I've been using this plugin for a customers website and I wondered if it was possible to have author type filters in a side box? I ask this as the client wants to be able to filter by Author and then also filter by Illustrator (which is a author type). Is this possible currently?

Thanks in advance!

Hi Red,

a filter for author type should not be too difficult to include. I have decided to reduce the number of other features I wanted to include in the next version 0.9.4beta, which means I will release 0.9.4beta rather soon, ideally by next week. That way the three recent requests /bugs posted here by yourself, DMLyons and amdad can be implemented / fixed, and I don't have to wrap up single files as an advance release to give you this functionality.

Please all be reminded here that this plugin is still in the beta stage, and although I feel it is rather stable already, it should only be used in a live shop if you know what you are doing ;)

Regards,
p.

Hi Philou,

I don't mean to be stepping on your toes but I didn't think that the version I have had this functionality so I started adding it.

I have got to the stage where I have updated files to use Illustrator name/description and added the necessary new files (as far as I could tell) for Illustrators. Unfortunately I can't get it to install so I've obviously bitten off more than I can chew and unfortunately I started doing these changes on version 0.91 (I didnt realise you had newer versions than this as I had only seen the uploaded file on the main site).

If you think you have a better version then I will certainly stop - I am just conscious that my client was wanting the functionality as quick as possible.

Kinsley (RedRansom)

Hi Kinsley,

no harm done. I happen to be working on it (and on the filters specifically) in these days, so I might as well add the author types filter too. As I am working on it, I discover a few lose ends even in the database, so I would think trying to implement this on your version 0.9.1 will be lots of pain for you with little pleasure at the end. Apart from the work to be done, you will have a solution that modifies many BookX core files, so expect headaches if you ever wanted to upgrade…

Concerning versions on ZC.com and sourceforge: It's true I have been lazy about updating the plugin here on ZC.com and I promise to be better about it from now on ;)

Regards,
p.

Quote:

---

Originally Posted by redransom

Hi ,

I've been using this plugin for a customers website and I wondered if it was possible to have author type filters in a side box? I ask this as the client wants to be able to filter by Author and then also filter by Illustrator (which is a author type). Is this possible currently?

Thanks in advance!

---

Just to be sure:
You want to filter the books by the author Joe Blow and then set a second filter so you see only the books which Joe Blow illustrated, but not the ones where he wrote the texts.

Is that your scenario?

Quote:

---

Originally Posted by redransom

Hi ,

I've been using this plugin for a customers website and I wondered if it was possible to have author type filters in a side box? I ask this as the client wants to be able to filter by Author and then also filter by Illustrator (which is a author type). Is this possible currently?

Thanks in advance!

---

Quote:

---

Originally Posted by philou

Just to be sure:
You want to filter the books by the author Joe Blow and then set a second filter so you see only the books which Joe Blow illustrated, but not the ones where he wrote the texts.

Is that your scenario?

---

The more I think about it, it seems strange to filter by author (name) first and then add another filter for author type. Wouldn't it be more intuitive to choose to only see e.g. "Illustrators" and then pick an author (= illustrator) from that list? Possibly the "author type" filter could even reduce the options in the "author" filter popup, meaning the "author" filter popup in the sidebox would only show illustrators if the corresponding "author type" filter is set.

Let me know what your use case is, so we can find the best way to implement this.

Regards,
p.

Back again...quick question...

I'm running 1.5.1, and I want to change the line-up of my product pages a bit. In specific, I want to have the series name show on the product page (it doesn't at the moment), and I want to move the price from the bottom of the page to further up...either above or below the book description, so readers can see the price right away. How would go about doing that?

Thanks in advance.
DML

There is a setting in Admin -> Catalog -> product types -> Product Type Bookx -> edit layout -> Product Detail: Show Series
If you turn that on, then Series should show on the Product Info page.

Looking at the page "product_bookx_info" on your site, i have the feeling you are still not using the latest version of BookX, because there the price is at the top…?
http://firebornpublishing.com/store/...products_id=39

Regards,
p.

Probably so, since setting every series possibility on the section you told me to to 1=Yes, unless it's empty (all but the showing the description were already set to 1 before I got to it) still doesn't result in the series name showing on the book page. The filter has always shown the series choices, but the book pages still don't. Guess I better see about updating again.

DML

And...this would be why I hate updating.
WARNING: An Error occurred, please refresh the page and try again.

I put the files in place. The latest version 0.9.3 already has the changes made in the files you have to make in a new installation. I changed the BAK file as I should...and I still get this error.

DML

Okay...though I'm still getting the error on updating to 0.9.3, the price and buy button have moved to the top, where I want them.

And 1=Yes, unless it's empty does NOT work, but 2=Yes does, so the series is showing below the description/excerpt.

My two cents? If it's working, don't mess with it. Thanks much for your help.

DML

Quote:

---

Originally Posted by DMLyons

And...this would be why I hate updating.
WARNING: An Error occurred, please refresh the page and try again.

I put the files in place. The latest version 0.9.3 already has the changes made in the files you have to make in a new installation. I changed the BAK file as I should...and I still get this error.

DML

---

Could you please try to run the installation again and when you get the error, please check the error log in your "cache" folder an tell me what it says, so I can find and fix the problem.

Regards,
p.

Sorry Philou,

Been woorking on other projects last couple of days.

No you are right - Illustrator or Author like you said it wouldnt make sense to do both.

And also upgrading to 0.9.3 then would probably be a mare - I'd rather obviously get the site live and then use the new version of bookx.

Kinsley

Hi Kinsley,

I currently favour the solution where the "Bookx Filter" sidebox contains a popup select element for "author type" which then reduces the authors listed in the sidebox popup "show authors" as well as it would filter the page "authors list" which you get when you choose "Show all authors" from the author filter popup.

Unless you tell me this won't work for your setup, I'll go ahead and implement it this way.

I agree that an update to 0.9.3 will not be of much use if the 0.9.4 is just around the corner.

p.

Hi Philou,

Yes I can see why you'd do that and to make sense it would allow you to handle more sites because of it. I just think the client wants a separate drop down which is why I was looking down the route of copying the author logic and creating a separate grouping class.

Kinsley

Hi Philou,

Yes I can see why you'd do that and to make sense it would allow you to handle more sites because of it. I just think the client wants a separate drop down which is why I was looking down the route of copying the author logic and creating a separate grouping class.

Kinsley

Hi Philou,
Thanks for your previous help, i need another help from you. your great plugin everything is ok on my site, my site running on zen cart version 1.5.1 and template is "cherry_zen". but recently i installed a new template "apple_zen" unfortunately when i click on list of all author then show all author but sidebox are not stay right place, mean sidebox move left to right and it stay below on list of all authors. like as this picture. please help me how can i solved it.Attachment 14492

Hi amdad,

it's not that easy on your screenshot to see exactly what the problem is, but my first guesses when things are being pushed down on the page would be:

(a) the content (some TABLE or DIV or something) is too wide to fit in the space, so it moves down on the page until there is enough width for it,

or (b) there is a an element (like sideboxes or so) which has an attribute "float: left" and then there is another element which has an attribute "clear: all", which is being pushed below the floating element.

Are you using web developer tools like they are built into Firefox? There you should try to find the element that has moved down and see if it is either to wide or maybe has a "clear: attribute".

Hope that helps,
p.

P.S. For anybody impatient about 0.9.4., I am on it in these minutes, but the testing takes time to make sure it all works.

By the way, if anybody is translating BookX langugage files into another language, I am happy to include those language files in the distribution…

Regards,
p.

isnt this allready possible with the use of attributes and dynamic filter sidebox module ?

hi philou,
I am very impatient to get very useful plugin bookx 0.9.4. Also i am waiting to see what new feature include this version. I am very happy to hear this version developed is complete. now left testing this plugin. please inform me approximately how many days required to finally published this plugin?

Hi amdad,

the development for this version is done and I am updating the installation script and testing installation with a sample shop.
If all goes well, the version 0.9.4beta should be available in the next days on Sourceforge. I will also submit it here at ZC.com, but the review process usually takes a bit of time before the plugin is available in the download section.

regards,
p.

Version 0.9.4 is available for download on Sourceforge https://sourceforge.net/projects/zencartbookx/files/

Please let me know if you install it, even if you should not have problems, that is also a valuable piece of information :)

The new version is also submitted here at ZC.com, but the review process will take some time.

Best regards,
p.

Hi Philou,
I am very happy to get your latest bookx plugin, now i installed your plugin on my site. Unfortunately 2 problem occur on my site.
problem-1: when i click on single publisher then publisher page can not be load but when click on list of publisher then show list of publisher.
problem-2: when click on list of publisher then show list of publisher but sidebox are not stay actual place it move bellow of publisher list.
please suggest me how can i solved it?

OOps, that's pretty bad. I'll fix that right away and let you know here when a new file is ready.

Quote:

---

Originally Posted by amdad

Hi Philou,
I am very happy to get your latest bookx plugin, now i installed your plugin on my site. Unfortunately 2 problem occur on my site.
problem-1: when i click on single publisher then publisher page can not be load but when click on list of publisher then show list of publisher.
problem-2: when click on list of publisher then show list of publisher but sidebox are not stay actual place it move bellow of publisher list.
please suggest me how can i solved it?

---

Hi amdad,

please find version v0.9.4r3 BETA on sourceforge. Only difference to 0.9.4r2 is the file "[YOUR_ZC_INSTALLATION]/includes/index_filters/bookx_filter.php", so you really only need to replace this one file and it should fix your problem No. 1.

Sorry about that :-/

Concerning your problem 2, I cannot reproduce the situation. Could you try to use another template and see if the boxes also move around with that template? Secondly you could try to temporarily rename "stylesheet_bookx.css" inside your template folder/css/ to something like "DISABLEstylesheet_bookx.css". This should disable all CSS styling like "floats" etc. of BookX, so you could see if that resolves them problem, and then we know it is a CSS problem together with your template.

Otherwise I would need to see the problematic page online somewhere.

Regards,
p.

Quote:

---

Originally Posted by philou

Hi amdad,

please find version v0.9.4r3 BETA on sourceforge. Only difference to 0.9.4r2 is the file "[YOUR_ZC_INSTALLATION]/includes/index_filters/bookx_filter.php", so you really only need to replace this one file and it should fix your problem No. 1.

Sorry about that :-/

Concerning your problem 2, I cannot reproduce the situation. Could you try to use another template and see if the boxes also move around with that template? Secondly you could try to temporarily rename "stylesheet_bookx.css" inside your template folder/css/ to something like "DISABLEstylesheet_bookx.css". This should disable all CSS styling like "floats" etc. of BookX, so you could see if that resolves them problem, and then we know it is a CSS problem together with your template.

Otherwise I would need to see the problematic page online somewhere.

Regards,
p.

---

Hi Philou,
Thanks a lot for your help, problem 1 is solved, you should be right about problem 2. when i used another template then problem 2 is solved, thanks again.

Hi philou,
Appreciate for your reply, and best of all everything on the site is working perfectly except the filters.
But i am a little confused with your solution, as the only files on the link are the Attachment 14509 Do i just over write and merge the relevant files or is there any other file to be worked upon

thanks a ton in advance

Hi desmat,

now that 0.9.4r3 is ready, I have removed the other previous downloads. Yes, you should replace all the files. Some files need manual modifications, most of which should already have been made on your shop, since you are upgrading from 0.9.3
Please check the included documentation.
I am a bit worried though since you got an error when upgrading to 0.9.3 and we didn't fix it at that time, so let's hope that doesn't cause bigger problems now.

p.

hi philou

great work you are doing,, i get
installed the latest version
all the filters work correctly except for the publishers,
if i use the filter i get the following error "WARNING: An Error occurred, please refresh the page and try again."

als i quite do not understand, that the filters have to be applied in genre, series and author, to get a cascaded filter, any other way does not work

help like always will be appreciated

Thanks for all the time you are investing

Dear philou
Another error that i discovered

if there is only one book in a series, or author, or genre ( publisher not working so cannot comment on that ) then the book is displayed but in the breadcrumb the topmost category is displayed and the listing shows number of books in the top most category, check out http://www.passionfruit.co.in
try any of the under and you will find the error
genre >> History & Civics, Geography
series >> VI to VIII
author >> Anupam Magon

Hi Desmat,

it's a silly bug I introduced in the first upload of 0.9.4beta. Please download the revised 0.9.4r3 from here or sourceforge:

Quote:

---

BookX – Product Type Book - Version: 0.9.4r3
0.9.4revision3 fixes a Fatal Error when filtering for publisher via sidebox filter. Only difference to 0.9.4r2 is the file "[YOUR_ZC_INSTALLATION]/includes/index_filters/bookx_filter.php". If you had installed 0.9.4r2 then you can simply exchange this one file and you have the fix.

---

Best regards,
p.

but thats what i have, i have installed the latest version at zen cart/sourceforge, Version: 0.9.4r3 Beta
:(

Ugh, that's bad. In that case please run the publisher filter to create the error and then look inside the folder "[YOUR–ZC-INSTALLATION]/cache" if there is a new debug log. Please tell me what exactly it says in there what the error is.

p.

Quote:

---

Originally Posted by Desmat

Dear philou
Another error that i discovered

if there is only one book in a series, or author, or genre ( publisher not working so cannot comment on that ) then the book is displayed but in the breadcrumb the topmost category is displayed and the listing shows number of books in the top most category, check out http://www.passionfruit.co.in
try any of the under and you will find the error
genre >> History & Civics, Geography
series >> VI to VIII
author >> Anupam Magon

---

I think there is a setting in ADMIN which says to take the visitor straight to the product page if there is only one product in the listing. So that part is expected behaviour. I agree that the breadcrumb should rather show the author than the category. The "previous/next" buttons at the top of the product info page relate to the category in which the product is placed not the filtered attribute like BookX author. The only solution for the moment would be for you to:
1) Turn off the feature to go straight to product page if there is only one product in the listing.
2) Hide the "previous/next" buttons until they work with BookX filters, not categories (for example with CSS: display: none;)

Regards,
p.

Quote:

---

Originally Posted by Desmat

Below I list a few bugs/irritants. The purpose is for you to be aware if you are not already.

1. Selecting any book after the filter listing, ( product info ) the breadcrumb always shows
first category/filter 1 /filter 2 / book name

in my opinion it should show the category the book belongs not the first category in the category listing, or not show at all

2. Keeping the same logic, as above, if there is one book , it shows
first category / book name

so there are there are two problems, a) does not show the filter applied at all, b) like above, it shows the first category, instead of the category the book belongs to

---

These two issues are part of the same problem. I am aware that the breadcrumbs do not yet work well with BookX. I was no aware of the option "go directly to product page if there is only one book in the listing", so I will keep an eye open for this feature and make sure it also works when the breadcrumbs will be implemented correctly (next version).

Quote:

---

3. Resetting the filter takes the navigation to the home page , instead of leaviing on the same page

---

Good point, should be easy to implement.

Quote:

---

4. Lastly if after selecting a book out of filtered list if we could just navigate previous next within the filter it would be just great

---

Yes, this is not yet implemented, but planned behaviour for a next release.

Hi Philou! I'm working on testing out the latest version of this plugin (in a fancy test environment, so this isn't live). I'm using zen 1.5.1 as the base, and I'm running into some non-critical problems.

For background, on my main catalog page, I have New Releases at the top, followed by Upcoming Products and then followed by Specials. The New Releases and the Upcoming Products are where I ran into some issues.

First, after upgrading, New Releases disappeared completely. It took me a while to figure out why, but I tracked it down to a date issue. I haven't been using the "Publishing Date" in the Bookx metadata; it wasn't something I needed based on how my books are set up and displayed. When I put that "Publishing Date" in one of my recent releases, it shows up. So maybe not a real problem, but it might be something to note for new users? Alternatively you could look into check for the "Date Available" when looking for new releases if that "Publish Date" isn't there?

The Upcoming Releases issue is part date and part product quantity. The product quantity is where I have the real problem. I list our books on the website a few months in advance of their release date and make them available for preorder. So these books have a product quantity immediately, and that excludes them from the "Upcoming Releases" box.

This box also sorts by date strangely. If a book doesn't have a Publish Date set, it's listed first in Date Available order. Then books with the Publish Date set are listed after. Obviously, assigning Publish Dates to all books will resolve the sorting issue, but again, I wasn't sure if you wanted to note that anywhere or find some way to tweak it so it looked at both or one?

Other than this, I haven't run into any issues, but I haven't finished testing everything just yet. :-)

Annnd I should look through all the options before I open my mouth. I found where to switch it to include/sort by Date Available rather than Publishing Date. :-) I had checked under the product type options, but not the Catalog -> Bookx Configuration.

Hi Nikerymis,

I was going to check out that setting too, but you were faster :)
Does that fix your problem? Also: at the top of the Admin form to edit product details there should be a message, stating what the current status of the product is. Was that correct and complete? Or should it be extended to say something about sorting by date available or publishing date, depending on the setting?

Hoep all is working for you now and thanks for testing!

Regards,
p.

It did and didn't fix my problem. For the New Products section, turning off the "Base on Publishing Date" option makes the books reappear there. The weird thing is that I have it set to show a maximum of six (six across, so one row), but it's showing five rows of six each (probably close to if not all the recent books within the time frame I have set). I also had it dressed down to bare bones -- just the book image and the title, with links for both, and I can't find where to remove the author, price, and series details that are listed near it for the Bookx version. (I can figure out how to shut this off manually by manipulating the code, but I mention it in case you want to make those options or if I'm missing someplace else to tweak these things.)

The Upcoming Products is stranger. I set the option to 0 to shut off Base on Publishing Date, and it crops up with an error and won't load the page past where the Upcoming Products are supposed to be listed. The log is below. I don't know if this is something that I caused when I was merging files, but I can't seem to pinpoint where the problem is, as the log is over my head. All I understand is that something is wrong in the syntax. :-) I tried this with both the \includes\templates\[my template]\templates\tpl_modules_upcoming_products.php that I merged with my formatting changes and then with the original from the plugin, but got the same error both times.

(Also, the product status (in stock vs. out of stock) is correct for all the book. I assume that's what you're referring to, but if I'm missing something there point me in the right direction.)

Code:

---

[21-Oct-2014 04:16:11 UTC] PHP Fatal 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 'GROUP BY p.products_id  ORDER BY be.publishing_date, p.products_date_available a' at line 17 :: select p.products_id,  be.publishing_date, pd.products_description, p.products_image,
                                                                            CONCAT_WS(""
                                                                                              ,pd.products_name
                                                                                              ,IF(NULLIF(be.volume, "") IS NOT NULL, CONCAT_WS("", " <span class='bookxProdVolume'>", REPLACE("vol. %s", "%s", be.volume), "</span>"), "")
                                                                                              ,IF(NULLIF(bed.products_subtitle, "") IS NOT NULL, CONCAT_WS("", " &ndash; <span class='bookxProdSubtitle'>", bed.products_subtitle, "</span>"), "")
                                                                                              ) AS products_name,
                                                                            CASE WHEN DAYOFMONTH(be.publishing_date) THEN DATE_FORMAT(be.publishing_date, "%m/%d/%Y")
                                                                                      WHEN MONTH(be.publishing_date) THEN DATE_FORMAT(be.publishing_date, "%M %Y")
                                                                                      ELSE YEAR(be.publishing_date)
                                                                            END AS formatted_publishing_date, be.size , printd.printing_description , bd.binding_description , cd.condition_description , p.products_model , GROUP_CONCAT(DISTINCT CONCAT_WS("", IF("" = IFNULL(batd.type_description,""), "", CONCAT_WS("", "<span class=\"bookxLabel\">", batd.type_description , ": </span>")), ba.author_name) ORDER BY bat.type_sort_order ASC SEPARATOR " &middot; ") AS authors, products_date_available as date_expected, p.master_categories_id
                    from products p, products_description pd
                    LEFT JOIN product_bookx_extra be ON be.products_id = pd.products_id
                                                    LEFT JOIN product_bookx_extra_description bed ON bed.products_id = pd.products_id AND bed.languages_id = "1" LEFT JOIN product_bookx_printing_description printd ON printd.bookx_printing_id = be.bookx_printing_id AND printd.languages_id = "1" LEFT JOIN product_bookx_binding_description bd ON bd.bookx_binding_id = be.bookx_binding_id AND bd.languages_id = "1" LEFT JOIN product_bookx_condition_descriptions cd ON cd.bookx_condition_id = be.bookx_condition_id AND cd.languages_id = "1" LEFT JOIN product_bookx_authors_to_products batp ON batp.products_id = be.products_id
                                                            LEFT JOIN product_bookx_authors ba ON batp.bookx_author_id = ba.bookx_author_id
                                                            LEFT JOIN product_bookx_author_types bat ON bat.bookx_author_type_id = batp.bookx_author_type_id  AND bat.type_sort_order < "1000"  LEFT JOIN product_bookx_author_types_description batd ON batd.bookx_author_type_id = batp.bookx_author_type_id AND batd.languages_id = "1" where p.products_id = pd.products_id
                    and p.products_status = 1
                    and pd.language_id = '1' and (p.products_date_available >20141021235959  GROUP BY p.products_id  ORDER BY be.publishing_date, p.products_date_available asc
                  limit 4 in C:\wamp\www\books3\includes\classes\db\mysql\query_factory.php on line 220
[21-Oct-2014 04:16:11 UTC] PHP Stack trace:
[21-Oct-2014 04:16:11 UTC] PHP  1. {main}() C:\wamp\www\books3\index.php:0
[21-Oct-2014 04:16:11 UTC] PHP  2. require() C:\wamp\www\books3\index.php:193
[21-Oct-2014 04:16:11 UTC] PHP  3. require() C:\wamp\www\books3\includes\templates\lt3shiny\common\tpl_main_page.php:122
[21-Oct-2014 04:16:11 UTC] PHP  4. require() C:\wamp\www\books3\includes\modules\pages\index\main_template_vars.php:433
[21-Oct-2014 04:16:11 UTC] PHP  5. include() C:\wamp\www\books3\includes\templates\lt3shiny\templates\tpl_index_default.php:81
[21-Oct-2014 04:16:11 UTC] PHP  6. queryFactory->Execute() C:\wamp\www\books3\includes\modules\lt3shiny\upcoming_products.php:63
[21-Oct-2014 04:16:11 UTC] PHP  7. queryFactory->set_error() C:\wamp\www\books3\includes\classes\db\mysql\query_factory.php:428
[21-Oct-2014 04:16:11 UTC] PHP  8. queryFactory->show_error() C:\wamp\www\books3\includes\classes\db\mysql\query_factory.php:190
[21-Oct-2014 04:16:11 UTC] PHP  9. trigger_error() C:\wamp\www\books3\includes\classes\db\mysql\query_factory.php:220

---

Hi Nikerymis,

thanks for taking the extra time to work this out for everyone –##I realize that a quick hack to make it work is often much faster then reporting a bug and resolving it :)

Anyway, at first glance there seems to be a bracket missing in the SQL statement. Since it is just after some BookX code, I would assume it is indeed a bug. I will look into this hopefully later today.

As for the date_available / publishing_date issue, I will make a few test products in my setup here and see if I can reproduce the issue. Off the top of my head I can't say if this is just a question of setting BookX options (and possibly explaining the options and their effects a bit better) or if this is also somewhat of a bug and needs to be improved.

I will let you know how I get on with it.

Regards,
p.

Hi Nikerymis,

here comes a list of your problems as I understand them, with (hopefully) solutions to most of them ;)

1.) Turning off the setting ADMIN -> Configuration -> Bookx: Configuration -> Upcoming Products: Base on Publication Date by setting it to "0" results in a fatal MYSQL error.
This is a bug indeed. You fix it by editing the file [YOUR_ZC_INSTALLATION] -> includes -> classes -> observers -> class.bookx_observers.php
Near line 1298 you need to replace this line:

Code:

---

$expected_query = str_replace(' p.products_date_available ', ' (p.products_date_available ', $expected_query);

---

by these lines:

Code:

---

if(!empty($extra_where_condition)) {
    $expected_query = str_replace(' p.products_date_available ', ' (p.products_date_available ', $expected_query);
}

---

I'll try my best to include this change in a version 0.9.4revison4 in the next few days.

2.) Turning off the setting ADMIN -> Configuration -> Bookx: Configuration -> New Products: Base on Publication Date by setting it to "0" results in more products being displayed than you expected
You say that you limited the numer of displayed new products to show a maximum of six. I have turned off any BookX modifications to the New Products module and it still shows all new products in the specified timeframe (ADMIN -> configuration -> Maximum Values -> New Product Listing - Limited to ...). I have not been able to test this with a completely fresh shop installation out fo the box, but so far it looks to me that something inside ZC is not working as it should...?

3.) The New Products listing shows BookX info you don't wish to show in your shop.
You are correct, that there are no extra settings for which info to show in New or Upcoming Product Listings. BookX uses the settings made for all product listings, as found in ADMIN -> catalog -> product types -> products Bookx -> edit layout.
I simply did not want to overload the admin interface with all too many settings. Maybe this should indeed be turned into a separate setting for New and Upcoming products?
In the meantime, I would suggest to you to hide the unwanted info via CSS rather than actually going into the template code and deleting something. For this you best make a file stylesheet_bookx_overrides.css (named so it loads after stylesheet_bookx.css )and hide elements like this for example:

Code:

---

#whatsNew .bookxAuthors {
  display: none;
}

---

4.) There are products you wish to show as upcoming, and at the same time allow customers to pre-order them. When you set the stock higher than "0" to allow ordering, BookX no longer marks the product as "upcoming".
I see your problem, however setting the stock higher than "0" on an item which is not actually stocked, means all kinds of grief for your HAL 9000 running Zen Cart. Maybe the setting ADMIN -> Configuration -> Stock -> Allow Checkout points the way to a safer solution, allowing your customers to pre-order out of stock items? Haven't fiddled much with this, so if BookX can add something to make this work, let me know.

5.) Sorting products by date is misbehaving, when products are a mix of "publishing_date" and "date_available".
I have already had some fights making these two dates work together, considering that some people may also have non-book products in theirs shops, which don't even have a publishing date.
I will look into this while working on the next release and try to improve on it.

Does that cover it?

Regards,
philou

Hi
First, thanks for this module, or feature for zencart and bookstore owners.
Just wanted to ask if there is a way to import via csv, just like easy populate.

Thanks !

Hi Mesnitu,

there is currently no CSV or other direkt import of products implemented. However, you could import your products for example via Easy Populate and then convert them to "BookX" product type via [ADMIN] –> Tools -> Bookx Tools. That should save you some time.

Regards,
p.

Hi
Yes, I've done that for testing. But with this module there are a lot of other fields...
I guess I'm asking a kind of feature request. :smile:

Thanks

Quote:

---

Originally Posted by mesnitu

I guess I'm asking a kind of feature request. :smile:

---

That's what I thought :smile:
I see how that would be interesting /useful. However since BookX is still in beta (strictly speaking) my priority is to make everything operational first, before adding icing to the cake.

If you are a little bit technology savvy and have access to your MySQL database via PHPmyadmin or something, you could import products via easypopulate, convert to BookX, export the tables with BookX extra info like ISBN and number of pages etc. Fill in the missing information and re-import into MySQL database. But you really have to know what you are doing with this approach. I wouldn't recommend that to you, if it's the first time you're doing this…

Regards,
p.

Hi Philou,

I've come back to implement version 0.9.4 on the site I was looking at a couple of months ago and I'm getting errors in trying to upgrade.

I've got version 0.9.1 on a site that a client is trialling and I need to update it but when I use the update option in admin it crashes with:

WARNING: An Error occurred, please refresh the page and try again.

I've copied in the files that are in the zip - is it going to be possible to update it or will I need to start again (which won't be good as the client has over 290 products already added in with Authors).

Thanks,

Kinsley

Hi Kinsley,

I sure hope you won't have to start again :-)

When this error occurs in your Admin, do you get a debug file in the folder "[YOUR_ZC_INSTALLATION]/cache" ? In there it could have detailed information about what the error is, so I can find the problem.

If not, I need to set up a store here with 0.9.1 and then try upgrading myself to 0.9.4. to try and reproduce the error.

Best regards,
p.

Hi Philou,

You are dedicated I must say that - very quick response!

I had checked the cache and the logs folder and realised there was no errors in there and so checking configure.php I have realised that it was set to point to a different version of the site - so I fixed the log path and tried again and got:

PHP Fatal 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 'WHERE configuration_key IN ('SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_STATUS'
' at line 2 :: DELETE FROM
WHERE configuration_key IN ('SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_TAGLINE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_PRODUCTS_TITLE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_PRODUCTS_SUBTITLE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_MODEL_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_PRICE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_AUTHOR_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_PUBLISHER_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_GENRE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_SERIES_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_IMPRINT_STATUS'
)

I'll just go and get some dinner and check out what could be causing this.

Hi Red,

do you have a database backup of the state before you tried to run the update the first time?
Might be a good idea to go back to that state, not knowing if possibly part of the update script ran and altered the DB in spite of the error you got the first time.

Looking at the MYSQL error (doesn't specify which table we want to delete from) it could be that you don't have this constant defined in your shop TABLE_PRODUCT_TYPE_LAYOUT_LANGUAGE. I assume you have a single language shop installation? This should be fixed in the installation script, in the meantime you could comment out this entire block of PHP around lines 435 inside [ADMIN]/includes/init_includes/init_product_type_bookx.php like so:

Code:

---

                            /* $sql = "DELETE FROM {$const['TABLE_PRODUCT_TYPE_LAYOUT_LANGUAGE']}
                                                    WHERE configuration_key IN ('SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_TAGLINE_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_PRODUCTS_TITLE_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_PRODUCTS_SUBTITLE_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_MODEL_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_PRICE_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_AUTHOR_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_PUBLISHER_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_GENRE_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_SERIES_STATUS'
                                                    ,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_IMPRINT_STATUS'
                                                    )";
                            $db->Execute($sql); */

---

make sure to also comment out the $db->Execute part.

Have nice dinner,
p.

Yes it looks that way certainly - only ENGLISH currently. Is there a way to add this easily or would it be a big job?

Anyway, I restored to the test version and then commented out the language code and re-run the update.

And now I get:

PHP Fatal 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 'WHERE configuration_key IN ('SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_STATUS'
' at line 2 :: DELETE FROM
WHERE configuration_key IN ('SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_TAGLINE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_PRODUCTS_TITLE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_PRODUCTS_SUBTITLE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_MODEL_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_PRICE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_AUTHOR_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_PUBLISHER_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_GENRE_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_SERIES_STATUS'
,'SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_IMPRINT_STATUS'
)

Many thanks,

Kinsley

I can fix this easily and I still have a 0.9.4revision4 upload pending with the bugfix discussed a few posts below, so it can happen very soon.

However it is very strange, that you are still getting the error. The SQL statement is missing the table name:

Code:

---

DELETE FROM XXX-THE_TABLE_NAME_SHOULD_BE_HERE-XXX
WHERE configuration_key IN ('SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_STATUS'

---

In [ADMIN]/includes/init_includes/init_product_type_bookx.php there is only that section with SHOW_PRODUCT_BOOKX_INFO_METATAGS_TITLE_STATUS etc, so if you are still getting the error, then you are also missing a constant TABLE_PRODUCT_TYPE_LAYOUT which I would expect you have even in a single-language shop?

Anyway, if you just want the quickest possible fix, then comment out the other SQL "DELETE" query just before that as well, since it is just programming hygiene happening here, deleting something that isn't used by Bookx afterall.

Let me know how you get on, so i can use your findings in a bugfix :)

regards,
p.

Ok you may call me an idiot - I was updating the wrong file...

So, I've run it again and it gets a lot further (in fact it says it's successful even though there are a bunch of errors). I'll go through these issues before I come back to you in case I did manage to get it wrong again.

Also, I did add some code in case the constants weren't defined - using a simple if (defined(...)) check.

Ok more basic issues:

Missing constants being defined in english:

TEXT_AUTHOR_DEFAULT_TYPE and TEXT_AUTHOR_TYPE_IMAGE_DIR

Also, after running the update it didn't update the Authors table to include the author_image_copyright field - only making this change in the 0.9.3 version of the code.

Hi Philou,

And finally I have a couple of other constants that are missing:

// Category listing items for product type bookx
define('LABEL_BOOKX_ISBN', 'ISBN: ');
define('LABEL_BOOKX_VOLUME', 'Volume %s');

These are missing from the product_bookx.php file in the lang\english\extra_definitions folder of admin.

I mentioned previously that I was wanting to be able to use the Author Type to distinguish between Authors and Illustrators so allowing the user to use the filtering to restrict based on one or the other - is this going to be an easy fix to implement?

Sorry for being so demanding!

Kinsley

And finally before I leave for the day.

There are various configurations not working so I had a look into the code and it appears I'm missing all of the configuration options of the BookX group.

So as an update from 0.9.1 to 0.9.4 it doesn't include these options!

Sorry for this!

Kinsley

Hi Kinsley,

looks like I best install 0.9.1 in a testshop and see what the updater does.
Just one thing: you do realize that the updates for 0.9.2 / 0.9.3 run right after the changes for 0.9.1, there are no "break" commands in the script..?
I just mention this because you say "only making this change in the 0.9.3 version of the code". Maybe you mean something else?

I will check as soon as I can, but it is quite possible that I won't get to it before Friday this week.

Author type and filtering based on that is implemented in 0.9.4 and I am not aware of any bugs at this time.

regards,
p.

Hi Philou,

Yeah I get that but what I don't understand is that if it doesn't have a break then why does it not have any of those configurations? The config group isn't there so its not even starting to create the configuration lines.

Very odd!

Hi Red,

I will most probably only get to this on Friday this week at the earliest, so I ask you to bear with me until i install a 0.9.1 testshop here and go through the upgrade process myself. But could you clarify for me what exactly you mean by "config group isn't there":
Are you looking in the database table and there is no entry for a BookX config group in the table "dbprefix_configuration_group" ?
Are you stepping through the installation script and variable "$cf_gid" is null ?
Or are you looking at the ZC Admin and there is no entry for Bookx in the menu "Configuration"?

This will help me understand a bit better what is happening.

In the meantime I recommend you resist the temptation to make any manual changes like adding defined clauses in the installation script or commenting out more code, because we will have a state of your files and your database, which will be next to impossible (for me) to troubleshoot. The plugin should really work out of the book in terms of basic functionality like upgrading etc. :)

Regards,
p.

Hi Philou,

That's fine - I'd rather not be making any changes to your code - I'll go through it like you suggest but otherwise (unless I find something obvious) I will wait till Friday for your review.

Thanks,

Kinsley

Hi Philou,

I found out that the reasons were down to missing data from a botched install of your code previously. I've taken on this job from someone else not knowing that the code failed to run successfully first time.

Apologies for wasting your time!

Kinsley

Hi
I'm having a issue, probably not related to the module itself , but I can't seen to get this working.

I'm using tabs to display new, featured and special in the main page.
For some reason when I make the necessary changes to the file new_products.php , all I get it's a blank in the news product tab.

The featured and special are ok, just the new product.
If I comment again the 3 alterations made in that file, everything it's ok , but of course no new bookx products comes up...
If I go to main_page=products_new the bookx products are there....

Thanks

By the way , did anyone already used the bookx modules with the ceon_uri mapping ?

I made a fresh install with 1.51 , and the template that is Responsive Avonlee Contempo Template, and the new products doesn't work...
As I just get a blank tab , I don't know were to look to try to make this work.
There's no error log...
Well , if anyone can point me some way to check for errors, or some tool to debug , or something :blink:

Thanks

Hi Mesnitu,

very difficult to say what the problem is with so little info. Are you sure there is no DEBUG log anywhere? Check this post about where to look for it: http://www.zen-cart.com/content.php?124-blank-page. The DENUG log should give some valuable info about what exactly is going wrong.

Regards,
p.

Hi Kinsley,

is your installation issue completely fixed then? I have now gotten around to install a fresh 0.9.1 on an english only ZC shop and in fact I am missing the Config entries as well. Instead of trying to figure out what went wrong I will now implement a "RESET" option which makes sure all the settings for BookX are in the DB. I have also included your comments on missing language constants, thanks for pointing that out.

I will be rolling all this into a 0.9.4revision 4 update hopefully by monday.

Regards,
p.

Thanks, I'll check that later, but I guess that's what I'm looking, someway to see the error.

I did manage to import the books, using csv . I already had a lot of authors in the metatags, and the author ID to product ID was the one that blast my head.
The only way I found was to use the vlookup function in libreoffice. But for some reason, libreoffice mess things up. Then I try with excel, same thing. Garbage. Then I try google spreadsheet, and imagine that, it made the job.

Anyway , they are there :)

About the filters:

Filter list: Size/Style - What are the options beside 0 or 1 ?
Filter Sidebox - Allow multiple filters active - This should allow multiple selections , right ? Or I'm getting this wrong ?

I would like to ask you, if you are planning to extend this filter to work more or less like the default zencart filter.
Ex: If I select a publisher, the filter should only display the publisher authors, collections, etc.... or if I select a genre, it would display only the authors, publishers, etc of that genre.

Thanks

@Nikerymis

I have just uploaded a version 0.9.4-revision4 to Sourceforge https://sourceforge.net/projects/zencartbookx/files/. It has an updating sorting mechanism for upcoming products, making a mix of publishing date and data available.

Let me know if this works for your shop.

Regards,
p.

Quote:

---

Originally Posted by mesnitu

I would like to ask you, if you are planning to extend this filter to work more or less like the default zencart filter.

---

Dumb question , sorry for that ! The filter does exactly what I was asking !

nobody was hurt, so it's okay ;-)

Hi Philou
As I was importing....or migrating products from the general product to bookx products by cvs, I probably did something wrong, because I'm getting this error when I use the sidebox to filter the publisher.
But this error appears to be looking for some imprint data. I don't have nothing yet on those tables.
Also I don't understand the Not unique "bi"
Can you guide me in this ?
Thanks

Code:

---

PHP Fatal error:  1066:Not unique table/alias: 'bi' :: SELECT DISTINCT bi.bookx_imprint_id, bi.imprint_name
                                          FROM product_bookx_imprints bi  LEFT JOIN product_bookx_extra be  ON be.bookx_imprint_id = bi.bookx_imprint_id  LEFT JOIN product_bookx_publishers bi ON bi.bookx_publisher_id = be.bookx_publisher_id  WHERE 1  AND  bi.bookx_publisher_id = "38"  ORDER by bi.imprint_sort_order, bi.imprint_name  in /home/daniel/lampstack/apache2/htdocs/pb/includes/classes/db/mysql/query_factory.php on line 120

---

Hi
I'm also having another issue, probably related to the index featured, new and special tabs of my template...
Ex: I select a genre A , it displays genre A
But if I reset the genre filter (or any other filter applied) it redirects to : index.php?main_page=index&typefilter=bookx&bookx_genre_id= ,(genres or whatever the filter is) and I get the blank modules....
If I could redirect upon the filter reset to index.php?main_page=index , it would be ok....

Thanks

Hi mesnitu,

at first sight this looks like a bug / mistake in the BookX code. I can only check that out tomorrow. It almost certainly has nothing to do with how you imported you data.

Jusy to be sure, you are using the latest version 0.9.4 ?(I think there was a publisher filter bug similar to this fixed in 0.9.4 revision 2)

Regards,
P.

Yes, 0.9.4r3..... I've downloaded the r4 now, but only tomorrow I'll do the update.

He is reading this from the modules/page/bookx_imprints_lists/header.php , but not sure why...
I've check the extra table , witch was the only one that I didn't do nothing. I was spectating to do something , but went I look, all the data was there from the other csv imports.

ok
Thanks