I am working with magento and the customer registration page shows duplicate state/province names suggestions . I checked the database. Only single entry is present there in both

  1. directory_country_region
  2. directory_country_region_name

Still why registration page shows duplicate ? any clue ?

  • You should post a screenshot. I can think of two answers right off the bat. First answer is that you have two blocks rendering the same content. (Ie, two layout updates) Two, you have invalid html. – df2k2 Nov 16 '16 at 7:26
  • @df2k2 any clue how to find those malicious blocks ? – Bineesh Nov 16 '16 at 9:29

Adding the list of states in India to Magento

I have tested this and worked for me on my server.
Please open your php my admin and Please truncate table and run following:
INSERT INTO directory_country_region VALUES
(NULL , "IN", "Andaman and Nicobar","Andaman and Nicobar"),
(NULL , "IN", "Andhra Pradesh","Andhra Pradesh"),
(NULL , "IN", "Arunachal Pradesh","Arunachal Pradesh"),
(NULL , "IN", "Assam","Assam"),
(NULL , "IN", "Bihar","Bihar"),
(NULL , "IN", "Chandigarh","Chandigarh"),
(NULL , "IN", "Chhattisgarh","Chhattisgarh"),
(NULL , "IN", "Dadra and Nagar Haveli","Dadra and Nagar Haveli"),
(NULL , "IN", "Daman and Diu","Daman and Diu"),
(NULL , "IN", "Delhi","Delhi"),
(NULL , "IN", "Goa","Goa"),
(NULL , "IN", "Gujarat","Gujarat"),
(NULL , "IN", "Haryana","Haryana"),
(NULL , "IN", "Himachal Pradesh","Himachal Pradesh"),
(NULL , "IN", "Jammu and Kashmir","Jammu and Kashmir"),
(NULL , "IN", "Jharkhand","Jharkhand"),
(NULL , "IN", "Karnataka","Karnataka"),
(NULL , "IN", "Kerala","Kerala"),
(NULL , "IN", "Lakshadweep","Lakshadweep"),
(NULL , "IN", "Madhya Pradesh","Madhya Pradesh"),
(NULL , "IN", "Maharashtra","Maharashtra"),
(NULL , "IN", "Manipur","Manipur"),
(NULL , "IN", "Meghalaya","Meghalaya"),
(NULL , "IN", "Mizoram","Mizoram"),
(NULL , "IN", "Nagaland","Nagaland"),
(NULL , "IN", "Orissa","Orissa"),
(NULL , "IN", "Pondicherry","Pondicherry"),
(NULL , "IN", "Punjab","Punjab"),
(NULL , "IN", "Rajasthan","Rajasthan"),
(NULL , "IN", "Sikkim","Sikkim"),
(NULL , "IN", "Tamil Nadu","Tamil Nadu"),
(NULL , "IN", "Tripura","Tripura"),
(NULL , "IN", "Uttar Pradesh","Uttar Pradesh"),
(NULL , "IN", "Uttaranchal","Uttaranchal"),
(NULL , "IN", "West Bengal","West Bengal");

INSERT INTO directory_country_region_name (locale ,region_id ,name ) SELECT 'en_US', tmp.region_id, tmp.default_name FROM directory_country_region AS tmp WHERE tmp.country_id='IN';

I hope it will help to you. http://tejabhagavan.blogspot.in/2015/12/adding-list-of-states-in-india-to.html

| improve this answer | |
  • this is not relevant for the question. i asked why duplicate suggestions are coming on address / customer creation pages of onepage – Bineesh Nov 16 '16 at 9:34
  • plz share screenshot – Teja Bhagavan Kollepara Nov 16 '16 at 10:09
  • This answer is not at all relavant to OP's question. Please do not copy an answer from somewhere and paste it here. – Rajeev K Tomy Nov 16 '16 at 10:10
  • @TejabhagavanKollepara please see screen shot postimg.org/image/lhrf6tszn – Bineesh Nov 16 '16 at 10:13
  • @RajeevKTomy have some clue to this error ? – Bineesh Nov 16 '16 at 10:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.