Hi Nicholas,
Joomla 1.5.23
sh404SEF 2.3.0.988
I was on the page where all products in the category silverware were shown in THB.
Then I used the currency switcher to go to USD.
With SEF disabled everything goes fine but with SEF enabled Hikashop goes back to the main shop page which shows all categories and the currency remains at THB.
This is what the log says:
Profile Information
Application afterLoad: 0.000 seconds, 0.39 MB
Application afterInitialise: 0.118 seconds, 5.78 MB
Application afterRoute: 0.216 seconds, 10.02 MB
Application afterDispatch: 0.499 seconds, 19.97 MB
Application afterRender: 0.703 seconds, 22.83 MB
Memory Usage
24141824
107 queries logged
SELECT *
FROM jos_languages
WHERE active=1
ORDER BY ordering
SELECT oldurl, newurl
FROM jos_redirection
WHERE oldurl = 'shop.html'
ORDER BY rank ASC
LIMIT 1
UPDATE jos_redirection
SET cpt=(cpt+1)
WHERE `newurl` = 'index.php?option=com_hikashop&Itemid=22&lang=en&layout=listing&view=category'
AND `oldurl` = 'shop.html'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(1,31,2,22,36,23,37,26,38,27,35,10,28,39,47,33,34,40,41,42)
AND jf_content.reference_table='menu'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(1,31,2,22,36,23,37,26,38,27,35,10,28,39,47,33,34,40,41,42)
AND jf_content.reference_table='menu'
SELECT id, parent_id, VALUE, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=23
SELECT *
FROM jos_hikashop_config
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 22)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_menu
WHERE id = '22'
LIMIT 1
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(22)
AND jf_content.reference_table='menu'
SELECT *
FROM jos_modules
WHERE id IN (92);
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(92)
AND jf_content.reference_table='modules'
SELECT category_id
FROM jos_hikashop_category
WHERE (category_access = 'all' OR category_access LIKE '%,25,%')
AND category_type='product'
AND category_id IN (15)
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(15)
AND jf_content.reference_table='hikashop_category'
SELECT *
FROM jos_hikashop_category
WHERE category_id = '15'
LIMIT 1
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(15)
AND jf_content.reference_table='hikashop_category'
SHOW TABLES
SELECT *
FROM jos_languages
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&format=feed&lang=en&layout=listing&type=rss&view=category'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&format=feed&lang=en&layout=listing&type=atom&view=category'
SELECT a.*
FROM jos_hikashop_category AS a
WHERE a.category_parent_id = 15
AND a.category_published=1
AND (a.category_access = 'all' OR a.category_access LIKE '%,25,%')
ORDER BY a.category_ordering ASC
LIMIT 0, 72
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(43,48,42,18,22,19,25,27,24,17)
AND jf_content.reference_table='hikashop_category'
SELECT *
FROM jos_hikashop_file
WHERE file_type='category'
AND file_ref_id IN (43,48,42,18,22,19,25,27,24,17)
SELECT COUNT(*)
FROM jos_hikashop_category AS a
WHERE a.category_parent_id = 15
AND a.category_published=1
AND (a.category_access = 'all' OR a.category_access LIKE '%,25,%')
SELECT a.*,b.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_file AS b
ON a.category_id=b.file_ref_id
AND b.file_type='category'
WHERE a.category_id = 15
LIMIT 1
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(15)
AND jf_content.reference_table='hikashop_category'
SELECT DISTINCT b.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_category AS b
ON a.category_left >= b.category_left
WHERE b.category_right >= a.category_right
AND a.category_id=15
ORDER BY b.category_left
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(1,2,15)
AND jf_content.reference_table='hikashop_category'
SELECT *
FROM jos_hikashop_field AS a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='category'
AND (a.field_access = 'all' OR a.field_access LIKE '%,25,%')
AND ((field_with_sub_categories=0
AND (field_categories="all" OR field_categories LIKE '%,15,%'))OR (field_with_sub_categories=1
AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,15,%')))
ORDER BY a.`field_ordering` ASC
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=43&ctrl=category&lang=en&name=silver-jewelry&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=48&ctrl=category&lang=en&name=silk-shawls&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=42&ctrl=category&lang=en&name=ceramics-vases&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=18&ctrl=category&lang=en&name=ceramics-home-decor&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=22&ctrl=category&lang=en&name=ceramics-tableware&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=19&ctrl=category&lang=en&name=ceramics-bencharong&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=25&ctrl=category&lang=en&name=laquerware&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=27&ctrl=category&lang=en&name=woodcarving&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=24&ctrl=category&lang=en&name=bronzeware&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=17&ctrl=category&lang=en&name=aluminum-relief-panels-&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=15&ctrl=category&lang=en&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&lang=en&layout=listing&view=category'
SELECT category_id
FROM jos_hikashop_category
WHERE (category_access = 'all' OR category_access LIKE '%,25,%')
AND category_id IN (15)
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(15)
AND jf_content.reference_table='hikashop_category'
SELECT *
FROM jos_hikashop_filter
WHERE filter_published = 1
ORDER BY filter_ordering
SELECT DISTINCT b.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_category AS b
ON a.category_left >= b.category_left
WHERE b.category_right >= a.category_right
AND a.category_id=15
ORDER BY b.category_left
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(1,2,15)
AND jf_content.reference_table='hikashop_category'
SELECT a.*,b.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_file AS b
ON a.category_id=b.file_ref_id
AND b.file_type='category'
WHERE a.category_id = 15
LIMIT 1
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(15)
AND jf_content.reference_table='hikashop_category'
SELECT DISTINCT b.*
FROM jos_hikashop_product_category AS a
LEFT JOIN jos_hikashop_product AS b
ON a.product_id=b.product_id
WHERE b.product_published=1
AND b.product_type = 'main'
AND a.category_id IN (15)
AND (b.product_access = 'all' OR b.product_access LIKE '%,25,%')
ORDER BY a.ordering ASC
LIMIT 0, 72
SELECT COUNT( DISTINCT b.product_id)
FROM jos_hikashop_product_category AS a
LEFT JOIN jos_hikashop_product AS b
ON a.product_id=b.product_id
WHERE b.product_published=1
AND b.product_type = 'main'
AND a.category_id IN (15)
AND (b.product_access = 'all' OR b.product_access LIKE '%,25,%')
ORDER BY a.ordering ASC
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 0
AND ( mm.menuid = 22 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(104,17,145,133,76,98,97,128,129,136,106,24)
AND jf_content.reference_table='modules'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&lang=en&layout=listing&view=category'
SELECT *
FROM jos_languages
WHERE active=1
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(1,31,2,22,36,23,37,26,38,27,35,10,28,39,47,33,34,40,41,42)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.reference_id IN(22)
AND jf_content.reference_table='menu'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&lang=nl&layout=listing&view=category'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&ctrl=currency&lang=en&task=update'
SELECT *
FROM jos_hikashop_currency
WHERE currency_published=1 OR currency_displayed = 1 OR currency_id IN ('155')
SELECT a.*
FROM jos_hikashop_cart AS a
WHERE a.user_id = 62 OR a.session_id = '73a92ce5b00488a55e03909f8b4d3a09'
ORDER BY a.cart_modified DESC
LIMIT 1
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&ctrl=checkout&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&ctrl=product&lang=en&task=updatecart&tmpl=component'
SELECT *
FROM jos_hikashop_field AS a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='item'
AND (a.field_access = 'all' OR a.field_access LIKE '%,25,%')
ORDER BY a.`field_ordering` ASC
SELECT category_id
FROM jos_hikashop_category
WHERE (category_access = 'all' OR category_access LIKE '%,25,%')
AND category_type='product'
AND category_id IN (15)
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(15)
AND jf_content.reference_table='hikashop_category'
SELECT a.*
FROM jos_hikashop_category AS a
WHERE a.category_parent_id = 15
AND a.category_published=1
AND (a.category_access = 'all' OR a.category_access LIKE '%,25,%')
ORDER BY a.category_ordering ASC
LIMIT 0, 72
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.reference_id IN(43,48,42,18,22,19,25,27,24,17)
AND jf_content.reference_table='hikashop_category'
SELECT *
FROM jos_hikashop_file
WHERE file_type='category'
AND file_ref_id IN (43,48,42,18,22,19,25,27,24,17)
SELECT COUNT(*)
FROM jos_hikashop_category AS a
WHERE a.category_parent_id = 15
AND a.category_published=1
AND (a.category_access = 'all' OR a.category_access LIKE '%,25,%')
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=43&ctrl=category&lang=en&name=silver-jewelry&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=48&ctrl=category&lang=en&name=silk-shawls&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=42&ctrl=category&lang=en&name=ceramics-vases&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=18&ctrl=category&lang=en&name=ceramics-home-decor&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=22&ctrl=category&lang=en&name=ceramics-tableware&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=19&ctrl=category&lang=en&name=ceramics-bencharong&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=25&ctrl=category&lang=en&name=laquerware&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=27&ctrl=category&lang=en&name=woodcarving&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=24&ctrl=category&lang=en&name=bronzeware&task=listing'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&cid=17&ctrl=category&lang=en&name=aluminum-relief-panels-&task=listing'
SELECT *
FROM jos_acymailing_config
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_acymailing&ctrl=sub&formid=129&lang=en&task=display&tmpl=component'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=2&id=2&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=22&lang=en&layout=listing&view=category'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=23&lang=en&layout=listing&view=category'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=26&lang=en&layout=step&view=checkout'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=27&id=23&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=35&id=33&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=10&id=44&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=28&id=2&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=39&id=29&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=47&id=50&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=33&lang=en&layout=step&view=checkout'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=34&id=40&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=40&id=23&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=41&id=46&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=42&id=47&lang=en&view=article'
SELECT CONCAT( 'search=', `search`, '
replace=', `replace`, '
area=', `area`, '
', `params` )
FROM jos_rereplacer
WHERE published = 1
AND area = 'component'
ORDER BY ordering, id
SELECT CONCAT( 'search=', `search`, '
replace=', `replace`, '
area=', `area`, '
', `params` )
FROM jos_rereplacer
WHERE published = 1
AND area = 'body'
ORDER BY ordering, id
SELECT CONCAT( 'search=', `search`, '
replace=', `replace`, '
area=', `area`, '
', `params` )
FROM jos_rereplacer
WHERE published = 1
AND area = 'everywhere'
ORDER BY ordering, id
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_user&lang=en&view=reset'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_hikashop&Itemid=38&lang=en&layout=cpanel&view=user'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_user&Itemid=36&lang=en&view=login'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_phocaguestbook&Itemid=46&id=1&lang=en&view=phocaguestbook'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=47&id=50&lang=en&view=article'
Language Files Loaded
/home/thaihand/public_html/language/en-GB/en-GB.ini 1
/home/thaihand/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
/home/thaihand/public_html/administrator/language/en-GB/en-GB.plg_joomfish_missing_translation.ini 1
/home/thaihand/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini
/home/thaihand/public_html/administrator/language/en-GB/en-GB.plg_system_rereplacer.ini 1
/home/thaihand/public_html/administrator/language/en-GB/en-GB.plg_system_modulesanywhere.ini 1
/home/thaihand/public_html/language/en-GB/en-GB.com_hikashop.ini 1
/home/thaihand/public_html/language/overrides/en-GB.override.ini 1
/home/thaihand/public_html/language/en-GB/en-GB.mod_hikashop.ini
/home/thaihand/public_html/language/en-GB/en-GB.tpl_vs_asianlegend.ini
/home/thaihand/public_html/language/en-GB/en-GB.mod_breadcrumbs.ini 1
/home/thaihand/public_html/language/en-GB/en-GB.mod_jflanguageselection.ini 1
/home/thaihand/public_html/language/en-GB/en-GB.mod_customlogin_register_text.ini
/home/thaihand/public_html/language/en-GB/en-GB.mod_hikashop_currency.ini
/home/thaihand/public_html/language/en-GB/en-GB.mod_hikashop_cart.ini
/home/thaihand/public_html/language/en-GB/en-GB.mod_acymailing.ini
/home/thaihand/public_html/language/en-GB/en-GB.mod_valaddthis_15.ini 1
/home/thaihand/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
Untranslated Strings Diagnostic
None
Untranslated Strings Designer
None