[Plugin: Auto Post Thumbnail] WordPress 3.4: Stopped Working, Thumbnails Missing

Hi all,

I am having the same problem and just want to make sure I am doing all the steps right.

I downloaded the fix for 3.4 at https://www.sanisoft.com/downloads/auto-post-thumbnail-for34.zip

and then did the clickthroughmarketing fix here and ran this php script: https://www.clickthrough-marketing.com/how-to-fix-auto-post-thumbnail-on-wordpress-3.4-seo-friendly-800610805/

I then went to the auto post thumbnail settings and regenerated the thumbnails and it’s still not working.

Am I doing something wrong? Thanks in advance for any help…

In case anyone is having this issue independent of this plugin (such as after importing images directly through a custom script during a site transfer), here’s how I solved it:


INSERT INTO wp_postmeta
(post_id,meta_key,meta_value)
SELECT
p.ID post_id,
‘_wp_attached_file’ meta_key,
REPLACE(p.guid,’https://www.yoursite.com/wp-content/uploads/’,”) meta_value
FROM wp_posts p
LEFT OUTER JOIN wp_postmeta m
ON m.post_id=p.ID
WHERE p.post_type=’attachment’
AND p.post_parent!=0
AND (SELECT COUNT(e.post_id) FROM wp_postmeta e WHERE e.meta_key=’_wp_attached_file’ AND e.post_id = p.ID)=0

Marking this thread as resolved. Create new threads for new issues

Not totally resolved to be honest @3c32’s solution worked for me, however, the specific media item needed to be connected to a post, if not, it wouldn’t be recovered. Any idea @3c32?

——

EDIT: Found it! Just don’t search for a post parent in the query. Like this:

INSERT INTO wpsteez_postmeta
(post_id,meta_key,meta_value)
SELECT
p.ID post_id,
'_wp_attached_file' meta_key,
REPLACE(p.guid,'https://localhost:8888/arcus/wp-content/uploads/','') meta_value
FROM wpsteez_posts p
LEFT OUTER JOIN wpsteez_postmeta m
ON m.post_id=p.ID
WHERE p.post_type='attachment'
AND (SELECT COUNT(e.post_id) FROM wpsteez_postmeta e WHERE e.meta_key='_wp_attached_file' AND e.post_id = p.ID)=0

fix.php

https://paste.php.lv/e89e7b6bf2767cb3b210719e8236456b/nonum

<?php

//////////////////////////////////////////////////////////////////////

ini_set('display_errors', 1);
ini_set('error_reporting', 'E_ALL & ~E_NOTICE');

header('Content-Type: text/html; charset=utf-8'); 

//////////////////////////////////////////////////////////////////////

include_once('wp-config.php');
include_once('wp-load.php');
include_once('wp-includes/wp-db.php');

//////////////////////////////////////////////////////////////////////

global $wpdb;

$q = "SELECT post_id, meta_value FROM ".$wpdb->postmeta." WHERE meta_key='_wp_attachment_metadata'";
$myrows = $wpdb->get_results($q);
$i=0;
foreach($myrows as $myrow)
{
	$id = null;
	$us = null;
	$_wp_attached_file = null;
	$_wp_attached_file_exists = null;

	$us = unserialize($myrow->meta_value);
	$post_id = $myrow->post_id;
	$_wp_attached_file = $us['file'] ;

	$q = "SELECT <code>meta_id</code> FROM <code>".$wpdb->postmeta."</code> WHERE <code>meta_key</code> = '_wp_attached_file' AND <code>post_id</code> = '".$post_id."' LIMIT 1";
	$_wp_attached_file_exists = $wpdb->get_var($q);
	if($_wp_attached_file_exists=='')
	{
		$i++;
		echo '<p> '.$i.' - _wp_attached_file not found - '.$id.'</p>';
		$q = "INSERT INTO <code>".$wpdb->postmeta."</code> SET <code>post_id</code> = '".$post_id."', meta_key='_wp_attached_file', meta_value='".$_wp_attached_file."'";
		$wpdb->query($q);
	}
}

//////////////////////////////////////////////////////////////////////

i always use external images in my posts. but this plugin is not generating thumbnails for url-linked images. is it supposed to generate thumbnails for uploaded images only?

not sure if this can help… but
I uploaded to 3.4. found same problem with the thumbnails, all disappear.

After reading the above, I wrote a snippet which I inserted into my single.php page. Since my site is traversed by google daily, I’ll let the robots update my meta info.

My approach is simple. just grab and insert the appropriate meta info into _wp_attached_file with the filename. see code further below for how-to.
as in.
Meta ID ID meta key meta value
2102702 134444 _wp_attached_file 2010/09/desk1-170×146.jpg

now the question is… do I also have to add the
_wp_attachment_metadata too?

My plan is to run this on my 3.3.1 blog for a while, then upgrade to 3.4 when I am sure all my posts have been updated.
This avoids deleting, regenerating, or even touching my actual images or thumbnails, and switching over to 3.4 only when all is stable.
NOTE: ASSUMPTION code below will parse out the upload dir based on any blog upload dir which is from year 2000 onwards to 2099.

if (has_post_thumbnail( $post->ID ) ) {
$image = wp_get_attachment_image_src(
$theid = get_post_thumbnail_id( $post->ID ), 'single-post-thumbnail' );
echo '<br>' . $theid .'<br>' ;
if (get_post_meta($theid, '_wp_attached_file',  true) == '') { echo "No attached file... inserting now" ; } else { echo "here's the meta: " . get_post_meta($theid, '_wp_attached_file',  true); }
$thumbnailURL = $image[0];
 $newstring = strstr ($thumbnailURL, "20") ;
add_post_meta($theid, '_wp_attached_file', $newstring, true);
}

NOTE: you can take out the echo statements above… I find them convenient just for debugging, of course.

By placing this on the single.php page, the job is done automagically for me and I can get back to biz..

So.. the only question now the question is… do I also have to add the
_wp_attachment_metadata too?

vincej,

I am a complete novice to php, and appreciate the share ..
“”NOTE: ASSUMPTION code below will parse out the upload dir based on any blog upload dir which is from year 2000 onwards to 2099.””

Can you please modify to include offsite images?

The following script did it for me (handmade).
What it does is this:
It selects all post_id values from wp_postmeta which have meta_key _wp_attachment_metadata.
It then runs a loop checking if there is a row in the table with any of those post_ids that have meta_key _wp_attached_file.
If there isn’t a meta_key _wp_attached_file
it fetches the guid from wp_posts with id = post_id, removes https://www.YOURDOMAIN.gr/wp-content/uploads/ from the value of guid and inserts a new row at wp_postmeta with meta_key _wp_attached_file and meta_value the substring of the guid.

NOTE: if your table prefix is not wp_ you should change the lines the words wp_postmeta and wp_posts with those of your mysql tables.

Also replace first line YOURCONNECTIONSCRIPT.php with your connection to the database and https://www.YOURDOMAIN.com on line 56 with your url.

Running this scirpt will with those changes will output a list with the post_id, the value to be entered and the query to the database that will add the rows to wp_postmeta. (It will not add anything in the first time). If you want to be sure just do 1 insert manually (take the line from the output and do the query on your db) and check if the post is fixed.
If yes you should remove the comments on line 63 so the script can run the queries and run it again. You will see again a large output with all the changes.
Run it again and you ll see nothing. This shows that everything entered as intended.

Here is the code, i hope i helped.

<?php require_once('YOURCONNECTIONSCRIPT.php'); ?>
<?php

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_myconnection, $myconnection);
$query_Recordset1 = "SELECT post_id FROM wp_postmeta WHERE meta_value like '%jpg%'and meta_key='_wp_attachment_metadata'";
$Recordset1 = mysql_query($query_Recordset1, $myconnection) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
$counter='0';
 do {
$postid = $row_Recordset1['post_id']; 

$query_Recordset2 = "SELECT post_id FROM wp_postmeta WHERE post_id ='$postid' AND meta_key='_wp_attached_file'";
$Recordset2 = mysql_query($query_Recordset2, $myconnection) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
if (!isset($row_Recordset2['post_id'])){
echo $postid;
$query_Recordset3 = "SELECT guid FROM wp_posts WHERE id ='$postid'";
$Recordset3 = mysql_query($query_Recordset3, $myconnection) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);

$newguid = str_replace('https://www.YOURDOMAIN.com/wp-content/uploads/', '', $row_Recordset3['guid']); 

echo "   ".$newguid."<br/>";
echo "INSERT INTO <code>wp_postmeta</code> (<code>meta_id</code> ,<code>post_id</code> ,<code>meta_key</code> ,<code>meta_value</code>) VALUES (NULL ,  '$postid',  '_wp_attached_file',  '$newguid')";

#### REMOVE THE COMMENTS FROM THE NEXT LINE AFTER YOU SEE THE FEEDBACK AND RUN THE SCRIPT AGAIN
## mysql_query("INSERT INTO <code>wp_postmeta</code> (<code>meta_id</code> ,<code>post_id</code> ,<code>meta_key</code> ,<code>meta_value</code>) VALUES (NULL ,  '$postid',  '_wp_attached_file',  '$newguid')", $myconnection) or die(mysql_error());

$counter++;
}
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
echo $counter;
if ($counter==0){echo "Great success!";}
?>
<?php
mysql_free_result($Recordset1);
mysql_free_result($Recordset2);
?>

So rather than trying to catch up on 3 pages of posts, what’s the verdict? Is this plugin fixed? Or was it a WP bug, and did 3.4.2 fix it? Where are we at?

Works fine with 3.5