alviro

Buenas Noches, Acabo de escribir a mi proveedor de alojamiento solicitando si hay alguna manera de que me optimicen el servidor para mejorar el funcionamiento de mi tienda, sobre todo el backoffice. Os adjunto lo que me han contestado: -------------------------------------------------------------------------------------------------------------------------- Buenas tardes El hecho que el FTP le vaya lento, no es algo que tenga tanto que ver con el servidor sino probablemente con su conexión internet, puede hacernos llegar una traza desde su conexión hacia el servidor? (inicio > ejecutar > cmd, teclee tracert laboutiquedelanavaja.com y haganos llegar el resultado) Haciendo la prueba con https://developers.google.com/speed/pagespeed/insights/, la respuesta no es mala ni mucho menos, pues se obtiene un 97/100 en la version ordenador y la respuesta del servidor es adcuado con el tiempo que indica goolge (0,2 segundo), dicho eso, hay varios factores que no han sido optimizado : - Eliminar el JavaScript que bloquea la visualización y el CSS del contenido de la mitad superior de la página - Habilitar compresión en el htaccess Segun webspeed, su web carga en 763ms : http://tools.pingdom.com/fpt/#!/dvDiJk/laboutiquedelanavaja.com Quedamos a la espera de su traza para comprobar si el problema real no esta relacionado con su conexión internet. Reciba un cordial saludo ------------------------------------------------------------------------------------------------------------------------------------------- Esta es la traza que yo les he enviado: Traza a la dirección laboutiquedelanavaja.com [193.42.143.45] sobre un máximo de 30 saltos: 1 <1 ms <1 ms <1 ms 192.168.1.1 2 24 ms 24 ms 24 ms 128.Red-80-58-67.staticIP.rima-tde.net [80.58.67 .128] 3 29 ms 31 ms 31 ms 129.Red-80-58-94.staticIP.rima-tde.net [80.58.94 .129] 4 30 ms 31 ms 31 ms 69.Red-80-58-76.staticIP.rima-tde.net [80.58.76. 69] 5 27 ms 29 ms 27 ms So-5-0-0-0-grtmadde2.red.telefonica-wholesale.ne t [84.16.9.165] 6 49 ms 62 ms 49 ms Xe-2-0-2-0-grtparix1.red.telefonica-wholesale.ne t [94.142.117.174] 7 48 ms 50 ms 51 ms 213.140.52.50 8 50 ms 55 ms 51 ms be2337.rcr21.par05.atlas.cogentco.com [130.117.1 .1] 9 52 ms 51 ms 52 ms be2424.ccr41.par01.atlas.cogentco.com [130.117.2 .237] 10 56 ms 55 ms 52 ms be2044.agr21.par01.atlas.cogentco.com [130.117.5 1.78] 11 54 ms 58 ms 54 ms te0-0-1-0.rcr11.rhe01.atlas.cogentco.com [154.54 .36.22] 12 58 ms 61 ms 57 ms ikoula.demarc.cogentco.com [149.6.104.2] 13 * 58 ms 62 ms po2.vss1.ikdc1.ikoula.com [213.246.32.117] 14 58 ms 57 ms 57 ms l013.configbox.com [193.42.143.45] Traza completa. ------------------------------------------------------------------------------------------------------------------------------------------------------------------ Su respuesta a la traza: Vemos que los tiempos son algo altos en la propia red de telefonica en los primeros pasos, y llega con tiempos algo altos también al servidor :

Hola de nuevo y buenas tardes, Enrique estoy de acuerdo contigo en que gran parte del buen rendimiento de una tienda online pasa por el tipo de alojamiento así como su configuración optima para prestashop. Yo ya he hablado en varias ocasiones con mi proveedor de alojamiento web y siempre me han dado la misma respuesta, que mi tienda va lenta por que la tengo mal configurada. He propuesto también el cambio a un tipo de hosting mas exclusivo u orientado a prestashop pero me dicen que no me aseguran que vaya a funcionarme mas rápido. Lo que si es verdad es como bien dice EcoLógic no se le puede presentar a un cliente una tienda en la que la navegación por ella se hace irritante, esta claro que eso repercutiría en las ventas negativamente. Yo ya he probado a limpiar la base de datos de conexiones así como a optimizarla. He configurado la tienda en las opciones de rendimiento como aconsejáis en este foro y en los manuales de prestashop. He revertido todos los cambios estéticos que hice en la plantilla que además es la que esta por defecto. He eliminado los módulos que instale por si alguno de ellos fuera el culpable y nada. Si he notado que lo que realmente va muy lento en le backoffice es cuando accedo al apartado de modulos por eso pienso que algún módulo puede tener la culpa, modulo de los que vienen preinstalados por que como ya apunté los que yo había instalado los elimine. Bueno, seguiremos probando opciones a ver si damos con el problema. Muchas gracias por vuestras respuestas.

