Wpp stop showing posts

Hi @hangook,

Don’t worry about your english, it’s fine as it is.

Just checked your site and the widget seems to be loading normally. Because of that, it’s difficult to say what’s going on.

When it happens again:

• Take a screenshot of your home page.
• Take a screenshot of your browser’s console while browsing the home page.
• Take a screenshot of your home page’s HTML source, specially the one related to the widget.
• Check your server’s error log and look for warning/error messages that may be related to the plugin.

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

Hey @cipote,

Thanks for your contribution to the WordPress community!

Don’t mention it. I’m really glad to know you like my plugin ??

Anyways, this right here is the problem: Unknown column 'v.view_datetime' in 'where clause' (are you related to / the same person as @hangook? Otherwise you’re hijacking @hangook’s topic, it would have been better if you opened your own instead to avoid confusions unless @hangook’s issue is the same as yours.)

For some reason, WPP failed to update its database tables when you updated the plugin. Running these queries should fix that.

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

I don’t really mind, it’s just that it can get confusing sometimes ?? I’m pretty sure OP’s issue is something entirely different.

Give that a try and let me know how it goes (no need to open a new topic, we’re already here anyways).

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?

You need to run those queries via phpmyadmin (or any similar tool your hosting might offer to manage databases).

If you don’t feel confident enough to do this yourself (as I know how scary/stressful tinkering with unknown stuff can be), feel free to contact me and I’ll lend you a hand with it.

Excellent!

Thank you!

Hello, its me again xD
It happens today, yesterday it works fine:

Homepage HTML:
https://vk.com/doc4809619_467739623?hash=c242de5085b03e41fe&dl=185fb8720c0756d406

Chrome console(when honepage is loading):
https://vk.com/doc4809619_467739624?hash=547e5d44b0302df140&dl=23e8867ae2c1b5b756

Admin panel count(i have at least 3 posts):
https://vk.com/doc4809619_467739621?hash=dbe03e52ed05e41bbc&dl=07293301759224c51d

Error logs(nearest error):
https://vk.com/doc4809619_467739627?hash=4b77012b9827fca6ab&dl=e3f1d038404ce6cfac
https://vk.com/doc4809619_467740448?hash=a0c77060b1d3f2053f&dl=71373f8e298dfb806a

And i have this warnings 3 days ago:
https://vk.com/doc4809619_467740445?hash=758460cb231f5718a8&dl=68a5e6a67ad9c476cf

• This reply was modified 6 years, 9 months ago by hangook.

Hi @hangook,

I didn’t find anything wrong. Could you please share screenshots of your widget settings?

sure:
https://pp.userapi.com/c824604/v824604262/1380e9/o_JgLlzOj1Q.jpg

That’s not what I meant, but thanks anywas as I was also going to ask you to share that. I was talking about the options set via Dashboard > Widgets > WordPress Popular Posts.

And since we’re at it, please:

1. Go to Settings > WordPress Popular Posts.
2. Add &tab=debug to the URL in the address bar of your browser and hit Enter.
3. Copy the content of the Debug screen and share it here.

This is it?

PHP version: 5.4.45

PHP extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, gmp, SPL, iconv, pcntl, readline, Reflection, session, standard, shmop, SimpleXML, mbstring, tokenizer, xml, litespeed, bcmath, dbase, dom, fileinfo, gd, geoip, imap, intl, json, ldap, lzf, exif, mcrypt, mongo, mysql, mysqli, mysqlnd, PDO, pdo_mysql, posix, soap, sockets, sysvmsg, sysvsem, sysvshm, tidy, xmlreader, xmlrpc, xmlwriter, zip, mhash, ionCube Loader, Zend Guard Loader

Database version: 5.5.52-MariaDB-cll-lve

InnoDB availability: DEFAULT

WordPress version: 4.9.6

Multisite: No

Active plugins: Breadcrumb NavXT 6.1.0, Clone Posts 1.0, Contact Form 7 5.0.2, Content Aware Sidebars 3.7.6, Duplicator 1.2.40, List category posts 0.76.1, MailChimp for WordPress 4.2.3, Post Types + 1.0, Quiz And Survey Master 5.3.2, Really Simple SSL 3.0.1, Redux 1.0, Slider Revolution 5.4.6.3.1, Snazzy Maps 1.1.3, Visual Composer Maced Google Maps 1.0.0, WooCommerce 3.4.2, WordPress Popular Posts 4.1.0, WPBakery Page Builder 5.4.5, WP Translitera p1.2.5

Theme: Accountant WP Child Theme (1.1.3.1528179940) by Azelab

Hi @hangook,

Sorry for the late reply. Had some urgent personal matters that kept me offline for the past couple of days.

Thanks for sharing the debug info. What about your widget’s settings?

Hello, sorry i dont understand what kind of setting you need xD
Maybe i can send you login and password for admin panel via email?