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.
Printable View
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.
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:Quote:
Originally Posted by Desmat
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.
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:
Originally Posted by Desmat
Good point, should be easy to implement.Quote:
3. Resetting the filter takes the navigation to the home page , instead of leaviing on the same page
Yes, this is not yet implemented, but planned behaviour for a next release.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
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("", " – <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 " · ") 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:
by these lines:Code:$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.Code:if(!empty($extra_where_condition)) {
$expected_query = str_replace(' p.products_date_available ', ' (p.products_date_available ', $expected_query);
}
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:
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".Code:#whatsNew .bookxAuthors {
display: none;
}
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 !