Matt

I obviously didn’t review my code well enough before posting that fix. I forgot to change a variable name from the source. It should be–

$post_date = current_time('mysql');
$post_date_gmt = get_gmt_from_date($post_date);

… not the ‘$current_time’ that I had.

Interestingly enough after typing this post and going back to my site and disabling multisite plugin manager, it now says the plugin is not active. I refreshed like 3 times before creating this thread.

I just turned it on. we’ll see if it happens again.

Here is your fix: https://www.diffchecker.com/a6wGmPQV

basically you want to use:

$post_date = current_time('mysql');
$post_date_gmt = get_gmt_from_date($current_time);

and then use those values in your UPDATE command for post_date and post_date_gmt.

$sql = $wpdb->prepare(
	"UPDATE $table_name SET post_date = '$post_date', post_date_gmt = '$post_date_gmt' WHERE ID = %d;",
	$ID
);
$wpdb->query($sql);

I got the idea from here: https://wp-mix.com/update-wordpress-post-current-time/

Tested and works.

(and you have this in two places, one for replace and the other for replace_and_search)

• This reply was modified 6 years, 3 months ago by Matt.

To be clear: my issue wasn’t with the time being updated, but HOW it’s being updated. I was pointing out a bug.

While I assumed this to be obvious, I figured I’d add a note that this is a time zone issue. I am GMT-5.

I am constantly having issues with this plugin thinking links are bad that don’t exist anymore. You’d think clicking “recheck” would at least re-check the content of the page too.

• This reply was modified 6 years, 7 months ago by Matt.

The cleaner page showed “media cleaner database not ready” (paraphrase) before clicking reset. After clicking reset that error went away but these appeared in the error log:

[27-Apr-2018 12:29:30 UTC] WordPress database error Table 'asd_wp.asdwp_mclean_scan' doesn't exist for query SELECT COUNT(*) FROM asdwp_mclean_scan WHERE ignored = 0 AND deleted = 0 made by require_once('d:\path\to\wp\wp-admin\admin.php'), do_action('media_page_media-cleaner'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Meow_WPMC_Core->wpmc_screen
[27-Apr-2018 12:29:30 UTC] WordPress database error Table 'asd_wp.asdwp_mclean_scan' doesn't exist for query SELECT SUM(size) FROM asdwp_mclean_scan WHERE ignored = 0 AND deleted = 0 made by require_once('d:\path\to\wp\wp-admin\admin.php'), do_action('media_page_media-cleaner'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Meow_WPMC_Core->wpmc_screen
[27-Apr-2018 12:29:30 UTC] WordPress database error Table 'asd_wp.asdwp_mclean_scan' doesn't exist for query SELECT SUM(size) FROM asdwp_mclean_scan WHERE ignored = 0 AND deleted = 1 made by require_once('d:\path\to\wp\wp-admin\admin.php'), do_action('media_page_media-cleaner'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Meow_WPMC_Core->wpmc_screen
[27-Apr-2018 12:29:30 UTC] WordPress database error Table 'asd_wp.asdwp_mclean_scan' doesn't exist for query SELECT COUNT(*) FROM asdwp_mclean_scan WHERE ignored = 1 made by require_once('d:\path\to\wp\wp-admin\admin.php'), do_action('media_page_media-cleaner'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Meow_WPMC_Core->wpmc_screen
[27-Apr-2018 12:29:30 UTC] WordPress database error Table 'asd_wp.asdwp_mclean_scan' doesn't exist for query SELECT COUNT(*) FROM asdwp_mclean_scan WHERE deleted = 1 made by require_once('d:\path\to\wp\wp-admin\admin.php'), do_action('media_page_media-cleaner'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Meow_WPMC_Core->wpmc_screen
[27-Apr-2018 12:29:30 UTC] WordPress database error Table 'asd_wp.asdwp_mclean_scan' doesn't exist for query SELECT id, type, postId, path, size, ignored, deleted, issue
						FROM asdwp_mclean_scan
						WHERE ignored = 0 AND deleted = 0  AND path LIKE '%%'
						ORDER BY time
						DESC LIMIT 0, 25 made by require_once('d:\path\to\wp\wp-admin\admin.php'), do_action('media_page_media-cleaner'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, Meow_WPMC_Core->wpmc_screen

However, it seems to be fixed now because subsequent click of reset does not re-produce the errors.

similar errors for ‘asd_wp.asdwp_mclean_scan`

WordPress database error Table ‘asd_wp.asdwp_mclean_scan’ doesn’t exist for query SELECT * FROM asdwp_mclean_scan WHERE postId = 11121 made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Media_List_Table->display_rows, WP_List_Table->single_row_columns, WP_Media_List_Table->handle_row_actions, WP_Media_List_Table->_get_row_actions, apply_filters(‘media_row_actions’), WP_Hook->apply_filters, call_user_func_array, Meow_WPMC_Core->media_row_actions

• This reply was modified 6 years, 11 months ago by Matt.

bump

Forgot to mention that image files are fine as well. It’s only the video (mp4) that’s a problem. Didn’t actually trying anything else other than a PNG and an mp4.

This plugin must be network activated?

I went back and found an old post because I didn’t want to mess up the one I just fixed. This post: https://www.abington.k12.pa.us/news/abington-senior-high-school-sculptureceramics-and-national-art-honor-society-students-create-fund-raising-bowls-for-annual-event/

Previously had this image set as a custom image (and it worked fine at that time): https://www.abington.k12.pa.us/media/posts/2015/12/2015-Empty-Bowl-Taylor-520×245.jpg

I just went in and changed the custom image to this: https://www.abington.k12.pa.us/media/posts/2015/12/2015-Empty-Bowl-Taylor-720×340.jpg

Now when I re-scrape it in the facebook debugger it warns me at the top:

Provided og:image, https://www.abington.k12.pa.us/media/posts/2015/12/2015-Empty-Bowl-Taylor.jpg could not be downloaded because it exceeded the maximum allowed sized of 8Mb or your server was too slow to respond.

(which is not the correct image)

I am having the same problem. If you specify the image under “Custom Image” by pasting in the URL of the image, it does not work. If you select an image under “image” (where it gives you the radio buttons for options) then it DOES work.

Have been using AIO for a long time and have always used the “custom image” option without issue. Tried multiple times this time and using the image picker was the only way I could get it to work. Definitely something going on.

p.s. in the image debugger the “og:image” tag is NOT correct when using “custom image”

• This reply was modified 7 years, 7 months ago by Matt.
• This reply was modified 7 years, 7 months ago by Matt.

bueller?