Loading...
 
Skip to main content

Read count undefined for articles created with Tiki 13+

Status
Closed
Subject
Read count undefined for articles created with Tiki 13+
Version
13.x Regression
14.x
15.x
16.x
17.x
Category
  • Usability
Feature
Article
Resolution status
Fixed or Solved
Submitted by
wagnerax
Volunteered to solve
Philippe Cloutier
Lastmod by
wagnerax, Philippe Cloutier
Rating
(0)
Description

When viewing articles in list, the number of reads is not displayed anymore (option: art_list_reads) on new articles since Tiki 13. Tiki 12 has no problem.

The bug was introduced in revision 49060. New articles now have tiki_articles.nbreads NULL rather than 0.

Image

Solution

Solved for Tiki 17 via r63367
Solved for Tiki 16 via r63368
Solved for Tiki 15 via r63369


These solutions prevent future articles from having inoperant counters, but does not fix the counters of articles which were created while the bug prevailed. Such articles can be fixed with the following SQL queries:
UPDATE tiki_articles SET nbreads=0 WHERE nbreads IS NULL;
UPDATE tiki_submissions SET nbreads=0 WHERE nbreads IS NULL;

However, these queries set the number of reads to 0 instead of the actual number of reads which happened since their creation, which can be misleading.

Starting from Tiki 18, these queries can be executed by running

Copy to clipboard
php console.php patch optional_20170801_initialize_article_nbreads_tiki
Importance
5
Easy to solve?
8
Priority
40
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
6014
Created
Friday 01 July, 2016 14:05:31 UTC
by wagnerax
LastModif
Thursday 03 August, 2017 13:41:42 UTC


Show PHP error messages