[Plugin: Contact Form 7 to Database Extension] url's no longer appear in the database…

  • I’ve been working with “Fast & Secure Contact Form” today, and installed the plugin so that it would also work with ‘Contact Form to DB’. So far it’s been working well and things get to the database.

    For some reason, and I’d swear this was working the first time around, suddenly the links in the (database to attachments that were uploaded) no longer are links. It appears as just text with the name of the uploaded file, but you cannot click it to see what is there. In the email I receive the attachments are included, but am I wrong about attachments ever getting sent to the database.

    I know the contact form plugin says that attachments are deleted after they’re sent out in the email, so maybe I only imagined seeing the link in the database. But I sure thought it was there once, so maybe I switched a setting and didn’t realize it.

    Anyone have any suggestions? I’d definitely prefer to have a copy of everything stored in the database if that’s workable.
    -C

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

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

    (@msimpson)

    Although the contact form plugin deletes it copy when done, the db plugin takes its own copy and stores that in the database. I think the files are still in the DB, but for some reason the plugin is not generating the link. If you run this query in your DB, it will show you any entries that have files.

    SELECT *
FROM  wp_cf7dbplugin_submits
WHERE file IS NOT NULL
AND LENGTH( file ) = 0
    Thread Starter chrislx

    (@chrislx)

    Hi Michael,
    After a test I just did I think this may have something to do with replacing the field names sent from the contact form. I used the second contact form as a clean sample, and only added one attachment field. Then, still on the contact form, I did some replacing of the field names to make them more readable (i.e. ex_field1=Attachment, etc.). I did not chose to not send any field names, and I touched nothing in the database options. Saving all that and testing the form:

    After four tests, any time I had replaced field names to something more readable, it only saved the wording as text (i.e “File is attached:Test-Image.jpg”). When I removed the entries to replace the names, the text came through as a working URL (in blue..perfect).

    I also checked the DB to see what was in ‘wp_cf7dbplugin_submits’, and it appears that the times the link failed there is nothing in the DB. The other times the image is there as a [BLOB-28Kib] entry links to the image.

    So, maybe the issue is with the passing of renamed field names by FSCF and not by your plug-in. I’m going to do a few more tests to check whatever I can imagine, but, so far, renaming field names kills the link for me.
    Thanks for your quick response..your DB connection is a terrific find.
    -C

    Plugin Author Michael Simpson

    (@msimpson)

    correction: 

    SELECT *
FROM  wp_cf7dbplugin_submits
WHERE LENGTH( file ) > 0
    Thread Starter chrislx

    (@chrislx)

    Tried your query just now and of the four test submissions the attachments are only in the two of them. So it sure looks like renaming the field names breaks whatever connection there should have been to get the attachment.
    Thanks,
    -C

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: Contact Form 7 to Database Extension] url's no longer appear in the database…’ is closed to new replies.