Buenos días, Tengo una tienda en prestashop aun en producción, tenemos ya mas de 3000 productos introducidos, cuando funcionabamos con la versión 1.5 la tienda andaba bastante ágil, desde que actualizamos a la 1.6 la cosa cambio y va muy lenta a veces desesperante en el backoffice. Se hace eterno, casi imposible, el introducir un producto nuevo. Os pregunto para ver si podéis darme algún tipo de solución ya que en este punto me encuentro desesperado. La tienda es laboutiquedelanavaja.es, os puedo pasar el pass por si podéis echarle un vistazo. He hablado con los administradores de mi hosting y me dicen que el tema de la lentitud se debe a un mala optimización del rendimiento de la tienda y no a un problema en el alojamiento. He activado el PS_DEBUG_PROFILING en la tienda para ver tiempos de carga e intuir que esta pasando. Si pusierais echarme una mano estaría muy agradecido. Stopwatch Doubles Tables stress ObjectModel instances Files included Stopwatch (with SQL_NO_CACHE) (total = 44) Query Time (ms) Rows Filesort Group By Location SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) 12.5 555 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Configuration.php:134 from /classes/Configuration.php:170 from /classes/Configuration.php:226 from /classes/shop/Shop.php:367 from /config/config.inc.php:97 from /administrator/index.php:34 SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_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 `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 != "displayPayment") AND (hm.id_shop = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 2.7 74 Yes Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:346 from /tools/profiling/Hook.php:50 from /classes/Dispatcher.php:414 from /classes/Dispatcher.php:230 from /classes/Dispatcher.php:193 from /administrator/index.php:54 SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m 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 != "displayPayment") AND (hm.id_shop = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 1.8 98 Yes Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:346 from /tools/profiling/Hook.php:50 from /classes/controller/AdminController.php:2438 from /tools/profiling/Controller.php:142 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m 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 != "displayPayment") AND (hm.id_shop = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 1.7 98 Yes Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:346 from /classes/Hook.php:416 from /tools/profiling/Hook.php:60 from /classes/controller/AdminController.php:2438 from /tools/profiling/Controller.php:142 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name 1.6 0 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:131 from /classes/Hook.php:420 from /tools/profiling/Hook.php:60 from /classes/controller/AdminController.php:2438 from /tools/profiling/Controller.php:142 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE t.*, tl.name FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 3) WHERE 1 ORDER BY t.`position` ASC 1.4 103 Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:256 from /classes/Profile.php:126 from /classes/Profile.php:108 from /classes/controller/AdminController.php:370 from /controllers/admin/AdminPerformanceController.php:34 from /classes/controller/Controller.php:135 from /classes/Dispatcher.php:367 from /administrator/index.php:54 SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC 1.3 111 Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Dispatcher.php:462 from /classes/Dispatcher.php:230 from /classes/Dispatcher.php:193 from /administrator/index.php:54 SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` LIKE "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 1 286 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/Shop.php:1013 from /classes/Configuration.php:175 from /classes/Configuration.php:226 from /classes/shop/Shop.php:367 from /config/config.inc.php:97 from /administrator/index.php:34 SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 3 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 6) LIMIT 1 0.9 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228 from /tools/profiling/ObjectModel.php:37 from /config/config.inc.php:125 from /administrator/index.php:34 SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang) 0.9 7 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Language.php:712 from /config/config.inc.php:122 from /administrator/index.php:34 SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps_product_attribute` LIMIT 1 0.9 2108 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:1486 from /classes/Combination.php:272 from /controllers/admin/AdminPerformanceController.php:218 from /controllers/admin/AdminPerformanceController.php:609 from /controllers/admin/AdminPerformanceController.php:634 from /tools/profiling/Controller.php:171 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.laboutiquedelanavaja.com' OR su.domain_ssl = 'www.laboutiquedelanavaja.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC 0.8 1 Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/Shop.php:329 from /config/config.inc.php:97 from /administrator/index.php:34 SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name 0.8 1 Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/Shop.php:641 from /classes/shop/Shop.php:689 from /classes/Configuration.php:223 from /classes/shop/Shop.php:367 from /config/config.inc.php:97 from /administrator/index.php:34 SELECT SQL_NO_CACHE * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.id_employee = c.id_employee AND c.id_shop = 1 WHERE (a.id_employee = 1) LIMIT 1 0.7 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228 from /tools/profiling/ObjectModel.php:37 from /classes/Employee.php:144 from /config/config.inc.php:166 from /administrator/index.php:34 SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m 0.7 98 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/module/Module.php:220 from /modules/themeconfigurator/themeconfigurator.php:46 from /classes/module/Module.php:1044 from /classes/Hook.php:492 from /tools/profiling/Hook.php:60 from /classes/controller/AdminController.php:2438 from /tools/profiling/Controller.php:142 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 3) ORDER BY `name` ASC 0.7 5 Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/QuickAccess.php:65 from /classes/controller/AdminController.php:1591 from /tools/profiling/Controller.php:166 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != "" 0.6 103 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:232 from /classes/Translate.php:49 from /classes/controller/AdminController.php:2366 from /classes/controller/AdminController.php:334 from /controllers/admin/AdminPerformanceController.php:34 from /classes/controller/Controller.php:135 from /classes/Dispatcher.php:367 from /administrator/index.php:54 SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab` 0.6 103 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:287 from /classes/Tab.php:365 from /classes/Dispatcher.php:307 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM `ps_tab` a LEFT JOIN `ps_tab_lang` `b` ON a.id_tab = b.id_tab AND b.id_lang = 3 WHERE (a.id_tab = 78) LIMIT 1 0.5 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228 from /tools/profiling/ObjectModel.php:37 from /classes/Tab.php:366 from /classes/Dispatcher.php:307 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM ps_memcached_servers 0.5 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/cache/CacheMemcache.php:200 from /classes/cache/CacheMemcache.php:100 from /classes/cache/CacheMemcache.php:45 from /classes/cache/Cache.php:131 from /classes/db/Db.php:503 from /classes/shop/Shop.php:329 from /config/config.inc.php:97 from /administrator/index.php:34 SELECT SQL_NO_CACHE * FROM `ps_hook_alias` 0.5 86 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:183 from /classes/Hook.php:202 from /classes/Hook.php:373 from /tools/profiling/Hook.php:50 from /classes/Dispatcher.php:414 from /classes/Dispatcher.php:230 from /classes/Dispatcher.php:193 from /administrator/index.php:54 SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 0.4 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/Shop.php:199 from /classes/shop/Shop.php:133 from /classes/shop/Shop.php:394 from /config/config.inc.php:97 from /administrator/index.php:34 SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 0.4 7 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Language.php:825 from /classes/Language.php:925 from /classes/Dispatcher.php:398 from /classes/Dispatcher.php:221 from /classes/Dispatcher.php:193 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1 0.4 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228 from /tools/profiling/ObjectModel.php:37 from /classes/Currency.php:103 from /classes/controller/AdminController.php:386 from /controllers/admin/AdminPerformanceController.php:34 from /classes/controller/Controller.php:135 from /classes/Dispatcher.php:367 from /administrator/index.php:54 UPDATE `ps_employee` SET `last_connection_date` = CURRENT_DATE() WHERE `id_employee` = 1 AND `last_connection_date`< CURRENT_DATE() 0.4 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Employee.php:460 from /classes/controller/AdminController.php:2445 from /tools/profiling/Controller.php:142 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1 0.3 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228 from /tools/profiling/ObjectModel.php:37 from /classes/shop/Shop.php:131 from /classes/shop/Shop.php:394 from /config/config.inc.php:97 from /administrator/index.php:34 SELECT SQL_NO_CACHE * FROM `ps_theme` a WHERE (a.id_theme = 8) LIMIT 1 0.3 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228 from /tools/profiling/ObjectModel.php:37 from /config/config.inc.php:98 from /administrator/index.php:34 SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) 0.3 18 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/module/Module.php:1931 from /classes/Hook.php:469 from /tools/profiling/Hook.php:60 from /classes/controller/AdminController.php:2438 from /tools/profiling/Controller.php:142 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE COUNT(*) n FROM `ps_module_shop` WHERE id_module=85 AND id_shop IN (1) GROUP BY id_module HAVING n=1 LIMIT 1 0.3 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/module/Module.php:1995 from /classes/controller/AdminController.php:1672 from /tools/profiling/Controller.php:166 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1 0.2 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228 from /tools/profiling/ObjectModel.php:37 from /classes/controller/AdminController.php:1723 from /tools/profiling/Controller.php:166 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE `id_employee` FROM `ps_employee` WHERE `id_employee` = 1 AND `passwd` = '95b321018e63ff1c0841a465c2a148cf' AND active = 1 LIMIT 1 0.2 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Employee.php:299 from /classes/Employee.php:342 from /classes/controller/AdminController.php:2454 from /classes/controller/AdminController.php:384 from /controllers/admin/AdminPerformanceController.php:34 from /classes/controller/Controller.php:135 from /classes/Dispatcher.php:367 from /administrator/index.php:54 SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 0.2 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/ShopUrl.php:163 from /classes/shop/ShopUrl.php:177 from /classes/Tools.php:202 from /classes/Link.php:52 from /config/config.inc.php:215 from /administrator/index.php:34 SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminperformance' LIMIT 1 0.2 103 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:188 from /classes/controller/AdminController.php:1624 from /tools/profiling/Controller.php:166 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE COUNT(*) FROM `ps_group` LIMIT 1 0.2 3 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Group.php:225 from /controllers/admin/AdminPerformanceController.php:258 from /controllers/admin/AdminPerformanceController.php:609 from /controllers/admin/AdminPerformanceController.php:634 from /tools/profiling/Controller.php:171 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 6) LIMIT 1 0.2 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228 from /tools/profiling/ObjectModel.php:37 from /classes/controller/AdminController.php:2521 from /classes/controller/AdminController.php:384 from /controllers/admin/AdminPerformanceController.php:34 from /classes/controller/Controller.php:135 from /classes/Dispatcher.php:367 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 3) LIMIT 1 0.2 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228 from /tools/profiling/ObjectModel.php:37 from /classes/Language.php:90 from /config/config.inc.php:178 from /administrator/index.php:34 SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 3) WHERE t.`id_tab` = 78 LIMIT 1 0.2 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:213 from /classes/Tab.php:485 from /classes/controller/AdminController.php:427 from /classes/controller/AdminController.php:2448 from /tools/profiling/Controller.php:142 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "vatnumber" LIMIT 1 0.2 0 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/module/Module.php:2291 from /classes/module/Module.php:1981 from /classes/helper/HelperForm.php:237 from /classes/helper/HelperForm.php:65 from /classes/controller/AdminController.php:2214 from /controllers/admin/AdminPerformanceController.php:625 from /controllers/admin/AdminPerformanceController.php:634 from /tools/profiling/Controller.php:171 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM `ps_country_lang` WHERE `id_country` = 6 0.2 7 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:235 from /tools/profiling/ObjectModel.php:37 from /classes/controller/AdminController.php:2521 from /classes/controller/AdminController.php:384 from /controllers/admin/AdminPerformanceController.php:34 from /classes/controller/Controller.php:135 from /classes/Dispatcher.php:367 from /administrator/index.php:54 SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 3) WHERE t.`id_tab` = 17 LIMIT 1 0.2 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:213 from /classes/Tab.php:485 from /classes/Tab.php:488 from /classes/controller/AdminController.php:427 from /classes/controller/AdminController.php:2448 from /tools/profiling/Controller.php:142 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1 0.2 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:1326 from /classes/Employee.php:150 from /config/config.inc.php:166 from /administrator/index.php:34 SELECT SQL_NO_CACHE * FROM ps_memcached_servers 0.2 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/cache/CacheMemcache.php:200 from /controllers/admin/AdminPerformanceController.php:601 from /controllers/admin/AdminPerformanceController.php:616 from /controllers/admin/AdminPerformanceController.php:634 from /tools/profiling/Controller.php:171 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps_product_attribute` LIMIT 1 0.2 2108 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:1486 from /classes/Combination.php:272 from /controllers/admin/AdminPerformanceController.php:232 from /controllers/admin/AdminPerformanceController.php:609 from /controllers/admin/AdminPerformanceController.php:634 from /tools/profiling/Controller.php:171 from /classes/Dispatcher.php:374 from /administrator/index.php:54 SELECT SQL_NO_CACHE class_name FROM ps_tab WHERE id_tab = 1 LIMIT 1 0.1 1 in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:535 from /classes/controller/AdminController.php:1728 from /tools/profiling/Controller.php:166 from /classes/Dispatcher.php:374 from /administrator/index.php:54 Doubles (IDs replaced by "XX") (total = 4) 2 SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m 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 != "displayPayment") AND (hm.id_shop = XX) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 2 SELECT * FROM ps_memcached_servers 2 SELECT `id_product_attribute` FROM `ps_product_attribute` LIMIT XX 2 SELECT * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX) WHERE t.`id_tab` = XX LIMIT XX Tables stress 8 tab 5 hook 5 module 4 module_shop 4 shop 4 shop_url 4 tab_lang 3 lang_shop 3 hook_module 3 lang 2 theme 2 hook_alias 2 product_attribute 2 configuration 2 country 2 shop_group 2 country_lang 2 country_shop 2 employee 2 memcached_servers 2 employee_shop 1 quick_access 1 quick_access_lang 1 group 1 hook_module_exceptions 1 meta 1 meta_lang 1 configuration_lang 1 currency 1 currency_shop ObjectModel instances Name Instance Source Language 2 config/config.inc.php [178] classes/controller/AdminController.php [1999] Shop 2 config/config.inc.php [97] classes/controller/AdminController.php [1736] Country 2 config/config.inc.php [125] classes/controller/AdminController.php [2521] ShopGroup 1 classes/controller/AdminController.php [1723] Currency 1 classes/controller/AdminController.php [386] Employee 1 config/config.inc.php [166] Theme 1 config/config.inc.php [98] Tab 1 classes/Dispatcher.php [307] Included files # Filename 1 administrator/index.php 2 administrator/../config/config.inc.php 3 config/config.inc.php 4 config/defines.inc.php 5 config/settings.inc.php 6 config/autoload.php 7 config/alias.php 8 classes/PrestaShopAutoload.php 9 cache/class_index.php 10 tools/profiling/Controller.php 11 classes/controller/Controller.php 12 tools/profiling/ObjectModel.php 13 classes/ObjectModel.php 14 tools/profiling/Hook.php 15 classes/Hook.php 16 tools/profiling/Db.php 17 classes/db/Db.php 18 tools/profiling/Tools.php 19 classes/Tools.php 20 classes/Context.php 21 classes/shop/Shop.php 22 config/db_slave_server.inc.php 23 classes/db/DbPDO.php 24 classes/cache/Cache.php 25 classes/cache/CacheMemcache.php 26 classes/Configuration.php 27 classes/Validate.php 28 classes/db/DbQuery.php 29 classes/Theme.php 30 config/defines_uri.inc.php 31 tools/htmlpurifier/HTMLPurifier.standalone.php 32 classes/Language.php 33 classes/Country.php 34 classes/PrestaShopCollection.php 35 classes/Cookie.php 36 classes/Rijndael.php 37 classes/Employee.php 38 classes/Link.php 39 classes/shop/ShopUrl.php 40 config/smarty.config.inc.php 41 tools/smarty/Smarty.class.php 42 tools/smarty/sysplugins/smarty_internal_data.php 43 tools/smarty/sysplugins/smarty_internal_templatebase.php 44 tools/smarty/sysplugins/smarty_internal_template.php 45 tools/smarty/sysplugins/smarty_resource.php 46 tools/smarty/sysplugins/smarty_internal_resource_file.php 47 tools/smarty/sysplugins/smarty_cacheresource.php 48 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php 49 config/smartyadmin.config.inc.php 50 administrator/functions.php 51 ./images.inc.php 52 classes/Dispatcher.php 53 classes/Group.php 54 tools/mobile_Detect/Mobile_Detect.php 55 classes/Tab.php 56 controllers/admin/AdminPerformanceController.php 57 classes/controller/AdminController.php 58 classes/Translate.php 59 translations/es/admin.php 60 classes/Profile.php 61 classes/Currency.php 62 classes/module/Module.php 63 modules/themeconfigurator/themeconfigurator.php 64 modules/themeconfigurator/translations/es.php 65 modules/minicslider/minicslider.php 66 modules/minicslider/es.php 67 modules/ganalytics/ganalytics.php 68 modules/ganalytics/translations/es.php 69 modules/ganalytics/es.php 70 cache/smarty/compile/63/8e/24/638e248907fb9ea1e13ef6419958b1e07b8b7aa3.file.login_addons.tpl.php 71 classes/Media.php 72 modules/dashactivity/dashactivity.php 73 modules/dashactivity/translations/es.php 74 modules/dashtrends/dashtrends.php 75 modules/dashtrends/translations/es.php 76 modules/dashgoals/dashgoals.php 77 modules/dashgoals/translations/es.php 78 classes/QuickAccess.php 79 modules/autoupgrade/autoupgrade.php 80 modules/autoupgrade/translations/es.php 81 modules/autoupgrade/es.php 82 classes/helper/Helper.php 83 classes/shop/ShopGroup.php 84 classes/Combination.php 85 classes/Feature.php 86 classes/helper/HelperForm.php 87 cache/smarty/compile/03/03/a9/0303a9f6ea8454bb4057cd42bd7bac8cc5f84d2a.file.form.tpl.php 88 tools/smarty/plugins/function.counter.php 89 cache/smarty/compile/02/4a/66/024a66791c9c6fa58aede5a30fcaff8036a1d404.file.modal.tpl.php 90 cache/smarty/compile/43/73/71/437371d94b6999d2bbe1d1b5655d348e3c065e85.file.content.tpl.php 91 cache/smarty/compile/c2/b6/b5/c2b6b5deea76ca6494e24abd8f99f79c96ca377a.file.page_header_toolbar.tpl.php 92 cache/smarty/compile/77/18/fb/7718fb026a7c42bc30526b0ee4e10bb420de1468.file.modal.tpl.php 93 cache/smarty/compile/d3/d5/9b/d3d59b8a8a085f3babac9426edb121ac4c1c378a.file.header.tpl.php 94 cache/smarty/compile/41/8e/81/418e8124cb0ce21bd871477ec5dd4f3496050279.file.javascript.tpl.php 95 tools/smarty/plugins/modifier.replace.php 96 cache/smarty/compile/67/dc/6e/67dc6e50ac0634297a7481d0ab4fd066dab0cadc.file.nav.tpl.php 97 cache/smarty/compile/37/9b/65/379b65589be4cc10cc0f66649d0778d647609d34.file.search_form.tpl.php 98 cache/smarty/compile/0f/38/de/0f38deca04c6885f7d5f15790f1be0204cabcfb1.file.footer.tpl.php 99 cache/smarty/compile/66/68/f2/6668f2cb5cdf450942bf0b99bfe5098cf7a8bbf0.file.layout.tpl.php

