Prestashop – desactivar todos los países

[cc]
UPDATE ps_country SET active=0 WHERE iso_code NOT LIKE ‘GB’
[/cc]

Valor ID de la zona península es: 9

INSERT INTO `ps_state` (`id_state`,`id_country`, `id_zone`, `name`, `iso_code`, `tax_behavior`, `active`) VALUES
(313, 6, 9, ‘La Coruña’, ‘C’, 0, 1),
(314, 6, 9, ‘Álava’, ‘VI’, 0, 1),
(315, 6, 9, ‘Albacete’ ,’AB’, 0, 1),
(316, 6, 9, ‘Alicante’, ‘A’, 0, 1),
(317, 6, 9, ‘Almería’, ‘AL’, 0, 1),
(318, 6, 9, ‘Asturias’, ‘O’, 0, 1),
(319, 6, 9, ‘Ávila’, ‘AV’, 0, 1),
(320, 6, 9, ‘Badajoz’, ‘BA’, 0, 1),
(321, 6, 11, ‘Islas Baleares’, ‘PM’, 0, 1),
(322, 6, 9, ‘Barcelona’, ‘B’, 0, 1),
(323, 6, 9, ‘Burgos’, ‘BU’, 0, 1),
(324, 6, 9, ‘Cáceres’, ‘CC’, 0, 1),
(325, 6, 9, ‘Cádiz’, ‘CA’, 0, 1),
(326, 6, 9, ‘Cantabria’, ‘S’, 0, 1),
(327, 6, 9, ‘Castellón’, ‘CS’, 0, 1),
(328, 6, 12, ‘Ceuta’, ‘CE’, 0, 1),
(329, 6, 9, ‘Ciudad Real’, ‘CR’, 0, 1),
(330, 6, 9, ‘Córdoba’, ‘CO’, 0, 1),
(331, 6, 9, ‘Cuenca’, ‘CU’, 0, 1),
(332, 6, 9, ‘Gerona’, ‘GI’, 0, 1),
(333, 6, 9, ‘Granada’, ‘GR’, 0, 1),
(343, 6, 9, ‘Guadalajara’, ‘GU’, 0, 1),
(345, 6, 9, ‘Guipuzcoa’, ‘SS’, 0, 1),
(346, 6, 9, ‘Huelva’, ‘H’, 0, 1),
(347, 6, 9, ‘Huesca’, ‘HU’, 0, 1),
(348, 6, 9, ‘Jaén’, ‘J’, 0, 1),
(349, 6, 9, ‘La Rioja’, ‘LO’, 0, 1),
(350, 6, 10, ‘Las Palmas’, ‘GC’, 0, 1),
(351, 6, 9, ‘León’, ‘LE’, 0, 1),
(352, 6, 9, ‘Lérida’, ‘L’, 0, 1),
(353, 6, 9, ‘Lugo’, ‘LU’, 0, 1),
(354, 6, 9, ‘Madrid’, ‘M’, 0, 1),
(355, 6, 9, ‘Málaga’, ‘MA’, 0, 1),
(356, 6, 12, ‘Melilla’, ‘ML’, 0, 1),
(357, 6, 9, ‘Murcia’, ‘MU’, 0, 1),
(358, 6, 9, ‘Navarra’, ‘NA’, 0, 1),
(359, 6, 9, ‘Orense’, ‘OR’, 0, 1),
(360, 6, 9, ‘Palencia’, ‘P’, 0, 1),
(361, 6, 9, ‘Pontevedra’, ‘PO’, 0, 1),
(362, 6, 9, ‘Salamanca’, ‘SA’, 0, 1),
(363, 6, 10, ‘Santa Cruz de Tenerife’, ‘TF’, 0, 1),
(364, 6, 9, ‘Segovia’, ‘SG’, 0, 1),
(365, 6, 9, ‘Sevilla’, ‘SE’, 0, 1),
(366, 6, 9, ‘Soria’, ‘SO’, 0, 1),
(367, 6, 9, ‘Tarragona’, ‘T’, 0, 1),
(368, 6, 9, ‘Teruel’, ‘TE’, 0, 1),
(369, 6, 9, ‘Toledo’, ‘TO’, 0, 1),
(370, 6, 9, ‘Valencia’, ‘V’, 0, 1),
(371, 6, 9, ‘Valladolid’, ‘VA’, 0, 1),
(372, 6, 9, ‘Vizcaya’, ‘BI’, 0, 1),
(373, 6, 9, ‘Zamora’, ‘ZA’, 0, 1),
(374, 6, 9, ‘Zaragoza’, ‘Z’, 0, 1);

Prestashop – habilitar modo debug

Útil para cuando queremos investigar errores en Prestashop. En config/config.inc.php modificar estas lineas

[cc]
@ini_set(‘display_errors’, ‘off’);
define(‘_PS_DEBUG_SQL_’, false);
[/cc]

por estas otras

[cc]
@ini_set(‘display_errors’, ‘on’);
define(‘_PS_DEBUG_SQL_’, true);
[/cc]