Billing fields configuration not working

Hi there!
Sorry I didn't get back to the 'truncate title...' thread, yet. I have another problem that is one of the last obstacles before going live with my new website (Not to push here but fast help would be really appreciated)

So the problem is that the configuration for the 'billing fields' is not working. For example, I have configured 'State' to not be a required field and it still shows as a mandatory field.
I had a look in the database but couldn't find the according table.

Thanx in advance
TJ

Hi

I believe you changed the settings in the configuration of the extension and that's the wrong place as change settings in Configuration only affect new events. In this case (existing events), you will need to edit the events, change billing fields settings from there.

After that, everything should work as expected.

Regards,

Tuan

Thanx Tuan

...you're right - makes perfect sense! Too bad I have almost 500 tours in my database :woohoo:

I am thinking about overriding that view and just hard-code the mandatory fields ...or maybe run an sql over the events table to update those settings. Any suggestions?

Cheers from Tofino

I don't think it is a good idea as there are several places in the code use that settings : Registration Form, Confirmation Page, Sending Emails.

I think if all events use the same settings , you can use the solution below :

1. Edit one event, change the settings for that event. The data for the settings is stored in params field in #__eb_events table.

2. Find a way (maybe find a SQL command) to update the params field of all other records to use the same value as the record you changed in #1 (I am sure you will be able to find it)

That should be the correct/easiest solution !

Tuan

Thanx for the guidance, that shouldn't be a problem!

But going one step back:
My original problem is that the formfield 'state' works fine for the US and Canada but if I select e.g. Germany, no 'Bundeslaender' (German for province) show up. So if 'state' is set as mandatory, the Germans, or Swiss etc. can't book!

Can you tell me how I can add provinces for other countries?

Sorry, I should use my own brains: I assume I can look-up the database entry for e.g. Canada and just copy and adapt that for other countries, right?

Correct ! The database table which store the data is #__eb_states. Look at that table and you will understand what you need to do !

Tuan

Yepp, found it! Nevermind ...and thanx again!

Great ! Thanks for the update !

Tuan