State/Province Dropdown has Gone Missing for Canada

[srshaw3]

A Magento CE 1.9.3.7 store has stopped displaying a dropdown for Canada  State/Province selection in the estimate shipping .

The field is specified as required in admin and an error is displayed if not Province is entered (in the non-existent field): This is a required field.

There are not any known changes to this store, to result in this behavior, except the import of Products.  I am questioning if there is something in that process that could cause such a change..... it does not seem likely from an overview perspective.

[Damian Culotta]

Hi @srshaw3,

Can you check if the data for that country is into the directory_country_region database table?

[gelanivishal]

Hello @srshaw3

Can you please run below SQL query to verify Canada's State in database?

SELECT * FROM `directory_country_region` WHERE `country_id` LIKE '%US%' ;

If yes then we need to debug any issue otherwise you have to add state for canada.

Let me know if you have any trouble.

--
if issue is solved, Click "Kudos" & "Accept as Solution"

[srshaw3]

Syntax of provided query would not work with the version of PHP on the server.

This query provided results of the states in the US, as I would expect:
SELECT * FROM directory_country_region WHERE country_id LIKE '%US%' ;

This query provided results of the states in the CA, as I would expect:
SELECT * FROM directory_country_region WHERE country_id LIKE '%CA%' ;

The issue isn't that the Canada Provinces are not in the database, but rather that the CSS is dynamically setting to "display:none".   I need to know where and how that CSS is set, so I can alter it.   Presumably the code is set based on the configuration of States Required in the configuration, which IS SET for Canada as documented in various posts in forums.

[gelanivishal]

Hello @srshaw3,

Can you share website URL?

Thank you.

[srshaw3]

https://esheaves.com/

Thank you for your interest

[srshaw3]

https://esheaves.com/

Thank you for your interest