PARINetwork / pari

Django/Wagtail based PARI webapp
http://ruralindiaonline.org
BSD 3-Clause "New" or "Revised" License
37 stars 11 forks source link

Translator credit has disappeared. Translator slug remains empty #298

Open siddadel opened 6 years ago

siddadel commented 6 years ago

If you run this query, it gives info on whole host of translator content

select author_author.slug, count (article_id) 
from article_article_translators, article_article, author_author
where article_id=page_ptr_id and
author_author.id = article_article_translators.author_id
group by author_author.slug order by count desc;

or

select * from article_article_translators, article_article, author_author
where article_id=page_ptr_id and
author_author.id = article_article_translators.author_id and
name = 'Rashmi Rekha  Das'

It returns all the articles written by Rashmi Rekha Das

But say if you go to any of these article e.g. https://ruralindiaonline.org/articles/চৰাঞ্চলবাসীৰ-সংগ্ৰাম

which was translated by Rashmi Rekha Das, her name does not appear under the Author credit (below the article) as Translator credit.

Also as an author her slugh "rashmirekha-das" should yield an author's page https://ruralindiaonline.org/authors/rashmirekha-das

The author's page works but it does not have any articles.

siddadel commented 5 years ago

Author page should have 3 different sections -- Articles, Translations and Photos