Magento – Error Array to string conversion in vendor/magento/framework/DB/Adapter/Pdo/Mysql.php on line 3101

databaseerrormagento2.3.2

When i tried to edit an image in custom module i am getting an error like below.

1 exception(s):
Exception #0 (Exception): Notice: Array to string conversion in /var/www/html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php on line 3101

I have a fix for this. replacing this code set

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

With

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

I want to know how can i do this in proper way rather than directly editing the core file.
UPDATE
My modules Save.php

try{
    $uploader = $this->_objectManager->create(
                'Magento\MediaStorage\Model\File\Uploader',
                ['fileId' => 'image']
            );
    $uploader->setAllowedExtensions(['jpg', 'jpeg', 'gif', 'png']);
            /** @var \Magento\Framework\Image\Adapter\AdapterInterface $imageAdapter */
    $imageAdapter = $this->_objectManager->get('Magento\Framework\Image\AdapterFactory')->create();
    $uploader->setAllowRenameFiles(true);
    $uploader->setFilesDispersion(true);
    /** @var \Magento\Framework\Filesystem\Directory\Read $mediaDirectory */
    $mediaDirectory = $this->_objectManager->get('Magento\Framework\Filesystem')
                ->getDirectoryRead(DirectoryList::MEDIA);
    $result = $uploader->save($mediaDirectory->getAbsolutePath('news_news'));
    if($result['error']==0)
    {
        $data['image'] = 'news_news' . $result['file'];
    }

Best Answer

The reason behind this error you are passing the array to the column that is causing the issue. You can use the following code to avoid this error.

if (isset($data['logo'][0]['name']) && isset($data['logo'][0]['tmp_name'])) {
                $data['image'] =$data['logo'][0]['name'];
                $this->imageUploader = \Magento\Framework\App\ObjectManager::getInstance()->get(
                'QaisarSatti\HelloWorld\HelloWorldImageUpload'
            );
                $this->imageUploader->moveFileFromTmp($data['image']);
            } elseif (isset($data['logo'][0]['image']) && !isset($data['logo'][0]['tmp_name'])) {
                $data['image'] = $data['logo'][0]['image'];
            } else {
                $data['image'] = null;
            }

Reference

Related Solutions

Magento 1.9 – Fix ERR (3): Notice: Array to String Conversion Error

Pretty simple: You're trying to cast $value as a string for the comparison, but $value is an array. If $value has some kind of value you need in it (perhaps it's nested inside an array) for the comparison, then you must process it so that it is not array.

Do this before the if statement.

var_dump($value); die;

Mage::log($value); // Check var/log/system.log with logging enabled

And just examine how the data is structured in $value. Make it into a string variable.

Magento 2 – Fixing Notice Error: Array to String Conversion

I don't know why plugin doesn't work with current scenario.

If anyone tell Why plugin not worked with this scenario ?

So, I used event called adminhtml_controller_salesrule_prepare_save to save my fields value to DB.

Here is full code.

Vendor/Module/etc/adminhtml/events.xml

<event name="adminhtml_controller_salesrule_prepare_save">
    <observer name="save_brands" 
        instance="Vendor\Module\Observer\SaveExcludedBrands" />
</event>

Than, Create observer file within your module.

Vendor/Module/Observer/SaveExcludedBrands.php

public function execute(Observer $observer)
{
    $data = $observer->getRequest()->getPostValue();
    //print_r($data); exit;
    $request = $observer->getEvent()->getRequest();

    $brands = implode(',',$data['brands']);

    $startDate = $this->timeZoneInterface->date($data['start_date'])->format('Y-m-d'); 
    $endDate = $this->timeZoneInterface->date($data['end_date'])->format('Y-m-d');


    $request->setPostValue('brands',$brands);
    $request->setPostValue('start_date',$startDate);
    $request->setPostValue('end_date',$endDate);
}

Now, No exception and notice and its working.

Best Answer

Related Solutions

Magento 1.9 – Fix ERR (3): Notice: Array to String Conversion Error

Magento 2 – Fixing Notice Error: Array to String Conversion

Related Topic