NecNecco

Thanks James again,

I many times checked the database by the utility before updating or downgrading the WP. It did not help.

I think I will wait 4.5 or so to retry updating.

Regards,

Nec

Yes it works as you suggested. I created some fresh post and comments. It displays OK.

But I am not still sure why comments on some pages of my real blog do not show up.

I sent the diff results for 4.3.1 and 4.4 above. They are subtle and do not contain any changes on comments table.

Any recommendations please?

Hi James,

OS = ?CentOS Linux 7.1.1503 (Core)?
Plesk = 12.5.30 Update #9
PHP = PHP 5.4.16 (cli) (built: Jun 23 2015 21:17:27)
Wordpress = 4.3.1

Regards,

Nec

Thanks again James,

I also fixed those PHP warnings by editing include_path for php.ini.

After everything is fixed, I tried another and no, it did not succeed.

Reverted back to 4.3.1 and I think I will stick with for a time.

BTW, I saw [email protected] email address in SQL file. Does WP have such kind of support service for update issues?

Regards,

Nec

SQL file seems to be fine to me but still can not understand why 4.4 can not execute have_comments() properly.

Just figured out that there are some logs for WP. I am not sure if these errors happened during update. Before update I put the site in maintenance mode by .htaccess file but later somehow it got deleted automatically without my notice and users may have entered the site. I am not sure below logs come from WP update or user interaction.

[10-Dec-2015 15:38:10 UTC] PHP Warning: require_once(/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php): failed to open stream: No such file or directory in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 15:38:10 UTC] PHP Fatal error: require_once(): Failed opening required ‘/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php’ (include_path=’.:/usr/share/pear:/usr/share/php’) in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 15:38:10 UTC] PHP Warning: require_once(/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php): failed to open stream: No such file or directory in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 15:38:10 UTC] PHP Fatal error: require_once(): Failed opening required ‘/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php’ (include_path=’.:/usr/share/pear:/usr/share/php’) in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 15:38:13 UTC] PHP Warning: require_once(/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php): failed to open stream: No such file or directory in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 15:38:13 UTC] PHP Fatal error: require_once(): Failed opening required ‘/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php’ (include_path=’.:/usr/share/pear:/usr/share/php’) in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 15:38:14 UTC] PHP Warning: require_once(/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php): failed to open stream: No such file or directory in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 15:38:14 UTC] PHP Fatal error: require_once(): Failed opening required ‘/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php’ (include_path=’.:/usr/share/pear:/usr/share/php’) in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 15:38:16 UTC] PHP Warning: require_once(/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php): failed to open stream: No such file or directory in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 15:38:16 UTC] PHP Fatal error: require_once(): Failed opening required ‘/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php’ (include_path=’.:/usr/share/pear:/usr/share/php’) in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 361
[10-Dec-2015 16:17:16 UTC] PHP Warning: require_once(/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php): failed to open stream: No such file or directory in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 343
[10-Dec-2015 16:17:16 UTC] PHP Fatal error: require_once(): Failed opening required ‘/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php’ (include_path=’.:/usr/share/pear:/usr/share/php’) in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 343
[10-Dec-2015 16:17:16 UTC] PHP Warning: require_once(/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php): failed to open stream: No such file or directory in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 343
[10-Dec-2015 16:17:16 UTC] PHP Fatal error: require_once(): Failed opening required ‘/var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php’ (include_path=’.:/usr/share/pear:/usr/share/php’) in /var/www/vhosts/example.com/httpdocs/wp-includes/load.php on line 343

I checked the files are in place.

Other than these, below entries are only available for 4.3.1 and deleted for 4.4 under

LOCK TABLES wp_options WRITE;
/*!40000 ALTER TABLE wp_options DISABLE KEYS */;

section.

‘,’yes’),(33212,’can_compress_scripts’,’1′,’yes’),

