Escenario: sistema lamp con opcode xcache instalado. Magento 1.7 producción. Configurando local.xml para tirar de caché backend Xcache vemos que Magento aloja igualmente la caché en /var/cache
Continue reading
Tag Archives: ecommerce
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]