Bocq

Dear codepeople,

I guess I have a similar issue. No changes can be saved.
The Query Monitor says:
“Row size too large.”
and
“Unknown column ‘vs_text_nmore’ in ‘field list'”

I should have the last unpaid version, like I uninstalled and installed the plugin again.
Thank you for your help.

@crescendoweb : Thanks a lot, it worked for me.

Select-Theme sent an upadte for the Theme Stockholm yesterday (13.04.2016, the mail from 12.04.16 has to be ignored). The Version of the Visual Composer in this update is the right one. Once Theme and Visual Composer are updated, everything should be fine again (that’s how it was by all my sites).

Thanks a lot.

Well, I hope the author can soon help us…

Her is how “my” script for the entire list would look like in your case:

<ul class="nav-listing clearfix">

        <li><a href="#" data-filter="*" class="selected"><span></span><?php _e('Show All','sampression'); ?></a></li>
       <?php

		$args = array(
		'exclude'=>  array(1)
		);
		$categories = get_categories($args);
        foreach($categories as $category):
        ?>
        <li><a href="javascript:void(0);" data-filter=".<?php echo $category->slug; ?>" id="<?php echo $category->slug; ?>" class="filter-data"><span></span><?php echo $category->name; ?></a></li>
        <?php
        endforeach;
        ?>
    </ul>

Hello

the other post from your category-1, “Ruszamy”, ist also schown on the home page. So it seems like your “exclude” does not work.
I think we don’t habe exacttlx the same problem: my “exclude” works by loading of the home-page but not any more when you choose “show all” once more.

Have you wrote

$args = array(
  'exclude' => array(1)
);

?

Hello jurgiel,
would you send me teh URL you are talking about?
Maybe it can help me.
Thank you.

Bonjour!
I have excluded some categories like jurgiel did and this works nice.
But when “show all” is selected again, all categories are shown.
Where can I change this?
Thanks a lot.

The Test Site:
https://www.wp.pep-berlin.de/wp/

The code:

<ul class="nav-listing clearfix">

        <li><a href="#" data-filter="*" class="selected"><span></span><?php _e('Show All','sampression'); ?></a></li>
       <?php
		/*to exclude some categories */
		$args = array(
		'exclude'=>  array(8,9,10,11,12)
		);
		$categories = get_categories($args);
        foreach($categories as $category):
        ?>
        <li><a href="javascript:void(0);" data-filter=".<?php echo $category->slug; ?>" id="<?php echo $category->slug; ?>" class="filter-data"><span></span><?php echo $category->name; ?></a></li>
        <?php
        endforeach;
        ?>
    </ul>

Great, thanks a lot, Stefan 83.
I use the Theme Sampression Lite and needed your Code to point directly to the websites of my clients.
https://www.bocqbox.de

Bonjour!
I’ve tried the 3 solutions and finally used the one of Michael in the topic 337364
To filter the actual category, I have included a variable
<?php $currentCat = get_query_var(‘cat’); ?>
and an argument
‘category__in’ => array($currentCat)

It works!
Sometime, a lonely title get lost and doesn’t appear properly alphabetically. I’ve search for forgotten spaces in the titles but could not find any real reason.

Anyway, THANKS a lot (I will check If I can also bring a contribution by the translations into French).

Here is the result https://valentine-meunier.de/wordpress/

And here is the code

<?php $currentCat = get_query_var('cat'); ?>
<?php
$args=array(
    'orderby' => 'date',
    'order' => 'ASC',
    'posts_per_page' => 1,
    'caller_get_posts'=>1,

);
$oldestpost =  get_posts($args);

$args=array(
    'orderby' => 'date',
    'order' => 'DESC',
    'posts_per_page' => 1,
    'caller_get_posts'=>1,

);
$newestpost =  get_posts($args);

if ( !empty($oldestpost) && !empty($newestpost) ) {
  $oldest = mysql2date("Y", $oldestpost[0]->post_date);
  $newest = mysql2date("Y", $newestpost[0]->post_date);

  for ( $counter = intval($newest); $counter >= intval($oldest); $counter = $counter - 1)  {

    $args=array(
      'year'     => $counter,
      'posts_per_page' => -1,
      'orderby' => 'title',
      'order' => 'ASC',
      'caller_get_posts'=>1,
	  'category__in' => array($currentCat)

);

    $my_query = new WP_Query($args);
    if( $my_query->have_posts() ) {
      echo '<h2 class="jahr">' . $counter . '</h2>';
      while ($my_query->have_posts()) : $my_query->the_post(); ?>
	    <h2 class="author"><?php the_title(); ?></h2>
 				<div class="entry">
					<?php the_content() ?>
				</div>
      <?php
        //the_content('Read the rest of this entry &raquo;');
      endwhile;
    } //if ($my_query)
  wp_reset_query();  // Restore global post data stomped by the_post().
  }
}
?>

Thanks both of you!
I have only tried alchymyth’s solution for now.
Now I only have to find my category again. I’m going ahead!

All right. The following code is still wrong, but could you tell me if it is the direction I should search in?

<?php $one_year = $wpdb->get_col("SELECT DISTINCT YEAR(post_date) FROM $wpdb->posts WHERE post_status = 'publish' ORDER BY post_date DESC"); ?>
	<?php foreach($one_year as $year) : ?>
		<?php while (have_posts()) : the_post(); ?>
			<?php query_posts($one_year. 'orderby=title&order=ASC' );?>
			<p><?php the_date('Y') ?></p>
			<h2 id="post-<?php the_ID(); ?>"><?php the_title(); ?></h2>
			<p><?php the_content() ?></p>
		<?php endwhile; ?>
	<?php endforeach; ?>

ok, but please don’t laugh (or cry)

<h2 class="pagetitle"><?php echo category_description(); ?></h2>
<?php $one_year = get_the_time('Y'); ?>
<?php foreach($one_year as $year) : ?>
	<?php while (have_posts()) : the_post(); ?>
	<?php echo get_year_link($one_year); ?>">Archive for the year <?php the_time('Y') ?>
	<?php query_posts($one_year. 'orderby=title&order=ASC' );?>
	<h2 id="post-<?php the_ID(); ?>"><?php the_title(); ?></h2>
	<p><?php the_content() ?></p>
	<?php endwhile; ?>
<?php endforeach; ?>

I’ll do it right now, Michael.