«Cannot gather stats» while opening a product in the backend (and my fix)

dmitry_fedyuk · February 21, 2016, 3:54pm

A similar problem:

magento/magento2/blob/e0ed4bad/lib/internal/Magento/Framework/Filesystem/Driver/File.php#L58-L75


/**
 * Gathers the statistics of the given path
 *
 * @param string $path
 * @return array
 * @throws FileSystemException
 */
public function stat($path)
{
    clearstatcache();
    $result = @stat($this->getScheme() . $path);
    if (!$result) {
        throw new FileSystemException(
            new \Magento\Framework\Phrase('Cannot gather stats! %1', [$this->getWarningMessage()])
        );
    }
    return $result;
}

github.com

magento/magento2/blob/e0ed4bad/lib/internal/Magento/Framework/Filesystem/Directory/Read.php#L156-L166


/**
 * Gathers the statistics of the given path
 *
 * @param string $path
 * @return array
 * @throws \Magento\Framework\Exception\FileSystemException
 */
public function stat($path)
{
    return $this->driver->stat($this->driver->getAbsolutePath($this->path, $path));
}

github.com

magento/magento2/blob/e0ed4bad/app/code/Magento/Catalog/Block/Adminhtml/Product/Helper/Form/Gallery/Content.php#L123-L138


public function getImagesJson()
{
    if (is_array($this->getElement()->getImages())) {
        $value = $this->getElement()->getImages();
        $directory = $this->_filesystem->getDirectoryRead(DirectoryList::MEDIA);
        if (is_array($value['images']) && count($value['images']) > 0) {
            foreach ($value['images'] as &$image) {
                $image['url'] = $this->_mediaConfig->getMediaUrl($image['file']);
                $fileHandler = $directory->stat($this->_mediaConfig->getMediaPath($image['file']));
                $image['size'] = $fileHandler['size'];
            }
            return $this->_jsonEncoder->encode($value['images']);
        }
    }
    return '[]';
}

dmitry_fedyuk · February 21, 2016, 4:19pm

My fix

SET @file = '/0/0/00fd10a57da2c072fbf5f037824f6ece35476368_1__2.png';
START TRANSACTION;
DELETE FROM catalog_product_entity_media_gallery WHERE value = @file;
DELETE FROM catalog_product_entity_varchar WHERE value = @file;
COMMIT;

dmitry_fedyuk · March 1, 2016, 4:35pm

You should specify a path relative to the media/catalog/product folder.
So when yoy see the C:/work/mage2.pro/store/pub/media/catalog/product/m/b/mb01-blue-0.jpg path in the message, you should specify the /m/b/mb01-blue-0.jpg path in the SQL script.

dmitry_fedyuk · April 2, 2016, 3:09am

The failure is occured because of a bug in the sample data packages: during an upgrade the sample data packages remove all the non-sample data product images from the pub/media folder.

dmitry_fedyuk · April 9, 2016, 2:04am

https://github.com/magento/magento2/issues/4054

https://github.com/magento/magento2/issues/3951

https://github.com/magento/magento2/issues/3964