antoniowp

Problem solved here.

We need to change AllowOverride None to AllowOverride All in two places.

Not in file /etc/apache2/apache2.conf, but /etc/apache2/sites-available/default instead.

Thanks.

I need an automated newsletter.

Is it possible to use a PHP template?

In case it is not and the one choice is HTML editing or creating a custom template, I guess I must use the token syntax “%title1%” for content and html comments marks for the automated module.

?Only title and excerpt may be used are tokens?

Thanks!

Just in case it helps, this SQL query in $wpdb has been working right:

<?php
    $postnr = 8; //number of posts
    $catid = 7;  //category of posts to fetch
    $consulta = "
        SELECT MAX($wpdb->posts.ID) AS ID, $wpdb->posts.post_author, $wpdb->posts.post_title
        FROM $wpdb->posts
        INNER JOIN (SELECT MAX($wpdb->posts.post_date) AS fecha, $wpdb->posts.post_author AS autor
        FROM $wpdb->posts
        JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id)
        JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
            AND $wpdb->term_taxonomy.taxonomy = 'category'
            AND $wpdb->term_taxonomy.term_id = $catid)
         WHERE $wpdb->posts.post_type = 'post'
            AND $wpdb->posts.post_status = 'publish'
            AND $wpdb->posts.post_date < NOW()
         GROUP BY autor
         ORDER BY fecha DESC
         LIMIT $postnr) AS consulta
    ON $wpdb->posts.post_date = fecha AND $wpdb->posts.post_author = autor AND $wpdb->posts.post_status = 'publish'
    GROUP BY $wpdb->posts.post_date, $wpdb->posts.post_author
    ORDER BY $wpdb->posts.post_date DESC
"; ?>

As it is using NOW() SQL function, beware of time change in daylight saving timezones.

Maybe solutions commented by wspencer and chase also do the job but as this is working it is enough for me. I guess it is a very heave query but I can’t see any other simple query.

The alternative is using a dynamic blogroll.

Switched to 20-11 and then it works. Definitely it has to do with the theme. I would have never guessed.

Thank you very much!

Thank you esmi.

I’m sorry I don’t understand.

The topic is already in WP-Advanced, thanks to Jan.

The topic is not about publishing in this forum, but the question about custom query I am asking.

Anyway for future questions I will consider your comment.

Thank you.

Thank you Jan.

Clicking on “Add new” in WP-Advaced takes me to the end of the page where I can read:

“New Topic in this Forum
Only moderators can post or move things into this forum.”

But no new-topic form is loaded.

Thank you.

Is it difficult to develop a custom theme? (I’m not PHP developer, should learn first).

Should I do it from scratch? is it possible to being with one theme and extend it?

I have asked for themes help:

https://www.ads-software.com/support/topic/themes-templates-for-news-site?replies=1

Michael: Thank you.

Regarding themes probably I should ask in ‘themes’ forum for some good advice.

The requirement is simply a full digital news paper: front page composition; news with title, sub-title and heading paragraph; sections; comments; articles; blogs; widgets (advertising, weather, polls, stock exchange…) and so forth. Nothing else specially.

You are right, and that is what I aim to do, I’m just asking for delimit the number of CMS to try, there are dozens! I think I will try WordPress and Drupal and then see.