Buenos días a toda la comunidad, Mi problema es el siguiente: cuando intento hacer login en mi tienda prestashop, me aparece una pagina de Error 404 Página no disponibleLo sentimos, la página no se encuentra disponible. He probado todo tipo de modificaciones que circulan por la web y todo lo que aparece en el foro sobre el tema, pero no doy con la solución. Me estoy planteando instalar in limpio la nueva versión de prestashop y exportar los miles de productos que tengo ya introducidos, pero despues de tanto trabajo perfiero ver si me podéis echarme una mano. Os cuanto lo que ya he probado sin éxito: activar: Desactivar apache MultiViews Reemplazar archivos de login del tema default a mi tema Borrar cookies del navegador entre otras.

Buenas tardes a todos, Ya he terminado de montar mi tienda en prestashop 1.5 con la pasarela de pago de banesto, modulo de pago el cual instalé y configuré sin problemas, pero haciendo las primeras pruebas en entorno real con el tpv cuando finalizo el pago a la hora de que el banco me redireccione y vuelva la tienda, me salta una pantalla en blanco con el siguiente mensaje: NO INPUT FILE SPECIFIED. He mirado en muchos sitios y tras indagar un poco creo que puede ser relacionado con la reescritura de url´s de prestashop en el archivo .htacces El caso es que ya no se que mas hacer, a ver si podéis arrojar un poco de luz con este tema que es el último paso para tener mi tienda lista. Agradecería cualquier ayuda. Muchas gracias de antemano

Buenas tardes, Soy nuevo con prestashop, la versión que tengo es la 1.5.3.1, tengo montada ya la tienda a falta de establecer la pasarela de pago y poner las categorías en la columna central. En el segundo punto es donde estoy atascado, no encuentro la manera de poner las categorías en el centro, con la imagen de cada categoria padre y el nombre y que cuando pinches te lleve a las subcategorías de esa categoría. Se que por el foro hay un modulo gratuito Home Categories para 1.5 el cual he instalado correctamente pero a la hora de asignar una imagen a las categorias padres no me la muestra. He visto que hay otro modulo homecategoriesplus, pero al ser nuevo en el foro no puedo descargármelo. Hay alguna solución tocando código para realizar esta tarea? Os estaría muy agradecido si me echarais una mano. Un saludo y muchas gracias por anticipado