Forums

ChronoForms v8 is now WordPress ready, ChronoMails is out

The JED needs volunteers!

problem create table

ez
ezzine 08 Mar, 2013
hello
tks for your service very very good.
i work with chronoforms fine but finly whene i try to creat table give me this errore can you help me plz.

Check table query below:

CREATE TABLE IF NOT EXISTS `#__chronoforms_data_primaprova000` ( `cf_id` INT(11) NOT NULL auto_increment, `cf_uid` VARCHAR(255) NOT NULL, `cf_created` DATETIME NOT NULL, `cf_modified` DATETIME NOT NULL, `cf_created_by` INT(11) NOT NULL, `cf_modified_by` INT(11) NOT NULL, `cf_ipaddress` VARCHAR(255) NOT NULL, `cf_user_id` INT(11) NOT NULL, `nome` VARCHAR(255) NOT NULL, `cognome` VARCHAR(255) NOT NULL, `datanascita` VARCHAR(255) NOT NULL, `logonascita` VARCHAR(255) NOT NULL, `residenza` VARCHAR(255) NOT NULL, `cap` VARCHAR(255) NOT NULL, `comune` VARCHAR(255) NOT NULL, `provincia` VARCHAR(255) NOT NULL, `telefono` VARCHAR(255) NOT NULL, `fax` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `email1` VARCHAR(255) NOT NULL, `den` VARCHAR(255) NOT NULL, `cf` VARCHAR(255) NOT NULL, `pi` VARCHAR(255) NOT NULL, `cciaa_prov` VARCHAR(255) NOT NULL, `cciaa` VARCHAR(255) NOT NULL, `cciaa_data` VARCHAR(255) NOT NULL, `ind_sede` VARCHAR(255) NOT NULL, `comune_sede` VARCHAR(255) NOT NULL, `prov_sede` VARCHAR(255) NOT NULL, `den_cen_azi` VARCHAR(255) NOT NULL, `ind_cen_azi` VARCHAR(255) NOT NULL, `comune_cen_azi` VARCHAR(255) NOT NULL, `prov_cen_azi` VARCHAR(255) NOT NULL, `dec11` VARCHAR(255) NOT NULL, `input_checkbox_group_336` VARCHAR(255) NOT NULL, `titolo` VARCHAR(255) NOT NULL, `dat_tit` VARCHAR(255) NOT NULL, `scuola` VARCHAR(255) NOT NULL, `input_checkbox_group_340` VARCHAR(255) NOT NULL, `qual` VARCHAR(255) NOT NULL, `azie_qual` VARCHAR(255) NOT NULL, `dal_all` VARCHAR(255) NOT NULL, `input_checkbox_group_341` VARCHAR(255) NOT NULL, `tipo_col1` VARCHAR(255) NOT NULL, `ett1` VARCHAR(255) NOT NULL, `ore1` VARCHAR(255) NOT NULL, `tipo_col2` VARCHAR(255) NOT NULL, `ett2` VARCHAR(255) NOT NULL, `ore2` VARCHAR(255) NOT NULL, `tipo_col3` VARCHAR(255) NOT NULL, `ett3` VARCHAR(255) NOT NULL, `ore3` VARCHAR(255) NOT NULL, `tipo_col4` VARCHAR(255) NOT NULL, `ett4` VARCHAR(255) NOT NULL, `ore4` VARCHAR(255) NOT NULL, `tipo_col5` VARCHAR(255) NOT NULL, `ett5` VARCHAR(255) NOT NULL, `ore5` VARCHAR(255) NOT NULL, `tipo_alli1` VARCHAR(255) NOT NULL, `capi1` VARCHAR(255) NOT NULL, `ore11` VARCHAR(255) NOT NULL, `tipo_all2` VARCHAR(255) NOT NULL, `capi2` VARCHAR(255) NOT NULL, `ore22` VARCHAR(255) NOT NULL, `tipo_all3` VARCHAR(255) NOT NULL, `capi3` VARCHAR(255) NOT NULL, `ore33` VARCHAR(255) NOT NULL, `tipo_all4` VARCHAR(255) NOT NULL, `capi4` VARCHAR(255) NOT NULL, `ore44` VARCHAR(255) NOT NULL, `tipo_tra1` VARCHAR(255) NOT NULL, `quan1` VARCHAR(255) NOT NULL, `ore111` VARCHAR(255) NOT NULL, `tipo_tras2` VARCHAR(255) NOT NULL, `quan2` VARCHAR(255) NOT NULL, `ore222` VARCHAR(255) NOT NULL, `tipo_tras3` VARCHAR(255) NOT NULL, `quan3` VARCHAR(255) NOT NULL, `ore333` VARCHAR(255) NOT NULL, `tipo_tras4` VARCHAR(255) NOT NULL, `quan4` VARCHAR(255) NOT NULL, `ore444` VARCHAR(255) NOT NULL, `sae` VARCHAR(255) NOT NULL, `input_radio_347` VARCHAR(255) NOT NULL, `val_az` VARCHAR(255) NOT NULL, `per_att` VARCHAR(255) NOT NULL, `vallll` VARCHAR(255) NOT NULL, `val_az2` VARCHAR(255) NOT NULL, `per_att2` VARCHAR(255) NOT NULL, `val_ind` VARCHAR(255) NOT NULL, `tot1` VARCHAR(255) NOT NULL, `non_agr1` VARCHAR(255) NOT NULL, `non_ag2` VARCHAR(255) NOT NULL, `non_ag3` VARCHAR(255) NOT NULL, `non_ag4` VARCHAR(255) NOT NULL, `tot_non_ag` VARCHAR(255) NOT NULL, `somma` VARCHAR(255) NOT NULL, `red11` VARCHAR(255) NOT NULL, `input_radio_349` VARCHAR(255) NOT NULL, `input_radio_350` VARCHAR(255) NOT NULL, `input_submit_324` VARCHAR(255) NOT NULL, `ult4` VARCHAR(255) NOT NULL, `input_textarea_351` VARCHAR(255) NOT NULL, `ult5` VARCHAR(255) NOT NULL, `data_inps` VARCHAR(255) NOT NULL, `sez_inps` VARCHAR(255) NOT NULL, `numero_inps` VARCHAR(255) NOT NULL, `sade` VARCHAR(255) NOT NULL, `sdfhjg` VARCHAR(255) NOT NULL, `aaa` VARCHAR(255) NOT NULL, `dd` VARCHAR(255) NOT NULL, `rrrf` VARCHAR(255) NOT NULL, `hkju` VARCHAR(255) NOT NULL, `dghfh` VARCHAR(255) NOT NULL, `ghkdf` VARCHAR(255) NOT NULL, `insinps` VARCHAR(255) NOT NULL, `parti` VARCHAR(255) NOT NULL, `hlkl` VARCHAR(255) NOT NULL, `ghkk` VARCHAR(255) NOT NULL, `input_checkbox_group_367` VARCHAR(255) NOT NULL, `input_checkbox_group_368` VARCHAR(255) NOT NULL, `input_checkbox_group_369` VARCHAR(255) NOT NULL, `input_textarea_370` VARCHAR(255) NOT NULL, `input_datetime_373` VARCHAR(255) NOT NULL, `input_text_374` VARCHAR(255) NOT NULL, PRIMARY KEY (`cf_id`) );
Gr
GreyHead 08 Mar, 2013
Hi ezzine,

