Form with uploaded files

  • Resolved helvil

    (@helvil)


    8 years, 8 months ago

    Hello,

    Thanks a lot for your plugin.
    I’m using WordPress 4.4.2. in French with Gravity Form 1.9.17.5 and Contact Form DB 2.10.2.

    I have an issue using the Admin table listing all entries (page admin.php?page=CF7DBPluginSubmissions&form_name=…) when the form contains uploaded files :
    – database contains the correct files (BLOB fields are correctly set, checked through phpmyadmin)
    – URL that should point to the uploaded file does not work and gives a “file not found” error.

    For example : xxxx/wp-admin/admin-ajax.php?action=cfdb-file&s=1457778786.9151&form=Inscription+concours+d%27entr%C3%A9e+2016&field=Photographie
    gives an error.

    Performing a SQL query in the database :
    SELECT * FROMwp_cf7dbplugin_submitswheresubmit_time=1457778786.9151 andfield_name='Photographie'

    Finds the relevant row :
    submit_time form_name field_name field_value field_order file
    1457778786.9151 Inscription concours d’entrée 2016 Photographie pamela5.JPG 68 [BLOB – 4,1 Mio]

    I would expect from the link “admin-ajax.php?action=cfdb-file” to read data from the table and export the BLOB but this does not work.

    Any solution to fix this and allow us to extract submitted files ?

    Thank you for your answer.

    Hélène
    https://www.cefedem-lorraine.fr
    https://www.ads-software.com/plugins/contact-form-7-to-database-extension/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    The plugin should be running this query. Can you check if it returns results in PHPMyAdmin?

    SELECT field_value, file FROM wp_cf7dbplugin_submits
WHERE submit_time = 1457778786.9151
AND form_name = 'Inscription concours d''entrée 2016'
AND field_name = 'Photographie'
    Plugin Author Michael Simpson

    (@msimpson)

    Actually try this one:

    SELECT field_value, file FROM wp_cf7dbplugin_submits WHERE submit_time = 1457778786.9151 AND form_name = 'Inscription concours d\\\'entrée 2016' AND field_name = 'Photographie'

    Plugin Author Michael Simpson

    (@msimpson)

    I think I found the problem. I will be releasing an update with a fix in the next day or two.

    Thread Starter helvil

    (@helvil)

    Thank you !
    It’s now working : the uploaded files can be found by clicking on the link using the Admin table listing all entries.

    Merci beaucoup !

    Hélène

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Form with uploaded files’ is closed to new replies.