setUserState : currency_id has no effect

  • Posts: 57
  • Thank you received: 2
9 years 10 months ago #160186

Hi,

I have set the Currency with

$app->setUserState( HIKASHOP_COMPONENT.'.currency_id', 2 );//dollar

redirected and checked with

$currencyID = $app->getUserState( 'HIKASHOP_COMPONENT'.'.currency_id');

which returns the correct setting.
But the prices are still in the standard currency that has been set in the cofigurations.

Can you help?
(I have attached the database queries from the debug mode)

Cheers,
Ralf





-- HikaShop version -- : 2.1.3
-- Joomla version -- : 2.5
-- PHP version -- : x.x.x
-- Browser(s) name and version -- : safari 5.0.6
-- Error-message(debug-mod must be tuned on) -- : Error_message

SELECT `data` 
  FROM `pet25_session` 
  WHERE `session_id` = 'd86c9672aa182ee46049e071b879d3ff'
DELETE 
  FROM `pet25_session` 
  WHERE `time` < '1402736363'
SELECT folder AS type, element AS name, params 
  FROM pet25_extensions 
  WHERE enabled >= 1 
  AND type ='plugin' 
  AND state >= 0 
  AND access IN (1,1) 
  ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
SELECT `value` 
  FROM `pet25_admintools_storage` 
  WHERE `key` = 'cparams'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM pet25_menu AS m 
  LEFT JOIN pet25_extensions AS e 
  ON m.component_id = e.extension_id 
  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0 
  ORDER BY m.lft
SELECT id, home, template, s.params 
  FROM pet25_template_styles as s 
  LEFT JOIN pet25_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id 
  WHERE s.client_id = 0 
  AND e.enabled = 1
SELECT * 
  FROM pet25_hikashop_config
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_hikashop'
SELECT * 
  FROM pet25_languages 
  WHERE published=1 
  ORDER BY ordering ASC
SELECT a.* 
  FROM pet25_hikashop_cart AS a 
  WHERE (a.cart_id = 568) 
  AND a.cart_type = 'cart' 
  ORDER BY a.cart_modified DESC 
  LIMIT 1
SELECT b.*,c.* 
  FROM pet25_hikashop_cart_product AS b 
  LEFT JOIN pet25_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 568 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT currency_id 
  FROM pet25_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 1
SELECT b.*,c.* 
  FROM pet25_hikashop_cart_product AS b 
  LEFT JOIN pet25_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 568 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM pet25_hikashop_file 
  WHERE file_ref_id IN (587) 
  AND file_type IN( 'product','file') 
  ORDER BY file_ref_id ASC, file_ordering ASC
SELECT a.*,b.* 
  FROM pet25_hikashop_variant AS a 
  LEFT JOIN pet25_hikashop_characteristic AS b 
  ON a.variant_characteristic_id=b.characteristic_id 
  WHERE a.variant_product_id IN (587) 
  ORDER BY a.ordering,b.characteristic_value
SELECT * 
  FROM pet25_hikashop_price 
  WHERE price_currency_id IN (1,2) 
  AND price_product_id IN (587) 
  ORDER BY price_value DESC
SELECT * 
  FROM pet25_hikashop_currency 
  WHERE currency_id IN (2)
SELECT b.*,c.* 
  FROM pet25_hikashop_category AS a 
  LEFT JOIN pet25_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN pet25_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey 
  WHERE a.category_id = 11 
  AND b.taxation_published=1 
  AND taxation_type = ''
SELECT * 
  FROM pet25_hikashop_zone 
  WHERE zone_id = 81
SELECT * 
  FROM pet25_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND ( discount_quota>discount_used_times OR discount_quota=0 ) 
  AND discount_start < 1402739964 
  AND ( discount_end > 1402739964 OR discount_end = 0 ) 
  AND ( discount_product_id IN (587) OR discount_product_id=0 ) 
  AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT * 
  FROM pet25_hikashop_currency 
  WHERE currency_id IN (1)
SELECT * 
  FROM pet25_hikashop_file 
  WHERE file_ref_id IN (587) 
  AND file_type='product' 
  ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
SELECT category_id, product_id 
  FROM pet25_hikashop_product_category 
  WHERE product_id IN (587);
SELECT count(*) 
  FROM pet25_hikashop_limit AS a 
  WHERE (a.limit_published = 1 
  AND (limit_start = 0 OR limit_start >= 1402739964) 
  AND (limit_end = 0 OR limit_end <= 1402739964) 
  AND (a.limit_product_id IN (587) OR limit_category_id IN (37)))