I don't see an actual error message but most likely you are breaking the maximum record size for a MySQL table. This is around 80 VARCHAR(255) records. The answer is to adjust the column sizes to match the data instead of using the default. For example, an email column probably only needs VARCHAR(64), a phone VARCHAR(16).

There's a bit more info in this FAQ.

Bob
ez
ezzine 08 Mar, 2013
hi
tks very much now it's ok.....😀
great work
ez
ezzine 08 Mar, 2013
hi sorry but now there is anather problem in my database can't memory the data no data in the database nodata in the return email
Gr
GreyHead 08 Mar, 2013
Hi ezzine,

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
ez
ezzine 08 Mar, 2013
OK

Data Array:
Array
(
[option] => com_chronoforms
[tmpl] => component
[chronoform] => primaprova
[event] => submit
[cf_sid] => 88677f971203b6d43f8b6c9b8edc28ea
[Itemid] =>
[ult4] =>
[input_textarea_351] =>
[ult5] =>
[data_inps] =>
[sez_inps] =>
[numero_inps] =>
[sade] =>
[sdfhjg] =>
[aaa] =>
[dd] =>
[rrrf] =>
[hkju] =>
[dghfh] =>
[ghkdf] =>
[insinps] =>
[parti] =>
[hlkl] =>
[ghkk] =>
[input_checkbox_group_367] =>
[input_checkbox_group_368] =>
[input_checkbox_group_369] =>
[input_textarea_370] =>
[input_datetime_373] =>
[input_text_374] =>
[submit_btn] => Invia Domanda
[43122d79d7dec3d79fa576ddb4fc9a19] => 1
[chronoform_data] => f61074474b2a192f310dccb5f0e30802,2013-03-08 12:21:42,0,89.97.190.194,0,com_chronoforms,component,primaprova,submit,88677f971203b6d43f8b6c9b8edc28ea,,,,,,,,,,,,,,,,,,,,,,,,,,Invia Domanda,1,4
[chronoform_data_cf_id] => 4
)
Validation Errors:
Array
(
)
Gr
GreyHead 08 Mar, 2013
Hi exzzine,

