Forums

Hi,
my form (registration for a sport event) is online and worked perfectly with DB save, email to admin and display thank message after submit
Today, as an admin, I receive new registration mails send by the form but DB save does not work anymore.
I checked the setup and everything is OK (no change)
What could be the problem ?

I just created this morning a new form on the same website which aim is to download CSV from the registration form as I did on other websites with CFV4 (only a submit button with event "csv export")
this one does the job but maybe there's a conflict with the registration form ?

Thanks
attached is the setup of the registration form

Hi Repitol,

If it was working before and isn't now then clearly something has changed. Adding another form shouldn't have any effect as long as the names are different.

Please drag a Debugger action into the On Submit event, then submit the form and post the debug - including the 'dummy emails' results here.

Bob

Here's the result, Hope I paste what you need.

Array
(
    [option] => com_chronoforms5
    [chronoform] => inscription
    [event] => submit
    [nom] => Durand
    [prenom] => Max
    [naissance] => 12/06/1968
    [adresse] => Rue de Rien
    [mail] => ger@gros.com
    [tel] => 05 65 00 00 00
    [participation] => Non, c'est la première fois
    [hidden18] => 
    [envoi] => Envoyer
    [2d74229611264bce4848c3727154e42114796c21] => 1
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
)

Hi Repitol,

Hmm . . . there's no sign of a DB Save or an Email action there :-(

The only possible problem I can see is the ' in [participation] => Non, c'est la première fois

If this is a select drop-down value please try changing it to remove the ' and see if that helps.

Bob

And doing this test with the debug action, DB save is working !
If I set "disable" to the debug action => no more DB save.

I've changed "Non, c'est la première fois" into "Non, première expérience"
but it doesn't work
it worked before with "Non, c'est la première fois" so I don't think this is the problem

when I download the csv file I can see some tests I used this morning are not at the good date and they replace older lines.

example : line 2 of the csv has been replaced by the latest test I did and the "modified" column indicates the today's date
then the former registration on line 2 has been erased
Weird !

New info
when I test form from admin, it is recorded in the Db at the last line of the view DB table fields - OK
when I use the form online, it is recorded systematically on line 2 of the DB table, replacing the previous record.
I tried with different names, email, etc...
I deleted the DB save action and inserted it again but this curious bug is still there.
:(

Hi Repitol,

What exactly do you mean by using it on-line? The link from the View Form is to the front-end of your site and you say that works OK. So how are you showing the form?

Bob

Hi Bob,
I use the form online with an insert on an article

 {chronoforms5}inscription{/chronoforms5}

where "inscription" is the name of the form

When I use the form that way, the last form user is registred on line 2 of the DB save

If I use the form through the admin link "test form", it's ok.
Do you think that could be a problem with SEF ?

Ok that's a SEF issue !
I use Artio Joomsef 4.6.2 (latest version for J!3)
when I disable Joomsef, it works well
when I enable it, db save on line 2 and always replace the former registration on that line

I changed Joomsef settings so that Chronoforms is not sef handled but that doesn't change anything.

I have to disable Joomsef. Not the best thing for my website but I have no other choice as the form has to be used this week.

Hi Repitol,

That sounds like a problem with the Article id in the URL. Please see this FAQ

Bob