Title: timbonicus's Replies | WordPress.org --- # timbonicus [ ](https://wordpress.org/support/users/timbonicus/) * [Profile](https://wordpress.org/support/users/timbonicus/) * [Topics Started](https://wordpress.org/support/users/timbonicus/topics/) * [Replies Created](https://wordpress.org/support/users/timbonicus/replies/) * [Reviews Written](https://wordpress.org/support/users/timbonicus/reviews/) * [Topics Replied To](https://wordpress.org/support/users/timbonicus/replied-to/) * [Engagements](https://wordpress.org/support/users/timbonicus/engagements/) * [Favorites](https://wordpress.org/support/users/timbonicus/favorites/) Search replies: ## Forum Replies Created Viewing 9 replies - 1 through 9 (of 9 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Popular Posts] Upgrade to 3.0 – Lost data No data so far](https://wordpress.org/support/topic/upgrade-to-30-lost-data-no-data-so-far/) * [timbonicus](https://wordpress.org/support/users/timbonicus/) * (@timbonicus) * [11 years, 5 months ago](https://wordpress.org/support/topic/upgrade-to-30-lost-data-no-data-so-far/page/2/#post-5017692) * Thanks Héctor, sorry to hijack the topic. * It appears that the “Post ID(s) to exclude” option is responsible for the mismatch. This gets applied in the outer where condition but not the sub-select. Some of the other exclusion conditions that get put into the where condition may be suspect as well (e.g. author). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Popular Posts] Upgrade to 3.0 – Lost data No data so far](https://wordpress.org/support/topic/upgrade-to-30-lost-data-no-data-so-far/) * [timbonicus](https://wordpress.org/support/users/timbonicus/) * (@timbonicus) * [11 years, 5 months ago](https://wordpress.org/support/topic/upgrade-to-30-lost-data-no-data-so-far/page/2/#post-5017690) * I’m having a similar problem after the update to 3.2.0. * I have a widget set to show up to 5 posts from the last 30 days. It displayed 5 until the upgrade, now it only shows 3 posts. * The problem seems to be in wordpress-popular-posts.php, line 1652: * ``` // ordered by views / avg else { $from = "(SELECT postid, IFNULL(SUM(pageviews), 0) AS pageviews FROM {$prefix}summary WHERE last_viewed > DATE_SUB('{$now}', INTERVAL {$interval}) GROUP BY postid ORDER BY pageviews DESC {$limit}) v LEFT JOIN {$wpdb->posts} p ON v.postid = p.ID"; ``` * The sub-select has {$limit}, limiting the sub-select results to 5. Then the outer select only returns 3 from this 5. If I remove {$limit} from the sub-select and add it to the outer query, it works as expected. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Mailchimp List Subscribe Form] Loading JS in the footer](https://wordpress.org/support/topic/loading-js-in-the-footer/) * [timbonicus](https://wordpress.org/support/users/timbonicus/) * (@timbonicus) * [12 years, 7 months ago](https://wordpress.org/support/topic/loading-js-in-the-footer/#post-4103533) * I’m also interested in this change, Google PageSpeed recommends against content- blocking JavaScript (including scripts in the header). * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [How to unschedule a draft](https://wordpress.org/support/topic/how-to-unschedule-a-draft/) * [timbonicus](https://wordpress.org/support/users/timbonicus/) * (@timbonicus) * [12 years, 7 months ago](https://wordpress.org/support/topic/how-to-unschedule-a-draft/#post-3371649) * A bit late to help Dominor I’m sure, but in case anyone else came across this post in a Google search like me… * The wp_posts post_date_gmt column is the scheduled date. It defaults to ‘0000- 00-00 00:00:00’ which means ‘publish immediately’. If you have a draft with a scheduled date that you want to remove, update this column to the default: * `update wp_posts set post_date_gmt='0000-00-00 00:00:00' where ID=` * One way to find the post ID is to search by title: `select ID, post_date, post_date_gmt, post_title, post_status from wp_posts where post_title like '%Keyword%' and post_status ='draft'` * Where Keyword is something from your title. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Popular Posts] Post counts incremented as expected, but counts are massively off](https://wordpress.org/support/topic/post-counts-incremented-as-expected-but-counts-are-massively-off/) * Thread Starter [timbonicus](https://wordpress.org/support/users/timbonicus/) * (@timbonicus) * [12 years, 8 months ago](https://wordpress.org/support/topic/post-counts-incremented-as-expected-but-counts-are-massively-off/#post-4079988) * Got it, the theme is using register_sidebar in functions.php and had an empty string for the before_widget/after_widget options. This overrides the default that adds an LI with a widget ID. * Sorry for the confusion! * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Popular Posts] Post counts incremented as expected, but counts are massively off](https://wordpress.org/support/topic/post-counts-incremented-as-expected-but-counts-are-massively-off/) * Thread Starter [timbonicus](https://wordpress.org/support/users/timbonicus/) * (@timbonicus) * [12 years, 8 months ago](https://wordpress.org/support/topic/post-counts-incremented-as-expected-but-counts-are-massively-off/#post-4079987) * I have some clues. The AJAX call works fine, but it’s trying to append the results to a jQuery object identified by $widget_id (‘#wpp-3’ in my case). * My theme renders widgets using the dynamic_sidebar function, which doesn’t seem to be setting widget IDs. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WP Popular Posts] Post counts incremented as expected, but counts are massively off](https://wordpress.org/support/topic/post-counts-incremented-as-expected-but-counts-are-massively-off/) * Thread Starter [timbonicus](https://wordpress.org/support/users/timbonicus/) * (@timbonicus) * [12 years, 8 months ago](https://wordpress.org/support/topic/post-counts-incremented-as-expected-but-counts-are-massively-off/#post-4079966) * Thanks Hector, I think the Ajaxify setting will clear out the fake views. The sidebar widget doesn’t show anything with this enabled; I see it reported in [this topic](http://wordpress.org/support/topic/ajaxify-causes-widget-to-disappear-and-views-inaccurate). Is the Ajaxify setting incompatible with the widget? * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Blank screen on automatic update to 3.5.2](https://wordpress.org/support/topic/blank-screen-on-automatic-update-to-352/) * Thread Starter [timbonicus](https://wordpress.org/support/users/timbonicus/) * (@timbonicus) * [12 years, 10 months ago](https://wordpress.org/support/topic/blank-screen-on-automatic-update-to-352/#post-3869596) * After some spelunking, I found that this was caused by a double-include of the Upgrader class in a theme file. * To be precise, Envato_WordPress_Theme_Upgrader from the envato-wordpress-toolkit- library was throwing an error “Cannot redeclare class Plugin_Upgrader”. * I switched to one of the default WordPress themes, performed the upgrade without any trouble, then switched back. Marking this as resolved. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Blank screen on automatic update to 3.5.2](https://wordpress.org/support/topic/blank-screen-on-automatic-update-to-352/) * Thread Starter [timbonicus](https://wordpress.org/support/users/timbonicus/) * (@timbonicus) * [12 years, 10 months ago](https://wordpress.org/support/topic/blank-screen-on-automatic-update-to-352/#post-3869515) * Right, if the automated install had run into a snag halfway through I’d definitely be concerned about corrupt or incomplete files. It seems as though the process doesn’t even start with my installation. * Does the automatic installation produce a log file somewhere to record what it’s done? The wp-content/upgrade folder was created, but there’s nothing in there. * I’m trying to dig rather than give up and do a manual install; if there’s a genuine WordPress problem I’d like to uncover it to help other users. If it’s a problem with my environment I’d like to fix it rather than revert to manual installation for all future updates. Viewing 9 replies - 1 through 9 (of 9 total)