Featured Products - View All - showing blank page

[BlackOrchidCouture]

Hi, I just discovered that if you go to my Featured Products page and click View All, it shows a blank white page with WARNING: An Error occurred, please refresh the page and try again.

The debug logs show this:

[13-May-2015 14:52:24 America/Los_Angeles] PHP Warning:  mysqli_query(): Empty query in /home/xxx/public_html/store/includes/classes/db/mysql/query_factory.php on line 43
[13-May-2015 14:52:24 America/Los_Angeles] PHP Fatal error:  0: ::  ==> (as called by) /home/xxx/public_html/store/includes/classes/split_page_results.php on line 54 <== in /home/xxx/public_html/store/includes/classes/db/mysql/query_factory.php on line 155

I'm not sure where to begin figuring out the root of this problem. I looked at those two files mentioned in the debug log, and by the date I can tell that I haven't modified them in any way.

Any ideas how to figure out the problem? Thanks!!

[frank18]

Hi, I just discovered that if you go to my Featured Products page and click View All, it shows a blank white page with WARNING: An Error occurred, please refresh the page and try again.

The debug logs show this:

[13-May-2015 14:52:24 America/Los_Angeles] PHP Warning:  mysqli_query(): Empty query in /home/xxx/public_html/store/includes/classes/db/mysql/query_factory.php on line 43
[13-May-2015 14:52:24 America/Los_Angeles] PHP Fatal error:  0: ::  ==> (as called by) /home/xxx/public_html/store/includes/classes/split_page_results.php on line 54 <== in /home/xxx/public_html/store/includes/classes/db/mysql/query_factory.php on line 155

I'm not sure where to begin figuring out the root of this problem. I looked at those two files mentioned in the debug log, and by the date I can tell that I haven't modified them in any way.

Any ideas how to figure out the problem? Thanks!!

Look at

https://www.zen-cart.com/content.php...t-of-a-page%29

[BlackOrchidCouture]

Hi, thanks for posting on this. I looked at that page, and I enabled strict error reporting just long enough to see what would happen on the Featured Products - All page, and this is all I saw on the page:

0
in:
[]

So it doesn't tell me much except that somehow I think it can't access the database for all featured products so nothing is being returned. I looked at my tables in my database, and there is one called featured, is there supposed to be another one for all featured products? Probably not.

Anyway, I found a quick workaround which will at least allow that page to never be accessed, under admin/configuration/maximum values, if I have the Products Listing- Number Per Page at a number larger than the number of featured products I have, then they all show on the page so there's no View All button, so no need to access that page. That should work for now, the place this showed up was in Webmaster Tools, the page showed a server error. Hopefully google can bypass it now....

If anyone can think of a way to fix it I'd still love to, just don't like knowing that there are errors, even if the page won't be accessed! Thanks!!!!