This is part of 1 record “post_views_count’, ‘a:2:{i:0;s:15878376:\”a:2:{i:0;s:7939168:\”a:2:{i:0;s:3969564:\”a:2:{i:0;s:1984762:\”a:2:{i:0;s:992362:\”a:2:{i:0;s:496162:\”a:2:{i:0;s:248062:\”a:2:{i:0;s:124012:\”a:2:{i:0;s:61988:\”a:2:{i:0;s:30976:\”a:2:{i:0;s:15470:\”a:2:{i:0;s:7718:\”a:2:{i:0;s:3842:\”a:2:{i:0;s:1904:\”a:2:{i:0;s:936:\”a:2:{i:0;s:452:\”a:2:{i:0;s:210:\ …”
Hi,
The post view counts are stored in the database
– https://www.screencast.com/t/YDNX7g4heDN
The ajax view count is recommended to be activated when caching is used, in order to display accurate values
– https://forum.tagdiv.com/ajax-view-count/
This option can be deactivated, but the result can be inaccurate results.
Thanks
Well…
I have many record like
(965, 125, ‘post_views_count’, ‘0’),
(966, 126, ‘post_views_count’, ‘0’),
But also 2 huge record like “post_views_count’, ‘a:2:{i:0;s:15878376:\”a:2:{i:0;s:7939168:\”a:2:{i:0;s:3969564:\”a:2:{i:0;s:1984762:\”a:2:{i:0;s:992362:\”a:2:{i:0;s:496162:\”a:2:{i:0;s:248062:\”a:2:{i:0;s:124012:\”a:2:{i:0;s:61988:\”a:2:{i:0;s:30976:\”a:2:{i:0;s:15470:\”a:2:{i:0;s:7718:\”a:2:{i:0;s:3842:\”a:2:{i:0;s:1904:\”a:2:{i:0;s:936:\”a:2:{i:0;s:452:\”a:2:{i:0;s:210:\ …”
Because I don’t need post count, can you confirm that I can do this https://www.screencast.com/t/YDNX7g4heDN
AND CAN DELETE the 2 huge records? Or do you think that the 2 huge record have also others important site data?
Thanks!
To disable post count I need to delete line 5 of https://www.screencast.com/t/YDNX7g4heDN or what?
Hi,
Or you can simply disable the post views in the theme panel, they will not be stored anymore, and also clear the fields in the database with existing post views information
– https://www.screencast.com/t/tMRnx4qxiqDy
Be sure to make a backup or export of the database just to be safe, before you start deleting.
Thanks
Hi!
Post views in the theme panel is disable. I don’t know why my database have this records, I remember to have disabled it from start…
Can you confirm that these records
(965, 125, ‘post_views_count’, ‘0’),
(966, 126, ‘post_views_count’, ‘0’),
ANDD
“post_views_count’, ‘a:2:{i:0;s:15878376:\”a:2:{i:0;s:7939168:\”a:2:{i:0;s:3969564:\”a:2:{i:0;s:1984762:\”a:2:{i:0;s:992362:\”a:2:{i:0;s:496162:\”a:2:{i:0;s:248062:\”a:2:{i:0;s:124012:\”a:2:{i:0;s:61988:\”a:2:{i:0;s:30976:\”a:2:{i:0;s:15470:\”a:2:{i:0;s:7718:\”a:2:{i:0;s:3842:\”a:2:{i:0;s:1904:\”a:2:{i:0;s:936:\”a:2:{i:0;s:452:\”a:2:{i:0;s:210:\ …”
Are Newspaper related records and can be safety delete, in particular
“post_views_count’, ‘a:2:{i:0;s:15878376:\”a:2:{i:0;s:7939168:\”a:2:{i:0;s:3969564:\”a:2:{i:0;s:1984762:\”a:2:{i:0;s:992362:\”a:2:{i:0;s:496162:\”a:2:{i:0;s:248062:\”a:2:{i:0;s:124012:\”a:2:{i:0;s:61988:\”a:2:{i:0;s:30976:\”a:2:{i:0;s:15470:\”a:2:{i:0;s:7718:\”a:2:{i:0;s:3842:\”a:2:{i:0;s:1904:\”a:2:{i:0;s:936:\”a:2:{i:0;s:452:\”a:2:{i:0;s:210:\ …”
Thanks!
Hi,
If the post views have been disabled, then these should not be present in the database. Maybe these were kept from a different theme that you used before. Go ahead and delete them but make a backup or database export before, just to be safe.
This is how the post views are kept
– https://www.screencast.com/t/vJXC1zZ7
– https://www.screencast.com/t/pfZ0ZUu3iVl
Thanks
Thanks!
Can you confirm that also this record “post_views_count’, ‘a:2:{i:0;s:15878376:\”a:2:{i:0;s:7939168:\”a:2:{i:0;s:3969564:\”a:2:{i:0;s:1984762:\”a:2:{i:0;s:992362:\”a:2:{i:0;s:496162:\”a:2:{i:0;s:248062:\”a:2:{i:0;s:124012:\”a:2:{i:0;s:61988:\”a:2:{i:0;s:30976:\”a:2:{i:0;s:15470:\”a:2:{i:0;s:7718:\”a:2:{i:0;s:3842:\”a:2:{i:0;s:1904:\”a:2:{i:0;s:936:\”a:2:{i:0;s:452:\”a:2:{i:0;s:210:\ …”
is generated by Newspaper theme?
Thanks!
Hi,
As I said these could have been created by another theme, make a backup or export before deleting these fields in the database. This is not difficult and it is the recommended method of making modifications in the database
– https://codex.wordpress.org/Backing_Up_Your_Database
Thanks
