Configuration des Modules impossible

[EricDesMontagnes]

Bonjour, je suis toujours en phase de test de Prestashop. J'ai un petit soucis avec le thème par défaut. Pas de soucis je peux activer ou désactiver ou installer des modules, par contre je ne peux pas les configurer.

 

Par exemple toujours dans le thème de base par défaut :

- Menu Haut Horizontal > Configurer > J'ajoute ou je retire des liens, rien ne se passe

- Bloc Tags > Je choisis par exemple d'afficher 15 tags au lieu de 10, j'enregistre, ça me renvoi sur la page d'accueil puis ça laisse la valeur initiale par défaut à 10.

- etc...

[Gregory Roussac]

Hello,

 

Il ya un cache sur le front office. Essaye de bidouiller Performances > cache. Mais la on dirait plutot un souci en back office. Regarde les logs de ton serveur error.log juste apres un enregistrement en back office pour voir. As tu activé l'affichage des erreurs dans defines.inc.php du dossier config ?

 

Cordialement

[EricDesMontagnes]

Donc j'ai désactivé le cache etc... rien ne change.

Je n'ai pas accès aux logs de mon serveur, j'ai activé l'affichage des erreurs dans le fichier cité du dossier config, je dois voir quoi exactement ?

Je peux mettre ce que ça me donne ici en "clair" ?

[Gregory Roussac]

Copiez le code affiché en mettant les balises

[code]

[/code]

, en supprimant les indications de l'adresse de votre back office effectivement.

[EricDesMontagnes]

Voici ce que ça donne :

 

