Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter tanguillo

    (@tanguillo)

    You’re welcome. And you’re completly right, I just change that ??

    Thread Starter tanguillo

    (@tanguillo)

    Ok, I think I solved. I add
    AddDefaultCharset UTF-8

    to the .htaccess file (between the <IfModule mod_rewrite.c> of the WPSuperCache block)

    Thread Starter tanguillo

    (@tanguillo)

    Ok, I discover what it is. I don’t know exactly why, but in the query to show the list of most popular post, the join and a clause where of the the category query is add. To show you exactly what I mean:
    This is the correct query, as it was use in all the pages but the home:

    SELECT ID, post_title FROM wp_posts LEFT JOIN wp_ak_popularity pop ON wp_posts.ID = pop.post_id WHERE post_status = 'publish' AND post_date < NOW() ORDER BY pop.total DESC LIMIT 10

    And this is how was use it in the home page:

    SELECT ID, post_title FROM wp_posts LEFT JOIN wp_ak_popularity pop ON wp_posts.ID = pop.post_id LEFT JOIN wp_post2cat ON wp_post2cat.post_id = wp_posts.ID WHERE post_status = 'publish' AND post_date < NOW() AND wp_post2cat.category_id NOT IN (19) ORDER BY pop.total DESC LIMIT 10

    I dont know to reason of it. I was using just the function: akpc_most_popular()

    Anyway, I was able to resolved that commenting the lines 1357, 1358 and 1359:

    //		$join = apply_filters('posts_join', '');
    //		$where = apply_filters('posts_where', '');
    //		$groupby = apply_filters('posts_groupby', '');

    Probably not the best solution, but working so far. And I star to use the akpc_most_popular_in_cat and it work correctly to.

Viewing 3 replies - 1 through 3 (of 3 total)