- Posts: 8
- Thank you received: 0
Module to display products in a category
12 years 3 months ago #162055
by robulus
Module to display products in a category was created by robulus
-- url of the page with the problem -- :
dev.blacklight.com.au/mcatool
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 3.3.1
-- PHP version -- : 5.4.29
-- Browser(s) name and version -- : Chrome 35.0.1916.153 m
Hi, I am trying to set up a simple module to display all products in a category "New Products". Simply cannot get this to work. Have checked forum replies, and read this tutorial: www.hikashop.com/support/support/documen...splay-front-end.html all to no avail.
A number of issues I find very confusing: why I can't select the category "New Products" in a module, how the module is supposed to connect to menu items and / or HikaShop display modules.
Are there a series of clear step by step instructions anywhere to create a simple module that will display all the products in a given category anywhere? I've tried the tutorial above, and this doesn't display anything.
Link to menu item showing category:
dev.blacklight.com.au/mcatool/index.php/new-products
There is a published module set up for the right column that should be showing the same products, just cannot get it working.
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 3.3.1
-- PHP version -- : 5.4.29
-- Browser(s) name and version -- : Chrome 35.0.1916.153 m
Hi, I am trying to set up a simple module to display all products in a category "New Products". Simply cannot get this to work. Have checked forum replies, and read this tutorial: www.hikashop.com/support/support/documen...splay-front-end.html all to no avail.
A number of issues I find very confusing: why I can't select the category "New Products" in a module, how the module is supposed to connect to menu items and / or HikaShop display modules.
Are there a series of clear step by step instructions anywhere to create a simple module that will display all the products in a given category anywhere? I've tried the tutorial above, and this doesn't display anything.
Link to menu item showing category:
dev.blacklight.com.au/mcatool/index.php/new-products
There is a published module set up for the right column that should be showing the same products, just cannot get it working.
Please Log in or Create an account to join the conversation.
12 years 3 months ago - 12 years 3 months ago #162060
by robulus
Replied by robulus on topic Module products in a category - cant set category
OK so I have the module working, I just can't change the the 'Associated category' setting. I can select the category "New Products", but as soon as I hit save it reverts back to "product category". Any ideas?
Last edit: 12 years 3 months ago by robulus.
Please Log in or Create an account to join the conversation.
12 years 3 months ago #162066
by Xavier
Replied by Xavier on topic Module products in a category - cant set category
Hi,
Thanks to enable the Joomla debug mode and set the error reporting level to "Maximum".
This should display an error message which can help us to understand the issue.
Are you sure that your category tree is not broken ? Could you try to rebuild it by clicking on the "rebuild" button in the toolbar ?
Thanks to enable the Joomla debug mode and set the error reporting level to "Maximum".
This should display an error message which can help us to understand the issue.
Are you sure that your category tree is not broken ? Could you try to rebuild it by clicking on the "rebuild" button in the toolbar ?
Please Log in or Create an account to join the conversation.
12 years 2 months ago - 12 years 2 months ago #163340
by robulus
Replied by robulus on topic Module products in a category - cant set category
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.
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.
Code:
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\"}'
Last edit: 12 years 2 months ago by robulus.
Please Log in or Create an account to join the conversation.
12 years 2 months ago #163465
by nicolas
Replied by nicolas on topic Module products in a category - cant set category
Hi,
Looking at the debug data, it just seem that you didn't select another category in the category selection popup.
Can you make sure that you click on the + icon of the "use" column of the categories listing in the popup ? Normally, it should close the popup automatically and refresh the associated category with the one you just selected and then when you click save it will be saved in the database.
Looking at the debug data, it just seem that you didn't select another category in the category selection popup.
Can you make sure that you click on the + icon of the "use" column of the categories listing in the popup ? Normally, it should close the popup automatically and refresh the associated category with the one you just selected and then when you click save it will be saved in the database.
Please Log in or Create an account to join the conversation.
12 years 2 months ago #163474
by robulus
Replied by robulus on topic Module products in a category - cant set category
Thanks Nicolas,
The associated category is definitely set to "New Products" before I click the save button, but afterward it has reverted to "Product Category". Is it maybe a javascript issue? I've attached two screen shots just to be certain we are talking about the same field.
The associated category is definitely set to "New Products" before I click the save button, but afterward it has reverted to "Product Category". Is it maybe a javascript issue? I've attached two screen shots just to be certain we are talking about the same field.
Please Log in or Create an account to join the conversation.
12 years 2 months ago #163475
by robulus
Replied by robulus on topic Module products in a category - cant set category
I know this would be an awful hack, but just to get me out of a spot is there anywhere I can update this value directly in the database?
Please Log in or Create an account to join the conversation.
12 years 2 months ago #163547
by nicolas
Replied by nicolas on topic Module products in a category - cant set category
Hi,
Then you should have the same problem with any of the settings of the module, not just this one.
Do you have the problem with other options ?
This would indicate either a server configuration issue, or a user session glitch.
Please first try with another browser, maybe it will help.
Otherwise, change the same option in the configuration and create a new module. It should directly have the category from the main configuration.
Then you should have the same problem with any of the settings of the module, not just this one.
Do you have the problem with other options ?
This would indicate either a server configuration issue, or a user session glitch.
Please first try with another browser, maybe it will help.
Otherwise, change the same option in the configuration and create a new module. It should directly have the category from the main configuration.
Please Log in or Create an account to join the conversation.
12 years 2 months ago #163594
by robulus
Replied by robulus on topic Module products in a category - cant set category
Thanks for your help. I tried it in IE (have been using Chrome) and got the same error. I also tried changing the setting for "Display add to cart button" to inherit, and this worked fine. Can you just elaborate on what you mean by "change the same option in the configuration and create a new module. It should directly have the category from the main configuration", I'm not clear on how to do that.
Please Log in or Create an account to join the conversation.
12 years 2 months ago #163621
by Xavier
Replied by Xavier on topic Module products in a category - cant set category
Hi,
You have to set the desired category in Configuration > Display > Modules main default options, option "Associated category".
This way, when creating a new module, it will get the selected category in the main configuration by default.
You have to set the desired category in Configuration > Display > Modules main default options, option "Associated category".
This way, when creating a new module, it will get the selected category in the main configuration by default.
Please Log in or Create an account to join the conversation.
12 years 2 months ago #164353
by robulus
Replied by robulus on topic Module products in a category - cant set category
OK, that works! Bit of a cludge but gets me out of a spot. Thanks for your help.
Please Log in or Create an account to join the conversation.
Time to create page: 0.243 seconds