Troubleshooting

Working with files and folders in Magento2

Magento® 2 offers you a bunch methods for file and folder operations, which allow you to implement quality modules in a short time. Especially if you are planning to publish modules on the Magento Marketplace you have to use those functions, otherwise you won’t meet Magento’s coding standards. In order to have access to cool functions like mkdirRecursive, deleteDirectory or changePermissionsRecursively simply inject \Magento\Framework\Filesystem\Driver\File in your constructor.

protected $driverFile;
...
public function __construct(
    ...
    \Magento\Framework\Filesystem\Driver\File $driverFile,
    ...
) {
    $this->driverFile = $driverFile;
    ...
    parent::__construct($context);
}

protected $driverFile;

...

public function __construct(

...

\Magento\Framework\Filesystem\Driver\File $driverFile,

...

) {

$this->driverFile = $driverFile;

...

parent::__construct($context);

}

Once you have re-compiled your code, you should be able to use those functions in your modules like below.

if ($this->driverFile->isExists(...)) {
...
}

if ($this->driverFile->isExists(...)) {

...

}

More functions are listed below.

1. Check if the file or folder exists on the file system.

/**
 * Is file or directory exist in file system
 *
 * @param string $path
 * @return bool
 * @throws FileSystemException
 */
public function isExists($path)

/**

* Is file or directory exist in file system

* @param string $path

* @return bool

* @throws FileSystemException

public function isExists($path)

2. Returns information like ctime and mtime or size, atime, uid and gid.

/**
 * Gathers the statistics of the given path
 *
 * @param string $path
 * @return array
 * @throws FileSystemException
 */
public function stat($path)

/**

* Gathers the statistics of the given path

* @param string $path

* @return array

* @throws FileSystemException

public function stat($path)

3. Check if a file is readable

/**
 * Check permissions for reading file or directory
 *
 * @param string $path
 * @return bool
 * @throws FileSystemException
 */
public function isReadable($path)

/**

* Check permissions for reading file or directory

* @param string $path

* @return bool

* @throws FileSystemException

public function isReadable($path)

4. Check if path is a file ( not folder )

/**
 * Tells whether the filename is a regular file
 *
 * @param string $path
 * @return bool
 * @throws FileSystemException
 */
public function isFile($path)

/**

* Tells whether the filename is a regular file

* @param string $path

* @return bool

* @throws FileSystemException

public function isFile($path)

5. Check if path is a directory ( not a file )

/**
 * Tells whether the filename is a regular directory
 *
 * @param string $path
 * @return bool
 * @throws FileSystemException
 */
public function isDirectory($path)

/**

* Tells whether the filename is a regular directory

* @param string $path

* @return bool

* @throws FileSystemException

public function isDirectory($path)

6. Get content of a regular file

/**
 * Retrieve file contents from given path
 *
 * @param string $path
 * @param string|null $flag
 * @param resource|null $context
 * @return string
 * @throws FileSystemException
 */
public function fileGetContents($path, $flag = null, $context = null)

/**

* Retrieve file contents from given path

* @param string $path

* @param string|null $flag

* @param resource|null $context

* @return string

* @throws FileSystemException

public function fileGetContents($path, $flag = null, $context = null)

7. Check if a regular file is writable ( not a folder )

/**
 * Check if given path is writable
 *
 * @param string $path
 * @return bool
 * @throws FileSystemException
 */
public function isWritable($path)

/**

* Check if given path is writable

* @param string $path

* @return bool

* @throws FileSystemException

public function isWritable($path)

8. Return the parent directory of a path

/**
 * Returns parent directory's path
 *
 * @param string $path
 * @return string
 */
public function getParentDirectory($path)

/**

* Returns parent directory's path

* @param string $path

* @return string

public function getParentDirectory($path)

9. Create a new directory with specific permissions

/**
 * Create directory
 *
 * @param string $path
 * @param int $permissions
 * @return bool
 * @throws FileSystemException
 */
public function createDirectory($path, $permissions = 0777)

/**

* Create directory

* @param string $path

* @param int $permissions

* @return bool

* @throws FileSystemException

public function createDirectory($path, $permissions = 0777)

10. Create a new directory recursively

/**
 * Create a directory recursively taking into account race conditions
 *
 * @param string $path
 * @param int $permissions
 * @return bool
 * @throws FileSystemException
 */
private function mkdirRecursive($path, $permissions = 0777)

