Short code method not working once it get some many post in it..

Anonymous

#69222

http://insertionorder.wpengine.com/accounts/ There is over 9000 post in a custom post type and it shows results and will filter up until the cache get a certain amount in it. Will the plugin not work with 1000 up on 1000 of post. Also I setup an archive page here http://insertionorder.wpengine.com/account/ to at least have them all showing. I am using shortcode methode to show results. Here the custom results code.

<?php
/**
 * Search & Filter Pro 
 *
 * Sample Results Template
 * 
 * @package   Search_Filter
 * @author    Ross Morsali
 * @link      http://www.designsandcode.com/
 * @copyright 2015 Designs & Code
 * 
 * Note: these templates are not full page templates, rather 
 * just an encaspulation of the your results loop which should
 * be inserted in to other pages by using a shortcode - think 
 * of it as a template part
 * 
 * This template is an absolute base example showing you what
 * you can do, for more customisation see the WordPress docs 
 * and using template tags - 
 * 
 * http://codex.wordpress.org/Template_Tags
 *
 */

if ( $query->have_posts() )
{
	?>
	   <table width="100%" border="0">
                    <tbody>
                      <tr class="tableheader">
						  <td colspan="1"><strong>Customer Name</strong></td>
						  <td colspan="1"><strong>Address</strong></td>
				
						  <td colspan="1"><strong>Sales Person</strong></td>
                      </tr>
	
<?php
	while ($query->have_posts())
	{
		$query->the_post();
		
		?>

  <tr>
    <td colspan="1"><?php the_title(); ?></td>
    <td colspan="1"><p style="font-size: 8px;"><?php  echo "".types_render_field("address-line-1", array("output"=>"HTML"));?></p>
		<p style="font-size: 8px;"><?php  echo "".types_render_field("address-line-2", array("output"=>"HTML"));?></p>
		<p style="font-size: 8px;"><?php  echo "".types_render_field("address-line-3", array("output"=>"HTML"));?></p>
		<p style="font-size: 8px;"><?php  echo "".types_render_field("city", array("output"=>"HTML"));?></p></td>
 
    <td colspan="1"><?php  echo "".types_render_field("sales-person", array("output"=>"HTML"));?></td>
  </tr>
<?php
	}
	?>
 </tbody>
                            </table>
 <div class="pagination">
		
		
		<?php
			/* example code for using the wp_pagenavi plugin */
			if (function_exists('wp_pagenavi'))
			{
				echo "<br />";
				wp_pagenavi( array( 'query' => $query ) );
			}
		?>
	</div>

<?php
}
else
{
	echo "There were no accounts found :( ";
}
?>

Hope you can help get this resolved please. Thank you.

Ross Moderator

#69238

Hey Jason

This is WP Engine killing long (length in characters) queries…

There is a constant you can use to prevent WP Engine from doing this:
https://support.searchandfilter.com/forums/topic/killed-query-errors-in-log/#post-64826

Hope that helps

Thanks

Anonymous

#69240

Worked Perfectly! Thank you!

[Author]

Posts