Form Submissions w/ apostrophes Not Saved

Hi,
I have a working form with a table that I had tested, but now I've found a bug with other users actually using my form. It seems that when users put in an apostrophe in one of the fields, the record does not get saved to the table, but thankfully I get the back up email. This particular field is set as VARCHAR (255), could this be responsible or would this be a validation isssue?

Thanks,
Matt

Hi Matt,

Which Chronoforms version is this ? the field type should not be a problem!

Regards
Max

Is there a place where I can find the version number? I honestly don't remember, I installed towards the beginning of summer, so maybe I have an old version?

Thanks,
Matt

sure you have an old version, I suggest you upgrade, you can find how here in the forums, start by knowing your current v number : Extensions >install/uninstall > components > Chronocontact

regards
Max

Hi, in looking at how to upgrade to 3.0 it says to backup the database tables. I know that I can back them up to excel or csv, but how will I restore that data when 3.0 is installed? Thanks in advance for dealing with my ignorance.

-Matt

Hi Matt,

by database tables you mean the forms code..etc or the data saved by forms ? if its the 2nd one then leave them as they are and get their names, in V3.0 you can connect and save data to any table!

Regards
Max

Thanks,

So to clarify, I meant the actual data saved in the database tables. I have already backed up the form html etc. using the Backup form button in Chronoforms 2.5. I was simply worried that I might somehow lose my database tables when I uninstalled 2.5. So the process I'm undertaking is as follows:

1) Back up forms (html, settings, etc.) using backup form button
2) Take note of database table names
3) Uninstall chrono 2.5
4) Install 3.0 stable
5) Restore Forms from backup files
6) Reconnect the database tables

Am I correct?

Also, another dumb question, where can I find the table names?

Hi Enrys,

Use PHPMyAdmin or the Joomla EasySQL component to look at your database. The ChronoForms form tables probably look line 'jos_chronoforms_99'.

Bob

Hi Emrys,

Restore Forms from backup files

No, you can't simply restore V2.5 backups to V3.0 due to many core changes, you will need to copy the code to some text files some where and start pasting it to new forms in V3.0 and recreate them!

Regards,
Max

Thank you sirs! I'll come back if I have any problems.