Thanks for getting back to me Xavier, apologies for the delay in my response.
I rebuilt the category tree, but still was not able to set "New Products" as the category for the module.
No error messages were displayed, I've pasted the database queries below, does this help at all?
I've also attached a screen shot of the module settings, just in case I'm doing something dumb.
20 Queries Logged 23.0 ms
Query Time: 0.41 ms Query memory: 0.013 MB Memory before query: 0.834 MB Rows returned: 1
SELECT `data`
FROM `dtqok_session`
WHERE `session_id` = 'e0f65cd62d6507236a1c4ec6ef762bef'
Explain
Profile
Call Stack
Query Time: 1.99 ms After last query: 15.37 ms Query memory: 0.012 MB Memory before query: 1.166 MB Rows returned: 70
SELECT folder AS type, element AS name, params
FROM dtqok_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE dtqok_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 170 Using where; Using filesort
Profile
Call Stack
Query Time: 0.90 ms After last query: 33.46 ms Query memory: 0.021 MB Memory before query: 1.865 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM dtqok_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
Explain
Profile
Call Stack
Query Time: 3.79 ms After last query: 0.65 ms Query memory: 0.017 MB Memory before query: 1.872 MB
UPDATE `dtqok_extensions`
SET `params` = '{\"mediaversion\":\"2bddeab4ceef7896db05eb010ff6e5c9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Explain
Profile
Call Stack
Query Time: 0.89 ms After last query: 3.19 ms Query memory: 0.008 MB Memory before query: 1.957 MB Rows returned: 1
SELECT template, s.params
FROM dtqok_template_styles as s
LEFT JOIN dtqok_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = '1'
ORDER BY home
Explain
Profile
Call Stack
Query Time: 0.84 ms After last query: 5.32 ms Query memory: 0.013 MB Memory before query: 2.017 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM dtqok_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
Explain
Profile
Call Stack
Query Time: 0.99 ms After last query: 21.35 ms Query memory: 0.014 MB Memory before query: 2.314 MB Rows returned: 250
SELECT *
FROM dtqok_hikashop_config
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE dtqok_hikashop_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 250
Profile
Call Stack
Query Time: 1.91 ms After last query: 26.28 ms Query memory: 0.021 MB Memory before query: 3.462 MB
UPDATE `dtqok_modules`
SET `module`='mod_hikashop',`title`='New Products',`showtitle`='1',`published`='1'
WHERE `id`='160'
Explain
Profile
Call Stack
Query Time: 0.45 ms After last query: 1.01 ms Query memory: 0.020 MB Memory before query: 3.511 MB
REPLACE INTO dtqok_hikashop_config (config_namekey,config_value)
VALUES ('params_160','YTozOTp7czoxMjoiY29udGVudF90eXBlIjtzOjc6InByb2R1Y3QiO3M6MTE6ImxheW91dF90eXBlIjtzOjM6ImRpdiI7czo3OiJjb2x1bW5zIjtzOjE6IjEiO3M6NToibGltaXQiO3M6MjoiMTAiO3M6NjoicmFuZG9tIjtzOjE6IjAiO3M6OToib3JkZXJfZGlyIjtzOjM6IkFTQyI7czoxMToiZmlsdGVyX3R5cGUiO3M6MToiMCI7czoxOToic2VsZWN0cGFyZW50bGlzdGluZyI7czoxOiIyIjtzOjE5OiJjb250ZW50X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6NjoiaXRlbWlkIjtzOjM6IjI1NyI7czoxMzoicHJvZHVjdF9vcmRlciI7czo4OiJvcmRlcmluZyI7czoxOToicHJvZHVjdF9zeW5jaHJvbml6ZSI7czoxOiIwIjtzOjE1OiJyZWNlbnRseV92aWV3ZWQiO3M6MToiMCI7czoxMToiYWRkX3RvX2NhcnQiO3M6MToiMSI7czoyMDoibGlua190b19wcm9kdWN0X3BhZ2UiO3M6MToiMSI7czoxNzoic2hvd192b3RlX3Byb2R1Y3QiO3M6MToiMCI7czoxMDoic2hvd19wcmljZSI7czoxOiIxIjtzOjE3OiJzaG93X291dF9vZl9zdG9jayI7czoyOiItMSI7czoxNDoicHJpY2Vfd2l0aF90YXgiO3M6MToiMyI7czoxOToic2hvd19vcmlnaW5hbF9wcmljZSI7czoxOiIwIjtzOjEzOiJzaG93X2Rpc2NvdW50IjtzOjE6IjEiO3M6MTg6InByaWNlX2Rpc3BsYXlfdHlwZSI7czo4OiJjaGVhcGVzdCI7czoxNDoiZGlzcGxheV9iYWRnZXMiO3M6MToiMSI7czoxNDoiY2F0ZWdvcnlfb3JkZXIiO3M6NzoiaW5oZXJpdCI7czoxODoiY2hpbGRfZGlzcGxheV90eXBlIjtzOjc6ImluaGVyaXQiO3M6MTE6ImNoaWxkX2xpbWl0IjtzOjA6IiI7czoyNDoibGlua3Nfb25fbWFpbl9jYXRlZ29yaWVzIjtzOjI6Ii0xIjtzOjE4OiJudW1iZXJfb2ZfcHJvZHVjdHMiO3M6MjoiLTEiO3M6MTY6Im9ubHlfaWZfcHJvZHVjdHMiO3M6MjoiLTEiO3M6MTE6ImltYWdlX3dpZHRoIjtzOjA6IiI7czoxMjoiaW1hZ2VfaGVpZ2h0IjtzOjA6IiI7czoyMDoiZGl2X2l0ZW1fbGF5b3V0X3R5cGUiO3M6NzoiaW5oZXJpdCI7czoxMToicGFuZV9oZWlnaHQiO3M6MDoiIjtzOjE2OiJiYWNrZ3JvdW5kX2NvbG9yIjtzOjA6IiI7czo2OiJtYXJnaW4iO3M6MDoiIjtzOjE0OiJib3JkZXJfdmlzaWJsZSI7czoyOiItMSI7czoxNToicm91bmRlZF9jb3JuZXJzIjtzOjI6Ii0xIjtzOjExOiJ0ZXh0X2NlbnRlciI7czoyOiItMSI7czoxMzoidWxfY2xhc3NfbmFtZSI7czowOiIiO30=')
Explain
Profile
Call Stack
Query Time: 0.68 ms After last query: 35.00 ms Query memory: 0.024 MB Memory before query: 4.054 MB Rows returned: 1
SELECT *
FROM dtqok_modules
WHERE id = '160'
LIMIT 1
Explain
Profile
Call Stack
Query Time: 0.53 ms After last query: 0.53 ms Query memory: 0.025 MB Memory before query: 4.092 MB Rows returned: 1
SELECT *
FROM dtqok_hikashop_category
WHERE category_id = '2'
LIMIT 1
Explain
Profile
Call Stack
Query Time: 1.20 ms After last query: 21.66 ms Query memory: 0.022 MB Memory before query: 4.263 MB Rows returned: 49
SELECT a.title as name, a.id as itemid, b.title
FROM `dtqok_menu` as a
LEFT JOIN `dtqok_menu_types` as b
on a.menutype = b.menutype
WHERE a.client_id=0
ORDER BY b.title ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 49 Using temporary; Using filesort
1 SIMPLE b eq_ref idx_menutype idx_menutype 74 blackdev_mcatool.a.menutype 1
Profile
Call Stack
Query Time: 0.84 ms After last query: 17.91 ms Query memory: 0.027 MB Memory before query: 4.407 MB Rows returned: 1
SELECT *
FROM dtqok_hikashop_product
LIMIT 0, 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE dtqok_hikashop_product ALL NULL NO INDEX KEY COULD BE USED NULL NULL 83
Profile
Call Stack
Query Time: 0.42 ms After last query: 4.57 ms Query memory: 0.027 MB Memory before query: 4.507 MB Rows returned: 1
SELECT *
FROM dtqok_hikashop_category
LIMIT 0, 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE dtqok_hikashop_category ALL NULL NO INDEX KEY COULD BE USED NULL NULL 30
Profile
Call Stack
Query Time: 1.73 ms After last query: 11.94 ms Query memory: 0.014 MB Memory before query: 4.617 MB Rows returned: 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM dtqok_modules AS m
LEFT JOIN dtqok_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN dtqok_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2014-07-07 23:12:12')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-07-07 23:12:12')
AND m.access IN (1,1,2,3)
AND m.client_id = 1
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 20 Using where; Using filesort
1 SIMPLE mm ref PRIMARY PRIMARY 4 blackdev_mcatool.m.id 1 Using where; Using index
1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 blackdev_mcatool.m.module,const 1 Using where
Profile
Call Stack
Query Time: 0.74 ms After last query: 18.34 ms Query memory: 0.015 MB Memory before query: 4.708 MB Rows returned: 1
SELECT COUNT(*)
FROM dtqok_messages
WHERE state = 0
AND user_id_to = 894
Explain
Profile
Call Stack
Query Time: 0.46 ms After last query: 0.28 ms Query memory: 0.015 MB Memory before query: 4.726 MB Rows returned: 1
SELECT COUNT(session_id)
FROM dtqok_session
WHERE guest = 0
AND client_id = 1
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE dtqok_session ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where
Profile
Call Stack
Query Time: 0.45 ms After last query: 0.25 ms Query memory: 0.015 MB Memory before query: 4.742 MB Rows returned: 1
SELECT COUNT(session_id)
FROM dtqok_session
WHERE guest = 0
AND client_id = 0
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE dtqok_session ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where
Profile
Call Stack
Query Time: 1.58 ms After last query: 37.85 ms Query memory: 0.019 MB Memory before query: 4.911 MB Rows returned: 42
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM dtqok_menu AS m
LEFT JOIN dtqok_extensions AS e
ON m.component_id = e.extension_id
WHERE m.client_id = 1
AND e.enabled = 1
AND m.id > 1
ORDER BY m.lft
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ref PRIMARY,idx_client_id_parent_id_alias_language,idx_componentid idx_client_id_parent_id_alias_language 1 const 42 Using where; Using filesort
1 SIMPLE e eq_ref PRIMARY PRIMARY 4 blackdev_mcatool.m.component_id 1 Using where
Profile
Call Stack
Query Time: 2.17 ms After last query: 55.82 ms Query memory: 0.003 MB Memory before query: 5.138 MB
UPDATE `dtqok_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:22;s:19:\"session.timer.start\";i:1404774555;s:18:\"session.timer.last\";i:1404774713;s:17:\"session.timer.now\";i:1404774732;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:12:\"com_hikashop\";O:8:\"stdClass\":2:{s:8:\"category\";O:8:\"stdClass\":7:{s:9:\"filter_id\";s:7:\"product\";s:12:\"filter_order\";s:19:\"a.category_ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:10:\"limitstart\";i:0;s:6:\"search\";s:0:\"\";s:10:\"list_limit\";i:20;s:11:\"filter_type\";i:0;}s:15:\"category_parent\";O:8:\"stdClass\":1:{s:9:\"filter_id\";s:7:\"product\";}}s:11:\"com_modules\";O:8:\"stdClass\":2:{s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"894\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:7:\"aaaa\";s:5:\"email\";s:27:\"aaaa\";s:8:\"password\";s:60:\"aaaa";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-02-19 03:21:15\";s:13:\"lastvisitDate\";s:19:\"2014-06-27 03:31:16\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:2:\"{}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"cce78f97c634661d8bac5c539d3fa9df\";}'
, `time` = '1404774732'
WHERE `session_id` = 'e0f65cd62d6507236a1c4ec6ef762bef'
Explain
Profile
Call Stack
18 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM dtqok_extensions
2 × SELECT COUNT(session_id)
FROM dtqok_session
1 × SELECT *
FROM dtqok_hikashop_category
LIMIT 0,
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM dtqok_modules AS m
LEFT JOIN dtqok_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN dtqok_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT COUNT(*)
FROM dtqok_messages
1 × SELECT *
FROM dtqok_hikashop_product
LIMIT 0,
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
FROM dtqok_menu AS m
LEFT JOIN dtqok_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM dtqok_hikashop_category
1 × SELECT template, s.params
FROM dtqok_template_styles as s
LEFT JOIN dtqok_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
1 × SELECT folder AS type, element AS name, params
FROM dtqok_extensions
1 × SELECT *
FROM dtqok_hikashop_confi
1 × SELECT *
FROM dtqok_modules
1 × SELECT `data`
FROM `dtqok_session`
1 × SELECT a.title as name, a.id as itemid, b.title
FROM `dtqok_menu` as a
LEFT JOIN `dtqok_menu_types` as b
on a.menutype = b.menutype
OTHER Tables:
1 × UPDATE `dtqok_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:22;s:19:\"session.timer.start\";i:1404774555;s:18:\"session.timer.last\";i:1404774713;s:17:\"session.timer.now\";i:1404774732;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":4:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:12:\"com_hikashop\";O:8:\"stdClass\":2:{s:8:\"category\";O:8:\"stdClass\":7:{s:9:\"filter_id\";s:7:\"product\";s:12:\"filter_order\";s:19:\"a.category_ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:10:\"limitstart\";i:0;s:6:\"search\";s:0:\"\";s:10:\"list_limit\";i:20;s:11:\"filter_type\";i:0;}s:15:\"category_parent\";O:8:\"stdClass\":1:{s:9:\"filter_id\";s:7:\"product\";}}s:11:\"com_modules\";O:8:\"stdClass\":2:{s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}s:4:\"edit\";O:8:\"stdClass\":1:{s:6:\"module\";O:8:\"stdClass\":2:{s:2:\"id\";a:0:{}s:4:\"data\";N;}}}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"894\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:7:\"------\";s:5:\"email\";s:27:\"-------\";s:8:\"password\";s:60:\"--------\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-02-19 03:21:15\";s:13:\"lastvisitDate\";s:19:\"2014-06-27 03:31:16\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:2:\"{}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"cce78f97c634661d8bac5c539d3fa9df\";}' , `time` = '1404774732'
1 × REPLACE INTO dtqok_hikashop_config (config_namekey,config_value)
VALUES ('params_160','YTozOTp7czoxMjoiY29udGVudF90eXBlIjtzOjc6InByb2R1Y3QiO3M6MTE6ImxheW91dF90eXBlIjtzOjM6ImRpdiI7czo3OiJjb2x1bW5zIjtzOjE6IjEiO3M6NToibGltaXQiO3M6MjoiMTAiO3M6NjoicmFuZG9tIjtzOjE6IjAiO3M6OToib3JkZXJfZGlyIjtzOjM6IkFTQyI7czoxMToiZmlsdGVyX3R5cGUiO3M6MToiMCI7czoxOToic2VsZWN0cGFyZW50bGlzdGluZyI7czoxOiIyIjtzOjE5OiJjb250ZW50X3N5bmNocm9uaXplIjtzOjE6IjEiO3M6NjoiaXRlbWlkIjtzOjM6IjI1NyI7czoxMzoicHJvZHVjdF9vcmRlciI7czo4OiJvcmRlcmluZyI7czoxOToicHJvZHVjdF9zeW5jaHJvbml6ZSI7czoxOiIwIjtzOjE1OiJyZWNlbnRseV92aWV3ZWQiO3M6MToiMCI7czoxMToiYWRkX3RvX2NhcnQiO3M6MToiMSI7czoyMDoibGlua190b19wcm9kdWN0X3BhZ2UiO3M6MToiMSI7czoxNzoic2hvd192b3RlX3Byb2R1Y3QiO3M6MToiMCI7czoxMDoic2hvd19wcmljZSI7czoxOiIxIjtzOjE3OiJzaG93X291dF9vZl9zdG9jayI7czoyOiItMSI7czoxNDoicHJpY2Vfd2l0aF90YXgiO3M6MToiMyI7czoxOToic2hvd19vcmlnaW5hbF9wcmljZSI7czoxOiIwIjtzOjEzOiJzaG93X2Rpc2NvdW50IjtzOjE6IjEiO3M6MTg6InByaWNlX2Rpc3BsYXlfdHlwZSI7czo4OiJjaGVhcGVzdCI7czoxNDoiZGlzcGxheV9iYWRnZXMiO3M6MToiMSI7czoxNDoiY2F0ZWdvcnlfb3JkZXIiO3M6NzoiaW5oZXJpdCI7czoxODoiY2hpbGRfZGlzcGxheV90eXBlIjtzOjc6ImluaGVyaXQiO3M6MTE6ImNoaWxkX2xpbWl0IjtzOjA6IiI7czoyNDoibGlua3Nfb25fbWFpbl9jYXRlZ29yaWVzIjtzOjI6Ii0xIjtzOjE4OiJudW1iZXJfb2ZfcHJvZHVjdHMiO3M6MjoiLTEiO3M6MTY6Im9ubHlfaWZfcHJvZHVjdHMiO3M6MjoiLTEiO3M6MTE6ImltYWdlX3dpZHRoIjtzOjA6IiI7czoxMjoiaW1hZ2VfaGVpZ2h0IjtzOjA6IiI7czoyMDoiZGl2X2l0ZW1fbGF5b3V0X3R5cGUiO3M6NzoiaW5oZXJpdCI7czoxMToicGFuZV9oZWlnaHQiO3M6MDoiIjtzOjE2OiJiYWNrZ3JvdW5kX2NvbG9yIjtzOjA6IiI7czo2OiJtYXJnaW4iO3M6MDoiIjtzOjE0OiJib3JkZXJfdmlzaWJsZSI7czoyOiItMSI7czoxNToicm91bmRlZF9jb3JuZXJzIjtzOjI6Ii0xIjtzOjExOiJ0ZXh0X2NlbnRlciI7czoyOiItMSI7czoxMzoidWxfY2xhc3NfbmFtZSI7czowOiIiO30='
1 × UPDATE `dtqok_modules`
SET `module`='mod_hikashop',`title`='New Products',`showtitle`='1',`published`='1'
1 × UPDATE `dtqok_extensions`
SET `params` = '{\"mediaversion\":\"2bddeab4ceef7896db05eb010ff6e5c9\"}'