1.7.6.0 Prestashop Database Exception

[Chithra Sreejith]

Unknown column 'custom_field_wysiwyg' in 'field list'<br /><br /><pre>INSERT INTO `pshop_product_lang` (`id_product`, `delivery_in_stock`, `delivery_out_stock`, `meta_description`, `meta_keywords`, `meta_title`, `link_rewrite`, `name`, `description`, `description_short`, `available_now`, `available_later`, `custom_field_wysiwyg`, `custom_field_lang`, `custom_field_lang_wysiwyg`, `id_lang`, `id_shop`) VALUES ('753', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '1')</pre>

Exception

Logs 2

Stack Trace

PrestaShopDatabaseException

in classes/db/Db.php (line 773)

        if ($webservice_call && $errno) {

            $dbg = debug_backtrace();

            WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);

        } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {

            if ($sql) {

                throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');

            }

            throw new PrestaShopDatabaseException($this->getMsgError());

        }

    }

DbCore->displayError('INSERT INTO `pshop_product_lang` (`id_product`, `delivery_in_stock`, `delivery_out_stock`, `meta_description`, `meta_keywords`, `meta_title`, `link_rewrite`, `name`, `description`, `description_short`, `available_now`, `available_later`, `custom_field_wysiwyg`, `custom_field_lang`, `custom_field_lang_wysiwyg`, `id_lang`, `id_shop`) VALUES (\'753\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'1\', \'1\')')in classes/db/Db.php (line 385)

DbCore->query('INSERT INTO `pshop_product_lang` (`id_product`, `delivery_in_stock`, `delivery_out_stock`, `meta_description`, `meta_keywords`, `meta_title`, `link_rewrite`, `name`, `description`, `description_short`, `available_now`, `available_later`, `custom_field_wysiwyg`, `custom_field_lang`, `custom_field_lang_wysiwyg`, `id_lang`, `id_shop`) VALUES (\'753\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'1\', \'1\')')in classes/db/Db.php (line 741)

DbCore->q('INSERT INTO `pshop_product_lang` (`id_product`, `delivery_in_stock`, `delivery_out_stock`, `meta_description`, `meta_keywords`, `meta_title`, `link_rewrite`, `name`, `description`, `description_short`, `available_now`, `available_later`, `custom_field_wysiwyg`, `custom_field_lang`, `custom_field_lang_wysiwyg`, `id_lang`, `id_shop`) VALUES (\'753\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'\', \'1\', \'1\')', true)in classes/db/Db.php (line 476)

DbCore->insert('pshop_product_lang', array(array('id_product' => 753, 'delivery_in_stock' => '', 'delivery_out_stock' => '', 'meta_description' => '', 'meta_keywords' => '', 'meta_title' => '', 'link_rewrite' => '', 'name' => '', 'description' => '', 'description_short' => '', 'available_now' => '', 'available_later' => '', 'custom_field_wysiwyg' => '', 'custom_field_lang' => '', 'custom_field_lang_wysiwyg' => '', 'id_lang' => '1', 'id_shop' => 1)))in classes/ObjectModel.php (line 599)

ObjectModelCore->add(true, false)in classes/Product.php (line 603)

ProductCore->add(true, false)in classes/ObjectModel.php (line 516)

ObjectModelCore->save()in src/PrestaShopBundle/Controller/Admin/ProductController.php (line 407)

ProductController->newAction()in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151)

HttpKernel->handleRaw(object(Request), 1)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68)

HttpKernel->handle(object(Request), 1, false)in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)

Kernel->handle(object(Request), 1, false)in admin24517impt/index.php (line 86)

 

 

 

 

please help me to fix this issue. I removed multistore option. then i cant add new products showing this erroe

 

[JBW]

On 1/16/2021 at 2:07 PM, Chithra Sreejith said:

ustom_field_wysiwyg`, `custom_field_lang`, `custom_field_lang_wysiwyg`

These fields are not part of Prestashop standard and might be requried by a module/override. Try to identify this module and reset it to get the database fields installed again.