store filename in db not working with more then 1 upload

i succesfully created a form with 2 file upload fields,
fieldnames are datei1 and datei2.
then i created a db table with the two filenames datei1 and datei2
in the setup section a fileupload action with configuration
datei1:jpg-png-gif-jpeg-bmp
datei2:jpg-png-gif-jpeg-bmp
is set and in the db save setting the table is selected.

when i submit the form, both files are uploaded correctly,
but only datei1 is filled with correct filen name, datei2 is empty at all!

any suggestions to fix that?

regards Wolfgang

Hi Wolfgang,

Please drag a Debugger action into the On Submit event, then submit the form and copy and paste the debug results here.

Bob

ok, here is the debugging information:

Array
(
    [chronoform] => Meldung
    [event] => submit
    [Vorname] => 
    [Name] => Woifi
    [Email] => wurzelsepp@gmail.com
    [telefon] => 
    [PLZ] => 1210
    [fahrzeug] => Citroen
    [Baujahr] => 2000
    [Versicherung] => Nein
    [button12] => Absenden
    [Meldung] => 
)

Array
(
)

regards Wolfgang

Hi Wolfgang,

I suspect that you have the Debugger at the start of the On Submit event, Please move it down to the end so that the results if the File Upload and DB Save actions are included.

Bob

Hi Bob,
this sounds a little bit stupid, but without having changed anything (execpt the Debugger statement), no it works
and it shows also the correct arrays, i have attached the hole debug info below, so thanks for your help!
I would insert another 3 upload fileds later and test the hole thing again!
regards Wolfgang

------ Debug-Info:

Array
(
    [chronoform] => Meldung
    [event] => submit
    [Vorname] => 
    [Name] => Woifi
    [Email] => wurzelsepp@gmail.com
    [telefon] => 
    [PLZ] => 1210
    [fahrzeug] => CLK
    [Baujahr] => 2000
    [Versicherung] => Nein
    [button12] => Absenden
    [Meldung] => 
    [datei1] => 20170130123701_320_-347993115.jpg
    [datei2] => 20170130123701_11116983_806073449429185_1204823080_n.jpg
    [id] => 3
)

Array
(
    [datei1] => Array
        (
            [name] => 20170130123701_320_-347993115.jpg
            [original_name] => 320_-347993115.jpg
            [path] => /home/.sites/93/site4447169/web/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130123701_320_-347993115.jpg
            [size] => 31135
            [link] => http://www.blechschaden.online/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130123701_320_-347993115.jpg
        )

    [datei2] => Array
        (
            [name] => 20170130123701_11116983_806073449429185_1204823080_n.jpg
            [original_name] => 11116983_806073449429185_1204823080_n.jpg
            [path] => /home/.sites/93/site4447169/web/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130123701_11116983_806073449429185_1204823080_n.jpg
            [size] => 20369
            [link] => http://www.blechschaden.online/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130123701_11116983_806073449429185_1204823080_n.jpg
        )

)

Errors

Array
(
)

Debug Info

Array
(
    [2] => Array
        (
            [Files Upload] => Array
                (
                    [0] => Upload routine started for file upload by : datei1
                    [1] => /home/.sites/93/site4447169/web/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130123701_320_-347993115.jpg has been uploaded successfully.
                    [2] => Upload routine started for file upload by : datei2
                    [3] => /home/.sites/93/site4447169/web/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130123701_11116983_806073449429185_1204823080_n.jpg has been uploaded successfully.
                )

        )

    [7] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `yvtu4_chronoengine_chronoforms_datatable_Meldung` (`Vorname`, `Name`, `Email`, `telefon`, `PLZ`, `fahrzeug`, `Baujahr`, `Versicherung`, `datei1`, `datei2`, `user_id`, `uniq_id`, `created`) values ('', 'Woifi', 'wurzelsepp@gmail.com', '', '1210', 'CLK', '2000', 'Nein', '20170130123701_320_-347993115.jpg', '20170130123701_11116983_806073449429185_1204823080_n.jpg', '527', '9b327e63eb102f6bf7cbf7f844bfe76aa715ddb9', '2017-01-30 12:37:01');
                        )

                )

        )

)

hi bob,
its me again ;-)

now i did following steps:
1. delete the database tabel
2. insert 3 more file upload fileds in the form and saved the form
3. create the table again with the manager
4. select the database table in the form again
5. all is uploaded correct, but in the insert statement there are only the 2 former upload fields, i attached the debug info below:
so please wehre is the bug?

Array
(
    [2] => Array
        (
            [Files Upload] => Array
                (
                    [0] => Upload routine started for file upload by : datei1
                    [1] => /home/.sites/93/site4447169/web/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130134232_1_hacked.png has been uploaded successfully.
                    [2] => Upload routine started for file upload by : datei2
                    [3] => /home/.sites/93/site4447169/web/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130134232_004.jpg has been uploaded successfully.
                    [4] => Upload routine started for file upload by : datei3
                    [5] => /home/.sites/93/site4447169/web/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130134232_320_-347993115.jpg has been uploaded successfully.
                    [6] => Upload routine started for file upload by : datei4
                    [7] => /home/.sites/93/site4447169/web/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130134232_50-122144-krankenschwester-kostuem2_1.jpg has been uploaded successfully.
                    [8] => Upload routine started for file upload by : datei5
                    [9] => /home/.sites/93/site4447169/web/components/com_chronoforms5/chronoforms/uploads/Meldung/20170130134232_fanbus.png has been uploaded successfully.
                )

        )

    [7] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `yvtu4_chronoengine_chronoforms_datatable_Meldung` (`Vorname`, `Name`, `Email`, `telefon`, `PLZ`, `fahrzeug`, `Baujahr`, `Versicherung`, `datei1`, `datei2`, `user_id`, `uniq_id`, `created`) values ('', 'Woifi', 'wurzelsepp@gmail.com', '', '1210', 'CLK', '2017', 'Ja', '20170130134232_1_hacked.png', '20170130134232_004.jpg', '527', 'cb6e8e9c7f09ebcec55d8b4b39d93868fbc91447', '2017-01-30 13:42:32');
                        )

                )

        )

)

Hi Wolfgang,

Please click the 'Delete Cache' icon in the Forms Manager toolbar to clear the CF database info which is cached for 24 hours. You need to do this any time that you change the table structure.

Bob

thanks a lot, that help!!!

just delete cache and it worked, for all file types, even if u add a textfield to the form!

many thanks for your help

greetings from vienna/austria