/**

* Create a directory recursively taking into account race conditions

* @param string $path

* @param int $permissions

* @return bool

* @throws FileSystemException

private function mkdirRecursive($path, $permissions = 0777)

11. Reads a directory and returns an array with all paths of its sub-directories

/**
 * Read directory
 *
 * @param string $path
 * @return string[]
 * @throws FileSystemException
 */
public function readDirectory($path)

/**

* Read directory

* @param string $path

* @return string[]

* @throws FileSystemException

public function readDirectory($path)

12. Search for a path

/**
 * Search paths by given regex
 *
 * @param string $pattern
 * @param string $path
 * @return string[]
 * @throws FileSystemException
 */
public function search($pattern, $path)

/**

* Search paths by given regex

* @param string $pattern

* @param string $path

* @return string[]

* @throws FileSystemException

public function search($pattern, $path)

13. Rename a regular file or a directory

/**
 * Renames a file or directory
 *
 * @param string $oldPath
 * @param string $newPath
 * @param DriverInterface|null $targetDriver
 * @return bool
 * @throws FileSystemException
 */
public function rename($oldPath, $newPath, DriverInterface $targetDriver = null)

/**

* Renames a file or directory

* @param string $oldPath

* @param string $newPath

* @param DriverInterface|null $targetDriver

* @return bool

* @throws FileSystemException

public function rename($oldPath, $newPath, DriverInterface $targetDriver = null)

14. Copy a file from A to B

/**
 * Copy source into destination
 *
 * @param string $source
 * @param string $destination
 * @param DriverInterface|null $targetDriver
 * @return bool
 * @throws FileSystemException
 */
public function copy($source, $destination, DriverInterface $targetDriver = null)

/**

* Copy source into destination

* @param string $source

* @param string $destination

* @param DriverInterface|null $targetDriver

* @return bool

* @throws FileSystemException

public function copy($source, $destination, DriverInterface $targetDriver = null)

15. Create a symlink

/**
 * Create symlink on source and place it into destination
 *
 * @param string $source
 * @param string $destination
 * @param DriverInterface|null $targetDriver
 * @return bool
 * @throws FileSystemException
 */
public function symlink($source, $destination, DriverInterface $targetDriver = null)

/**

* Create symlink on source and place it into destination

* @param string $source

* @param string $destination

* @param DriverInterface|null $targetDriver

* @return bool

* @throws FileSystemException

public function symlink($source, $destination, DriverInterface $targetDriver = null)

16. Delete a regular file ( not a file )

/**
 * Delete file
 *
 * @param string $path
 * @return bool
 * @throws FileSystemException
 */
public function deleteFile($path)

/**

* Delete file

* @param string $path

* @return bool

* @throws FileSystemException

public function deleteFile($path)

17. Delete a directory recursively

/**
 * Recursive delete directory
 *
 * @param string $path
 * @return bool
 * @throws FileSystemException
 */
public function deleteDirectory($path)

/**

* Recursive delete directory

* @param string $path

* @return bool

* @throws FileSystemException

public function deleteDirectory($path)

18. Change permissions of a directory

/**
 * Change permissions of given path
 *
 * @param string $path
 * @param int $permissions
 * @return bool
 * @throws FileSystemException
 */
public function changePermissions($path, $permissions)

/**

* Change permissions of given path

* @param string $path

* @param int $permissions

* @return bool

* @throws FileSystemException

public function changePermissions($path, $permissions)

19. Change permissions of a directory and file recursively

/**
 * Recursively change permissions of given path
 *
 * @param string $path
 * @param int $dirPermissions
 * @param int $filePermissions
 * @return bool
 * @throws FileSystemException
 */
public function changePermissionsRecursively($path, $dirPermissions, $filePermissions)

/**

* Recursively change permissions of given path

* @param string $path

* @param int $dirPermissions

* @param int $filePermissions

* @return bool

* @throws FileSystemException

public function changePermissionsRecursively($path, $dirPermissions, $filePermissions)

20. Manipulate the access and modification time of a file

/**
 * Sets access and modification time of file.
 *
 * @param string $path
 * @param int|null $modificationTime
 * @return bool
 * @throws FileSystemException
 */
public function touch($path, $modificationTime = null)

