Jump to content

1.7.6.0 Prestashop Database Exception


Recommended Posts

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

 

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More