Module to display products in a category

  • Posts: 8
  • Thank you received: 0
11 years 2 months ago #162055

-- 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.

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
11 years 2 months ago #162060

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: 11 years 2 months ago by robulus.

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
11 years 2 months ago #162066

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 ?

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
11 years 2 months ago #163340

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\"}'

Attachments:
Last edit: 11 years 2 months ago by robulus.

Please Log in or Create an account to join the conversation.

  • Posts: 84300
  • Thank you received: 13697
  • MODERATOR
11 years 2 months ago #163465

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.

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
11 years 2 months ago #163474

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.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
11 years 2 months ago #163475

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.

  • Posts: 84300
  • Thank you received: 13697
  • MODERATOR
11 years 2 months ago #163547

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.

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
11 years 2 months ago #163594

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.

  • Posts: 13201
  • Thank you received: 2322
11 years 2 months ago #163621

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.

Please Log in or Create an account to join the conversation.

  • Posts: 8
  • Thank you received: 0
11 years 1 month ago #164353

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.083 seconds
Powered by Kunena Forum