Checkbox Field needs to be fixed!! Please!

I had already alerted Stiofan, he might have missed it.
I’ll give him another alert.

It should be possible to update this in the DB, but it’s a bit tricky for existing data.

The geodir_custom_fields table is straightforward enough and with each row, you can edit it by hand, changing 3 fields it appears.

1) data_type for select is empty (was VARCHAR for checkbox)
2) field_type will now be “select” (no quotes)
3) option_values will need your choices (No answer (or a blank), Yes, No)

The trick is that the data in geodir_(post_type_name)_detail is a bit corrupted. Let’s deal with one generic column called “wheelchair” for wheelchair access, and our choices are “No Answer”, “Yes” and “No”.

“No Answer” seems needed as you can’t create an empty entry in the select list that I can see.

Right now, where you checked the box before, it has a 1 in the column “wheelchair” which is easy, because it means it is wheelchair accessible. So you can update all of those like (untested queries):

UPDATE geodir_gd_place_detail SET geodir_wheelchair='Yes' WHERE geodir_wheelchair = '1';

The problem comes with “no” or “no answer” because right now many of those are showing 0 for both cases – which is your original problem. You need to choose whether to leave those as “No” or make them all empty when you don’t know the correct value.

Set all to “No”:

UPDATE geodir_gd_place_detail SET geodir_wheelchair='No' WHERE geodir_wheelchair <> 'Yes';

Clear all unknown:

UPDATE geodir_gd_place_detail SET geodir_wheelchair=NULL WHERE geodir_wheelchair <> 'Yes';

– this basically clears them. It’s not “No” and it’s not “No Answer” just empty or unanswered.

Brian, You know how to reach me if you need help with this. I can also chat on Skype at jeff.rose1 if that’s better than email.

This is resolved