View Count Zero (0, Incorrect)

[iacas]

http://thesandtrap.com/forums/forum/7-tour-talk/

I searched, and I swear I've seen this discussed elsewhere, but how can a topic have 30 replies but 0 views? Why are the views for so many of these things showing zero? What can be done to fix this?

 

[FabioPaz]

I have the same problem, this will be corrected in the next update that will be launched very soon (words from the support)

edit: Ah, and the views aren't lost, after the patch it will show the correct views.

[iacas]

4 hours ago, FabioPaz said:

I have the same problem, this will be corrected in the next update that will be launched very soon (words from the support)

edit: Ah, and the views aren't lost, after the patch it will show the correct views.

Thanks. In 4.1.5?

[Stuart Silvester]

28 minutes ago, iacas said:

Thanks. In 4.1.5?

Yes, there will be a fix for this in 4.1.5.

[iacas]

6 minutes ago, Stuart Silvester said:

Yes, there will be a fix for this in 4.1.5.

Thank you.

[Jean-Philippe]

I'm testing IPS 4.1.6 and I still have this problem of views count (on forums) always at "0" (zero)

Any solution ?

[Luis Manson]

Same here :\

[Jesse Rapczak]

Go to System>Advanced Configuration and click on the "View Tasks" link. Then find the "viewupdates" task and run it (play button). If after you do that your views are now back to normal, it means you haven't configured your cron tasks to run properly.

[bradl]

Weird, I have views o'plenty but  some topics show 0 replies where there are many. Have forced several likely looking tasks to run (as above) but reply count does not update).

[Luis Manson]

i had this same feeling, saw the code, checked table rows and started the task again:

explain SELECT classname, id, COUNT(*) AS count FROM `gacore_view_updates` AS `core_view_updates` GROUP BY `classname`,`id` LIMIT 20;
+------+-------------+-------------------+------+---------------+------+---------+------+---------+---------------------------------+
| id   | select_type | table             | type | possible_keys | key  | key_len | ref  | rows    | Extra                           |
+------+-------------+-------------------+------+---------------+------+---------+------+---------+---------------------------------+
|    1 | SIMPLE      | core_view_updates | ALL  | NULL          | NULL | NULL    | NULL | 1249247 | Using temporary; Using filesort |
+------+-------------+-------------------+------+---------------+------+---------+------+---------+---------------------------------+
1 row in set (0.00 sec)

 

actually it take its time without explain (6.5secs on a SSD)

the row count decreased at least...now, what index can i make to speed this!?

[Luis Manson]

Fixed that fuc***

the index had a size smaller than colum size, and mysql docs say:

For columns in the index, full column values must be indexed, not just a prefix. For example, with c1 VARCHAR(20), INDEX (c1(10)), the index cannot be used for loose index scan.