SELECT b.*,c.* 
  FROM pet25_hikashop_cart_product AS b 
  LEFT JOIN pet25_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 568 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM pet25_hikashop_discount 
  WHERE discount_type='coupon' 
  AND discount_published=1 
  AND discount_auto_load=1 
  ORDER BY discount_minimum_order DESC, discount_minimum_products DESC
SELECT * 
  FROM pet25_hikashop_shipping 
  ORDER BY shipping_ordering ASC
SELECT b.*,c.* 
  FROM pet25_hikashop_cart_product AS b 
  LEFT JOIN pet25_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 568 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM pet25_hikashop_file 
  WHERE file_ref_id IN (587) 
  AND file_type IN( 'product','file') 
  ORDER BY file_ref_id ASC, file_ordering ASC
SELECT a.*,b.* 
  FROM pet25_hikashop_variant AS a 
  LEFT JOIN pet25_hikashop_characteristic AS b 
  ON a.variant_characteristic_id=b.characteristic_id 
  WHERE a.variant_product_id IN (587) 
  ORDER BY a.ordering,b.characteristic_value
SELECT * 
  FROM pet25_hikashop_price 
  WHERE price_currency_id IN (1,2) 
  AND price_product_id IN (587) 
  ORDER BY price_value DESC
SELECT * 
  FROM pet25_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND ( discount_quota>discount_used_times OR discount_quota=0 ) 
  AND discount_start < 1402739964 
  AND ( discount_end > 1402739964 OR discount_end = 0 ) 
  AND ( discount_product_id IN (587) OR discount_product_id=0 ) 
  AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT * 
  FROM pet25_hikashop_file 
  WHERE file_ref_id IN (587) 
  AND file_type='product' 
  ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
SELECT category_id, product_id 
  FROM pet25_hikashop_product_category 
  WHERE product_id IN (587);
SELECT count(*) 
  FROM pet25_hikashop_limit AS a 
  WHERE (a.limit_published = 1 
  AND (limit_start = 0 OR limit_start >= 1402739964) 
  AND (limit_end = 0 OR limit_end <= 1402739964) 
  AND (a.limit_product_id IN (587) OR limit_category_id IN (37)))
SELECT b.*,c.* 
  FROM pet25_hikashop_cart_product AS b 
  LEFT JOIN pet25_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 568 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM pet25_hikashop_discount 
  WHERE discount_type='coupon' 
  AND discount_published=1 
  AND discount_auto_load=1 
  ORDER BY discount_minimum_order DESC, discount_minimum_products DESC
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM pet25_modules AS m 
  LEFT JOIN pet25_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN pet25_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-06-14 09:59:24') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-06-14 09:59:24') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 254 OR mm.menuid <= 0) 
  ORDER BY m.position, m.ordering
select parent_id, menutype, ordering 
  from pet25_menu 
  where id = 254 
  limit 1
select parent_id, menutype, ordering 
  from pet25_menu 
  where id = 1 
  limit 1
SELECT count(*) 
  FROM pet25_menu AS m 
  WHERE menutype='' 
  AND published=1 
  AND parent_id=0 
  and ordering < 0 
  AND access <= '0'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_contact'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_content'
SELECT b.*,c.* 
  FROM pet25_hikashop_cart_product AS b 
  LEFT JOIN pet25_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 568 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT b.*,c.* 
  FROM pet25_hikashop_cart_product AS b 
  LEFT JOIN pet25_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 568 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM pet25_hikashop_file 
  WHERE file_ref_id IN (587) 
  AND file_type IN( 'product','file') 
  ORDER BY file_ref_id ASC, file_ordering ASC
SELECT a.*,b.* 
  FROM pet25_hikashop_variant AS a 
  LEFT JOIN pet25_hikashop_characteristic AS b 
  ON a.variant_characteristic_id=b.characteristic_id 
  WHERE a.variant_product_id IN (587) 
  ORDER BY a.ordering,b.characteristic_value
SELECT * 
  FROM pet25_hikashop_price 
  WHERE price_currency_id IN (1,2) 
  AND price_product_id IN (587) 
  ORDER BY price_value DESC
SELECT * 
  FROM pet25_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND ( discount_quota>discount_used_times OR discount_quota=0 ) 
  AND discount_start < 1402739964 
  AND ( discount_end > 1402739964 OR discount_end = 0 ) 
  AND ( discount_product_id IN (587) OR discount_product_id=0 ) 
  AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT * 
  FROM pet25_hikashop_file 
  WHERE file_ref_id IN (587) 
  AND file_type='product' 
  ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
SELECT category_id, product_id 
  FROM pet25_hikashop_product_category 
  WHERE product_id IN (587);
