News & Views.

The latest news, web designs and digital projects happening at Storm.

Sharing is caring:

Unknown column database error in WP Popular Posts 2.3

Adam Pope Profile Image

Adam Pope
September 3, 2012

We just upgraded WP Popular Posts to 2.3 and found that it left the site littered with database errors like this

WordPress database error: [Unknown column 'day_no_time' in 'field list']

INSERT INTO wp_popularpostsdatacache (id, day, day_no_time) VALUES (400, '2012-09-03 14:09:10', '2012-09-03') ON DUPLICATE KEY UPDATE pageviews = pageviews + 1, day = '2012-09-03 14:09:10', day_no_time = '2012-09-03';

Notice: Undefined property: wpdb::$print_error in /wp-content/plugins/wordpress-popular-posts/wordpress-popular-posts.php on line 483

Simple fix to this one – deactivate the plugin and reactivate it.