Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: Error in front-end in publisher when dynamic channel queries cache is on

Status Resolved
Add-on / Version Publisher 2.7.5
Severity
EE Version 3.5.12

Kevin Chatel

Feb 19, 2018

Description:

Cache dynamic channel queries is set to On

Fatal error: Uncaught Error: Call to a member function num_rows() on null in /data/html/system/user/addons/publisher/ext.publisher.php:624 Stack trace: #0 /data/html/system/ee/legacy/libraries/Extensions.php(243): Publisher_ext->channel_entries_query_result(Object(Channel), Array) #1 /data/html/system/ee/legacy/libraries/Extensions.php(138): EE_Extensions->call_class(‘Publisher_ext’, ‘channel_entries…’, Array, Array) #2 /data/html/system/ee/EllisLab/Addons/channel/mod.channel.php(2397): EE_Extensions->call(‘channel_entries…’, Object(Channel), Array) #3 /data/html/system/ee/EllisLab/Addons/channel/mod.channel.php(297): Channel->parse_channel_entries() #4 /data/html/system/ee/legacy/libraries/Template.php(1712): Channel->entries() #5 /data/html/system/ee/legacy/libraries/Template.php(1349): EE_Template->process_tags() #6 /data/html/system/ee/legacy/libraries/Template.php(553): EE_Template->tags() #7 /data/html/sys in /data/html/system/user/addons/publisher/ext.publisher.php on line 624


Detailed steps to reproduce the issue:
1.
2.
3.

#1

BoldMinded (Brian)

What other add-ons do you have installed? Are you able to replicate this in a clean EE environment?

I know why it would throw that error, and due to where the error is coming from in the code would need to be able to debug the code, so I’d need FTP and CP access, preferably to a clean EE environment, or at the very minimum a very stripped down template in your current environment with only an entries tag in it with the minimum number of entries necessary to replicate the issue. No other styles, or template code, extensions etc just the bare minimum. I’ll be debugging queries, so the fewest I have to look at the easier it’ll be.

If you wanted to do some preliminary debugging you can go to Service/Entry/EntryResult.php line 911 where the getModifiedEntriesQuery() function is and var_dump($currentQueries);

#2

BoldMinded (Brian)

Closing this ticket bc it’s been over a month with no response.

Login to reply