<br>Load time: 338ms<br>Good boy! That's what I call a webserver!<br>config: 170ms<br>constructor: 0ms<br>init: 69ms<br>checkAccess: 0ms<br>setMedia: 20ms<br>postProcess: 0ms<br>initHeader: 24ms<br>initContent: 33ms<br>initFooter: 0ms<br>display: 22ms<br>Hook processing: 30ms / 1.25 Mb<br>displayBackOfficeHeader: 24ms / 1.08 Mb<br>moduleRoutes: 5ms / 0.14 Mb<br>displayBackOfficeFooter: 0ms / 0.01 Mb<br>displayAdminHomeQuickLinks: 0ms / 0.01 Mb<br>actionAdminControllerSetMedia: 0ms / 0 Mb<br>actionDispatcher: 0ms / 0.01 Mb<br>displayBackOfficeTop: 0ms / 0.01 Mb<br>displayAdminHomeStatistics: 0ms / 0 Mb<br>displayAdminHomeInfos: 0ms / 0 Mb<br>displayBackOfficeHome: 0ms / 0 Mb<br>Memory peak usage: 12.1 Mb<br>config: 7.27 Mb<br>constructor: 0 Mb<br>init: 2.27 Mb<br>checkAccess: 0 Mb<br>setMedia: 0 Mb<br>postProcess: 0 Mb<br>initHeader: 0.37 Mb<br>initContent: 0.66 Mb<br>initFooter: 0 Mb<br>display: 0.39 Mb<br><br>Total cache size (in Cache class): 0.08 Mb DB type: MySQL<br>SQL Queries: 46 queries<br>Time spent querying: 25ms Included files: 74<br>Size of included files: 1.55 Mb Globals (> 1 Ko only): 770 Ko<br>_LANGADM ˜ 703.1 Ko<br>context ˜ 27.7 Ko<br>_ENV ˜ 6.7 Ko<br>_SERVER ˜ 4.9 Ko<br>HTTP_SERVER_VARS ˜ 4.9 Ko<br>HTTP_ENV_VARS ˜ 4.9 Ko<br>_MODULE ˜ 3.7 Ko<br>_MODULES ˜ 3.4 Ko<br>_REQUEST ˜ 3.2 Ko<br>HTTP_COOKIE_VARS ˜ 3 Ko<br>_COOKIE ˜ 2.8 Ko<br>Go to Stopwatch<br>Go to Doubles<br>Go to Tables<br>Go to ObjectModels<br>Stopwatch (with SQL_NO_CACHE) (total = 46)<br>2.096 ms 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)<br>in [---]classes\Configuration.php:116<br>328 rows browsed<br>1.683 ms 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 ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) ORDER BY hm.`position`<br>in [---]classes\Hook.php:296<br>USING FILESORT - 65 rows browsed<br>1.138 ms 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` = 1) ORDER BY t.`position` ASC<br>in [---]classes\Tab.php:230<br>USING FILESORT - 103 rows browsed<br>0.849 ms SELECT SQL_NO_CACHE *, ( SELECT osl.`name` FROM `ps_order_state_lang` osl WHERE osl.`id_order_state` = o.`current_state` AND osl.`id_lang` = 1 LIMIT 1 ) AS `state_name` FROM `ps_orders` o LEFT JOIN `ps_customer` c ON (c.`id_customer` = o.`id_customer`) WHERE 1 AND o.id_shop IN (1) ORDER BY o.`date_add` DESC LIMIT 0, 10<br>in [---]classes\order\Order.php:873<br>USING FILESORT - 1 row browsed<br>0.841 ms SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1) as total FROM `ps_module` m<br>in [---]classes\module\Module.php:163<br>65 rows browsed<br>0.766 ms 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<br>in [---]classes\shop\Shop.php:602<br>USING FILESORT - 1 row browsed<br>0.708 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l INNER 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<br>in [---]classes\Language.php:774<br>1 row browsed<br>0.659 ms 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` = 1) ORDER BY `name` ASC<br>in [---]classes\QuickAccess.php:65<br>USING FILESORT - 5 rows browsed<br>0.563 ms SELECT SQL_NO_CACHE total_paid / conversion_rate as total_converted, left(invoice_date, 10) as invoice_date FROM ps_orders o WHERE valid = 1 AND total_paid > 0 AND invoice_date BETWEEN '2013-06-21 00:00:00' AND '2013-06-28 15:14:45' AND id_shop IN (1)<br>in [---]controllers\admin\AdminHomeController.php:386<br>1 row browsed<br>0.543 ms 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.j39distri.fr' OR su.domain_ssl = 'www.j39distri.fr') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC<br>in [---]classes\shop\Shop.php:317<br>USING FILESORT - 1 row browsed<br>0.533 ms SELECT SQL_NO_CACHE SUM(pv.`counter`) AS total_viewed FROM `ps_page_viewed` pv LEFT JOIN `ps_date_range` dr ON pv.`id_date_range` = dr.`id_date_range` LEFT JOIN `ps_page` p ON pv.`id_page` = p.`id_page` LEFT JOIN `ps_page_type` pt ON pt.`id_page_type` = p.`id_page_type` WHERE pt.`name` = 'product' AND dr.`time_start` BETWEEN '2013-06-01 00:00:00' AND '2013-06-31 23:59:59' AND dr.`time_end` BETWEEN '2013-06-01 00:00:00' AND '2013-06-31 23:59:59' AND id_shop IN (1) LIMIT 1<br>in [---]controllers\admin\AdminHomeController.php:321<br>1 row browsed<br>0.524 ms SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""<br>in [---]classes\Tab.php:206<br>103 rows browsed<br>0.524 ms 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<br>in [---]classes\ObjectModel.php:212<br>1 row browsed<br>0.504 ms 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 = 1 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1<br>in [---]classes\ObjectModel.php:212<br>1 row browsed<br>0.502 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias`<br>in [---]classes\Hook.php:142<br>86 rows browsed<br>0.502 ms SELECT SQL_NO_CACHE IFNULL(SUM(`total_paid_real` / conversion_rate), "0") as total_sales, COUNT(*) as total_orders FROM `ps_orders` WHERE valid = 1 AND `invoice_date` BETWEEN '2013-06-01 00:00:00' AND '2013-06-31 23:59:59' AND id_shop IN (1) LIMIT 1<br>in [---]controllers\admin\AdminHomeController.php:302<br>1 row browsed<br>0.498 ms SELECT SQL_NO_CACHE domain FROM ps_shop_url WHERE main=1 AND id_shop = 1 LIMIT 1<br>in [---]classes\shop\ShopUrl.php:151<br>1 row browsed<br>0.48 ms 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)<br>in [---]classes\Language.php:670<br>1 row browsed<br>0.479 ms 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<br>in [---]classes\ObjectModel.php:212<br>1 row browsed<br>0.466 ms SELECT SQL_NO_CACHE date_upd FROM ps_configuration WHERE name = "PS_HTACCESS_CACHE_CONTROL" LIMIT 1<br>in [---]controllers\admin\AdminHomeController.php:60<br>1 row browsed<br>0.465 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`<br>in [---]classes\Tab.php:260<br>103 rows browsed<br>0.458 ms SELECT SQL_NO_CACHE `id_hook` FROM `ps_hook` WHERE `name` = 'displayBackOfficeHeader' OR `name` = 'backofficeheader' LIMIT 1<br>in [---]classes\Hook.php:125<br>2 rows browsed<br>0.455 ms SELECT SQL_NO_CACHE COUNT(`id_customer`) AS total_registrations FROM `ps_customer` c WHERE c.`date_add` BETWEEN '2013-06-01 00:00:00' AND '2013-06-31 23:59:59' AND id_shop IN (1) LIMIT 1<br>in [---]controllers\admin\AdminHomeController.php:309<br>1 row browsed<br>0.454 ms SELECT SQL_NO_CACHE `id_employee` FROM `ps_employee` WHERE `id_employee` = 1 AND `passwd` = '42059059a56e64e7544f005cd8a75385' AND active = 1 LIMIT 1<br>in [---]classes\Employee.php:208<br>1 row browsed<br>0.449 ms 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 = 1) LIMIT 1<br>in [---]classes\ObjectModel.php:212<br>1 row browsed<br>0.44 ms SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1<br>in [---]classes\ObjectModel.php:212<br>1 row browsed<br>0.44 ms 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<br>in [---]classes\shop\Shop.php:200<br>1 row browsed<br>0.439 ms SELECT SQL_NO_CACHE domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop=1 LIMIT 1<br>in [---]classes\shop\ShopUrl.php:163<br>1 row browsed<br>0.436 ms SELECT SQL_NO_CACHE module FROM ps_tab_module_preference WHERE `id_tab` = 1 AND `id_employee` = 1<br>in [---]classes\Tab.php:518<br>1 row browsed<br>0.432 ms SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1<br>in [---]classes\ObjectModel.php:212<br>1 row browsed<br>0.431 ms SELECT SQL_NO_CACHE `id_employee` FROM `ps_employee` WHERE `id_employee` = 1 AND `passwd` = '42059059a56e64e7544f005cd8a75385' AND active = 1 LIMIT 1<br>in [---]classes\Employee.php:208<br>1 row browsed<br>0.412 ms SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1<br>in [---]classes\ObjectModel.php:1184<br>1 row browsed<br>0.41 ms SELECT SQL_NO_CACHE * FROM `ps_tab_lang` WHERE `id_tab` = 1<br>in [---]classes\ObjectModel.php:219<br>1 row browsed<br>0.402 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminhome' LIMIT 1<br>in [---]classes\Tab.php:171<br>103 rows browsed<br>0.394 ms 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` = 1) WHERE t.`id_tab` = 1 LIMIT 1<br>in [---]classes\Tab.php:190<br>1 row browsed<br>0.391 ms SELECT SQL_NO_CACHE * FROM `ps_tab` a WHERE (a.id_tab = 1) LIMIT 1<br>in [---]classes\ObjectModel.php:212<br>1 row browsed<br>0.376 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminhome' LIMIT 1<br>in [---]classes\Tab.php:171<br>103 rows browsed<br>0.375 ms SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1<br>in [---]classes\ObjectModel.php:1229<br>1 row browsed<br>0.373 ms SELECT SQL_NO_CACHE * FROM `ps_currency` WHERE `deleted` = 0 AND `id_currency` = 1 LIMIT 1<br>in [---]classes\Currency.php:277<br>1 row browsed<br>0.367 ms SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1<br>in [---]classes\ObjectModel.php:1184<br>1 row browsed<br>0.338 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminhome' LIMIT 1<br>in [---]classes\Tab.php:171<br>103 rows browsed<br>0.328 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_customer_thread` WHERE `status` LIKE "%pending%" LIMIT 1<br>in [---]controllers\admin\AdminHomeController.php:246<br>1 row browsed<br>0.328 ms SELECT SQL_NO_CACHE COUNT(*) FROM ps_customer_thread LIMIT 1<br>in [---]controllers\admin\AdminHomeController.php:244<br>1 row browsed<br>0.295 ms SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps_required_field<br>in [---]classes\ObjectModel.php:1143<br>1 row browsed<br>0.288 ms SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)<br>in [---]classes\module\Module.php:1507<br>1 row browsed<br>0.271 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_customer_thread` WHERE `status` = "open" LIMIT 1<br>in [---]controllers\admin\AdminHomeController.php:245<br>1 row browsed<br>Doubles (IDs replaced by "XX") (total = 42)<br>3 SELECT `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminhome' LIMIT XX<br>2 SELECT id_shop FROM `ps_currency_shop` WHERE `id_currency` = XX AND id_shop = XX LIMIT XX<br>2 SELECT `id_employee` FROM `ps_employee` WHERE `id_employee` = XX AND `passwd` = 'XXaXXeXXeXXfXXcdXXaXX' AND active = XX LIMIT XX<br>1 SELECT * FROM `ps_shop_group` a WHERE (a.id_shop_group = XX) LIMIT XX<br>1 SELECT module FROM ps_tab_module_preference WHERE `id_tab` = XX AND `id_employee` = XX<br>1 SELECT * FROM `ps_shop` a WHERE (a.id_shop = XX) LIMIT XX<br>1 SELECT id_required_field, object_name, field_name FROM ps_required_field<br>1 SELECT * 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` = XX) ORDER BY `name` ASC<br>1 SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'displayBackOfficeHeader' OR `name` = 'backofficeheader' LIMIT XX<br>1 SELECT m.`id_module`, m.`name`, (SELECT COUNT(*) FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX) as total FROM `ps_module` m<br>1 SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (XX)<br>1 SELECT IFNULL(SUM(`total_paid_real` / conversion_rate), "XX") as total_sales, COUNT(*) as total_orders FROM `ps_orders` WHERE valid = XX AND `invoice_date` BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND id_shop IN (XX) LIMIT XX<br>1 SELECT COUNT(`id_customer`) AS total_registrations FROM `ps_customer` c WHERE c.`date_add` BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND id_shop IN (XX) LIMIT XX<br>1 SELECT *, ( SELECT osl.`name` FROM `ps_order_state_lang` osl WHERE osl.`id_order_state` = o.`current_state` AND osl.`id_lang` = XX LIMIT XX ) AS `state_name` FROM `ps_orders` o LEFT JOIN `ps_customer` c ON (c.`id_customer` = o.`id_customer`) WHERE XX AND o.id_shop IN (XX) ORDER BY o.`date_add` DESC LIMIT XX, XX<br>1 SELECT * FROM `ps_currency` WHERE `deleted` = XX AND `id_currency` = XX LIMIT XX<br>1 SELECT date_upd FROM ps_configuration WHERE name = "PS_HTACCESS_CACHE_CONTROL" LIMIT XX<br>1 SELECT total_paid / conversion_rate as total_converted, left(invoice_date, XX) as invoice_date FROM ps_orders o WHERE valid = XX AND total_paid > XX AND invoice_date BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND id_shop IN (XX)<br>1 SELECT COUNT(*) FROM `ps_customer_thread` WHERE `status` LIKE "%pending%" LIMIT XX<br>1 SELECT SUM(pv.`counter`) AS total_viewed FROM `ps_page_viewed` pv LEFT JOIN `ps_date_range` dr ON pv.`id_date_range` = dr.`id_date_range` LEFT JOIN `ps_page` p ON pv.`id_page` = p.`id_page` LEFT JOIN `ps_page_type` pt ON pt.`id_page_type` = p.`id_page_type` WHERE pt.`name` = 'product' AND dr.`time_start` BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND dr.`time_end` BETWEEN 'XX-XX-XX XX:XX:XX' AND 'XX-XX-XX XX:XX:XX' AND id_shop IN (XX) LIMIT XX<br>1 SELECT COUNT(*) FROM ps_customer_thread LIMIT XX<br>1 SELECT COUNT(*) FROM `ps_customer_thread` WHERE `status` = "open" LIMIT XX<br>1 SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = XX WHERE (a.id_currency = XX) LIMIT XX<br>1 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<br>1 SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = XX WHERE (a.id_lang = XX) LIMIT XX<br>1 SELECT domain FROM ps_shop_url WHERE main=XX AND id_shop = XX LIMIT XX<br>1 SELECT domain_ssl FROM ps_shop_url WHERE main = XX AND id_shop=XX LIMIT XX<br>1 SELECT id_shop FROM `ps_employee_shop` WHERE `id_employee` = XX<br>1 SELECT * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.id_employee = c.id_employee AND c.id_shop = XX WHERE (a.id_employee = XX) LIMIT XX<br>1 SELECT 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)<br>1 SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)<br>1 SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = XX LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = XX WHERE (a.id_country = XX) LIMIT XX<br>1 SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l INNER JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = XX) WHERE l.`active` = XX LIMIT XX<br>1 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 ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (XX)) = XX) AND (h.name != "displayPayment") AND (hm.id_shop = XX) ORDER BY hm.`position`<br>1 SELECT * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX) ORDER BY t.`position` ASC<br>1 SELECT 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.jXXdistri.fr' OR su.domain_ssl = 'www.jXXdistri.fr') AND s.active = XX AND s.deleted = XX ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC<br>1 SELECT 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 = XX WHERE s.deleted = XX AND gs.deleted = XX ORDER BY gs.name, s.name<br>1 SELECT t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""<br>1 SELECT * FROM `ps_tab_lang` WHERE `id_tab` = XX<br>1 SELECT * FROM `ps_hook_alias`<br>1 SELECT id_tab, class_name FROM `ps_tab`<br>1 SELECT * FROM `ps_tab` a WHERE (a.id_tab = XX) LIMIT XX<br>1 SELECT 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 = XX AND s.active = XX AND s.deleted = XX AND su.main = XX LIMIT XX<br>Tables stress<br>8 tab<br>5 shop_url<br>4 shop<br>3 tab_lang<br>3 employee<br>3 lang_shop<br>3 lang<br>3 orders<br>3 customer_thread<br>3 currency_shop<br>2 module_shop<br>2 shop_group<br>2 currency<br>2 hook<br>2 employee_shop<br>2 configuration<br>2 module<br>2 customer<br>1 tab_module_preference<br>1 page_type<br>1 order_state_lang<br>1 date_range<br>1 quick_access_lang<br>1 page_viewed<br>1 page<br>1 hook_alias<br>1 configuration_lang<br>1 theme<br>1 required_field<br>1 country<br>1 country_lang<br>1 hook_module_exceptions<br>1 hook_module<br>1 country_shop<br>1 quick_access<br>ObjectModel instances<br>2 Currency<br>1 ShopGroup<br>1 Tab<br>1 Language<br>1 Country<br>1 Employee<br>1 Shop<br>Included files<br>1 adminXXXX/index.php<br>2 config/config.inc.php<br>3 config/defines.inc.php<br>4 config/settings.inc.php<br>5 config/autoload.php<br>6 config/alias.php<br>7 classes/Autoload.php<br>8 cache/class_index.php<br>9 tools/profiling/Controller.php<br>10 classes/controller/Controller.php<br>11 tools/profiling/ObjectModel.php<br>12 classes/ObjectModel.php<br>13 tools/profiling/Hook.php<br>14 classes/Hook.php<br>15 tools/profiling/Db.php<br>16 classes/db/Db.php<br>17 tools/profiling/Tools.php<br>18 classes/Tools.php<br>19 classes/Context.php<br>20 classes/shop/Shop.php<br>21 classes/db/MySQL.php<br>22 classes/cache/Cache.php<br>23 classes/Validate.php<br>24 classes/db/DbQuery.php<br>25 config/defines_uri.inc.php<br>26 classes/Configuration.php<br>27 classes/Language.php<br>28 classes/Country.php<br>29 classes/Collection.php<br>30 classes/Cookie.php<br>31 classes/Blowfish.php<br>32 classes/Employee.php<br>33 classes/Link.php<br>34 classes/shop/ShopUrl.php<br>35 config/smarty.config.inc.php<br>36 tools/smarty/Smarty.class.php<br>37 tools/smarty/sysplugins/smarty_internal_data.php<br>38 tools/smarty/sysplugins/smarty_internal_templatebase.php<br>39 tools/smarty/sysplugins/smarty_internal_template.php<br>40 tools/smarty/sysplugins/smarty_resource.php<br>41 tools/smarty/sysplugins/smarty_internal_resource_file.php<br>42 tools/smarty/sysplugins/smarty_cacheresource.php<br>43 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php<br>44 config/smartyadmin.config.inc.php<br>45 adminXXXX/functions.php<br>46 ./images.inc.php<br>47 classes/Dispatcher.php<br>48 classes/Tab.php<br>49 controllers/admin/AdminHomeController.php<br>50 classes/controller/AdminController.php<br>51 classes/Translate.php<br>52 translations/fr/admin.php<br>53 classes/Profile.php<br>54 classes/Currency.php<br>55 classes/module/Module.php<br>56 modules/gamification/gamification.php<br>57 modules/gamification/classes/Badge.php<br>58 modules/gamification/classes/Advice.php<br>59 modules/gamification/classes/Condition.php<br>60 modules/gamification/classes/GamificationTools.php<br>61 modules/gamification/fr.php<br>62 classes/Media.php<br>63 classes/QuickAccess.php<br>64 classes/helper/Helper.php<br>65 classes/shop/ShopGroup.php<br>66 classes/Upgrader.php<br>67 classes/Chart.php<br>68 classes/order/Order.php<br>69 cache/smarty/compile/22/2e/79/222e7914a3abf36503c21862412f113383be872a.file.optimizationTips.tpl.php<br>70 cache/smarty/compile/0c/72/c9/0c72c9ccd50575830a977e15cac18f05d0574621.file.content.tpl.php<br>71 cache/smarty/compile/6d/32/dc/6d32dc2faff9b47ec342bfc4c80b9d1007d3309e.file.layout.tpl.php<br>72 cache/smarty/compile/89/a2/f8/89a2f8c31b9c625f04de1bd9414a1b6de3c0bfcc.file.header.tpl.php<br>73 tools/smarty/plugins/modifier.escape.php<br>74 cache/smarty/compile/95/10/4e/95104e9dd330435733f5e6f8c171e79bf984594b.file.footer.tpl.php<br>

 

[Gregory Roussac]

Re,

 

Dans vos tests vous auriez pas passé _PS_DEBUG_PROFILING_ à true par hasard ? dans defines.inc.php

[EricDesMontagnes]

Heu si... Mais si je mets seulement l'autre débug à true, ça ne sortait rien :'(

[Gregory Roussac]

Pourquoi vous n'avez pas accès aux logs de votre serveur ?

[EricDesMontagnes]

Mon prestataire ne me donne pas l'accès aux logs c'est pour ça. Je n'ai qu'un accès partiel à certaines fonctions, mais pas les logs.

[Paul MONFILS]

Un conseil: changez d'hébergeur (ou de prestataire).