/**

* Sets access and modification time of file.

* @param string $path

* @param int|null $modificationTime

* @return bool

* @throws FileSystemException

public function touch($path, $modificationTime = null)

21. Write content to a file

/**
 * Write contents to file in given path
 *
 * @param string $path
 * @param string $content
 * @param string|null $mode
 * @return int The number of bytes that were written.
 * @throws FileSystemException
 */
public function filePutContents($path, $content, $mode = null)

/**

* Write contents to file in given path

* @param string $path

* @param string $content

* @param string|null $mode

* @return int The number of bytes that were written.

* @throws FileSystemException

public function filePutContents($path, $content, $mode = null)

22. Opens a file like fopen

/**
 * Open file
 *
 * @param string $path
 * @param string $mode
 * @return resource file
 * @throws FileSystemException
 */
public function fileOpen($path, $mode)

/**

* Open file

* @param string $path

* @param string $mode

* @return resource file

* @throws FileSystemException

public function fileOpen($path, $mode)

23. Returns a line from the given handle

/**
 * Reads the line content from file pointer (with specified number of bytes from the current position).
 *
 * @param resource $resource
 * @param int $length
 * @param string $ending [optional]
 * @return string
 * @throws FileSystemException
 */
public function fileReadLine($resource, $length, $ending = null)

/**

* Reads the line content from file pointer (with specified number of bytes from the current position).

* @param resource $resource

* @param int $length

* @param string $ending [optional]

* @return string

* @throws FileSystemException

public function fileReadLine($resource, $length, $ending = null)

24. Reads a file like fread.

/**
 * Reads the specified number of bytes from the current position.
 *
 * @param resource $resource
 * @param int $length
 * @return string
 * @throws FileSystemException
 */
public function fileRead($resource, $length)

/**

* Reads the specified number of bytes from the current position.

* @param resource $resource

* @param int $length

* @return string

* @throws FileSystemException

public function fileRead($resource, $length)

25. Reads a CSV file like fgetcsv

/**
 * Reads one CSV row from the file
 *
 * @param resource $resource
 * @param int $length [optional]
 * @param string $delimiter [optional]
 * @param string $enclosure [optional]
 * @param string $escape [optional]
 * @return array|bool|null
 * @throws FileSystemException
 */
public function fileGetCsv($resource, $length = 0, $delimiter = ',', $enclosure = '"', $escape = '\\')

/**

* Reads one CSV row from the file

* @param resource $resource

* @param int $length [optional]

* @param string $delimiter [optional]

* @param string $enclosure [optional]

* @param string $escape [optional]

* @return array|bool|null

* @throws FileSystemException

public function fileGetCsv($resource, $length = 0, $delimiter = ',', $enclosure = '"', $escape = '\\')

26. Returns position of a pointer like ftell

/**
 * Returns position of read/write pointer
 *
 * @param resource $resource
 * @return int
 * @throws FileSystemException
 */
public function fileTell($resource)

/**

* Returns position of read/write pointer

* @param resource $resource

* @return int

* @throws FileSystemException

public function fileTell($resource)

27. Seeks to a specific offset like fseek

/**
 * Seeks to the specified offset
 *
 * @param resource $resource
 * @param int $offset
 * @param int $whence
 * @return int
 * @throws FileSystemException
 */
public function fileSeek($resource, $offset, $whence = SEEK_SET)

/**

* Seeks to the specified offset

* @param resource $resource

* @param int $offset

* @param int $whence

* @return int

* @throws FileSystemException

public function fileSeek($resource, $offset, $whence = SEEK_SET)

28. Returns true if pointer is at the end of a file

/**
 * Returns true if pointer at the end of file or in case of exception
 *
 * @param resource $resource
 * @return boolean
 */
public function endOfFile($resource)

/**

* Returns true if pointer at the end of file or in case of exception

* @param resource $resource

* @return boolean

public function endOfFile($resource)

29. Close a file

/**
 * Close file
 *
 * @param resource $resource
 * @return boolean
 * @throws FileSystemException
 */
public function fileClose($resource)

/**

* Close file

* @param resource $resource

* @return boolean

* @throws FileSystemException

public function fileClose($resource)

30. Write to a file like fwrite

/**
 * Writes data to file
 *
 * @param resource $resource
 * @param string $data
 * @return int
 * @throws FileSystemException
 */
public function fileWrite($resource, $data)

/**

* Writes data to file

* @param resource $resource

* @param string $data

* @return int

* @throws FileSystemException

public function fileWrite($resource, $data)

31. Write one row to a CSV file

/**
 * Writes one CSV row to the file.
 *
 * @param resource $resource
 * @param array $data
 * @param string $delimiter
 * @param string $enclosure
 * @return int
 * @throws FileSystemException
 */
