• Resolved ninportal

    (@ninportal)


    I moved WordPress to a new Server and updated my WordPress site from 4.5.3 to 4.9.8 the other day.
    After that, wordpress popular posts plugin doesn’t work on only one site.(My wordpress is Multisite.)

    ——
    ■Contents of Debug Screen

    PHP version: 7.2.12

    PHP extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, gettext, SPL, iconv, session, json, ldap, mbstring, standard, mysqlnd, pcntl, mysqli, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, apcu, posix, Reflection, imap, SimpleXML, soap, sockets, exif, sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, cgi-fcgi, apc, Phar, imagick, Zend OPcache

    Database version: 10.0.37-MariaDB-wsrep

    InnoDB availability: DEFAULT

    WordPress version: 4.9.8

    Multisite: Yes

    External object cache: No

    WPP_CACHE_VIEWS: No

    Active plugins: Active Directory Integration 1.1.8, All-in-One WP Migration 6.83, All-in-One WP Migration Multisite Extension 3.65, BackWPup 3.6.7, Breadcrumb NavXT 6.2.1, Category Order 1.0.3, Contact Form 7 5.1.1, Count Per Day 3.6.1, Highlight Search Terms 1.5, Raw HTML 1.5.1, Search Exclude 1.2.2, TinyMCE Advanced 5.0.0, Unfiltered MU 1.3.1, Use Google Libraries 1.6.2.3, WordPress Popular Posts 4.2.2, WP DS FAQ 1.3.3, WP Multibyte Patch 2.8.2

    Theme: BizVektor (1.12.0) by Vektor,Inc.
    ——

    The following is apache error log.
    Got error ‘PHP message:
    Unknown column ‘view_datetime’ in ‘field list’ for query INSERT INTO wp_11_popularpostssummary\r\n (postid, pageviews, view_date, view_datetime) VALUES (6636, 1, ‘2019-01-30’, ‘2019-01-30 09:13:50’)\r\n ON DUPLICATE KEY UPDATE pageviews = pageviews + 1, view_datetime = ‘2019-01-30 09:13:50’;
    made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Popular_Posts_Controller->update_views_count\n’,

    I deleted WordPress Popular Posts chache and data.

    What should I do?

    Thank you,

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Hector Cabrera

    (@hcabrera)

    Hi @ninportal,

    Unknown column ‘view_datetime’ in ‘field list’

    You’re seeing this error because WordPress Popular Posts couldn’t update its database tables. This happens when your database user doesn’t have enough permissions to modify tables.

    Try running this query manually via PHPMyAdmin (or whichever database management tool your hosting provider offers):

    ALTER TABLE wp_popularpostssummary CHANGE last_viewed view_datetime datetime NOT NULL, ADD KEY view_datetime (view_datetime);

    Remember to change the wp_ prefix to the one your site uses.

    Please report back your results.

    Thread Starter ninportal

    (@ninportal)

    Thank you for your quick response.
    This was resolved by running the query.

    Thank you!!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Not working after update to 4.9.8’ is closed to new replies.