It looks as though:[list=a]
  • The input names don't match the column names in the table

  • The form inputs were all empty when you submitted the form

  • You have a Handle Arrays action after the DB Save and before the Debugger action (I'm just not sure what that is doing but it does the convert the saved data array into a single string which makes it nearly impossible to read ).
    • [/list:o]

    Bob
    ez
    ezzine 08 Mar, 2013
    tka again for your reply. so i move handele array befor db save like and the debug is

    Data Array: 
Array
(
    [option] => com_chronoforms
    [tmpl] => component
    [chronoform] => primaprova
    [event] => submit
    [cf_sid] => 814fa7b3faecf20908a5aa730b3bc411
    [Itemid] => 
    [ult4] => 
    [input_textarea_351] => 
    [ult5] => 
    [data_inps] => 
    [sez_inps] => 
    [numero_inps] => 
    [sade] => 
    [sdfhjg] => 
    [aaa] => 
    [dd] => 
    [rrrf] => 
    [hkju] => 
    [dghfh] => 
    [ghkdf] => 
    [insinps] => 
    [parti] => 
    [hlkl] => 
    [ghkk] => 
    [input_checkbox_group_367] => 
    [input_checkbox_group_368] => 
    [input_checkbox_group_369] => 
    [input_textarea_370] => 
    [input_datetime_373] => 
    [input_text_374] => 
    [submit_btn] => Invia Domanda
    [79bf657b10075b62285d31d38a70a019] => 1
    [chronoform_data] => Array
        (
            [cf_uid] => fd95b669f2cff1293fc4c51a67c60b62
            [cf_created] => 2013-03-08 23:35:03
            [cf_created_by] => 0
            [cf_ipaddress] => 160.97.72.251
            [cf_user_id] => 0
            [option] => com_chronoforms
            [tmpl] => component
            [chronoform] => primaprova
            [event] => submit
            [cf_sid] => 814fa7b3faecf20908a5aa730b3bc411
            [Itemid] => 
            [ult4] => 
            [input_textarea_351] => 
            [ult5] => 
            [data_inps] => 
            [sez_inps] => 
            [numero_inps] => 
            [sade] => 
            [sdfhjg] => 
            [aaa] => 
            [dd] => 
            [rrrf] => 
            [hkju] => 
            [dghfh] => 
            [ghkdf] => 
            [insinps] => 
            [parti] => 
            [hlkl] => 
            [ghkk] => 
            [input_checkbox_group_367] => 
            [input_checkbox_group_368] => 
            [input_checkbox_group_369] => 
            [input_textarea_370] => 
            [input_datetime_373] => 
            [input_text_374] => 
            [submit_btn] => Invia Domanda
            [79bf657b10075b62285d31d38a70a019] => 1
            [cf_id] => 8
        )

    [chronoform_data_cf_id] => 8
)
Validation Errors: 
Array
(
)
    Gr
    GreyHead 09 Mar, 2013
    HI ezzine,

    That's easier to read but you still have the other two problems:

    [list=a]

  • The input names don't match the column names in the table

  • The form inputs were all empty when you submitted the form
    • [/list:o]


    Bob
    ez
    ezzine 13 Mar, 2013
    hello
    to be useful to others
      I finally found the last error was only forgetfulness of multi page action in on submit that is all.


    Thanks for everything and see you soon
    Gr
    GreyHead 13 Mar, 2013
    Hi ezzine,

    Great, good to hear that you got it all working.

    Bob
    ez
    ezzine 20 Mar, 2013
    hi

    I have an other problem is tha db save can't save the first page...
    can you help me i think taht is easy problem but i can't find it

    debug:

    Data Array: 
Array
(
    [option] => com_chronoforms
    [tmpl] => component
    [chronoform] => primaprova
    [event] => submit
    [cf_sid] => 12e00c2691af635e009c6682e7df5a2f
    [Itemid] => 
    [rechiesta_iap] => yes
    [elenco_sogg] => hgjk
    [cassa_previdenziale] => 
    [data_inps] => 346
    [sez_inps] => 34643
    [numero_inps] => 63463
    [agev_conc] => 
    [input_text_377] => 3463
    [foglio_num] => 4346
    [particella] => 346
    [agev_fis_formazione] => 
    [ag_1] => 346
    [ag_2] => 346
    [ag_3] => 346
    [ag_4] => 346
    [ag_5] => 346
    [ag_6] => 346
    [iscr_sis_previ] => 
    [parti_bando] => choice 1
    [cod_ass_bando] => 346
    [misure_bando] => 346
    [conc_aiuti_comuni] => choice 1
    [percen_amb_esp] => choice 1
    [altro_event_info] => choice 1
    [scrive_altro] => 23462346dhe
    [data_pres_domanda] => 
    [input_text_374] => 
    [submit_btn] => Invia Domanda
    [5bf3fb8a11fe34776e300f5bc4d3e951] => 1
    [Denominazione] => 
    [cf] => 34573457358fsxdf4235
    [pi] => partita ok 235234624
    [cciaa_prov] => catanzaro
    [numero_cciaa] => 
    [data_isc_cciaa] => 
    [ind_sede_legale] => 
    [comune_sede_legale] => 
    [prov_sede_legale] => 
    [den_cen_azi] => charika
    [ind_cen_azi] => via centro aziendale
    [comune_cen_azi] => papanase
    [prov_cen_azi] => crotone
    [pagina_succ_1] => Pagina Succissiva
    [possesso_dei_requisiti] => No
    [Capacita_Professionale] => choice 1
    [titolo] => laurea
    [dat_tit] => aaaa/mm/gg
    [scuola] => scuoal superiore
    [Attivita_Agricola] => choice 1
    [qual] => qualifica
    [azie_qual] => azienda qualifica
    [Periodo_Attività_agr] => 
    [Requisiti_Nessuno] => 
    [pagina_succ_2] => Pagina Successiva
    [tipo_col_1] => 
    [ett_col_1] => 
    [ore_col_1] => 
    [tipo_col2] => xsdfhx
    [ett_col_2] => 
    [ore_col_2] => 
    [tipo_col3] => 
    [ett_col_3] => 
    [ore_col_3] => 
    [tipo_col4] => 
    [ett_col_4] => 
    [ore_col_4] => 
    [tipo_col5] => 
    [ett_col_5] => 
    [ore_col_5] => 
    [tipo_alliv_1] => vnjlg
    [capi_1] => 
    [ore_alliv_1] => 
    [tipo_alliv_2] => 
    [capi_2] => 
    [ore_alliv_2] => 
    [tipo_alliv_3] => 
    [capi_3] => 
    [ore_alliv_3] => 
    [tipo_alliv_4] => 
    [capi4] => 
    [ore_alliv_4] => 
    [tipo_tras_1] => sdfgsd
    [quan_tras_1] => 
    [ore_tras_1] => 
    [tipo_tras_2] => 
    [quan_tras_2] => 
    [ore_tras_2] => 
    [tipo_tras_3] => 
    [quan_tras_3] => 
    [ore_tras_3] => 
    [tipo_tras_4] => 
    [quan_tras_4] => 
    [ore_tras_4] => 
    [tempo_lavoro_raggiunto] => 
    [tempo_lavoro_non_raggiunto] => No
    [pagina_succ_3] => Pagina Successiva
    [Valore_aziendale_agr] => 357
    [Percentuale_attribuzione_agr] => 357
    [Valore_individuale_agr] => 347
    [Valore_aziendale_red] => 3457
    [Percentuale_attribuzione_red] => 3457
    [Valore_individuale_red] => 457457
    [totale_red_agr] => 457457
    [red_att_non_agr] => 4745
    [red_lavoro_autonomo] => 745745
    [red_impresa] => 7457457
    [red_diversi] => 457457
    [totale_red_non_agr] => 457
    [totale_red_lavoro] => 457457
    [red_agr_ragg] => No
    [red_agr_non_ragg] => 
    [nessun_redito] => 
    [pagina_succ_4] => Pagina Succissiva
    [chronoform_data] => Array
        (
            [cf_uid] => 9e6ada59b6cf4efb58658712dfaea076
            [cf_created] => 2013-03-20 10:02:44
            [cf_created_by] => 0
            [cf_ipaddress] => 89.97.190.194
            [cf_user_id] => 0
            [option] => com_chronoforms
            [tmpl] => component
            [chronoform] => primaprova
            [event] => submit
            [cf_sid] => 12e00c2691af635e009c6682e7df5a2f
            [Itemid] => 
            [rechiesta_iap] => yes
            [elenco_sogg] => hgjk
            [cassa_previdenziale] => 
            [data_inps] => 346
            [sez_inps] => 34643
            [numero_inps] => 63463
            [agev_conc] => 
            [input_text_377] => 3463
            [foglio_num] => 4346
            [particella] => 346
            [agev_fis_formazione] => 
            [ag_1] => 346
            [ag_2] => 346
            [ag_3] => 346
            [ag_4] => 346
            [ag_5] => 346
            [ag_6] => 346
            [iscr_sis_previ] => 
            [parti_bando] => choice 1
            [cod_ass_bando] => 346
            [misure_bando] => 346
            [conc_aiuti_comuni] => choice 1
            [percen_amb_esp] => choice 1
            [altro_event_info] => choice 1
            [scrive_altro] => 23462346dhe
            [data_pres_domanda] => 
            [input_text_374] => 
            [submit_btn] => Invia Domanda
            [5bf3fb8a11fe34776e300f5bc4d3e951] => 1
            [Denominazione] => 
            [cf] => 34573457358fsxdf4235
            [pi] => partita ok 235234624
            [cciaa_prov] => catanzaro
            [numero_cciaa] => 
            [data_isc_cciaa] => 
            [ind_sede_legale] => 
            [comune_sede_legale] => 
            [prov_sede_legale] => 
            [den_cen_azi] => charika
            [ind_cen_azi] => via centro aziendale
            [comune_cen_azi] => papanase
            [prov_cen_azi] => crotone
            [pagina_succ_1] => Pagina Succissiva
            [possesso_dei_requisiti] => No
            [Capacita_Professionale] => choice 1
            [titolo] => laurea
            [dat_tit] => aaaa/mm/gg
            [scuola] => scuoal superiore
            [Attivita_Agricola] => choice 1
            [qual] => qualifica
            [azie_qual] => azienda qualifica
            [Periodo_Attività_agr] => 
            [Requisiti_Nessuno] => 
            [pagina_succ_2] => Pagina Successiva
            [tipo_col_1] => 
            [ett_col_1] => 
            [ore_col_1] => 
            [tipo_col2] => xsdfhx
            [ett_col_2] => 
            [ore_col_2] => 
            [tipo_col3] => 
            [ett_col_3] => 
            [ore_col_3] => 
            [tipo_col4] => 
            [ett_col_4] => 
            [ore_col_4] => 
            [tipo_col5] => 
            [ett_col_5] => 
            [ore_col_5] => 
            [tipo_alliv_1] => vnjlg
            [capi_1] => 
            [ore_alliv_1] => 
            [tipo_alliv_2] => 
            [capi_2] => 
            [ore_alliv_2] => 
            [tipo_alliv_3] => 
            [capi_3] => 
            [ore_alliv_3] => 
            [tipo_alliv_4] => 
            [capi4] => 
            [ore_alliv_4] => 
            [tipo_tras_1] => sdfgsd
            [quan_tras_1] => 
            [ore_tras_1] => 
            [tipo_tras_2] => 
            [quan_tras_2] => 
            [ore_tras_2] => 
            [tipo_tras_3] => 
            [quan_tras_3] => 
            [ore_tras_3] => 
            [tipo_tras_4] => 
            [quan_tras_4] => 
            [ore_tras_4] => 
            [tempo_lavoro_raggiunto] => 
            [tempo_lavoro_non_raggiunto] => No
            [pagina_succ_3] => Pagina Successiva
            [Valore_aziendale_agr] => 357
            [Percentuale_attribuzione_agr] => 357
            [Valore_individuale_agr] => 347
            [Valore_aziendale_red] => 3457
            [Percentuale_attribuzione_red] => 3457
            [Valore_individuale_red] => 457457
            [totale_red_agr] => 457457
            [red_att_non_agr] => 4745
            [red_lavoro_autonomo] => 745745
            [red_impresa] => 7457457
            [red_diversi] => 457457
            [totale_red_non_agr] => 457
            [totale_red_lavoro] => 457457
            [red_agr_ragg] => No
            [red_agr_non_ragg] => 
            [nessun_redito] => 
            [pagina_succ_4] => Pagina Succissiva
            [chronoform_data] => 9eca798a3f6f57dce16a4339a3705a0a,2013-03-20 09:24:42,0,89.97.190.194,0,com_chronoforms,component,primaprova,submit,963519ef94334e17ad4d3a342e6db962,,yes,hgjk,,,,,,,,,,,,,,,,,,,,,,,,,,Invia Domanda,1,1
            [chronoform_data_id] => 
            [chronoform_data_cf_id] => 1
            [cf_id] => 1
        )

    [chronoform_data_id] => 
    [chronoform_data_cf_id] => 1
)
Validation Errors: 
Array
(
)





    tks a lot
    Gr
    GreyHead 20 Mar, 2013
    Hi ezzine,

    Everything there looks OK :-(

    Please take a Form Backup using the icon in the Forms Manager and post it here (as a zipped file) or PM or email it to me and I'll take a closer look.

    Bob
    Gr
    GreyHead 20 Mar, 2013
    Hi ezzine,

    I'm afraid that I don't see anything obviously wrong with the form either, I'll try to find time to check it through in more detail.

    Bob
    ez
    ezzine 20 Mar, 2013
    ok tks i am waiting
    This topic is locked and no more replies can be posted.