Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted December 2, 20159 yr 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?
December 2, 20159 yr 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.
December 2, 20159 yr Author 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?
December 2, 20159 yr 28 minutes ago, iacas said: Thanks. In 4.1.5? Yes, there will be a fix for this in 4.1.5.
December 2, 20159 yr Author 6 minutes ago, Stuart Silvester said: Yes, there will be a fix for this in 4.1.5. Thank you.
January 10, 20169 yr I'm testing IPS 4.1.6 and I still have this problem of views count (on forums) always at "0" (zero) Any solution ?
January 11, 20169 yr 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.
January 12, 20169 yr 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).
January 12, 20169 yr 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!?
January 12, 20169 yr 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.
Archived
This topic is now archived and is closed to further replies.