Asking for State when doing international shipping

-- url of the page with the problem -- : www.ariesgamesandminis.com
-- HikaShop version -- : 2.2.2
-- Joomla version -- : 2.5.14
-- PHP version -- : Don't know
-- Browser(s) name and version -- : IE10 & Google Chrome

When customers are selecting their country, they cannot save out of the address entry screen as it keeps asking for a U.S. State. A while back, I had an issue of the U.S. State not working and was solved in this thread...

www.hikashop.com/forum/4-how-to/80444-st...k-for-us-states.html

Could the fix for the U.S. State in the thread above be the issue here?

Thanks

Ok...I will try to post that later today.

On a side note, there were 2 different requests for registration from 2 different hikashop test names...both are now activated.

Here is what was reported...

Joomla! Debug Console
Session
__default
Profile Information
Application 0.000 seconds (+0.000); 0.41 MB (+0.412) - afterLoad
Application 0.046 seconds (+0.046); 1.80 MB (+1.386) - afterInitialise
Application 0.057 seconds (+0.011); 2.14 MB (+0.341) - afterRoute
Application 0.113 seconds (+0.055); 3.25 MB (+1.111) - afterDispatch
Application 0.119 seconds (+0.006); 3.35 MB (+0.102) - beforeRenderModule mod_menu ()
Application 0.127 seconds (+0.008); 3.59 MB (+0.240) - afterRenderModule mod_menu ()
Application 0.127 seconds (+0.000); 3.59 MB (-0.002) - beforeRenderModule mod_menu ()
Application 0.132 seconds (+0.005); 3.60 MB (+0.010) - afterRenderModule mod_menu ()
Application 0.132 seconds (+0.000); 3.60 MB (-0.003) - beforeRenderModule mod_menu ()
Application 0.134 seconds (+0.002); 3.61 MB (+0.007) - afterRenderModule mod_menu ()
Application 0.134 seconds (+0.000); 3.60 MB (-0.002) - beforeRenderModule mod_search ()
Application 0.138 seconds (+0.004); 3.61 MB (+0.011) - afterRenderModule mod_search ()
Application 0.142 seconds (+0.004); 3.61 MB (-0.004) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.146 seconds (+0.004); 3.64 MB (+0.032) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
Application 0.162 seconds (+0.016); 3.72 MB (+0.082) - afterRender
Memory Usage
3.77 MB (3,956,040 Bytes)
Database Queries
34 Queries Logged
SELECT `data`
FROM `jos_session`
WHERE `session_id` = '6358ee4742f1f9b6d83f9f2ca9dc2c63'
SELECT folder AS type, element AS name, params
FROM jos_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 jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT name,value
FROM jos_jsn_poweradmin_config
WHERE 1
SELECT COUNT(*)
FROM jos_extensions
WHERE element="jsnadminbar"
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_kunena'
SELECT `value`
FROM `jos_admintools_storage`
WHERE `key` = 'cparams'
SHOW FULL COLUMNS
FROM `jos_assets`
SELECT id
FROM jos_assets
WHERE parent_id = 0
SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 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 jos_menu AS m
LEFT JOIN jos_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 jos_template_styles as s
LEFT JOIN jos_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 extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_menus'
SELECT *
FROM jos_hikashop_config
SELECT *
FROM jos_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_namekey!='address_name'
AND a.field_table='user'
ORDER BY a.`field_ordering` ASC
SELECT *
FROM jos_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_namekey!='address_name'
AND a.field_table='address'
ORDER BY a.`field_ordering` ASC
SELECT *
FROM jos_hikashop_field as a
WHERE a.`field_published` = 1
AND a.field_namekey!='address_name'
AND a.field_table='address'
ORDER BY a.`field_ordering` ASC
SELECT a.*
FROM jos_hikashop_zone_link AS b
LEFT JOIN jos_hikashop_zone AS a
ON b.zone_child_namekey=a.zone_namekey
WHERE a.zone_type='state'
AND b.zone_parent_namekey='Mr'
AND a.zone_published=1
ORDER BY a.zone_name_english ASC
SELECT a.*
FROM jos_hikashop_zone AS a
WHERE a.zone_type IN ('country')
AND a.zone_published=1
ORDER BY a.zone_name_english ASC
SELECT *
FROM jos_hikashop_zone
WHERE zone_id = '4314'
LIMIT 1
SELECT a.zone_parent_namekey
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('state_Wisconsin_4314');
SELECT a.zone_parent_namekey
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_United_States_of_America_223');
SELECT a.*
FROM jos_hikashop_zone_link AS b
LEFT JOIN jos_hikashop_zone AS a
ON b.zone_child_namekey=a.zone_namekey
WHERE a.zone_type='state'
AND b.zone_parent_namekey='country_United_States_of_America_223'
AND a.zone_published=1
ORDER BY a.zone_name_english ASC
SELECT *
FROM jos_hikashop_zone
WHERE zone_id = '4314'
LIMIT 1
SELECT a.zone_parent_namekey
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('state_Wisconsin_4314');
SELECT a.zone_parent_namekey
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_United_States_of_America_223');
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2013-11-08 23:48:36')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-11-08 23:48:36')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT manifest_cache
FROM jos_extensions
WHERE element='com_hikashop'
UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1383954463;s:18:\"session.timer.last\";i:1383954483;s:17:\"session.timer.now\";i:1383954516;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.101 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{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:12:\"com_hikashop\";O:8:\"stdClass\":2:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:4:\"4314\";}}}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:\"79be41cf4021a16a8aeb29ba6856170c\";}' , `time` = '1383954516'
WHERE `session_id` = '6358ee4742f1f9b6d83f9f2ca9dc2c63'
22 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
4 × SELECT a.zone_parent_namekey
FROM jos_hikashop_zone_link AS a
3 × SELECT *
FROM jos_hikashop_field as a
2 × SELECT a.*
FROM jos_hikashop_zone_link AS b
LEFT JOIN jos_hikashop_zone AS a
ON b.zone_child_namekey=a.zone_namekey
2 × SELECT *
FROM jos_hikashop_zone
1 × SELECT *
FROM jos_hikashop_confi
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM jos_languages
1 × SELECT a.*
FROM jos_hikashop_zone AS a
1 × SELECT manifest_cache
FROM jos_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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT COUNT(*)
FROM jos_extensions
1 × SELECT name,value
FROM jos_jsn_poweradmin_config
1 × SELECT folder AS type, element AS name, params
FROM jos_extensions
1 × SELECT `value`
FROM `jos_admintools_storage`
1 × SELECT id
FROM jos_assets
1 × SELECT `data`
FROM `jos_session`
1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
OTHER Tables:
1 × UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1383954463;s:18:\"session.timer.last\";i:1383954483;s:17:\"session.timer.now\";i:1383954516;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.101 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{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:12:\"com_hikashop\";O:8:\"stdClass\":2:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:4:\"4314\";}}}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:\"79be41cf4021a16a8aeb29ba6856170c\";}' , `time` = '1383954516'
1 × SHOW FULL COLUMNS
FROM `jos_assets

Just noticed I posted the bug report on the wrong link...I've edited the above post to reflect the correct link provided.

Nicolas, I PM'd you some info, but have not heard back from you yet. Any luck?

Thanks

Hi,

Joomla World Conference

Part of our team is attending the Joomla World Conference, so you might experience some delay for our answers.
Thank you for bearing with us

Ah...ok, thanks for the heads up.

Nicolas, I just bumped you up to Super User...could you please try again? It's working for me

Nicolas...any luck since I upped your permissions?

PM'd you nicolas...

Nicolas, any luck looking in to this issue? Thanks

I am still in need of help on this, can someone please help me out?

Thanks

Hi,

Do you still have trouble ?
It seems that we still don't have the FTP access, so thanks to send it via pm, in the message thanks to give the url of this topic.

Yes, I still am having issues with this...PM'ing you now

Awesome! Thank you, I just tried it and it seems to be working now. I sincerely appreciate your help Xavier!