Magento – Array to string conversion in Magento 2

magento2.2.2PHP

Notice: Array to string conversion in
/home/pacifi48/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php
on line 2999 Magento 2 Version 2.2.2

How to solve???

Best Answer

To solve please do modification in below paths

Path : vendor/magento/framework/DB/Adapter/Pdo/Mysql.php
Under --> public function prepareColumnValue(array $column, $value)

Replace old code:

 case 'longtext':
    $value  = (string)$value;
    if ($column['NULLABLE'] && $value == '') {
        $value = null;
    }
    break;

With new code:

case 'longtext':
    if(!is_array($value)) $value  = (string)$value;
    else $value = '';
    if ($column['NULLABLE'] && $value == '') {
        $value = null;
    }
    break;

same error came to me now it solved

Related Solutions

Magento – Magento 2 Fatal error: Uncaught Error: Class not found

Use below on your helper file:

class PdfCrowd extends \Magento\Framework\App\Helper\AbstractHelper{
}

instead of

class PdfCrowd{
}

Magento – Magento 2.3.1 php 7.2 upgrade Parameter must be an array or an object

As of PHP 7.2 this is a warning about a non-Countable object being passed to count():

count() will now yield a warning on invalid countable types passed to the array_or_countable parameter.

Without any further code to look at (e.g. the code that defines the $list variable) or knowing what $list contains, I would guess that however $list is defined one of the valid results is null. You have two options:

Check the value of $list before that line and redefine it if necessary:

if(!is_array($list) || !($list instanceof \Countable) {
    $list = [];
}

Find out how $list is defined and fix it so it returns only an array or an object that implements the Countable interface.

Best Answer

Related Solutions

Magento – Magento 2 Fatal error: Uncaught Error: Class not found

Magento – Magento 2.3.1 php 7.2 upgrade Parameter must be an array or an object

Related Topic