Database Error occurs in backoffice after deleting store group

[May Zin]

Hi,

I'm newbie in prestashop.  I switched on multi store, then created shop group and shops. Those all works well in this stage. After that, my curious mind forced me to delete the store group and got database exception error  in backoffice immediately but the front one is still pretty fine.   May I know the related tables in creating or deleting store or Could someone please help to get out of this? I got that error as follows. 

[joseantgv]

Could you paste the full error?

[May Zin]

Hi @joseantgv,

Here is the log.

[joseantgv]

But Exception tab!

[May Zin]

DbCore->displayError('SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as moduleFROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop IN () AND module_shop.enable_device & 1)INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)GROUP BY hm.id_hook, hm.id_moduleORDER BY hm.`position`')in classes/db/Db.php (line 385)

DbCore->query('SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as moduleFROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop IN () AND module_shop.enable_device & 1)INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)GROUP BY hm.id_hook, hm.id_moduleORDER BY hm.`position`')in classes/db/Db.php (line 613)

DbCore->executeS('SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as moduleFROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop IN () AND module_shop.enable_device & 1)INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)GROUP BY hm.id_hook, hm.id_moduleORDER BY hm.`position`')in classes/Hook.php (line 670)