(33184,’theme_switched’,”,’yes’),(33194,’_site_transient_timeout_wporg_theme_feature_list’,’1549753735′,’yes’),(33195,’_site_transient_wporg_theme_feature_list’,’a:4:{s:6:\”Colors\”;a:15:{i:0;s:5:\”black\”;i:1;s:4:\”blue\”;i:2;s:5:\”brown\”;i:3;s:4:\”gray\”;i:4;s:5:\”green\”;i:5;s:6:\”orange\”;i:6;s:4:\”pink\”;i:7;s:6:\”purple\”;i:8;s:3:\”red\”;i:9;s:6:\”silver\”;i:10;s:3:\”tan\”;i:11;s:5:\”white\”;i:12;s:6:\”yellow\”;i:13;s:4:\”dark\”;i:14;s:5:\”light\”;}s:6:\”Layout\”;a:9:{i:0;s:12:\”fixed-layout\”;i:1;s:12:\”fluid-layout\”;i:2;s:17:\”responsive-layout\”;i:3;s:10:\”one-column\”;i:4;s:11:\”two-columns\”;i:5;s:13:\”three-columns\”;i:6;s:12:\”four-columns\”;i:7;s:12:\”left-sidebar\”;i:8;s:13:\”right-sidebar\”;}s:8:\”Features\”;a:20:{i:0;s:19:\”accessibility-ready\”;i:1;s:8:\”blavatar\”;i:2;s:10:\”buddypress\”;i:3;s:17:\”custom-background\”;i:4;s:13:\”custom-colors\”;i:5;s:13:\”custom-header\”;i:6;s:11:\”custom-menu\”;i:7;s:12:\”editor-style\”;i:8;s:21:\”featured-image-header\”;i:9;s:15:\”featured-images\”;i:10;s:15:\”flexible-header\”;i:11;s:20:\”front-page-post-form\”;i:12;s:19:\”full-width-template\”;i:13;s:12:\”microformats\”;i:14;s:12:\”post-formats\”;i:15;s:20:\”rtl-language-support\”;i:16;s:11:\”sticky-post\”;i:17;s:13:\”theme-options\”;i:18;s:17:\”threaded-comments\”;i:19;s:17:\”translation-ready\”;}s:7:\”Subject\”;a:3:{i:0;s:7:\”holiday\”;i:1;s:13:\”photoblogging\”;i:2;s:8:\”seasonal\”;}}’,’yes’),(

0:{}}}}’,’yes’),(33209,’gzipcompression’,’0′,’yes’),(33210,’advanced_edit’,’0′,’yes’),(33215,’_site_transient_timeout_poptags_40cd750bba9879889f18aada2478b24840a’,’144435973547′,’yes’),(33216,’_site_transient_poptags_40cd750hrdb9570f18aada2478b25840a’,’a:100:{s:6:\”widget\”;a:3:{s:4:\”name\”;s:6:\”widget\”;s:4:\”slug\”;s:6:\”widget\”;s:5:\”count\”;s:4:\”5590\”;}s:4:\”post\”;a:3:{s:4:\”name\”;s:4:\”Post\”;s:4:\”slug\”;s:4:\”post\”;s:5:\”count\”;s:4:\”3496\”;}s:6:\”plugin\”;a:3:{s:4:\”name\”;s:6:\”plugin\”;s:4:\”slug\”;s:6:\”plugin\”;s:5:\”count\”;s:4:\”3442\”;}s:5:\”admin\”;a:3:{s:4:\”name\”;s:5:\”admin\”;s:4:\”slug\”;s:5:\”admin\”;s:5:\”count\”;s:4:\”2953\”;}s:5:\”posts\”;a:3:{s:4:\”name\”;s:5:\”posts\”;s:4:\”slug\”;s:5:\”posts\”;s:5:\”count\”;s:4:\”2691\”;}s:9:\”shortcode\”;a:3:{s:4:\”name\”;s:9:\”shortcode\”;s:4:\”slug\”;s:9:\”shortcode\”;s:5:\”count\”;s:4:\”2153\”;}s:7:\”sidebar\”;a:3:{s:4:\”name\”;s:7:\”sidebar\”;s:4:\”slug\”;s:7:\”sidebar\”;s:5:\”count\”;s:4:\”2143\”;}s:6:\”google\”;a:3:{s:4:\”name\”;s:6:\”google\”;s:4:\”slug\”;s:6:\”google\”;s:5:\”count\”;s:4:\”1967\”;}s:7:\”twitter\”;a:3:{s:4:\”name\”;s:7:\”twitter\”;s:4:\”slug\”;s:7:\”twitter\”;s:5:\”count\”;s:4:\”1927\”;}s:6:\”images\”;a:3:{s:4:\”name\”;s:6:\”images\”;s:4:\”slug\”;s:6:\”images\”;s:5:\”count\”;s:4:\”1908\”;}s:4:\”page\”;a:3:{s:4:\”name\”;s:4:\”page\”;s:4:\”slug\”;s:4:\”page\”;s:5:\”count\”;s:4:\”1902\”;}s:8:\”comments\”;a:3:{s:4:\”name\”;s:8:\”comments\”;s:4:\”slug\”;s:8:\”comments\”;s:5:\”count\”;s:4:\”1859\”;}s:5:\”image\”;a:3:{s:4:\”name\”;s:5:\”image\”;s:4:\”slug\”;s:5:\”image\”;s:5:\”count\”;s:4:\”1755\”;}s:8:\”facebook\”;a:3:{s:4:\”name\”;s:8:\”Facebook\”;s:4:\”slug\”;s:8:\”facebook\”;s:5:\”count\”;s:4:\”1564\”;}s:3:\”seo\”;a:3:{s:4:\”name\”;s:3:\”seo\”;s:4:\”slug\”;s:3:\”seo\”;s:5:\”count\”;s:4:\”1481\”;}s:9:\”wordpress\”;a:3:{s:4:\”name\”;s:9:\”wordpress\”;s:4:\”slug\”;s:9:\”wordpress\”;s:5:\”count\”;s:4:\”1454\”;}s:11:\”woocommerce\”;a:3:{s:4:\”name\”;s:11:\”woocommerce\”;s:4:\”slug\”;s:11:\”woocommerce\”;s:5:\”count\”;s:4:\”1339\”;}s:6:\”social\”;a:3:{s:4:\”name\”;s:6:\”social\”;s:4:\”slug\”;s:6:\”social\”;s:5:\”count\”;s:4:\”1272\”;}s:5:\”links\”;a:3:{s:4:\”name\”;s:5:\”links\”;s:4:\”slug\”;s:5:\”links\”;s:5:\”count\”;s:4:\”1243\”;}s:7:\”gallery\”;a:3:{s:4:\”name\”;s:7:\”gallery\”;s:4:\”slug\”;s:7:\”gallery\”;s:5:\”count\”;s:4:\”1221\”;}s:5:\”email\”;a:3:{s:4:\”name\”;s:5:\”email\”;s:4:\”slug\”;s:5:\”email\”;s:5:\”count\”;s:4:\”1117\”;}s:7:\”widgets\”;a:3:{s:4:\”name\”;s:7:\”widgets\”;s:4:\”slug\”;s:7:\”widgets\”;s:5:\”count\”;s:4:\”1048\”;}s:5:\”pages\”;a:3:{s:4:\”name\”;s:5:\”pages\”;s:4:\”slug\”;s:5:\”pages\”;s:5:\”count\”;s:4:\”1011\”;}s:6:\”jquery\”;a:3:{s:4:\”name\”;s:6:\”jquery\”;s:4:\”slug\”;s:6:\”jquery\”;s:5:\”count\”;s:3:\”968\”;}s:5:\”media\”;a:3:{s:4:\”name\”;s:5:\”media\”;s:4:\”slug\”;s:5:\”media\”;s:5:\”count\”;s:3:\”928\”;}s:3:\”rss\”;a:3:{s:4:\”name\”;s:3:\”rss\”;s:4:\”slug\”;s:3:\”rss\”;s:5:\”count\”;s:3:\”898\”;}s:4:\”ajax\”;a:3:{s:4:\”name\”;s:4:\”AJAX\”;s:4:\”slug\”;s:4:\”ajax\”;s:5:\”count\”;s:3:\”864\”;}s:5:\”video\”;a:3:{s:4:\”name\”;s:5:\”video\”;s:4:\”slug\”;s:5:\”video\”;s:5:\”count\”;s:3:\”856\”;}s:9:\”ecommerce\”;a:3:{s:4:\”name\”;s:9:\”ecommerce\”;s:4:\”slug\”;s:9:\”ecommerce\”;s:5:\”count\”;s:3:\”856\”;}s:7:\”content\”;a:3:{s:4:\”name\”;s:7:\”content\”;s:4:\”slug\”;s:7:\”content\”;s:5:\”count\”;s:3:\”855\”;}s:5:\”login\”;a:3:{s:4:\”name\”;s:5:\”login\”;s:4:\”slug\”;s:5:\”login\”;s:5:\”count\”;s:3:\”831\”;}s:10:\”javascript\”;a:3:{s:4:\”name\”;s:10:\”javascript\”;s:4:\”slug\”;s:10:\”javascript\”;s:5:\”count\”;s:3:\”792\”;}s:10:\”buddypress\”;a:3:{s:4:\”name\”;s:10:\”buddypress\”;s:4:\”slug\”;s:10:\”buddypress\”;s:5:\”count\”;s:3:\”754\”;}s:5:\”photo\”;a:3:{s:4:\”name\”;s:5:\”photo\”;s:4:\”slug\”;s:5:\”photo\”;s:5:\”count\”;s:3:\”723\”;}s:4:\”feed\”;a:3:{s:4:\”name\”;s:4:\”feed\”;s:4:\”slug\”;s:4:\”feed\”;s:5:\”count\”;s:3:\”717\”;}s:7:\”youtube\”;a:3:{s:4:\”name\”;s:7:\”youtube\”;s:4:\”slug\”;s:7:\”youtube\”;s:5:\”count\”;s:3:\”717\”;}s:8:\”security\”;a:3:{s:4:\”name\”;s:8:\”security\”;s:4:\”slug\”;s:8:\”security\”;s:5:\”count\”;s:3:\”716\”;}s:10:\”responsive\”;a:3:{s:4:\”name\”;s:10:\”responsive\”;s:4:\”slug\”;s:10:\”responsive\”;s:5:\”count\”;s:3:\”711\”;}s:4:\”link\”;a:3:{s:4:\”name\”;s:4:\”link\”;s:4:\”slug\”;s:4:\”link\”;s:5:\”count\”;s:3:\”705\”;}s:4:\”spam\”;a:3:{s:4:\”name\”;s:4:\”spam\”;s:4:\”slug\”;s:4:\”spam\”;s:5:\”count\”;s:3:\”696\”;}s:5:\”share\”;a:3:{s:4:\”name\”;s:5:\”Share\”;s:4:\”slug\”;s:5:\”share\”;s:5:\”count\”;s:3:\”694\”;}s:10:\”e-commerce\”;a:3:{s:4:\”name\”;s:10:\”e-commerce\”;s:4:\”slug\”;s:10:\”e-commerce\”;s:5:\”count\”;s:3:\”678\”;}s:6:\”photos\”;a:3:{s:4:\”name\”;s:6:\”photos\”;s:4:\”slug\”;s:6:\”photos\”;s:5:\”count\”;s:3:\”671\”;}s:8:\”category\”;a:3:{s:4:\”name\”;s:8:\”category\”;s:4:\”slug\”;s:8:\”category\”;s:5:\”count\”;s:3:\”664\”;}s:5:\”embed\”;a:3:{s:4:\”name\”;s:5:\”embed\”;s:4:\”slug\”;s:5:\”embed\”;s:5:\”count\”;s:3:\”638\”;}s:9:\”analytics\”;a:3:{s:4:\”name\”;s:9:\”analytics\”;s:4:\”slug\”;s:9:\”analytics\”;s:5:\”count\”;s:3:\”638\”;}s:4:\”form\”;a:3:{s:4:\”name\”;s:4:\”form\”;s:4:\”slug\”;s:4:\”form\”;s:5:\”count\”;s:3:\”628\”;}s:3:\”css\”;a:3:{s:4:\”name\”;s:3:\”CSS\”;s:4:\”slug\”;s:3:\”css\”;s:5:\”count\”;s:3:\”624\”;}s:6:\”search\”;a:3:{s:4:\”name\”;s:6:\”search\”;s:4:\”slug\”;s:6:\”search\”;s:5:\”count\”;s:3:\”621\”;}s:9:\”slideshow\”;a:3:{s:4:\”name\”;s:9:\”slideshow\”;s:4:\”slug\”;s:9:\”slideshow\”;s:5:\”count\”;s:3:\”618\”;}s:6:\”custom\”;a:3:{s:4:\”name\”;s:6:\”custom\”;s:4:\”slug\”;s:6:\”custom\”;s:5:\”count\”;s:3:\”593\”;}s:5:\”stats\”;a:3:{s:4:\”name\”;s:5:\”stats\”;s:4:\”slug\”;s:5:\”stats\”;s:5:\”count\”;s:3:\”588\”;}s:6:\”slider\”;a:3:{s:4:\”name\”;s:6:\”slider\”;s:4:\”slug\”;s:6:\”slider\”;s:5:\”count\”;s:3:\”580\”;}s:7:\”comment\”;a:3:{s:4:\”name\”;s:7:\”comment\”;s:4:\”slug\”;s:7:\”comment\”;s:5:\”count\”;s:3:\”575\”;}s:6:\”button\”;a:3:{s:4:\”name\”;s:6:\”button\”;s:4:\”slug\”;s:6:\”button\”;s:5:\”count\”;s:3:\”569\”;}s:4:\”menu\”;a:3:{s:4:\”name\”;s:4:\”menu\”;s:4:\”slug\”;s:4:\”menu\”;s:5:\”count\”;s:3:\”566\”;}s:5:\”theme\”;a:3:{s:4:\”name\”;s:5:\”theme\”;s:4:\”slug\”;s:5:\”theme\”;s:5:\”count\”;s:3:\”564\”;}s:4:\”tags\”;a:3:{s:4:\”name\”;s:4:\”tags\”;s:4:\”slug\”;s:4:\”tags\”;s:5:\”count\”;s:3:\”562\”;}s:9:\”dashboard\”;a:3:{s:4:\”name\”;s:9:\”dashboard\”;s:4:\”slug\”;s:9:\”dashboard\”;s:5:\”count\”;s:3:\”558\”;}s:10:\”categories\”;a:3:{s:4:\”name\”;s:10:\”categories\”;s:4:\”slug\”;s:10:\”categories\”;s:5:\”count\”;s:3:\”551\”;}s:10:\”statistics\”;a:3:{s:4:\”name\”;s:10:\”statistics\”;s:4:\”slug\”;s:10:\”statistics\”;s:5:\”count\”;s:3:\”537\”;}s:3:\”ads\”;a:3:{s:4:\”name\”;s:3:\”ads\”;s:4:\”slug\”;s:3:\”ads\”;s:5:\”count\”;s:3:\”524\”;}s:6:\”mobile\”;a:3:{s:4:\”name\”;s:6:\”mobile\”;s:4:\”slug\”;s:6:\”mobile\”;s:5:\”count\”;s:3:\”520\”;}s:4:\”user\”;a:3:{s:4:\”name\”;s:4:\”user\”;s:4:\”slug\”;s:4:\”user\”;s:5:\”count\”;s:3:\”512\”;}s:6:\”editor\”;a:3:{s:4:\”name\”;s:6:\”editor\”;s:4:\”slug\”;s:6:\”editor\”;s:5:\”count\”;s:3:\”509\”;}s:5:\”users\”;a:3:{s:4:\”name\”;s:5:\”users\”;s:4:\”slug\”;s:5:\”users\”;s:5:\”count\”;s:3:\”498\”;}s:7:\”picture\”;a:3:{s:4:\”name\”;s:7:\”picture\”;s:4:\”slug\”;s:7:\”picture\”;s:5:\”count\”;s:3:\”497\”;}s:4:\”list\”;a:3:{s:4:\”name\”;s:4:\”list\”;s:4:\”slug\”;s:4:\”list\”;s:5:\”count\”;s:3:\”494\”;}s:7:\”plugins\”;a:3:{s:4:\”name\”;s:7:\”plugins\”;s:4:\”slug\”;s:7:\”plugins\”;s:5:\”count\”;s:3:\”493\”;}s:9:\”affiliate\”;a:3:{s:4:\”name\”;s:9:\”affiliate\”;s:4:\”slug\”;s:9:\”affiliate\”;s:5:\”count\”;s:3:\”489\”;}s:9:\”multisite\”;a:3:{s:4:\”name\”;s:9:\”multisite\”;s:4:\”slug\”;s:9:\”multisite\”;s:5:\”count\”;s:3:\”464\”;}s:6:\”simple\”;a:3:{s:4:\”name\”;s:6:\”simple\”;s:4:\”slug\”;s:6:\”simple\”;s:5:\”count\”;s:3:\”461\”;}s:12:\”contact-form\”;a:3:{s:4:\”name\”;s:12:\”contact form\”;s:4:\”slug\”;s:12:\”contact-form\”;s:5:\”count\”;s:3:\”453\”;}s:8:\”pictures\”;a:3:{s:4:\”name\”;s:8:\”pictures\”;s:4:\”slug\”;s:8:\”pictures\”;s:5:\”count\”;s:3:\”448\”;}s:7:\”contact\”;a:3:{s:4:\”name\”;s:7:\”contact\”;s:4:\”slug\”;s:7:\”contact\”;s:5:\”count\”;s:3:\”442\”;}s:12:\”social-media\”;a:3:{s:4:\”name\”;s:12:\”social media\”;s:4:\”slug\”;s:12:\”social-media\”;s:5:\”count\”;s:3:\”442\”;}s:10:\”navigation\”;a:3:{s:4:\”name\”;s:10:\”navigation\”;s:4:\”slug\”;s:10:\”navigation\”;s:5:\”count\”;s:3:\”425\”;}s:5:\”flash\”;a:3:{s:4:\”name\”;s:5:\”flash\”;s:4:\”slug\”;s:5:\”flash\”;s:5:\”count\”;s:3:\”420\”;}s:3:\”url\”;a:3:{s:4:\”name\”;s:3:\”url\”;s:4:\”slug\”;s:3:\”url\”;s:5:\”count\”;s:3:\”414\”;}s:4:\”html\”;a:3:{s:4:\”name\”;s:4:\”html\”;s:4:\”slug\”;s:4:\”html\”;s:5:\”count\”;s:3:\”413\”;}s:10:\”newsletter\”;a:3:{s:4:\”name\”;s:10:\”newsletter\”;s:4:\”slug\”;s:10:\”newsletter\”;s:5:\”count\”;s:3:\”406\”;}s:3:\”api\”;a:3:{s:4:\”name\”;s:3:\”api\”;s:4:\”slug\”;s:3:\”api\”;s:5:\”count\”;s:3:\”406\”;}s:4:\”shop\”;a:3:{s:4:\”name\”;s:4:\”shop\”;s:4:\”slug\”;s:4:\”shop\”;s:5:\”count\”;s:3:\”400\”;}s:4:\”meta\”;a:3:{s:4:\”name\”;s:4:\”meta\”;s:4:\”slug\”;s:4:\”meta\”;s:5:\”count\”;s:3:\”396\”;}s:4:\”news\”;a:3:{s:4:\”name\”;s:4:\”News\”;s:4:\”slug\”;s:4:\”news\”;s:5:\”count\”;s:3:\”393\”;}s:9:\”marketing\”;a:3:{s:4:\”name\”;s:9:\”marketing\”;s:4:\”slug\”;s:9:\”marketing\”;s:5:\”count\”;s:3:\”392\”;}s:3:\”tag\”;a:3:{s:4:\”name\”;s:3:\”tag\”;s:4:\”slug\”;s:3:\”tag\”;s:5:\”count\”;s:3:\”390\”;}s:6:\”events\”;a:3:{s:4:\”name\”;s:6:\”events\”;s:4:\”slug\”;s:6:\”events\”;s:5:\”count\”;s:3:\”385\”;}s:8:\”tracking\”;a:3:{s:4:\”name\”;s:8:\”tracking\”;s:4:\”slug\”;s:8:\”tracking\”;s:5:\”count\”;s:3:\”382\”;}s:8:\”calendar\”;a:3:{s:4:\”name\”;s:8:\”calendar\”;s:4:\”slug\”;s:8:\”calendar\”;s:5:\”count\”;s:3:\”380\”;}s:9:\”thumbnail\”;a:3:{s:4:\”name\”;s:9:\”thumbnail\”;s:4:\”slug\”;s:9:\”thumbnail\”;s:5:\”count\”;s:3:\”379\”;}s:11:\”advertising\”;a:3:{s:4:\”name\”;s:11:\”advertising\”;s:4:\”slug\”;s:11:\”advertising\”;s:5:\”count\”;s:3:\”377\”;}s:4:\”text\”;a:3:{s:4:\”name\”;s:4:\”text\”;s:4:\”slug\”;s:4:\”text\”;s:5:\”count\”;s:3:\”376\”;}s:4:\”code\”;a:3:{s:4:\”name\”;s:4:\”code\”;s:4:\”slug\”;s:4:\”code\”;s:5:\”count\”;s:3:\”374\”;}s:8:\”lightbox\”;a:3:{s:4:\”name\”;s:8:\”lightbox\”;s:4:\”slug\”;s:8:\”lightbox\”;s:5:\”count\”;s:3:\”368\”;}s:6:\”upload\”;a:3:{s:4:\”name\”;s:6:\”upload\”;s:4:\”slug\”;s:6:\”upload\”;s:5:\”count\”;s:3:\”368\”;}s:10:\”shortcodes\”;a:3:{s:4:\”name\”;s:10:\”shortcodes\”;s:4:\”slug\”;s:10:\”shortcodes\”;s:5:\”count\”;s:3:\”365\”;}s:9:\”automatic\”;a:3:{s:4:\”name\”;s:9:\”automatic\”;s:4:\”slug\”;s:9:\”automatic\”;s:5:\”count\”;s:3:\”363\”;}s:7:\”profile\”;a:3:{s:4:\”name\”;s:7:\”profile\”;s:4:\”slug\”;s:7:\”profile\”;s:5:\”count\”;s:3:\”361\”;}s:7:\”sharing\”;a:3:{s:4:\”name\”;s:7:\”sharing\”;s:4:\”slug\”;s:7:\”sharing\”;s:5:\”count\”;s:3:\”360\”;

DROP TABLE IF EXISTS wp_users;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE wp_users (
ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_login varchar(60) NOT NULL DEFAULT ”,
user_pass varchar(64) NOT NULL DEFAULT ”,
user_nicename varchar(50) NOT NULL DEFAULT ”,
user_email varchar(100) NOT NULL DEFAULT ”,
user_url varchar(100) NOT NULL DEFAULT ”,
user_registered datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
user_activation_key varchar(60) NOT NULL DEFAULT ”,
user_status int(11) NOT NULL DEFAULT ‘0’,
display_name varchar(250) NOT NULL DEFAULT ”,
PRIMARY KEY (ID),
KEY user_login_key (user_login),
KEY user_nicename (user_nicename)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS wp_users;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE wp_users (
ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_login varchar(60) NOT NULL DEFAULT ”,
user_pass varchar(255) NOT NULL DEFAULT ”,
user_nicename varchar(50) NOT NULL DEFAULT ”,
user_email varchar(100) NOT NULL DEFAULT ”,
user_url varchar(100) NOT NULL DEFAULT ”,
user_registered datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
user_activation_key varchar(255) NOT NULL DEFAULT ”,
user_status int(11) NOT NULL DEFAULT ‘0’,
display_name varchar(250) NOT NULL DEFAULT ”,
PRIMARY KEY (ID),
KEY user_login_key (user_login),
KEY user_nicename (user_nicename)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

Thank you very much for your help James.

I updated manually but unfortunately the issue persists. I copied the SQL file for 4.3.1 before updating. And after update I compared the new SQL file for 4.4

Only 4 sections are updated which comes fine to me. Upper section codes belong to 4.3.1 while the second section is 4.4. Bold sections are changes.

DROP TABLE IF EXISTSwp_options;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE wp_options (
option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
option_name varchar(64) NOT NULL DEFAULT ”,
option_value longtext NOT NULL,
autoload varchar(20) NOT NULL DEFAULT ‘yes’,
PRIMARY KEY (option_id),
UNIQUE KEY option_name (option_name)
) ENGINE=MyISAM AUTO_INCREMENT=33274 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTSwp_options;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE wp_options (
option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
option_name varchar(191) DEFAULT NULL,
option_value longtext NOT NULL,
autoload varchar(20) NOT NULL DEFAULT ‘yes’,
PRIMARY KEY (option_id),
UNIQUE KEY option_name (option_name)
) ENGINE=MyISAM AUTO_INCREMENT=33274 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

(54,’db_version’,’33056′,’yes’)

(54,’db_version’,’35700′,’yes’)

Hello James,

Thank you very much for your time and help.

I downloaded and uploaded latest version as you suggested. It did not help.

I downloaded v4.3.1 and uploaded to the site. Database change required. And comments section came back.

So this shows something is broken when WordPress 4.0 requires database changes. Do you have any idea about this database issue?

This is the first time I dealt with such a bug. All years I happen to upgrade many times without any issues.

BTW, why WordPress requires database update during upgrades?

Regards,

Nec

yes, they are all there. I also double checked in myqsl.

just today noticed Akismet API token is expired. Anyway I disabled the plugin but issue persists.

Double checked.

Twenty Fifteen also does not show up comments.

Thanks again.

Yes I call

<?php comments_template(); ?>

in

single.php

I check
get_comments_number
before have_comments and it is 51.

But

<?php if ( have_comments() ) : ?>
returns false and

<?php wp_list_comments(); ?>

never executed.

Hey James,

Thanks for reply.

Disabled all plugins and switched to default themes. Issue persists.

I use custom template for 4 years. It did not create any issue till now.

Strangely, in comments.php

get_comments()

returns correctly all comments but

have_comments()

returns empty. That is why my current comments does not appear. I use have_comments() to list all approved comments.

But as of now, I am not sure why it returns empty and prevents comments to show up.

Any recommendation?

Oh, thank you very much. I will apply recommended security measures.

Cheers