Contact Form DB File Uploads not all Linking

  • When viewing Contact Form 7 submissions via Contact Form DB I am seeing some images linked and others are not. These submissions date back to January of this year and we’ve updated WP to 4.2.1 since then with the same intermittent results. I would estimate that about 30% of submitted files do not appear to be saved to the database.

    As a test I created a shortcode to display the images on a public page and the same images that were not linked in the Contact Form DB table are not displaying on the public page.

    The max file upload size for both the website and the form is 8mb. I would think if the max upload size was hit the form would throw an error and not submit at all.

    I’m wondering A, what is causing this and B, can we recover the missing images via phpmyadmin? Thanks in advance for the great plugin and any help!

    [file* applicant-photo-886 limit:8mb filetypes:gif|png|jpg|jpeg]
    [contact-form-7 id=”810″ title=”Application”]

    https://tinypic.com/r/xmodgy/8

    https://www.ads-software.com/plugins/contact-form-7-to-database-extension/

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

    (@msimpson)

    That is very strange. I doubt it has anything to do with the upgrade.

    When you look at a form submission, does it have a file name or link for the upload? Then when you click on it, what happens?

    Thread Starter InHouse

    (@inhouse)

    The screenshot I posted shows what I see. Some filenames in the database table are linked and some are not. The linked filenames work fine. The filenames that aren’t linked don’t do anything of course and I don’t have any way of recovering them. Is there anything in particular I could look for in my server error log?

    Plugin Author Michael Simpson

    (@msimpson)

    Let’s check the database directly. You’ll need to get the submit_time key for the submission.

    On the short code builder page, create a cfdb-table short code
    – in “show” put “submit_time,UPLOAD_FIELD_NAME”
    – then click the short code to see the results.
    – copy the submit_time from one of the bad entries. It will be a number like 1363479099.2186

    Then go to PhpMyAdmin, execute
    SELECT * FROMwp_cf7dbplugin_submitswhere submit_time = '1363479099.2186'
    (using your submit time).

    One of the rows returned will be for the upload field. In the “file” column, it should be something like “[BLOB – 21.8 KiB]”, If it is “NULL” then it is empty.

    Thread Starter InHouse

    (@inhouse)

    I’m seeing “NULL” in the file upload row for images that aren’t linked and BLOB for the correctly linked images.

    Plugin Author Michael Simpson

    (@msimpson)

    missing some spaces…

    SELECT * FROM wp_cf7dbplugin_submits WHERE submit_time = '1430252936.2726'

    Thread Starter InHouse

    (@inhouse)

    Sorry, I was editing my post when you replied. I got the query working fine but have discovered the images aren’t being saved every time.

    Thread Starter InHouse

    (@inhouse)

    Just checking in. Where do we go from here? Do we need to look at the server error log for anything in particular? If I know what to look for I could share the contents with you.

    ?? I have the same problem. Only files small size about < 1MB are linked, other files > 1MB only show name of file, although I set the accepted file size > 10MB.

    https://prntscr.com/79hyj3

    Thread Starter InHouse

    (@inhouse)

    Any luck @thai_kont ? I haven’t heard back from the developer about a possible solution or anything I can do to help track down the cause. All we’ve determined is that the images aren’t always saving to the database but no pattern or cause.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Contact Form DB File Uploads not all Linking’ is closed to new replies.