[PrestaShopDatabaseException]

Subquery returns more than 1 row

SELECT IFNULL(
(
SELECT left_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme )
LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta )
WHERE t.id_theme =18
AND m.page = "index" ) , default_left_column
)
FROM ps_theme
WHERE id_theme =18 LIMIT 1


at line 635 in file classes/db/Db.php

629. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630. }
631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632. {
633. if ($sql)
634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635. throw new PrestaShopDatabaseException($this->getMsgError());
636. }
637. }
638.
639. /**

DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
DbCore->query - [line 547 - classes/db/Db.php] - [1 Arguments]
DbCore->getRow - [line 572 - classes/db/Db.php] - [2 Arguments]
DbCore->getValue - [line 198 - classes/Theme.php] - [1 Arguments]
ThemeCore->hasLeftColumn - [line 3903 - modules/themeeditor/themeeditor.php] - [1 Arguments]
ThemeEditor->hookCalculateGrid - [line 507 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 188 - config/smarty.config.inc.php] - [3 Arguments]
smartyHook - [line - ] - [2 Arguments]
call_user_func_array - [line 241 - config/smarty.config.inc.php] - [2 Arguments]
SmartyLazyRegister->__call - [line 59 - cache/smarty/compile/ab/f5/13/abf513b4205a88d2edfcb2273af1427acd5ad815.file.product-list.tpl.cache.php] - [2 Arguments]
SmartyLazyRegister->smartyHook - [line 59 - cache/smarty/compile/ab/f5/13/abf513b4205a88d2edfcb2273af1427acd5ad815.file.product-list.tpl.cache.php] - [2 Arguments]
content_5534d91badbc58_54179812 - [line 188 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments]
Smarty_Internal_TemplateBase->fetch - [line 303 - tools/smarty/sysplugins/smarty_internal_template.php] - [7 Arguments]
Smarty_Internal_Template->getSubTemplate - [line 28 - cache/smarty/compile/c2/91/28/c29128863c7d1d1f80c68d3ec32fb50d0960cee2.file.homefeatured.tpl.cache.php] - [7 Arguments]
content_5534d915d0dbe8_37095346 - [line 188 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments]
Smarty_Internal_TemplateBase->fetch - [line 2032 - classes/module/Module.php]
ModuleCore->display - [line 159 - modules/homefeatured/homefeatured.php] - [3 Arguments]
HomeFeatured->hookDisplayHome - [line 507 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 40 - controllers/front/IndexController.php] - [1 Arguments]
IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php]
ControllerCore->run - [line 373 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.html]

Проверить следующие таблицы ps_theme_meta и ps_meta в них содержатся 2 одинаковых значения (удалить одно лишнее значение для `index`).

По умолчанию занести такое невозможно, проверьте структуру таблицы ps_meta


Тема перемещена в раздел prestashop 1.6