upgrade error

Dear Aicha,

I moved my site to a subdomain for testing purpose, to reproduce the error.

The steps are the followings:
1. Moving Joomla from 3.3.6 to 3.4.1 via system installer, using Joomla_3.4.1-Stable-Update_Package.zip
2. Moving Visforms 3.2.2 to 3.4.3 via system installer, using visForms_j3.3.6_3.4.3.zip package
3. Installer message: Component Visforms update version 3.2.2 to 3.4.3 successful
4. In my template folder I turned off the override, by making "_mod_visforms"
5. I tested the forms and everything looks good: all data and attached files are delivered properly.
6. But, when I open the form, then open a Select field and save without any changes produce Joomla 404 error page on front end: "0 - Select must have at least one option." So the whole is blocked.
7. I need to reopen that Select filed and recreate the Options, because they are deleted. I don't know why and how.

I mailed the visforms_update.php file to you.

What I can not reproduce is the blank mails what I get some day ago.

Thank you for your help.
If you need anything more just contact me.

Hi Gabor,

thanks a lot for your work!
I looked into it but did not find the source of the problem yet.

I just send you a mail with more questions

Kind regards,
Aicha

Hi Gabor,

thank you for sending me the visforms and visfields table.
I found the problem.
For Visforms 3.2.0 I changed the creation of select options and how they are stored in the database.
I had to convert all old select option from the old format to the new format.
I looks as if the conversion does not work correctly with special characters or the character set used by your website or database.
There are to many escape characters \ stored in the database.
This is only a problem, when you save the select field in the administration but is not a problem, in the frontend view of the form.
So, as long as you do not open a select in the administration everything is fine.
When you open a select field which was created on Visforms before Version 3.2 and save it, the options are lost.
When you create the options again, everything is ok and will not get lost again.

So this is not an upgrade error of Visforms 3.4 but of Visforms 3.2
Sadly the only solutions for you is to recreate the options of all select fields which were create on Visforms before 3.2.
After that, the forms should work fine.

I cannot reproduce the problem with the emails and the problem with the "choose an option" was solved with Visforms 3.2.3 and is still solved.
I have a Joomla! 3.4.1 with Visforms 3.4.3 and imported your form and field definitions. There is no "choose an option" option in the selects in the form.

I only idea I have about this problom is that maybe the old form is still cached on your website.

Regards,
Aicha

I understand Aicha, thank you for your investigation.
Special characters on my site: I use UTF-8 years ago so I don't know how they are produced.

I think this topic can be close.

Best,
Gabor

Hi Gabor,

thanks.
I apology for your trouble and hope everything works now fine!

Regards,
Aicha

Hi everybody,

as described earliery in this topic, this error occured if
- on Visforms 3.1.2 there were fields of type select or radio with options containing special characters and
- Visforms was updated to Visforms 3.2.0 or higher

The problem was only visible if the select or radio field with the options with special characters was opened and saved in administration. Therefore it mostly was not detected directly after the update but only a long time after.

I was now able to fix the update script, so that everybody who updates a Visforms 3.1.2 installation from no on will not have this problem (using the installation/update packages downloaded from this website).

But I cannot mend Visforms installations which are already updated. So if you encounter this problem you sadly have to recreate the options in the affected fields once. This will fix it.

Thank you,
Aicha