Forums

I created a form with several fields for recording in Joomla, configured everything correctly, as described in your tutorial and also did the override and it all works perfectly.
I only have the problem that when then later in the user management of Joomla and I go to see the profile for the newly created I do not save fields that I created in the form of ChronoForms
What could be wrong?
thanks a lot

stefano

Hi stefano,

Have you set the form up so that they save to the profile table?

Bob

Hi stefano,

Have you set the form up so that they save to the profile table?

Bob

And how do you?

thanks a lot

stefano

Hi stefano,

The same as any other table, use a DB Save action.

Bob

Done, you can see in the screenshot, but it does not work
I create a user but does not save the other data in the user profile, if you want to step access to the site and see for yourself.

Thanks

stefano
[attachment=0]Torino_Sposi_Web_-_Amministrazione_-_Form_Wizard__FormRegistrazione.jpg[/attachment]

Hi stefano,

Have you matched up the column names? If you add a Debugger action you can see the DB Query that is being created and check that.

Bob

Excuse my ignorance but I did not understand what should I do
I turned on the debugger and I get this error

Debug Data

Tableuser_profiles: :store fallito - Duplicate entry '0-' for key 'idx_user_id_profile_key' SQL=INSERT INTO `l2e3g_user_profiles` () VALUES ()

Hi riga75,

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

Note: if you are using the Easy Wizard you can turn on Debug on the Others tab.

Bob

Data Array:

Array
(
    [option] => com_chronoforms
    [chronoform] => FormRegistrazione
    [event] => submit
    [Itemid] => 
    [nomeutente] => boiachimolla1
    [password] => 12345
    [confermapassword] => 12345
    [email] => porca@ciao.it
    [confermaemail] => porca@ciao.it
    [nome] => stefan
    [cognome] => origaz
    [indirizzo] => ghfjhgjf
    [citta] => gjhkgkjhgjk
    [cap] => 12344
    [telefono] => 4364376478
    [cellulare] => 46476476
    [sitoweb] => 
    [infopersonale] => dfsdv
    [facebook] => facebook
    [twitter] => tw
    [google] => g+
    [bugdet] => 
    [numeroinvitati] => 
    [datamatrimonio] => 
    [Invia] => Invia
    [f610c6b2bbe54654cecce54f7a5c122b] => 1
)

Validation Errors:

Array
(
)

Debug Data

    Tableuser_profiles: :store fallito - Duplicate entry '0-' for key 'idx_user_id_profile_key' SQL=INSERT INTO `l2e3g_user_profiles` () VALUES ()
    email
        2
            Result An email has been SENT successfully from (admin)porca@ciao.it to myemail@gmail.com
            Body

            Nome Utente: boiachimolla1

            Password:12345

            Conferma Password: 12345

            Indirizzo Email: porca@ciao.it

            Conferma Indirizzo Email:porca@ciao.it

            Nome: stefan

            Cognome: origaz

            Indirizzo: ghfjhgjf

            Città: gjhkgkjhgjk

            CAP: 12344

            Numero di Telefono: 4364376478

            Numero Cellulare: 46476476

            Sito Internet:

            Info Personale:dfsdv

            Social

            Account Facebook: facebook

            Account Twitter: tw

            Account Google+: g+

            Riservato per gli sposi

            Budget Previsto:

            Numero invitati:

            Data Matrimonio:

            Riservato per i fornitori

            Sito Internet:

            Sito Internet:

            Sito Internet:


            Submitted by 82.56.5.30
            Attachments array ( )

And this is the screenshot

[attachment=0]Schermata 2013-08-07 alle 19.35.45.png[/attachment]


thanks a lot

stefano

Hi riga75,

The problem is here

Tableuser_profiles: :store fallito - Duplicate entry '0-' for key 'idx_user_id_profile_key' SQL=INSERT INTO `l2e3g_user_profiles` () VALUES ()

It looks as though the DB Save is set up so that there are no entries to save.

Bob

is how do I fix it?

Hi riga75,

You set the date up to save correctly to the '#__user_profiles' table - you'll need to look at the table to see what columns and values are needed.

Bob