CE4.9.7 Drop Down State Selection Missing

I am not sure, but I may have discovered a bug in the current version when it comes to Australian setups.

In my other shop setting on CE 4.6.4_49061, when a customer selects the country to be Australia, a new box or drop down menu appears asking the user to select a State. This is NOT present in CE4.9.7 for some reason.

Its either this or I have inadvertently turned it off or deleted it.

So, what can I do to restore this functionality as it is pretty important.

Don,

just looked it up in the Database: for Australia, there are no states defined yet. Unfortunately, it cannot be done via admin panel but adding new entries into oxstates (name of the table) via phpMyAdmin should be as easy as a charm. Please note: the country ID you need is 8f241f11095410f38.37165361.

Would be glad if you could provide your table of Australian states here so we can add it to the standard delivery of the database.

Cheers!

Hey Marco,

Looking at phpMyAdmin has opened up a new dimension for me just now and another “How to Navigate” chapter.

I found:

 Full texts 	OXID 	OXCOUNTRYID Ascending 	OXTITLE 	OXISOALPHA2
	Edit Edit 	Copy Copy 	Delete Delete 	ACT 	8f241f11095410f38.37165361 	Australian Capital Territory 	ACT
	Edit Edit 	Copy Copy 	Delete Delete 	VIC 	8f241f11095410f38.37165361 	Victoria 	VIC
	Edit Edit 	Copy Copy 	Delete Delete 	WA 	8f241f11095410f38.37165361 	Western Australia 	WA
	Edit Edit 	Copy Copy 	Delete Delete 	NT 	8f241f11095410f38.37165361 	Northern Territory 	NT
	Edit Edit 	Copy Copy 	Delete Delete 	SA 	8f241f11095410f38.37165361 	South Australia 	SA
	Edit Edit 	Copy Copy 	Delete Delete 	TAS 	8f241f11095410f38.37165361 	Tasmania 	TAS
	Edit Edit 	Copy Copy 	Delete Delete 	NSW 	8f241f11095410f38.37165361 	New South Wales 	NSW
	Edit Edit 	Copy Copy 	Delete Delete 	QLD 	8f241f11095410f38.37165361 	Queensland 	QLD

Now that I found them, I don’t know what to do next. I coloured the correct name (OxTitle) and correct abbreviation (Oxisoalpha2) however perhaps using the OXID reference is more correct?

As you “found” it, it should appear, shouldn’t it?
Can you please take a look into oxstates and oxstates_de table if you find these entries there, too?

Cheers

I found the information in an earlier version of CE - CE 4.6.4_49061.
I couldn’t do the same trick in the newer version of CE.

Is a transplant possible?

I was hoping to hear back from someone regarding the implementation of a dropdown menu for the states of Australia - how to implement it, sort of step by step if possible.

Hey Don,

sorry - was busy with other stuff meanwhile.

  1. Backup your database
  2. Backup your database again
  3. Insert this SQL (not tested, no warranty etc…)

INSERT INTO `oxstates` (`OXID`, `OXCOUNTRYID`, `OXTITLE`, `OXISOALPHA2`, `OXTITLE_1`, `OXTITLE_2`, `OXTITLE_3`) VALUES
('ACT', '8f241f11095410f38.37165361', 'Australian Capital Territory', 'ACT', 'Australian Capital Territory', '', ''),
('VIC', '8f241f11095410f38.37165361', 'Victoria', 'VIC', 'Victoria', '', ''),
('WA', '8f241f11095410f38.37165361', 'Western Australia', 'WA', 'Western Australia', '', ''),
('NT', '8f241f11095410f38.37165361', 'Northern Territory', 'NT', 'Northern Territory', '', ''),
('SA', '8f241f11095410f38.37165361', 'South Australia', 'SA', 'South Australia', '', ''),
('TAS', '8f241f11095410f38.37165361', 'Tasmania', 'TAS', 'Tasmania', '', ''),
('NSW', '8f241f11095410f38.37165361', 'New South Wales', 'NSW', 'New South Wales', '', ''),
('QLD', '8f241f11095410f38.37165361', 'Queensland', 'QLD', 'Queensland', '', '');

Good luck!

Oh - and thanks BTW. Will request to put that into the standard delivery :wink:

Hey Marco,

I inserted the code line by line, entry by entry as I could not see a way to copy and paste the entire code that you laid out all at once.
I did encounter an issue when it came to WA or Western Australia - it appears that there is another WA in the database belonging to the Yanks. I deleted Washington and I was then able to add WA, Western Australia but until then I kept getting duplication errors.
This was the only work around I found.

Many thanks for your help to establish the database.

Cheers

Don

[QUOTE=NHWS;179381]
I did encounter an issue when it came to WA or Western Australia - it appears that there is another WA in the database belonging to the Yanks. I deleted Washington and I was then able to add WA, Western Australia but until then I kept getting duplication errors. [/QUOTE]

Exactly. This is because of a bug:
https://bugs.oxid-esales.com/view.php?id=5029

That’s why my commit had to be reverted :frowning:

Wow Marco,

I actually performed a workaround and it WAS an actually bug!! I think I am getting more familiar with this stuff all the time.