Forum Replies Created

Viewing 15 replies - 1 through 15 (of 35 total)
  • @corrinarusso It’s a pretty hefty Woocommerce site. I think there are definitely some

    I tried to find a workaround, using this tutorial , but I couldn’t find where the my.cnf file was in MAMP.

    So it sounds like I may have to chunk it out and export/import a batch of tables at a time?

    @corrinarusso Hmm, seems like my database might be even too large to do it this way as well. The database is 9GB.

    I used this command in terminal:

    /Applications/MAMP/Library/bin/mysql -u root -p ab964b9d_6e5f38 < /Users/labedzde/Downloads/ab964b9d_6e5f38.sql

    And I received this error message in response:

    ERROR 2006 (HY000) at line 5253794: MySQL server has gone away

    Thanks so much for the reply @corrinarusso! I actually ended up fixing part of the problem just by updating my version of MAMP. I didn’t think jumping from 5.5 to 5.7 would be such a big deal, but oh well, I was then able to access all my MAMP sites again.

    Yes, I was trying to import the database using phpMyAdmin, which of course failed, so I then tried to edit the php.ini file and that’s where I ran into trouble.

    I will try using the command line instead. Might be the best option with such an enormous database.

    Hello! I updated the version of Yoast SEO to the current one, and that did not solve the no index, no follow issue.

    It also created another issue. I’m getting an error about not being able to create database tables.

    Again the site I’m talking about is https://www.learncharter.org/

    Hmm. I was using the next/previous post links found here: https://codex.wordpress.org/Function_Reference/next_post_link

    I didn’t see anywhere on the page saying this was deprecated.

    I just want the filter to affect this query.

    Here’s how I’ve added the filter to my query:

    
    	<?php 
    
    $args = array(
    'post_type' => 'people',
    'orderby'   => 'title',
    'order' => 'ASC',
    'tax_query' => array(
    array(
    'taxonomy' => 'people',
    'field' => 'slug',
    'terms' => 'njapf'
    )
    )
    );
    
    add_filter( 'posts_orderby', 'posts_orderby_lastname' );
    //$query = new WP_Query( $args ); // this line is useless in your code
     
    // The Query
    $the_query = new WP_Query( $args );
    
     
    // The Loop
    if ( $the_query->have_posts() ) {
    while ( $the_query->have_posts() ) {
    $the_query->the_post();
    
    echo '<div class="artist-grid-item">';
    
    if(has_post_thumbnail()){
    
    	echo '<a href="'. get_permalink() . '">';
    
                   echo '<div class="artist-grid-image">' . get_the_post_thumbnail( $_post->ID, 'large' ) . '</div>';
                 }
    
    echo '<p>' . get_the_title() . '</p>';
    
    echo ' </a></div>';
    
    }
    
    } else {
    // no posts found
    }
    
    remove_filter( 'posts_orderby', 'posts_orderby_lastname' );
    
    /* Restore original Post Data */
    wp_reset_postdata();?>

    It re-ordered the posts, so something happened, but not what was expected. They’re not ordered by last name, but appear to be in some sort of random order.

    Again, here’s my filter that I added to functions.php:

    function posts_orderby_lastname ($orderby_statement) 
    {
      $orderby_statement = "RIGHT(post_title, LOCATE(' ', REVERSE(post_title)) - 1) DESC";
        return $orderby_statement;
    }

    I wonder if there’s an issue with that instead.

    Thanks for your reply! This is not the CPT archive page, it’s a custom page template where I’m displaying posts from the “njapf” taxonomy term within the “People” CPT.

    I’m ok if all other instances of the “People” CPT are sorted by last name (second word of title).

    Given that, which method might be best for implementing the filter?

    Yep, of course I realized my syntax error shortly after posting the question. Thanks for checking in! This issue is, indeed, resolved.

    bibliofille

    (@bibliofille)

    I was trying to use this method that I found in the codex in my example: https://codex.wordpress.org/Plugin_API/Filter_Reference/single_template

    But perhaps this won’t work for what I’m trying to do because it’s coming from the Plugin API?

    I found the Codex link through this StackExchange question, and was trying to employ the same approach: https://wordpress.stackexchange.com/questions/113991/custom-post-type-taxonomy-single-templates

    Thanks for the suggestion! Would I need to re-write my loop to work around this code or place it before or after my current loop?

    No, I’m trying to figure out how to separate the posts in the grid under an <h5> that outputs only the month and year.

    If I could attach a screenshot from the mockup, that’d be easier.

    Yep, the issue was ACF. I dug through their forums and found a reference to this helpful post: https://adambalee.com/search-wordpress-by-custom-fields-without-a-plugin/

    Worked like a charm!

    Thanks for the tip. Hmm, I tried deactivating all the plugins, however, a lot of my content is served using ACF Pro, so when I deactivate that, there’s virtually nothing left to search, except a couple pieces of content that are hard coded within the template.

    But the search form should pick up that data since it’s stored in the database, no?

    I am using Bones as a starter theme, and I couldn’t find any place within functions.php or bones.php where it looked like the theme itself was altering search functionality.

    Ok, here’s the code I’m now using for the events grid:

    <div class="event-container">
    
    							
    
    							<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
    
    							<div class="event-item">
    
    							<h5><?php
    $categories = get_the_category();
    $separator = ' ';
    $output = '';
    if($categories){
        foreach($categories as $category) {
    if($category->name !== 'open to public') 
    {
            $output .= '<a href="'.get_category_link( $category->term_id ).'" title="' . esc_attr( sprintf( __( "View all posts in %s" ), $category->name ) ) . '">'.$category->cat_name.'</a>'.$separator; }
        }
    echo trim($output, $separator);
    }
    ?>
    </h5>
    
    							<div class="<?php if ($category->name == 'open to public') : ?> 'special-category' <?php endif; ?>">
    
    							
    
    									<h4><a href="<?php the_permalink() ?>" rel="bookmark" title="<?php the_title_attribute(); ?>"><?php the_title(); ?></a></h4>
    									
    									<p><?php the_field('event_date'); ?> | <?php the_field('event_start_time'); ?> - <?php the_field('event_end_time'); ?></p>
    
    									<p><?php the_field('event_description'); ?> <a href="mailto:<?php the_field('event_rsvp_email'); ?>"><?php the_field('event_rsvp_email'); ?></a></p>
    
    				
    
    </div>
    							<?php endwhile; ?>
    
    						
    
    							<?php endif; ?>
    
    						
    
    						</div>
    
    					</div>

    It’s getting close, but it’s not quite there. I don’t see the notice error anymore, but I’m also not seeing that “special-category” is added as a class when I look at the page using Chrome inspector. It lists an “undefined variable” error in view source, but not on the front end of the page.

    And I really need the category name to appear at the bottom of the event item div.

    Is there no way to wrap the entire event item in a div IF the category is “open to public”, then display that category name AFTER the rest of the content?

    I tried to implement a solution, but I must be doing something a bit off, because it’s not working.

    Here’s the full code for the events post grid. I tried to add the suggested code from @danieltj to add a div inside the “event-item” div called “special-category” IF the category is “open to public”.

    <div class="event-container">
    
    							
    
    							<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
    
    							<div class="event-item">
    
    								<?php if ($category->name == 'Open to Public'); ?>
    
    <div class="<?php if ($category->name == 'Open to Public') : ?> special-category <?php endif; ?>">
    
    									<h4><a href="<?php the_permalink() ?>" rel="bookmark" title="<?php the_title_attribute(); ?>"><?php the_title(); ?></a></h4>
    									
    									<p><?php the_field('event_date'); ?> | <?php the_field('event_start_time'); ?> - <?php the_field('event_end_time'); ?></p>
    
    									<p><?php the_field('event_description'); ?> <a href="mailto:<?php the_field('event_rsvp_email'); ?>"><?php the_field('event_rsvp_email'); ?></a></p>
    
    <h5><?php
    $categories = get_the_category();
    $separator = ' ';
    $output = '';
    if($categories){
        foreach($categories as $category) {
    if($category->name !== 'open to public') 
    {
            $output .= '<a href="'.get_category_link( $category->term_id ).'" title="' . esc_attr( sprintf( __( "View all posts in %s" ), $category->name ) ) . '">'.$category->cat_name.'</a>'.$separator; }
        }
    echo trim($output, $separator);
    }
    ?>
    
    </div>
    
    							<?php endwhile; ?>
    
    						
    
    							<?php endif; ?>
    
    						
    
    						</div>

    I put it in wp_debug mode and got the following notices:

    Notice: Undefined variable: category in /Users/labedzde/Documents/Sites/cgla/wp-content/themes/cgla/archive-events.php on line 25

    Notice: Trying to get property of non-object in /Users/labedzde/Documents/Sites/cgla/wp-content/themes/cgla/archive-events.php on line 25

    Line 25 is this:
    <?php if ($category->name == 'Open to Public'); ?>

    So, I must be doing something wrong there?

Viewing 15 replies - 1 through 15 (of 35 total)