public function filePutCsv($resource, array $data, $delimiter = ',', $enclosure = '"')

/**

* Writes one CSV row to the file.

* @param resource $resource

* @param array $data

* @param string $delimiter

* @param string $enclosure

* @return int

* @throws FileSystemException

public function filePutCsv($resource, array $data, $delimiter = ',', $enclosure = '"')

32. Flush output of a file. See fflush.

/**
 * Flushes the output
 *
 * @param resource $resource
 * @return bool
 * @throws FileSystemException
 */
public function fileFlush($resource)

/**

* Flushes the output

* @param resource $resource

* @return bool

* @throws FileSystemException

public function fileFlush($resource)

33. Lock a file before write content to a file

/**
 * Lock file in selected mode
 *
 * @param resource $resource
 * @param int $lockMode
 * @return bool
 * @throws FileSystemException
 */
public function fileLock($resource, $lockMode = LOCK_EX)

/**

* Lock file in selected mode

* @param resource $resource

* @param int $lockMode

* @return bool

* @throws FileSystemException

public function fileLock($resource, $lockMode = LOCK_EX)

34. Unlock a file after all file manipulations are done

/**
 * Unlock file
 *
 * @param resource $resource
 * @return bool
 * @throws FileSystemException
 */
public function fileUnlock($resource)

/**

* Unlock file

* @param resource $resource

* @return bool

* @throws FileSystemException

public function fileUnlock($resource)

35. Return a absolute path

/**
 * @param string $basePath
 * @param string $path
 * @param string|null $scheme
 * @return string
 */
public function getAbsolutePath($basePath, $path, $scheme = null)

/**

* @param string $basePath

* @param string $path

* @param string|null $scheme

* @return string

public function getAbsolutePath($basePath, $path, $scheme = null)

36. Fixes a path separator

/**
 * Fixes path separator
 * Utility method.
 *
 * @param string $path
 * @return string
 */
protected function fixSeparator($path)

/**

* Fixes path separator

* Utility method.

* @param string $path

* @return string

protected function fixSeparator($path)

37. Reads a directory recursively and returns paths as an array

/**
 * Read directory recursively
 *
 * @param string $path
 * @return string[]
 * @throws FileSystemException
 */
public function readDirectoryRecursively($path = null)

/**

* Read directory recursively

* @param string $path

* @return string[]

* @throws FileSystemException

public function readDirectoryRecursively($path = null)

38. Return the real path like realpath

/**
 * Get real path
 *
 * @param string $path
 *
 * @return string|bool
 */
public function getRealPath($path)

/**

* Get real path

* @param string $path

* @return string|bool

public function getRealPath($path)

39. Returns a path for link

/**
 * Return correct path for link
 *
 * @param string $path
 * @return mixed
 */
public function getRealPathSafety($path)