SELECT count(*) 
  FROM pet25_hikashop_limit AS a 
  WHERE (a.limit_published = 1 
  AND (limit_start = 0 OR limit_start >= 1402739964) 
  AND (limit_end = 0 OR limit_end <= 1402739964) 
  AND (a.limit_product_id IN (587) OR limit_category_id IN (37)))
SELECT b.*,c.* 
  FROM pet25_hikashop_cart_product AS b 
  LEFT JOIN pet25_hikashop_product AS c 
  ON b.product_id=c.product_id 
  WHERE b.cart_id = 568 
  AND b.product_id > 0 
  ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT * 
  FROM pet25_hikashop_discount 
  WHERE discount_type='coupon' 
  AND discount_published=1 
  AND discount_auto_load=1 
  ORDER BY discount_minimum_order DESC, discount_minimum_products DESC
SELECT * 
  FROM pet25_modules 
  WHERE published=1 
  ORDER BY id ;
UPDATE `pet25_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:15;s:19:\"session.timer.start\";i:1402737960;s:18:\"session.timer.last\";i:1402739947;s:17:\"session.timer.now\";i:1402739963;s:22:\"session.client.browser\";s:115:\"Mozilla/5.0 (Macintosh; PPC Mac OS X 10_5_8) AppleWebKit/534.50.2 (KHTML, like Gecko) Version/5.0.6 Safari/533.22.3\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"com_hikashop\";O:8:\"stdClass\":10:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:2:\"81\";s:7:\"cart_id\";i:568;s:15:\"shipping_method\";s:0:\"\";s:11:\"shipping_id\";s:0:\"\";s:13:\"shipping_data\";s:0:\"\";s:8:\"cart_new\";s:1:\"1\";s:14:\"payment_method\";s:6:\"paypal\";s:10:\"payment_id\";s:1:\"2\";s:12:\"payment_data\";O:8:\"stdClass\":29:{s:10:\"payment_id\";s:1:\"2\";s:12:\"payment_name\";s:6:\"PayPal\";s:19:\"payment_description\";s:112:\"You can pay by credit card <strong>(paypal account is not required)</strong> or directly by your paypal account.\";s:14:\"payment_images\";s:16:\"de-pp-logo-100px\";s:14:\"payment_params\";O:8:\"stdClass\":19:{s:16:\"payment_currency\";s:1:\"1\";s:18:\"payment_percentage\";s:1:\"0\";s:3:\"url\";s:44:\"https://www.sandbox.paypal.com/cgi-bin/websc\";s:5:\"email\";s:18:\"paypal@buntype.com\";s:12:\"address_type\";s:7:\"billing\";s:16:\"address_override\";s:1:\"1\";s:11:\"no_shipping\";s:1:\"1\";s:12:\"notification\";s:1:\"1\";s:7:\"details\";s:1:\"0\";s:10:\"validation\";s:1:\"0\";s:5:\"debug\";s:1:\"1\";s:10:\"cancel_url\";s:0:\"\";s:10:\"return_url\";s:0:\"\";s:16:\"cpp_header_image\";s:0:\"\";s:3:\"ips\";a:3:{i:0;s:11:\"23.43.114.*\";i:1;s:10:\"173.0.81.*\";i:2;s:10:\"173.0.82.*\";}s:14:\"invalid_status\";s:0:\"\";s:14:\"pending_status\";s:7:\"created\";s:15:\"verified_status\";s:9:\"confirmed\";s:2:\"rm\";s:1:\"1\";}s:12:\"payment_type\";s:6:\"paypal\";s:20:\"payment_zone_namekey\";s:18:\"country_Germany_81\";s:14:\"payment_access\";s:3:\"all\";s:24:\"payment_shipping_methods\";s:8:\"manual_1\";s:16:\"payment_currency\";s:5:\",1,2,\";s:13:\"payment_price\";d:0;s:12:\"extension_id\";s:5:\"10168\";s:4:\"name\";s:30:\"Hikashop Paypal Payment Plugin\";s:4:\"type\";s:6:\"plugin\";s:7:\"element\";s:6:\"paypal\";s:6:\"folder\";s:15:\"hikashoppayment\";s:9:\"client_id\";s:1:\"0\";s:7:\"enabled\";s:1:\"1\";s:6:\"access\";s:1:\"1\";s:9:\"protected\";s:1:\"0\";s:14:\"manifest_cache\";s:375:\"{\"legacy\":false,\"name\":\"Hikashop Paypal Payment Plugin\",\"type\":\"plugin\",\"creationDate\":\"April 2010\",\"author\":\"Hikashop\",\"copyright\":\"Copyright (C) 2010 HIKARI SOFTWARE SARL - All rights reserved.\",\"authorEmail\":\"dev@hikashop.com\",\"authorUrl\":\"http:\\/\\/www.hikashop.com\",\"version\":\"1.0.0\",\"description\":\"This plugin enables you to setup your paypal payment system\",\"
  group\":\"\"}\";s:6:\"params\";s:0:\"\";s:11:\"custom_data\";s:0:\"\";s:11:\"system_data\";s:0:\"\";s:11:\"checked_out\";s:2:\"75\";s:16:\"checked_out_time\";s:19:\"2013-06-01 13:34:12\";s:8:\"ordering\";i:2;s:5:\"state\";s:1:\"0\";s:5:\"total\";O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":6:{s:11:\"price_value\";d:198;s:20:\"price_value_with_tax\";d:198;s:17:\"price_currency_id\";i:1;s:5:\"taxes\";a:0:{}s:27:\"price_value_without_payment\";d:198;s:36:\"price_value_without_payment_with_tax\";d:198;}}}}}s:18:\"HIKASHOP_COMPONENT\";O:8:\"stdClass\":1:{s:11:\"currency_id\";i:2;}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"82e1b7f2cbb299c5be45c5205a84375b\";}hikashop_new_itemid|s:0:\"\";' , `time` = '1402739964' 
  WHERE `session_id` = 'd86c9672aa182ee46049e071b879d3ff'
27 QUERY TYPES LOGGED, SORTED BY OCCURRENCES.
SELECT TABLES:
8 × SELECT b.*,c.* 
  FROM pet25_hikashop_cart_product AS b 
  LEFT JOIN pet25_hikashop_product AS c 
  ON b.product_id=c.product_id
6 × SELECT * 
  FROM pet25_hikashop_discount
6 × SELECT * 
  FROM pet25_hikashop_file
4 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions
3 × SELECT * 
  FROM pet25_hikashop_price
3 × SELECT category_id, product_id 
  FROM pet25_hikashop_product_category
3 × SELECT count(*) 
  FROM pet25_hikashop_limit AS a
3 × SELECT a.*,b.* 
  FROM pet25_hikashop_variant AS a 
  LEFT JOIN pet25_hikashop_characteristic AS b 
  ON a.variant_characteristic_id=b.characteristic_id
2 × SELECT * 
  FROM pet25_hikashop_currency
2 × select parent_id, menutype, ordering 
  from pet25_menu
1 × SELECT folder AS type, element AS name, params 
  FROM pet25_extensions
1 × SELECT `value` 
  FROM `pet25_admintools_storage`
1 × SELECT * 
  FROM pet25_hikashop_shipping
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM pet25_modules AS m 
  LEFT JOIN pet25_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN pet25_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT * 
  FROM pet25_modules
1 × SELECT count(*) 
  FROM pet25_menu AS m
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM pet25_menu AS m 
  LEFT JOIN pet25_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT * 
  FROM pet25_hikashop_zone
1 × SELECT currency_id 
  FROM pet25_hikashop_currency
1 × SELECT * 
  FROM pet25_languages
1 × SELECT * 
  FROM pet25_hikashop_confi
1 × SELECT `data` 
  FROM `pet25_session`
1 × SELECT b.*,c.* 
  FROM pet25_hikashop_category AS a 
  LEFT JOIN pet25_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN pet25_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey
1 × SELECT id, home, template, s.params 
  FROM pet25_template_styles as s 
  LEFT JOIN pet25_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id
1 × SELECT a.* 
  FROM pet25_hikashop_cart AS a
OTHER TABLES:
1 × UPDATE `pet25_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:15;s:19:\"session.timer.start\";i:1402737960;s:18:\"session.timer.last\";i:1402739947;s:17:\"session.timer.now\";i:1402739963;s:22:\"session.client.browser\";s:115:\"Mozilla/5.0 (Macintosh; PPC Mac OS X 10_5_8) AppleWebKit/534.50.2 (KHTML, like Gecko) Version/5.0.6 Safari/533.22.3\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"com_hikashop\";O:8:\"stdClass\":10:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:2:\"81\";s:7:\"cart_id\";i:568;s:15:\"shipping_method\";s:0:\"\";s:11:\"shipping_id\";s:0:\"\";s:13:\"shipping_data\";s:0:\"\";s:8:\"cart_new\";s:1:\"1\";s:14:\"payment_method\";s:6:\"paypal\";s:10:\"payment_id\";s:1:\"2\";s:12:\"payment_data\";O:8:\"stdClass\":29:{s:10:\"payment_id\";s:1:\"2\";s:12:\"payment_name\";s:6:\"PayPal\";s:19:\"payment_description\";s:112:\"You can pay by credit card <strong>(paypal account is not required)</strong> or directly by your paypal account.\";s:14:\"payment_images\";s:16:\"de-pp-logo-100px\";s:14:\"payment_params\";O:8:\"stdClass\":19:{s:16:\"payment_currency\";s:1:\"1\";s:18:\"payment_percentage\";s:1:\"0\";s:3:\"url\";s:44:\"https://www.sandbox.paypal.com/cgi-bin/websc\";s:5:\"email\";s:18:\"paypal@buntype.com\";s:12:\"address_type\";s:7:\"billing\";s:16:\"address_override\";s:1:\"1\";s:11:\"no_shipping\";s:1:\"1\";s:12:\"notification\";s:1:\"1\";s:7:\"details\";s:1:\"0\";s:10:\"validation\";s:1:\"0\";s:5:\"debug\";s:1:\"1\";s:10:\"cancel_url\";s:0:\"\";s:10:\"return_url\";s:0:\"\";s:16:\"cpp_header_image\";s:0:\"\";s:3:\"ips\";a:3:{i:0;s:11:\"23.43.114.*\";i:1;s:10:\"173.0.81.*\";i:2;s:10:\"173.0.82.*\";}s:14:\"invalid_status\";s:0:\"\";s:14:\"pending_status\";s:7:\"created\";s:15:\"verified_status\";s:9:\"confirmed\";s:2:\"rm\";s:1:\"1\";}s:12:\"payment_type\";s:6:\"paypal\";s:20:\"payment_zone_namekey\";s:18:\"country_Germany_81\";s:14:\"payment_access\";s:3:\"all\";s:24:\"payment_shipping_methods\";s:8:\"manual_1\";s:16:\"payment_currency\";s:5:\",1,2,\";s:13:\"payment_price\";d:0;s:12:\"extension_id\";s:5:\"10168\";s:4:\"name\";s:30:\"Hikashop Paypal Payment Plugin\";s:4:\"type\";s:6:\"plugin\";s:7:\"element\";s:6:\"paypal\";s:6:\"folder\";s:15:\"hikashoppayment\";s:9:\"client_id\";s:1:\"0\";s:7:\"enabled\";s:1:\"1\";s:6:\"access\";s:1:\"1\";s:9:\"protected\";s:1:\"0\";s:14:\"manifest_cache\";s:375:\"{\"legacy\":false,\"name\":\"Hikashop Paypal Payment Plugin\",\"type\":\"plugin\",\"creationDate\":\"April 2010\",\"author\":\"Hikashop\",\"copyright\":\"Copyright (C) 2010 HIKARI SOFTWARE SARL - All rights reserved.\",\"authorEmail\":\"dev@hikashop.com\",\"authorUrl\":\"http:\\/\\/www.hikashop.com\",\"version\":\"1.0.0\",\"description\":\"This plugin enables you to setup your paypal payment system\",\"
  group\":\"\"}\";s:6:\"params\";s:0:\"\";s:11:\"custom_data\";s:0:\"\";s:11:\"system_data\";s:0:\"\";s:11:\"checked_out\";s:2:\"75\";s:16:\"checked_out_time\";s:19:\"2013-06-01 13:34:12\";s:8:\"ordering\";i:2;s:5:\"state\";s:1:\"0\";s:5:\"total\";O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":6:{s:11:\"price_value\";d:198;s:20:\"price_value_with_tax\";d:198;s:17:\"price_currency_id\";i:1;s:5:\"taxes\";a:0:{}s:27:\"price_value_without_payment\";d:198;s:36:\"price_value_without_payment_with_tax\";d:198;}}}}}s:18:\"HIKASHOP_COMPONENT\";O:8:\"stdClass\":1:{s:11:\"currency_id\";i:2;}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"82e1b7f2cbb299c5be45c5205a84375b\";}hikashop_new_itemid|s:0:\"\";' , `time` = '1402739964'
1 × DELETE 
  FROM `pet25_session`

Last edit: 9 years 10 months ago by nicolas.

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

  • Posts: 81515
  • Thank you received: 13068
  • MODERATOR
9 years 10 months ago #160294

Hi,

As far as I know, this should definitely work.
Looking at the queries I don't see any problem either.

It's the same method we use for the currency switcher module of HikaShop. Does it work on your website ?

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

  • Posts: 57
  • Thank you received: 2
9 years 10 months ago #160412

Hi,

yes, the switcher works.
I found out, that the code works on pages only where my products are listed, but not on the other pages. This is also true for my minicart module. But I can't find any option for that...
(the currency switcher is working on any page)
Any hint?

Cheers,
Ralf

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

  • Posts: 26000
  • Thank you received: 4004
  • MODERATOR
9 years 10 months ago #160421

Hi,

If HIKASHOP_COMPONENT is not defined, it could explain why.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 57
  • Thank you received: 2
9 years 10 months ago #160517

Ok, but how can I fix it. Maybe simple, but I have not the slightest idea. Please Help.

Cheers,
Ralf

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

  • Posts: 81515
  • Thank you received: 13068
  • MODERATOR
9 years 10 months ago #160586

Replace the text HIKASHOP_COMPONENT with 'com_hikashop' and it will work even if HIKASHOP_COMPONENT is not defined.

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

  • Posts: 57
  • Thank you received: 2
9 years 10 months ago #160717

Thanks, the currency switch is now working.

But I am still missing the Hikashop Cart Module. The Hikashop currency switcher module is loaded on every page. But the Hikashop Cart Module only on pages with product listing or on checkout...
Modul Assignment is set to "On all pages"
Any hints?

Cheers,
Ralf

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

  • Posts: 81515
  • Thank you received: 13068
  • MODERATOR
9 years 10 months ago #160837

I've never seen that so I don't know.
If a module is set to display on all pages it should display on all pages.

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

  • Posts: 57
  • Thank you received: 2
9 years 10 months ago #160946

Must be something in the template. Other Templates work. But what kind of code could prevent only the Hikashop cart module from showing? Any Ideas?

Cheers
Ralf

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

  • Posts: 57
  • Thank you received: 2
9 years 10 months ago #160947

Addendum:
I have disabled all direct calls to the hikashop component.

Cheers
Ralf

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

  • Posts: 81515
  • Thank you received: 13068
  • MODERATOR
9 years 10 months ago #160963

Try to create a new instance of the cart module via the Joomla modules manager and see if that helps.
Also, try to turn on the "debug mode" and "error reporting" options of the configuration of Joomla and see if you get any error coming from the module on pages where it is not displayed.

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

  • Posts: 57
  • Thank you received: 2
9 years 10 months ago #161109

I have tried many new instances and several module positions. Everytime the same behaviour.
There are no errors and the database query calls the cart in the same way as on the pages where it appears.
The strange thing is, that it the module appears on my product pages (even if there are no products to be shown.)
I have disabled most of the code on the not working template, only some calls to application and document classes can't be removed. But no success. Strange again, that all other Hika modules appear always.

Is it possible that the code of the card has been corrupted. Can you tell me, wher I can find it to replace?

Cheers, Ralf

here is the querie of a page, where the module does not appear:

SELECT `data` 
  FROM `pet25_session` 
  WHERE `session_id` = '7d255246c764a9fb27d2c22cc9cb2c67'
DELETE 
  FROM `pet25_session` 
  WHERE `time` < '1403254525'
SELECT folder AS type, element AS name, params 
  FROM pet25_extensions 
  WHERE enabled >= 1 
  AND type ='plugin' 
  AND state >= 0 
  AND access IN (1,1) 
  ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
SELECT `value` 
  FROM `pet25_admintools_storage` 
  WHERE `key` = 'cparams'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM pet25_menu AS m 
  LEFT JOIN pet25_extensions AS e 
  ON m.component_id = e.extension_id 
  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0 
  ORDER BY m.lft
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_content'
SELECT * 
  FROM pet25_languages 
  WHERE published=1 
  ORDER BY ordering ASC
SELECT id, home, template, s.params 
  FROM pet25_template_styles as s 
  LEFT JOIN pet25_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id 
  WHERE s.client_id = 0 
  AND e.enabled = 1
SELECT b.rules 
  FROM pet25_assets AS a 
  LEFT JOIN pet25_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt 
  WHERE (a.name = 'com_content' OR a.parent_id=0) 
  GROUP BY b.id, b.rules, b.lft 
  ORDER BY b.lft
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_users'
SELECT b.id 
  FROM pet25_usergroups AS a 
  LEFT JOIN pet25_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt 
  WHERE a.id = 1
SELECT c.*, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM pet25_categories as c 
  LEFT JOIN pet25_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN (SELECT cat.id as id 
  FROM pet25_categories AS cat JOIN pet25_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id 
  LEFT JOIN `pet25_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1 
  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=7 
  AND badcats.id is null 
  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id 
  ORDER BY c.lft
SELECT b.rules 
  FROM pet25_assets AS a 
  LEFT JOIN pet25_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt 
  WHERE (a.name = 'com_content.category.7' OR a.parent_id=0) 
  GROUP BY b.id, b.rules, b.lft 
  ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM pet25_content AS a 
  LEFT JOIN pet25_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN pet25_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN pet25_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN pet25_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language 
  FROM pet25_contact_details AS contact 
  WHERE contact.published = 1 
  GROUP BY contact.user_id, contact.language) AS contact 
  ON contact.user_id = a.created_by 
  LEFT JOIN pet25_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pet25_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM pet25_categories AS cat JOIN pet25_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id 
  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.catid = 7 OR a.catid IN ( SELECT sub.id 
  FROM pet25_categories as sub 
  INNER JOIN pet25_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt 
  WHERE this.id = 7 
  AND sub.level <= this.level + 5)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-06-20 09:55:25') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-06-20 09:55:25') 
  GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls 
  ORDER BY c.lft, 
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created 
  LIMIT 0, 3
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM pet25_content AS a 
  LEFT JOIN pet25_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN pet25_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN pet25_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN pet25_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language 
  FROM pet25_contact_details AS contact 
  WHERE contact.published = 1 
  GROUP BY contact.user_id, contact.language) AS contact 
  ON contact.user_id = a.created_by 
  LEFT JOIN pet25_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pet25_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM pet25_categories AS cat JOIN pet25_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id 
  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.catid = 7 OR a.catid IN ( SELECT sub.id 
  FROM pet25_categories as sub 
  INNER JOIN pet25_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt 
  WHERE this.id = 7 
  AND sub.level <= this.level + 5)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-06-20 09:55:25') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-06-20 09:55:25') 
  GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls 
  ORDER BY c.lft, 
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.created
SELECT c.*, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM pet25_categories as c 
  LEFT JOIN pet25_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN (SELECT cat.id as id 
  FROM pet25_categories AS cat JOIN pet25_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id 
  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=7 
  AND badcats.id is null 
  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id 
  ORDER BY c.lft
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM pet25_modules AS m 
  LEFT JOIN pet25_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN pet25_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-06-20 09:55:25') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-06-20 09:55:25') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 132 OR mm.menuid <= 0) 
  ORDER BY m.position, m.ordering
select parent_id, menutype, ordering 
  from pet25_menu 
  where id = 132 
  limit 1
select parent_id, menutype, ordering 
  from pet25_menu 
  where id = 42 
  limit 1
select parent_id, menutype, ordering 
  from pet25_menu 
  where id = 1 
  limit 1
SELECT count(*) 
  FROM pet25_menu AS m 
  WHERE menutype='' 
  AND published=1 
  AND parent_id=0 
  and ordering < 0 
  AND access <= '0'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_contact'
SELECT * 
  FROM pet25_modules 
  WHERE published=1 
  ORDER BY id ;
SELECT * 
  FROM pet25_hikashop_config
SELECT currency_id 
  FROM pet25_hikashop_currency 
  WHERE currency_id = 2 
  AND ( currency_published=1 OR currency_displayed=1 )
SELECT a.* 
  FROM pet25_hikashop_cart AS a 
  WHERE (a.session_id = '7d255246c764a9fb27d2c22cc9cb2c67') 
  AND a.cart_type = 'cart' 
  ORDER BY a.cart_modified DESC 
  LIMIT 1
SELECT currency_id 
  FROM pet25_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 1
UPDATE `pet25_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:41;s:19:\"session.timer.start\";i:1403253898;s:18:\"session.timer.last\";i:1403257725;s:17:\"session.timer.now\";i:1403258125;s:22:\"session.client.browser\";s:115:\"Mozilla/5.0 (Macintosh; PPC Mac OS X 10_5_8) AppleWebKit/534.50.2 (KHTML, like Gecko) Version/5.0.6 Safari/533.22.3\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"com_hikashop\";O:8:\"stdClass\":3:{s:11:\"currency_id\";i:2;s:7:\"zone_id\";s:2:\"81\";s:12:\"ssl_redirect\";i:0;}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4c37eca0a9f72f8b17139c838c926382\";s:16:\"com_mailto.links\";a:1:{s:40:\"e1531c6d367573e717a7b7a003fbdca368da1377\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://localhost:8888/service/news/buntype-com-beta.html\";s:6:\"expiry\";i:1403258126;}}}__easycalccheck|a:12:{s:12:\"hidden_class\";s:7:\"r0h1ecs\";s:12:\"hidden_field\";s:8:\"kc1s6a8r\";s:18:\"hidden_field_label\";s:11:\"piayyml6039\";s:19:\"jform[contact_name]\";s:10:\"nzud0qx0zr\";s:20:\"jform[contact_email]\";s:11:\"knpqsq61r9o\";s:22:\"jform[contact_subject]\";s:11:\"cgacm2uwhj9\";s:22:\"jform[contact_message]\";s:10:\"fva8khf2uf\";s:9:\"spamcheck\";s:12:\"fr6sbizm6vsj\";s:5:\"rot13\";i:1;s:15:\"spamcheckresult\";s:4:\"ZmZ=\";s:4:\"time\";i:1403256251;s:2:\"ip\";s:3:\"::1\";}' , `time` = '1403258126' 
  WHERE `session_id` = '7d255246c764a9fb27d2c22cc9cb2c67'
21 QUERY TYPES LOGGED, SORTED BY OCCURRENCES.
SELECT TABLES:
4 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM pet25_extensions
3 × select parent_id, menutype, ordering 
  from pet25_menu
2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM pet25_content AS a 
  LEFT JOIN pet25_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN pet25_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN pet25_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN pet25_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language 
  FROM pet25_contact_details AS contact
2 × SELECT currency_id 
  FROM pet25_hikashop_currency
2 × SELECT b.rules 
  FROM pet25_assets AS a 
  LEFT JOIN pet25_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM pet25_modules AS m 
  LEFT JOIN pet25_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN pet25_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT * 
  FROM pet25_modules
1 × SELECT a.* 
  FROM pet25_hikashop_cart AS a
1 × SELECT * 
  FROM pet25_hikashop_confi
1 × SELECT c.*, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM pet25_categories as c 
  LEFT JOIN pet25_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN (SELECT cat.id as id 
  FROM pet25_categories AS cat JOIN pet25_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt
1 × SELECT count(*) 
  FROM pet25_menu AS m
1 × SELECT c.*, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  FROM pet25_categories as c 
  LEFT JOIN pet25_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN (SELECT cat.id as id 
  FROM pet25_categories AS cat JOIN pet25_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt
1 × SELECT `value` 
  FROM `pet25_admintools_storage`
1 × SELECT folder AS type, element AS name, params 
  FROM pet25_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM pet25_menu AS m 
  LEFT JOIN pet25_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT * 
  FROM pet25_languages
1 × SELECT b.id 
  FROM pet25_usergroups AS a 
  LEFT JOIN pet25_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt
1 × SELECT id, home, template, s.params 
  FROM pet25_template_styles as s 
  LEFT JOIN pet25_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id
1 × SELECT `data` 
  FROM `pet25_session`
OTHER TABLES:
1 × UPDATE `pet25_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:41;s:19:\"session.timer.start\";i:1403253898;s:18:\"session.timer.last\";i:1403257725;s:17:\"session.timer.now\";i:1403258125;s:22:\"session.client.browser\";s:115:\"Mozilla/5.0 (Macintosh; PPC Mac OS X 10_5_8) AppleWebKit/534.50.2 (KHTML, like Gecko) Version/5.0.6 Safari/533.22.3\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:12:\"com_hikashop\";O:8:\"stdClass\":3:{s:11:\"currency_id\";i:2;s:7:\"zone_id\";s:2:\"81\";s:12:\"ssl_redirect\";i:0;}s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":1:{s:4:\"data\";a:1:{s:6:\"return\";s:39:\"index.php?option=com_users&view=profile\";}}}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"4c37eca0a9f72f8b17139c838c926382\";s:16:\"com_mailto.links\";a:1:{s:40:\"e1531c6d367573e717a7b7a003fbdca368da1377\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://localhost:8888/service/news/buntype-com-beta.html\";s:6:\"expiry\";i:1403258126;}}}__easycalccheck|a:12:{s:12:\"hidden_class\";s:7:\"r0h1ecs\";s:12:\"hidden_field\";s:8:\"kc1s6a8r\";s:18:\"hidden_field_label\";s:11:\"piayyml6039\";s:19:\"jform[contact_name]\";s:10:\"nzud0qx0zr\";s:20:\"jform[contact_email]\";s:11:\"knpqsq61r9o\";s:22:\"jform[contact_subject]\";s:11:\"cgacm2uwhj9\";s:22:\"jform[contact_message]\";s:10:\"fva8khf2uf\";s:9:\"spamcheck\";s:12:\"fr6sbizm6vsj\";s:5:\"rot13\";i:1;s:15:\"spamcheckresult\";s:4:\"ZmZ=\";s:4:\"time\";i:1403256251;s:2:\"ip\";s:3:\"::1\";}' , `time` = '1403258126'
1 × DELETE 
  FROM `pet25_session`

Last edit: 9 years 9 months ago by Xavier. Reason: Thanks to use [code] [/code] tags

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

  • Posts: 26000
  • Thank you received: 4004
  • MODERATOR
9 years 7 months ago #172313

Hi,

I am reviewing some old threads which does not have answers.
Regarding your debug log, the HikaShop cart content is loaded by HikaShop ; as the HikaShop configuration.
Regarding the code of the HikaShop cart module, it is not possible that the module does not display anything except if you change something in the view "product / cart".
The view does not have any way to display nothing, so if the cart module is really display, I am afraid that you have modifications which generate this result.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

Time to create page: 0.085 seconds
Powered by Kunena Forum