Hola a todos, tengo un problema con mi tienda en prestashop, estoy migrando de local a un servidor remoto, pero me muestra este mensaje "Fatal error: Uncaught The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay

<pre>SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ck_module` m INNER JOIN ck_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ck_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ck_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ck_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ck_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` </pre> thrown in /home3/pulsarma/public_html/classes/db/Db.php on line 791".

Alguien puede ayudarme como solucionar este problema?

Muchas gracias por su ayuda