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

[philou]

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.

[philou]

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.

[mesnitu]

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

[philou]

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

[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 !

[philou]

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

[mesnitu]

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

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

[mesnitu]

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

[philou]

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.

[mesnitu]

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