FAQ view count for non-FAQ posts

Resolved Andreas Brain
(@abrain)

9 years, 8 months ago

As mentioned here there is another problem regarding the FAQ view count.

There are more entries for FAQ view counts in the database than FAQ posts. The one with the most views is post ID 0, so that got me courious.

The SQL query SELECT m.post_id, p.ID, p.post_type, m.meta_key, m.meta_value FROM wp_postmeta m LEFT JOIN wp_posts p ON (m.post_id = p.ID) WHERE m.meta_key = 'ufaq_view_count' shows 26 entries for 11 published FAQ posts. Most of the surplus entries don’t even have a counterpart in the posts table. And those 2 that do, have the post types revision and attachment.

Hope this helps.

Cheers,
Andreas

https://wordpress.org/plugins/ultimate-faqs/

Viewing 3 replies - 1 through 3 (of 3 total)

etoilewebdesign

(@etoilewebdesign)

9 years, 8 months ago

Hi Andreas,

Could you let us know what are the post IDs for the remaining entries? We aren’t seeing the same issue on our end.

Thank you.

Best regards,

Thread Starter

Andreas Brain

(@abrain)

9 years, 8 months ago

Yes, of course.

I hope, this works:

post_id |  ID  | post_type  | meta_key        | meta_value
      0 | NULL |    NULL    | ufaq_view_count | 185
      1 | NULL |    NULL    | ufaq_view_count |   5
      5 |    5 | attachment | ufaq_view_count |   6
      9 |    9 |  revision  | ufaq_view_count |   7
     30 |   30 |    ufaq    | ufaq_view_count |  25
     97 | NULL |    NULL    | ufaq_view_count |   1
    494 | NULL |    NULL    | ufaq_view_count |   1
    495 | NULL |    NULL    | ufaq_view_count |   2
    500 | NULL |    NULL    | ufaq_view_count |   1
    501 | NULL |    NULL    | ufaq_view_count |   1
    502 | NULL |    NULL    | ufaq_view_count |   2
    566 | NULL |    NULL    | ufaq_view_count |   1
    578 | NULL |    NULL    | ufaq_view_count |   1
    579 | NULL |    NULL    | ufaq_view_count |   3
    580 | NULL |    NULL    | ufaq_view_count |   1
    778 | NULL |    NULL    | ufaq_view_count |   1
   1494 | 1494 |    ufaq    | ufaq_view_count |  17
   1495 | 1495 |    ufaq    | ufaq_view_count |  19
   1500 | 1500 |    ufaq    | ufaq_view_count |  22
   1501 | 1501 |    ufaq    | ufaq_view_count |  33
   1502 | 1502 |    ufaq    | ufaq_view_count |  74
   1566 | 1566 |    ufaq    | ufaq_view_count |  19
   1578 | 1578 |    ufaq    | ufaq_view_count |   7
   1579 | 1579 |    ufaq    | ufaq_view_count |   9
   1580 | 1580 |    ufaq    | ufaq_view_count |  13
   1626 | 1626 |    ufaq    | ufaq_view_count |   9

The gap between the first ufaq (ID 30) and the second one (ID 1494) comes from an import of posts from another WP site.

Another thing I just realized after sorting the result by ID is that most of the invalid IDs are IDs of ufaq posts, but with the leading 1 missing.

It seems, that the problem didn’t occur for ID 1626, which is the only FAQ that was created July 2016, the rest was created back in March 2016. So maybe there was a problem in former versions of the plugin? I can’t tell which versions exactly were used, but I usually perform plugin updates whenever they are available.

(There are also two FAQ drafts with IDs 1496 and 1497, which could explain ID 97)

Best regards

etoilewebdesign

(@etoilewebdesign)

9 years, 8 months ago

Hi Andreas,

We’ve improved the view counts on the dashboard by excluding post_id=’0′. We’re also currently looking in to where the other random posts could be added from.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘FAQ view count for non-FAQ posts’ is closed to new replies.