Wpp stop showing posts

Hello Hector,

Thanks for your contribution to the WordPress community!
I’m able to see the list of popular posts when I’m in the admin area ‘Theme customize’ yet the post don’t appear in the widget as expected.

I don’t know if this would give you any idea as to what could be goin on but here’s what I get:

Querry:

SELECT SUM(pageviews) AS total
FROM wp_popularpostssummary v
LEFT JOIN wp_posts p
ON v.postid = p.ID
WHERE p.post_type IN( ‘post’, ‘page’ )
AND p.post_status = ‘publish’
AND p.post_password = ”
AND v.view_datetime > DATE_SUB( ‘2018-06-11 13:29:01’, INTERVAL 1 HOUR );

Caller:
Unknown

Component:
Unknown

Error Message:
Unknown column ‘v.view_datetime’ in ‘where clause’

Error Code:
qmdb

—
WordPress Popular Posts
Debug

PHP version: 5.3.6

PHP extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, calendar, ctype, curl, dba, dom, hash, fileinfo, filter, gd, gettext, SPL, iconv, json, mbstring, mcrypt, mysql, mysqli, session, PDO, pdo_mysql, pdo_sqlite, standard, pspell, Reflection, Phar, SimpleXML, soap, SQLite, exif, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, cgi-fcgi, mhash

Database version: 5.1.55

InnoDB availability:

WordPress version: 4.9.6

Multisite: No

Active plugins: Advanced Random Posts Widget 2.1.1, Lightbox 2 2.9.2, NextGEN Gallery 1.6.2, Query Monitor 3.0.1, WordPress Database Backup 2.3.3, WordPress Popular Posts 4.1.0

Theme: Twenty Twelve (2.5) by the WordPress team

Thanks, Hector. I thought mine was similar to @hangook. Sorry about hijacking your post, @hangook.

Thanks!

Unfortunately, I don’t exactly know what to change. I’m not versed on the backend side of things. Would you mind pointing me to what file(s) I need to edit?

Excellent!

Thank you!