Support » Plugin: WordPress Popular Posts » getting error while pageview updation

  • sajitkk

    (@sajitkk)


    gitting this error in browser console

    <div id=”error”><p class=”wpdberror”>WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%4$d, last_viewed = '%3$s'' at line 3]<br />`INSERT INTO wp_popularpostsdata
    (postid, day, last_viewed, pageviews) VALUES (146, ‘2017-09-20 12:49:31’, ‘2017-09-20 12:49:31’, 1)
    ON DUPLICATE KEY UPDATE pageviews = pageviews + %4$d, last_viewed = ‘%3$s’;</p></div><div id="error"><p class="wpdberror"><strong>WordPress database error:</strong> [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%2$d, last_viewed = '%4$s'' at line 3]<br />INSERT INTO wp_popularpostssummary
    (postid, pageviews, view_date, last_viewed) VALUES (146, 1, ‘2017-09-20’, ‘2017-09-20 12:49:31’)
    ON DUPLICATE KEY UPDATE pageviews = pageviews + %2$d, last_viewed = ‘%4$s’;`</p></div>WPP: Oops, could not update the views count!

    • This topic was modified 2 months ago by  sajitkk.
Viewing 7 replies - 1 through 7 (of 7 total)
Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this review.