cipote

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?

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

It feels slow to me… It took considerably long to load.

Have you tried to disable all the plugins before doing the upgrade?

Michael posted a fix in this thread for a similar issue.
I applied his suggestion to my blog and now it works as expected!

I see the video just fine using Safari on a Mac.