Jump to content

Welcome, Guest!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

ALM

Members
  • Content Count

    32
  • Joined

  • Last visited

  • Days Won

    1

ALM last won the day on March 12

ALM had the most liked content!

Community Reputation

2 Neutral

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. The following is my final finding: If you enable the hiding of the IOSslider for Mobile, the problem exists! https://www.sunnytoo.com/forums/topic/tb-1-1-x-questions-problems#post-103765 Waiting for feedback from yobo (Panda theme)
  2. thank you for finding the cause!
  3. Slider has been disabled and cache deleted, now it seems to work on mobile. @toplakdCould you kindly repeat on linux?
  4. Hi guys, thanks for the feedback. My findings are that it works in Edge, Mozilla and Chrome on PC (Windows 10PRO 64 Bit), even for resolution below 767px. For mobile it hangs most of the time. Also, the slider is disabled for the mobile version. Any tool recommendations for debugging on mobile android?
  5. Hello, I noticed that my TB1.1.X mostly does not work on cell phones. I tested it with Galaxy S10+, S8, S20 and Android Tablet. Each device hangs mostly after a few seconds, sometimes however rarely I have seen it work properly. My TB1.1.X was a clean install with Panda theme. Anyway, there are no error logs on the server side. After I contacted the web host, he couldn't find any server problems either. In my opinion, the web host can't find any problem because I have a second other domain with exactly the same configuration (clean TB1.1.X installation with Panda). At the moment I'm at the end of how to debug the problem further. Hopefully you have some tips for identifying the root cause.
  6. anybody there? I identified that the tree structure comes from the JS located in /admin/themes/default/js/tree.js. The basic question is still why the categories are missing for new products... Hope to receive some troubleshoot tips at least. Thx
  7. Repeated the same procedure on the 2nd store where category selection works for new products. And here the same, no interaction with category tables. In summary, it should be some other function that is responsible for viewing category options. Is it some java function? Hope for some feedback from the core team...;(
  8. Profile for new category: Stopwatch SQL - 69 queries Query Time (ms) Rows Filesort Group By Location SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS `value`, c.`id_shop_group`, c.`id_shop` FROM `tb_configuration` c LEFT JOIN `tb_configuration_lang` `cl` ON c.`id_configuration` = cl.`id_configuration` 8.5 2114 /classes/Configuration.php:437 SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `tb_tab` t WHERE (t.`module` IS NOT NULL) AND (t.`module` != "") 3.6 106 /classes/Tab.php:191 SELECT SQL_NO_CACHE m.`page`, ml.`url_rewrite`, ml.`id_lang` FROM `tb_meta` m LEFT JOIN `tb_meta_lang` `ml` ON m.`id_meta` = ml.`id_meta` AND ml.id_shop = 1 ORDER BY LENGTH(ml.`url_rewrite`) DESC 2.9 224 Yes /classes/Dispatcher.php:609 SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `tb_module` m INNER JOIN tb_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 `tb_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `tb_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `tb_hook` h ON hm.`id_hook` = h.`id_hook` WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 2.7 138 Yes Yes /classes/Hook.php:588 SELECT SQL_NO_CACHE `id_hook`, `name` FROM `tb_hook` UNION SELECT `id_hook`, ha.`alias` AS name FROM `tb_hook_alias` ha INNER JOIN `tb_hook` h ON ha.name = h.name 2.3 0 /classes/Hook.php:731 SELECT SQL_NO_CACHE t.*, COALESCE(NULLIF(tl.`name`, ""), tl_def.`name`) AS `name` FROM `tb_tab` t LEFT JOIN `tb_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1 LEFT JOIN `tb_tab_lang` `tl_def` ON t.`id_tab` = tl_def.`id_tab` AND tl_def.`id_lang` = 1 ORDER BY t.`position` ASC 1.4 106 Yes /classes/Tab.php:227 SELECT SQL_NO_CACHE value FROM `tb_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 0.8 2114 /classes/shop/Shop.php:1304 SELECT SQL_NO_CACHE c.id_category, cl.name FROM `tb_category` c INNER JOIN tb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `tb_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 RIGHT JOIN `tb_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright` WHERE 1 AND `id_lang` = 5 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC 0.7 28 Yes /classes/Category.php:291 SELECT SQL_NO_CACHE `id_tab`, `class_name` FROM `tb_tab` 0.6 106 /classes/Tab.php:135 SELECT SQL_NO_CACHE cg.`id_group` FROM `tb_category_group` cg WHERE (cg.`id_category` = 0) 0.6 1 /classes/Category.php:2274 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 `tb_shop_group` gs LEFT JOIN `tb_shop` `s` ON s.`id_shop_group` = gs.`id_shop_group` LEFT JOIN `tb_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.6 1 Yes /classes/shop/Shop.php:753 SELECT SQL_NO_CACHE * FROM `tb_tab` a LEFT JOIN `tb_tab_lang` `b` ON a.`id_tab` = b.`id_tab` AND b.`id_lang` = 1 WHERE (a.`id_tab` = 22) LIMIT 1 0.6 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop` FROM `tb_module` m LEFT JOIN `tb_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 1 0.5 47 /classes/module/Module.php:214 SELECT SQL_NO_CACHE s.`id_shop`, CONCAT(su.`physical_uri`, su.`virtual_uri`) AS `uri`, su.`domain`, su.`main` FROM `tb_shop_url` su LEFT JOIN `tb_shop` `s` ON s.`id_shop` = su.`id_shop` WHERE (su.domain = 'www.xeniamode.de' OR su.domain_ssl = 'www.xeniamode.de') AND (s.`active` = 1) AND (s.`deleted` = 0) ORDER BY LENGTH(CONCAT(su.`physical_uri`, su.`virtual_uri`)) DESC 0.5 1 Yes /classes/shop/Shop.php:353 SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`) FROM `tb_lang` l INNER JOIN `tb_lang_shop` ls ON ls.`id_lang` = l.`id_lang` WHERE (ls.`id_shop` = 1) AND (l.`active` = 1) LIMIT 1 0.5 4 /classes/Language.php:395 SELECT SQL_NO_CACHE DISTINCT g.`id_group`, g.`reduction`, g.`price_display_method`, gl.`name` FROM `tb_group` g LEFT JOIN `tb_group_lang` `gl` ON g.`id_group` = gl.`id_group` AND gl.`id_lang` = 1 INNER JOIN tb_group_shop group_shop ON (group_shop.id_group = g.id_group AND group_shop.id_shop = 1) ORDER BY g.`id_group` ASC 0.5 5 /classes/Group.php:132 SELECT SQL_NO_CACHE * FROM `tb_employee` a LEFT JOIN `tb_employee_shop` `c` ON a.`id_employee` = c.`id_employee` AND c.`id_shop` = 1 WHERE (a.`id_employee` = 1) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_image_type` WHERE (`products` = 1) ORDER BY `name` ASC 0.5 21 Yes /classes/ImageType.php:156 SELECT SQL_NO_CACHE * FROM `tb_country` a LEFT JOIN `tb_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 1) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_currency` a LEFT JOIN `tb_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 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `tb_category` c LEFT JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN tb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 5 AND c.`id_parent` = 2 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC 0.4 12 Yes Yes /classes/Category.php:560 SELECT SQL_NO_CACHE * FROM `tb_hook_alias` 0.4 86 /classes/Hook.php:685 SELECT SQL_NO_CACHE * FROM `tb_country` a LEFT JOIN `tb_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `tb_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 1) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_lang` a LEFT JOIN `tb_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `tb_lang` l LEFT JOIN `tb_lang_shop` `ls` ON l.`id_lang` = ls.`id_lang` 0.4 2 /classes/Language.php:177 SELECT SQL_NO_CACHE `id_employee` FROM `tb_employee` WHERE (`id_employee` = 1) AND (`active` = 1) AND (`passwd` = '$2y$10$dMUVBtC5zi8TX2xTU7pHsOR.HH9Ye4m1Z9QL9h6IcNNAhCU4/tSly') LIMIT 1 0.4 1 /classes/Employee.php:635 SELECT SQL_NO_CACHE * FROM `tb_quick_access` qa LEFT JOIN `tb_quick_access_lang` `qal` ON qa.`id_quick_access` = qal.`id_quick_access` WHERE (qal.`id_lang` = 1) ORDER BY `name` ASC 0.4 4 Yes /classes/QuickAccess.php:83 SELECT SQL_NO_CACHE * FROM `tb_category` a LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE c.id_category, "" AS name FROM `tb_category` c LEFT JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN tb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 5 AND c.`id_parent` = 15 LIMIT 1 0.3 7 /classes/Category.php:598 SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM `tb_shop` s LEFT JOIN `tb_shop_url` `su` ON s.`id_shop` = su.`id_shop` LEFT JOIN `tb_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.3 1 /classes/shop/Shop.php:179 SELECT SQL_NO_CACHE * FROM `tb_currency` c INNER JOIN tb_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE (`deleted` = 0) ORDER BY `name` ASC 0.3 1 Yes /classes/Currency.php:354 SELECT SQL_NO_CACHE DISTINCT c.* FROM `tb_category` c LEFT JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1) WHERE `level_depth` = 1 0.3 3 /classes/Category.php:442 SELECT SQL_NO_CACHE c.id_category, "" AS name FROM `tb_category` c LEFT JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN tb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 5 AND c.`id_parent` = 26 LIMIT 1 0.3 1 /classes/Category.php:598 SELECT SQL_NO_CACHE `name` FROM `tb_image_type` 0.3 21 /classes/ImageType.php:183 SELECT SQL_NO_CACHE * FROM `tb_country_lang` WHERE (`id_country` = 1) 0.3 8 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE * FROM `tb_tab` t LEFT JOIN `tb_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1 WHERE (t.`id_tab` = 22) LIMIT 1 0.3 1 /classes/Tab.php:437 SELECT SQL_NO_CACHE * FROM `tb_category` a LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) AS last_flush FROM `tb_smarty_last_flush` WHERE type='compile' LIMIT 1 0.3 1 /classes/SmartyCustom.php:199 SELECT SQL_NO_CACHE `domain`, `domain_ssl` FROM `tb_shop_url` WHERE (`main` = 1) AND (`id_shop` = 1) LIMIT 1 0.3 1 /classes/shop/ShopUrl.php:253 SELECT SQL_NO_CACHE * FROM `tb_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(*) n FROM `tb_module_shop` WHERE (`id_module` = 103) AND (`id_shop` IN (1)) GROUP BY `id_module` HAVING (n = 1) LIMIT 1 0.3 1 /classes/module/Module.php:3109 SELECT SQL_NO_CACHE * FROM `tb_hook_module_exceptions` WHERE (`id_shop` IN (1)) 0.3 1 /classes/module/Module.php:3035 SELECT SQL_NO_CACHE * FROM `tb_group_lang` WHERE (`id_group` = 1) 0.3 8 /Adapter/Adapter_EntityMapper.php:88 UPDATE `tb_employee` SET `last_connection_date` = CURRENT_DATE() WHERE `id_employee` = 1 AND `last_connection_date` < CURRENT_DATE() 0.3 1 /classes/Employee.php:270 SELECT SQL_NO_CACHE c.id_category, "" AS name FROM `tb_category` c LEFT JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN tb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 5 AND c.`id_parent` = 16 LIMIT 1 0.3 3 /classes/Category.php:598 SELECT SQL_NO_CACHE DISTINCT g.`id_group`, g.`reduction`, g.`price_display_method`, gl.`name` FROM `tb_group` g LEFT JOIN `tb_group_lang` `gl` ON g.`id_group` = gl.`id_group` AND gl.`id_lang` = 1 ORDER BY g.`id_group` ASC 0.3 5 /classes/Group.php:132 SELECT SQL_NO_CACHE * FROM `tb_category` a LEFT JOIN `tb_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5 LEFT JOIN `tb_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(*) n FROM `tb_module_shop` WHERE (`id_module` = 30) AND (`id_shop` IN (1)) GROUP BY `id_module` HAVING (n = 1) LIMIT 1 0.2 1 /classes/module/Module.php:3109 SELECT SQL_NO_CACHE c.id_category, "" AS name FROM `tb_category` c LEFT JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN tb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 5 AND c.`id_parent` = 18 LIMIT 1 0.2 4 /classes/Category.php:598 SELECT SQL_NO_CACHE * FROM `tb_lang` a LEFT JOIN `tb_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 5) LIMIT 1 0.2 0 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_category_lang` WHERE (`id_category` = 2) AND (`id_shop` = 1) 0.2 8 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE c.id_category, "" AS name FROM `tb_category` c LEFT JOIN `tb_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN tb_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 5 AND c.`id_parent` = 17 LIMIT 1 0.2 1 /classes/Category.php:598 SELECT SQL_NO_CACHE * FROM `tb_image_type` WHERE (`categories` = 1) ORDER BY `name` ASC 0.2 21 Yes /classes/ImageType.php:156 SELECT SQL_NO_CACHE c.*, cl.* FROM `tb_category` c LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category` WHERE (`id_lang` = 5 AND cl.id_shop = 1 ) AND (c.`id_category` = 2) LIMIT 1 0.2 1 /classes/Category.php:2222 SELECT SQL_NO_CACHE * FROM `tb_group` a LEFT JOIN `tb_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_tab` t LEFT JOIN `tb_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1 WHERE (t.`id_tab` = 9) LIMIT 1 0.2 1 /classes/Tab.php:437 SELECT SQL_NO_CACHE * FROM `tb_theme` a WHERE (a.`id_theme` = 2) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_group` a LEFT JOIN `tb_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 2) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE id_shop FROM `tb_employee_shop` WHERE `id_employee` = 1 0.2 1 /classes/ObjectModel.php:1733 SELECT SQL_NO_CACHE * FROM `tb_group_lang` WHERE (`id_group` = 2) 0.2 8 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE * FROM `tb_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_group_lang` WHERE (`id_group` = 3) 0.2 8 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE `id_parent` FROM `tb_tab` WHERE (LOWER(`class_name`) = 'admincategories') LIMIT 1 0.2 106 /classes/Tab.php:162 SELECT SQL_NO_CACHE `class_name` FROM `tb_tab` WHERE (`id_tab` = 1) LIMIT 1 0.2 1 /classes/Tab.php:589 SELECT SQL_NO_CACHE `id_module`, `name` FROM `tb_module` 0.2 47 /classes/module/Module.php:1766 SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, cl.`id_lang` FROM `tb_category` c LEFT JOIN `tb_category_lang` `cl` ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE (cl.`id_lang` = 5) AND (c.`id_category` IN (2)) 0.2 1 /classes/Category.php:1055 SELECT SQL_NO_CACHE * FROM `tb_group` a LEFT JOIN `tb_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 3) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(*) n FROM `tb_module_shop` WHERE (`id_module` = 136) AND (`id_shop` IN (1)) GROUP BY `id_module` HAVING (n = 1) LIMIT 1 0.2 1 /classes/module/Module.php:3109 SELECT SQL_NO_CACHE id_shop FROM `tb_category_shop` WHERE `id_category` = 2 AND id_shop = 1 LIMIT 1 Profile for new product (no interaction with category tables): Stopwatch SQL - 50 queries Query Time (ms) Rows Filesort Group By Location SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS `value`, c.`id_shop_group`, c.`id_shop` FROM `tb_configuration` c LEFT JOIN `tb_configuration_lang` `cl` ON c.`id_configuration` = cl.`id_configuration` 8.6 2114 /classes/Configuration.php:437 SELECT SQL_NO_CACHE `id_hook`, `name` FROM `tb_hook` UNION SELECT `id_hook`, ha.`alias` AS name FROM `tb_hook_alias` ha INNER JOIN `tb_hook` h ON ha.name = h.name 2.2 0 /classes/Hook.php:731 SELECT SQL_NO_CACHE m.`page`, ml.`url_rewrite`, ml.`id_lang` FROM `tb_meta` m LEFT JOIN `tb_meta_lang` `ml` ON m.`id_meta` = ml.`id_meta` AND ml.id_shop = 1 ORDER BY LENGTH(ml.`url_rewrite`) DESC 2 224 Yes /classes/Dispatcher.php:609 SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `tb_module` m INNER JOIN tb_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 `tb_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `tb_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `tb_hook` h ON hm.`id_hook` = h.`id_hook` WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 1.9 138 Yes Yes /classes/Hook.php:588 SELECT SQL_NO_CACHE t.*, COALESCE(NULLIF(tl.`name`, ""), tl_def.`name`) AS `name` FROM `tb_tab` t LEFT JOIN `tb_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1 LEFT JOIN `tb_tab_lang` `tl_def` ON t.`id_tab` = tl_def.`id_tab` AND tl_def.`id_lang` = 1 ORDER BY t.`position` ASC 1.4 106 Yes /classes/Tab.php:227 SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM `tb_shop` s LEFT JOIN `tb_shop_url` `su` ON s.`id_shop` = su.`id_shop` LEFT JOIN `tb_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 1.2 1 /classes/shop/Shop.php:179 SELECT SQL_NO_CACHE t.`id_lang`, t.`name` FROM `tb_tag` t LEFT JOIN `tb_product_tag` `pt` ON pt.`id_tag` = t.`id_tag` WHERE (pt.`id_product` = 0) 1.2 1 /classes/Tag.php:331 SELECT SQL_NO_CACHE * FROM `tb_quick_access` qa LEFT JOIN `tb_quick_access_lang` `qal` ON qa.`id_quick_access` = qal.`id_quick_access` WHERE (qal.`id_lang` = 1) ORDER BY `name` ASC 0.9 4 Yes /classes/QuickAccess.php:83 SELECT SQL_NO_CACHE * FROM `tb_currency` c INNER JOIN tb_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE (`deleted` = 0) ORDER BY `name` ASC 0.7 1 Yes /classes/Currency.php:354 SELECT SQL_NO_CACHE `id_product_attribute` FROM `tb_product_attribute` WHERE `id_product` = 0 0.6 1 /classes/Product.php:5764 SELECT SQL_NO_CACHE value FROM `tb_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 0.6 2114 /classes/shop/Shop.php:1304 SELECT SQL_NO_CACHE * FROM `tb_tab` t LEFT JOIN `tb_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1 WHERE (t.`id_tab` = 21) LIMIT 1 0.5 1 /classes/Tab.php:437 SELECT SQL_NO_CACHE COUNT(*) n FROM `tb_module_shop` WHERE (`id_module` = 103) AND (`id_shop` IN (1)) GROUP BY `id_module` HAVING (n = 1) LIMIT 1 0.5 1 /classes/module/Module.php:3109 SELECT SQL_NO_CACHE `id_parent` FROM `tb_tab` WHERE (LOWER(`class_name`) = 'adminproducts') LIMIT 1 0.5 106 /classes/Tab.php:162 UPDATE `tb_employee` SET `last_connection_date` = CURRENT_DATE() WHERE `id_employee` = 1 AND `last_connection_date` < CURRENT_DATE() 0.5 1 /classes/Employee.php:270 SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `tb_tab` t WHERE (t.`module` IS NOT NULL) AND (t.`module` != "") 0.5 106 /classes/Tab.php:191 SELECT SQL_NO_CACHE * FROM `tb_tab` a LEFT JOIN `tb_tab_lang` `b` ON a.`id_tab` = b.`id_tab` AND b.`id_lang` = 1 WHERE (a.`id_tab` = 21) LIMIT 1 0.5 1 /Adapter/Adapter_EntityMapper.php:80 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 `tb_shop_group` gs LEFT JOIN `tb_shop` `s` ON s.`id_shop_group` = gs.`id_shop_group` LEFT JOIN `tb_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.5 1 Yes /classes/shop/Shop.php:753 SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module` AS `mshop` FROM `tb_module` m LEFT JOIN `tb_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = 1 0.4 47 /classes/module/Module.php:214 SELECT SQL_NO_CACHE COUNT(*) n FROM `tb_module_shop` WHERE (`id_module` = 30) AND (`id_shop` IN (1)) GROUP BY `id_module` HAVING (n = 1) LIMIT 1 0.4 1 /classes/module/Module.php:3109 SELECT SQL_NO_CACHE * FROM `tb_tab` t LEFT JOIN `tb_tab_lang` `tl` ON t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1 WHERE (t.`id_tab` = 9) LIMIT 1 0.4 1 /classes/Tab.php:437 SELECT SQL_NO_CACHE * FROM `tb_employee` a LEFT JOIN `tb_employee_shop` `c` ON a.`id_employee` = c.`id_employee` AND c.`id_shop` = 1 WHERE (a.`id_employee` = 1) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE COUNT(*) n FROM `tb_module_shop` WHERE (`id_module` = 136) AND (`id_shop` IN (1)) GROUP BY `id_module` HAVING (n = 1) LIMIT 1 0.4 1 /classes/module/Module.php:3109 SELECT SQL_NO_CACHE * FROM `tb_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE `id_employee` FROM `tb_employee` WHERE (`id_employee` = 1) AND (`active` = 1) AND (`passwd` = '$2y$10$dMUVBtC5zi8TX2xTU7pHsOR.HH9Ye4m1Z9QL9h6IcNNAhCU4/tSly') LIMIT 1 0.4 1 /classes/Employee.php:635 SELECT SQL_NO_CACHE * FROM `tb_currency` a LEFT JOIN `tb_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 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_image_type` WHERE (`products` = 1) ORDER BY `name` ASC 0.4 21 Yes /classes/ImageType.php:156 SELECT SQL_NO_CACHE * FROM `tb_country` a LEFT JOIN `tb_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 1) LIMIT 1 0.4 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE s.`id_shop`, CONCAT(su.`physical_uri`, su.`virtual_uri`) AS `uri`, su.`domain`, su.`main` FROM `tb_shop_url` su LEFT JOIN `tb_shop` `s` ON s.`id_shop` = su.`id_shop` WHERE (su.domain = 'www.xeniamode.de' OR su.domain_ssl = 'www.xeniamode.de') AND (s.`active` = 1) AND (s.`deleted` = 0) ORDER BY LENGTH(CONCAT(su.`physical_uri`, su.`virtual_uri`)) DESC 0.4 1 Yes /classes/shop/Shop.php:353 SELECT SQL_NO_CACHE COUNT(DISTINCT l.`id_lang`) FROM `tb_lang` l INNER JOIN `tb_lang_shop` ls ON ls.`id_lang` = l.`id_lang` WHERE (ls.`id_shop` = 1) AND (l.`active` = 1) LIMIT 1 0.4 4 /classes/Language.php:395 SELECT SQL_NO_CACHE * FROM `tb_image` i LEFT JOIN `tb_image_lang` `il` ON i.`id_image` = il.`id_image` WHERE (i.`id_product` = 0) AND (il.`id_lang` = 1) ORDER BY i.`position` ASC 0.3 1 Yes /classes/Image.php:178 SELECT SQL_NO_CACHE COUNT(*) FROM `tb_product_attribute` pa INNER JOIN tb_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (pa.`id_product` = 0) LIMIT 1 0.3 1 /classes/Product.php:5819 SELECT SQL_NO_CACHE `id_tab`, `class_name` FROM `tb_tab` 0.3 106 /classes/Tab.php:135 SELECT SQL_NO_CACHE * FROM `tb_country` a LEFT JOIN `tb_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `tb_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 1) LIMIT 1 0.3 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_country_lang` WHERE (`id_country` = 1) 0.3 8 /Adapter/Adapter_EntityMapper.php:88 SELECT SQL_NO_CACHE DISTINCT pl.name as name FROM `tb_product_lang` pl WHERE (pl.id_product = 0) AND (pl.id_lang = 1 AND pl.id_shop = 1 ) LIMIT 1 0.3 0 /classes/Product.php:3707 SELECT SQL_NO_CACHE * FROM `tb_hook_alias` 0.3 86 /classes/Hook.php:685 SELECT SQL_NO_CACHE `id_product_download` FROM `tb_product_download` WHERE (`id_product` = 0) AND (`active` = 1) ORDER BY `id_product_download` DESC LIMIT 1 0.3 0 /classes/ProductDownload.php:138 SELECT SQL_NO_CACHE `id_module`, `name` FROM `tb_module` 0.3 47 /classes/module/Module.php:1766 SELECT SQL_NO_CACHE `class_name` FROM `tb_tab` WHERE (`id_tab` = 1) LIMIT 1 0.3 1 /classes/Tab.php:589 SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `tb_lang` l LEFT JOIN `tb_lang_shop` `ls` ON l.`id_lang` = ls.`id_lang` 0.3 2 /classes/Language.php:177 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) AS last_flush FROM `tb_smarty_last_flush` WHERE type='compile' LIMIT 1 0.3 1 /classes/SmartyCustom.php:199 SELECT SQL_NO_CACHE `domain`, `domain_ssl` FROM `tb_shop_url` WHERE (`main` = 1) AND (`id_shop` = 1) LIMIT 1 0.3 1 /classes/shop/ShopUrl.php:253 SELECT SQL_NO_CACHE * FROM `tb_hook_module_exceptions` WHERE (`id_shop` IN (1)) 0.2 1 /classes/module/Module.php:3035 SELECT SQL_NO_CACHE `id_module` FROM `tb_module_shop` WHERE (`id_module` = 92) AND (`id_shop` = 1) LIMIT 1 0.2 1 /classes/module/Module.php:1508 SELECT SQL_NO_CACHE * FROM `tb_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_lang` a LEFT JOIN `tb_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 5) LIMIT 1 0.2 0 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_lang` a LEFT JOIN `tb_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE * FROM `tb_theme` a WHERE (a.`id_theme` = 2) LIMIT 1 0.2 1 /Adapter/Adapter_EntityMapper.php:80 SELECT SQL_NO_CACHE id_shop FROM `tb_employee_shop` WHERE `id_employee` = 1 0.2 1 /classes/ObjectModel.php:1733
  9. The following are my next findings: 1. i checked the database and found out that the following tables are responsible for the categories: tb_category tb_category_group tb_category_lang tb_category_product tb_category_shop 2. in the table tb_category_lang I have identified the strings for all categories. In it I can see the created test categories. 3. enable profiling for debug purposes and disable cache + CCC. 4. when trying to create a new category, profile interaction with category tables is detectable 5. when trying to create a new product, interaction with category tables is NOT available --> What? How does the form know which categories to display for selection?
  10. @AndyC I'm thankful for any hint/tip. No, not really. I also uninstalled the "related product module", anyhow still same problem persists
  11. any further ideas? or troubleshoot tips at least?
  12. Yes, of course. Tried different browsers, different pcs, deleted cache, STRG+F5, etc...
  13. Hi guys, I am facing the same problem as described in the first post. Is there any progress on the solution? The strange thing is that I have 2 domains with TB1.1.x installed, hosted on the same web server, same PHP version, similar modules installed, same theme version (2xpanda licenses), but on one domain the created categories are available after creation. On the other not, how is this possible.... Any troubleshooting tip is welcome. PS: I already asked Jonny (Panda support), but he thinks that it is not a theme problem.
  14. OK, thank you for feedback. I seemly have to update the module...grr
  15. can you change on your site the shipping costs and they are correctly shown after modification? PS: I changed the *.tpl files as recommended by Petr and the warning message does not popup anymore, but unfortunately the module himself is still not working correctly.
×
×
  • Create New...