Forums

Hi!
Having some troubles🙂
Few questions:
I'm not able to save UTF-8 (non Latin symbols) in DB. If I try to do so - the question marks are saved in DB instead of entered symbols.
By default DB have UTF-8 collation. But I don't why, I don't see the created DB by chronoforms in phpMyAdmin. Only two table are shown:

_chronoforms
_chronoform_actions

Another two questions are regarding "page break". I've done form with two pages. See attach.
[attachment=0]multi.png[/attachment]
The captcha is used on the second page and when it fails - the user is redirected to the first page from starters. What is wrong. How can I fix it?

Thank you!

Hi 01,

You can see the Db Table name in the DB Save action.

If you can't see the table how do you know that the data is being incorrectly saved? Could it be that the page you are viewing the data in has the wrong Character set??

ChronoForms uses the default collation setting in the Create table - you'd need to check with PHPMyAdmin to see exactly what the table settings are.

++++++

Please use separate posts for unrelated questions!

Why would you put a Captcha on the second page of a multi-page form?

Bob

Hi, GreyHead!
Thank you for your reply!
I see table name in "Tables Connected". Then I press "Show data" and I see records.
The created table has "_chronoforms_data_survey" name and it's absent in phpMyAdmin what is very weird for me😀 I also tried to make a search by "chrono" or "survey". But no luck... And it must be somewhere created😀 Riddle🙂

Sorry for separate question.
I put in in the end that I want that user would enter the code after filling the whole survey.

Sorry, it was my permission problem. Now I see all tables.
What is very weird the created table has "latin1_swedish_ci" collation where whole DB - "utf8_general_ci".
A bug?

Hi 01,

As I said, I don't think that ChronoForms sets a collation; if not it must be coming from a database setting somewhere.

Bob

Understood. Maybe it's of a DB restore action😟 Will try to debug.

Regarding captcha check, is it possible to disallow redirection to the first page? When wrong capcha's code is entered on the second page?

+ as I noticed that filling the form second time it has prechecked values in checkbox group which were selected previously. As I understand it's of a session. How can session can be cleared?
Thank you!

Hi 01,

The Session to Data action has an option to clear the data ChronoForms has saved in a User session.

Bob

Brilliant!
Placed in "On Submit" action - working like a charm!
Thank you!
One question. When validation fails - the first page has all values, and second page has all entered values except checkbox group. If only one checkbox was selected in group - it will be prechecked. Otherwise - empty checkboxes. How it can be fixed? Placing " Session to Data" to another action?