ZenTools2 modules providing errors if the parent category has no items in it?

scarney

I am having a problem where ZenTools2 is causing page errors if I try to have it display child categories for a category for which there is no blog in the parent category.

This is the error message:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-08-09 02:15' at line 3
You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.
Please try one of the following pages:

Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below.

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 ') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-08-09 02:15' at line 3

I created a ZenTools2 module which is currently unpublished which you can turn on temporarily to see the problem.

The parent menu item is Shop -> Amazon Storefront -> Books (category named Amazon Books)

This is where the module will be displayed in sidebar2. But, if you turn on the module the page will no longer be available. And, not only that but the child categories will also become unavailable.

https://www.drcarney.com/shop/amazon-storefront/books/cookbooks

https://www.drcarney.com/shop/amazon-storefront/books/nutrition-diet

Joshua-M

Hi,

Did you solve the issue? Because I've enabled this Zentool2 module and can't see the error message on the following pages:
https://www.drcarney.com/shop/amazon-storefront/books/cookbooks
https://www.drcarney.com/shop/amazon-storefront/books/nutrition-diet

Please make sure you've cleared the browser's cache..

Cheers
Joshua

scarney

I am sorry but I forgot to give the name of the module I was testing. It is called "Amazon Books TEST"

I just found it UNPUBLISHED. When I published it then I got the error messages. I did clear the cache on the server and then launched a different web browser and still get the error message.

The modules that I placed on the two pages which you listed above worked just fine because there are published EasyBlog posts in the associated categories. Those two modules are named "Cookbooks" and "Nutrition & Diet".

I think the reason that the test module is not working is because it is trying to display EasyBlog posts that are in the books category. But, there are NOT books in the books category. They are all published in the child categories.

Sean

Joshua-M

Hi,

I can see the error now..
If you disable "Also on child items" option from module zentools2 Assignments tab it works properly on the parent page?

Cheers
Joshua

scarney

Joshua-M If I turn off the child items then it only breaks the parent page. But, the whole point for me is that the parent should be displaying the items from the children. So, either way it is broken.

Thanks, Sean

paulus1031

Hi Sean,

I've tested this on one of my test sites and it works ok

Are we ok to create content and a new module and publish it to your site?
Do you get the same on any test / development sites?

Cheers
Paul

scarney

paulus1031 Yes, you can. But, now that I set you up with a test site maybe you can also consider doing it there since it is a copy of the same site. The credentials are in my thread about Colourshift2. :-)

scarney

https://dev1.carneycorner.com

paulus1031

ok will look at doing this tomorrow

Cheers
Paul

scarney

Thank you. In this case I have changed the access information above to be this test server instead of the main web site like we did with the other ticket that I have open now.

Sean

paulus1031

Hi Sean,

Is the site ok on this server?

As my malware scanner blocks access to the site reporting malware

Cheers
Paul

paulus1031

scarney

paulus1031 OK. Very interesting. I will be asking my host to look at this.

Thank you, Sean Carney

paulus1031

Thanks Sean

Once you let me know I will ask the team to look at the problem - I can't at the moment given the warnings on the site

scarney

The host ran a report that found a problem which was riskware but when we chased it down it was very humorous. we have an article on our site titled "Is Vegan the New Viagra" located at https://www.drcarney.com/blog/entry/is-vegan-the-new-viagra

And, we have other blogs and articles that link to it. The word Viagra and the link to the word viagra got marked as riskware.

Sean

paulus1031

Thanks Sean

paulus1031

How are we able to access the database?

I'm not sure of the setup on cloudhost

Cheers
Paul

scarney

paulus1031 Good question. They have their own control panel and I should be able to give you access but it may be that I have to create an account for you. Let me ask them and get you an answer ASAP. What email should I use if I need to create you an account there?
Sean

scarney

Here is the url with the instructions. It looks complicated because of all the options but it is not. Just scroll to the instructions at the bottom. I will create an account for you and give you the login and password up above shortly.

https://www.cloudaccess.net/cloud-control-panel-ccp/155-application-management/240-accessing-a-mysql-database-remotely.html

scarney

The database access has been created. I just updated the access instructions above. Please let me know if you have any problems.

Sean