/**

* Return correct path for link

* @param string $path

* @return mixed

public function getRealPathSafety($path)

Cheers

The use of function filectime() / filemtime() is discouraged in Magento2

The problem I had today was located in a helper ( [Namespace]\[Module]\Helper\FileSystem ) which I have created for some basic filesystem operations. The below message was the result of Magento’s EQP which I use before I commit any code.

 68 | WARNING | The use of function filectime() is discouraged
 69 | WARNING | The use of function filemtime() is discouraged

1 2	68 \| WARNING \| The use of function filectime() is discouraged 69 \| WARNING \| The use of function filemtime() is discouraged

The warning message basically means, I should find another way to get the creation and modification time of a file because of Magento’s coding standards. I have done that a couple of times already and would like to share my solution this time. First you have to pass \Magento\Framework\Filesystem\Driver\File in your existing constructor or create a new one.

protected $driverFile;
...
public function __construct(
    ...
    \Magento\Framework\Filesystem\Driver\File $driverFile,
    ...
) {
    $this->driverFile = $driverFile;
    ...
    parent::__construct($context);
}

protected $driverFile;

...

public function __construct(

...

\Magento\Framework\Filesystem\Driver\File $driverFile,

...

) {

$this->driverFile = $driverFile;

...

parent::__construct($context);

}

Once you have re-compiled your code, you have access to the file stats as follows.

$file = '/absolute/path/to/your/file.extension';
$fileData = $this->driverFile->stat($file);

1 2	$file = '/absolute/path/to/your/file.extension'; $fileData = $this->driverFile->stat($file);

Beside ctime and mtime the array $fileData should have other file information like size, atime, uid and gid.

UI Components and searchResultToOutput in Magento2

Today I had to fix the following issue in a custom module. The error appeared on the UI Component list view.

Fatal error: Method Magento\Ui\TemplateEngine\Xhtml\Result::__toString() must not throw an exception, caught TypeError: Argument 1 passed to Magento\Framework\View\Element\UiComponent\DataProvider\DataProvider::searchResultToOutput() must implement interface Magento\Framework\Api\Search\SearchResultInterface, instance of [Namespace]\[Module]\Model\ResourceModel\Team\Collection given, called in

Fatal error: Method Magento\Ui\TemplateEngine\Xhtml\Result::__toString() must not throw an exception, caught TypeError: Argument 1 passed to Magento\Framework\View\Element\UiComponent\DataProvider\DataProvider::searchResultToOutput() must implement interface Magento\Framework\Api\Search\SearchResultInterface, instance of [Namespace]\[Module]\Model\ResourceModel\Team\Collection given, called in

I found the reason of the problem in the di.xml file. All what was missing was the following virtualType node. After adding this and re-compiling the code, the list view was fixed.

<virtualType name="[Namespace]\[Module]\Model\ResourceModel\Team\Collection" type="Magento\Framework\View\Element\UiComponent\DataProvider\SearchResult">
    <arguments>
        <argument name="mainTable" xsi:type="string">[namespace]_[module]_team</argument>
        <argument name="resourceModel" xsi:type="string">[Namespace]\[Module]\Model\ResourceModel\Team</argument>
    </arguments>
</virtualType>

<argument name="mainTable" xsi:type="string">[namespace]_[module]_team</argument>

<argument name="resourceModel" xsi:type="string">[Namespace]\[Module]\Model\ResourceModel\Team</argument>

</arguments>

</virtualType>

UI Component Listing And Not registered handle in Magento2

Today I created a new listing for a custom module, but unfortunately all what I got was the error message below.

Not registered handle [namespace]_[module]_team_index_data_source

1	Not registered handle [namespace]_[module]_team_index_data_source

After digging around for few minutes I noticed the above handler was actually missing in the di.xml file. I simply added the following collections argument and re-compiled the code.

<type name="Magento\Framework\View\Element\UiComponent\DataProvider\CollectionFactory">
    <arguments>
        <argument name="collections" xsi:type="array">
            ...
            <item name="[namespace]_[module]_team_index_data_source" xsi:type="string">[Namespace]\[Module]\Model\ResourceModel\Team\Collection</item>
            ...
        </argument>
    </arguments>
</type>

...

<item name="[namespace]_[module]_team_index_data_source" xsi:type="string">[Namespace]\[Module]\Model\ResourceModel\Team\Collection</item>

...

</argument>

</arguments>

</type>

All good!

Update composer.lock without updating code

Recently I had to fix a broken composer.lock but without actually updating code. I have found the composer option ” nothing ” which updates the composer.lock file only.

$ composer update nothing

1	$ composer update nothing

Once the command ran successfully, you should see a line ” Writing lock file ” in the output.

$ composer update nothing
Loading composer repositories with package information
Updating dependencies (including require-dev)
Nothing to install or update
Writing lock file
Generating autoload files

$ composer update nothing

Loading composer repositories with package information

Updating dependencies (including require-dev)

Nothing to install or update

Writing lock file

Generating autoload files

If you have issues with dependencies you can update the composer.lock file with –ignore-platform-reqs.

$ composer update nothing --ignore-platform-reqs

1	$ composer update nothing --ignore-platform-reqs

Missing required argument $name of Xtento\ProductExport\Logger\Logger.

If you are using Xtento in combination with an automated product importer, you may have seen the following error before.

Missing required argument $name of Xtento\ProductExport\Logger\Logger.

1	Missing required argument $name of Xtento\ProductExport\Logger\Logger.

The error message appears right after saving a product. The reason is that, at least one of your products in Products > Catalog has no Name. To fix this, you can update the name manually via MySQL queries or simply delete the products and import again correctly.

Category “Default Category/abc/def/” has not been created. URL key for specified store already exists in Magento2

A new day, a new problem. While importing new products in Magento 2.1.2 via System > Data Transfer > Import something was causing the following error message.

1. Category "Default Category/abc/def/" has not been created. URL key for specified store already exists. in row(s): 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

1	1. Category "Default Category/abc/def/" has not been created. URL key for specified store already exists. in row(s): 1, 2, 3, 4, 5, 6, 7, 8, 9, 10

The CSV file was 100% correct, which was making it difficult to figure out why it is causing the error. I ran few more test imports and noticed that the main category actually had an empty space at the end, which I believe was causing the whole problem.

The import ran through without any errors after removing the empty space. However, before I also removed all related URL rewrites as follows. Not sure if this was actually necessary.

mysql> DELETE FROM url_rewrite WHERE entity_type = 'category' AND request_path like '%abc/def/%';
Query OK, 6 rows affected (0.01 sec)

1 2	mysql> DELETE FROM url_rewrite WHERE entity_type = 'category' AND request_path like '%abc/def/%'; Query OK, 6 rows affected (0.01 sec)

After that I rebuilt the re-write table with https://github.com/olegkoval/magento2-regenerate_url_rewrites because for some reason the importer didn’t create the rewrite URLs.

$ php bin/magento ok:urlrewrites:regenerate
Regenerating of Url rewrites:

[Store ID: 0, Store View code: admin]:....................
....................
....................
....................
....................
....................
....................
....................
....................
....................
................URL key for specified store already exists.
....
..

$ php bin/magento ok:urlrewrites:regenerate

Regenerating of Url rewrites:

[Store ID: 0, Store View code: admin]:....................

....................

................URL key for specified store already exists.

....

After that everything was working as expected.

Class not found in AbstractFactory

Today I had some trouble with removing a module on Magento2 and its custom product attributes. After removing the code of Mageplaza_Seo I was not able to edit products, categories or even checkout anymore.

Fatal error: Uncaught Error: Class 'Mageplaza\Seo\Model\Source\Robots' not found in /home/www/client/src/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:93 Stack trace: #0
/home/www/client/src/vendor/magento/framework/ObjectManager/Factory/Compiled.php(88): Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject('Mageplaza\\Seo\\M...', Array) #1
/home/www/client/src/vendor/magento/framework/ObjectManager/ObjectManager.php(57): Magento\Framework\ObjectManager\Factory\Compiled->create('Mageplaza\\Seo\\M...', Array) #2
/home/www/client/src/vendor/magento/framework/Validator/UniversalFactory.php(36): Magento\Framework\ObjectManager\ObjectManager->create('Mageplaza\\Seo\\M...', Array) #3
/home/www/client/src/vendor/magento/module-eav/Model/Entity/Attribute/AbstractAttribute.php(551): Magento\Framework\Validator\UniversalFactory->create('\\Mageplaza\\Seo\\...') #4
/home/www/client/src/vendor/magento/module-catalog/Mode in /home/www/client/src/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php on line 93

Fatal error: Uncaught Error: Class 'Mageplaza\Seo\Model\Source\Robots' not found in /home/www/client/src/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:93 Stack trace: #0

/home/www/client/src/vendor/magento/framework/ObjectManager/Factory/Compiled.php(88): Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject('Mageplaza\\Seo\\M...', Array) #1

/home/www/client/src/vendor/magento/framework/ObjectManager/ObjectManager.php(57): Magento\Framework\ObjectManager\Factory\Compiled->create('Mageplaza\\Seo\\M...', Array) #2

/home/www/client/src/vendor/magento/framework/Validator/UniversalFactory.php(36): Magento\Framework\ObjectManager\ObjectManager->create('Mageplaza\\Seo\\M...', Array) #3

/home/www/client/src/vendor/magento/module-eav/Model/Entity/Attribute/AbstractAttribute.php(551): Magento\Framework\Validator\UniversalFactory->create('\\Mageplaza\\Seo\\...') #4

/home/www/client/src/vendor/magento/module-catalog/Mode in /home/www/client/src/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php on line 93

The reason was an attribute called mp_meta_robots which was still pointing to the class \Mageplaza\Seo\Model\Source\Robots. I found the attribute by checking the table eav_attribute as follows.

mysql> SELECT * FROM eav_attribute WHERE source_model LIKE '%Mageplaza%'; 
+--------------+----------------+----------------+-----------------+---------------+--------------+---------------+----------------+----------------+----------------+----------------+------------------------------------+-------------+-----------------+---------------+-----------+------------------------+
| attribute_id | entity_type_id | attribute_code | attribute_model | backend_model | backend_type | backend_table | frontend_model | frontend_input | frontend_label | frontend_class | source_model                       | is_required | is_user_defined | default_value | is_unique | note                   |
+--------------+----------------+----------------+-----------------+---------------+--------------+---------------+----------------+----------------+----------------+----------------+------------------------------------+-------------+-----------------+---------------+-----------+------------------------+
|          222 |              4 | mp_meta_robots | NULL            | NULL          | varchar      | NULL          | NULL           | select         | Meta Robots    | NULL           | \Mageplaza\Seo\Model\Source\Robots |           0 |               0 | NULL          |         0 | Added by Mageplaza.com |
|          223 |              3 | mp_meta_robots | NULL            | NULL          | varchar      | NULL          | NULL           | select         | Meta Robots    | NULL           | \Mageplaza\Seo\Model\Source\Robots |           0 |               0 | NULL          |         0 | Added by Mageplaza.com |
+--------------+----------------+----------------+-----------------+---------------+--------------+---------------+----------------+----------------+----------------+----------------+------------------------------------+-------------+-----------------+---------------+-----------+------------------------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM eav_attribute WHERE source_model LIKE '%Mageplaza%';

+--------------+----------------+----------------+-----------------+---------------+--------------+---------------+----------------+----------------+----------------+----------------+------------------------------------+-------------+-----------------+---------------+-----------+------------------------+

2 rows in set (0.00 sec)

Removing this via backend or MySQL has fixed the problem.

mysql> delete from eav_attribute where attribute_code = 'mp_meta_robots';
Query OK, 2 rows affected (0.01 sec)

1 2	mysql> delete from eav_attribute where attribute_code = 'mp_meta_robots'; Query OK, 2 rows affected (0.01 sec)

Update Order Status With SQL Queries in Magento2

Today I had to update order numbers which were processed already, but not updated in Magento. Here is how I changed the order status directly in the database based on the increment_id.

The first query will update the state and status on the table sales_order.

mysql> UPDATE sales_order SET state='complete', status='complete' WHERE increment_id IN (000043719,000044003,000044117,...);
Query OK, 15 rows affected (0.08 sec)
Rows matched: 16  Changed: 15  Warnings: 0

mysql> UPDATE sales_order SET state='complete', status='complete' WHERE increment_id IN (000043719,000044003,000044117,...);

Query OK, 15 rows affected (0.08 sec)

Rows matched: 16 Changed: 15 Warnings: 0

The second one will update the status in the grid view in Sales > Orders.

mysql> UPDATE sales_order_grid SET status='complete' WHERE increment_id IN (000043719,000044003,000044117,...);
Query OK, 15 rows affected (0.03 sec)
Rows matched: 16  Changed: 15  Warnings: 0

mysql> UPDATE sales_order_grid SET status='complete' WHERE increment_id IN (000043719,000044003,000044117,...);

Query OK, 15 rows affected (0.03 sec)

Rows matched: 16 Changed: 15 Warnings: 0

Cannot gather stats! Warning!stat(): stat failed

Today I imported a couple of new products with uRapidFlow in Magento 2.1.2. I ran the import with the option Action on missing image file which was set to WARNING and update image field. It worked fine, but I accidentally forgot to upload the product images.

So basically uRapidFlow added non-existing product images to the database which broke the product edit form in the admin panel.

Cannot gather stats! Warning!stat(): stat failed for /var/www/src/pub/media/catalog/product/A_217823.JPG

1	Cannot gather stats! Warning!stat(): stat failed for /var/www/src/pub/media/catalog/product/A_217823.JPG

The temporarily solution was to manipulate ./vendor/magento/module-catalog/Block/Adminhtml/Product/Helper/Form/Gallery/Content.php in vendor around line 142,143.

if (is_readable($this->_mediaConfig->getMediaPath($image['file'])))
{
    $fileHandler = $mediaDir->stat($this->_mediaConfig->getMediaPath($image['file']));
    $image['size'] = $fileHandler['size'];
}

if (is_readable($this->_mediaConfig->getMediaPath($image['file'])))

{

$fileHandler = $mediaDir->stat($this->_mediaConfig->getMediaPath($image['file']));

$image['size'] = $fileHandler['size'];

}

I basically added is_readable to check if the file exists. Not great, but at least I was able to edit products again and proceed with a permanent fix.