Email sent, but rows missing in Contact Form DB

  • morespinach

    (@morespinach)


    10 years, 8 months ago

    [Topic title and initial post content moderated. Your issues are no more urgent than anyone else’s.]

    Using Contact Form 7, the emails are being sent. There’s some issue with that already (the field names are not being registered properly — perhaps an issue with UTF8?), but more importantly for all the emails that are being sent to us via form submissions as updates, 3 out of 10 are NOT being added to the Contact Form DB.

    Why? Any ideas? Please help!

    http://wordpress.org/plugins/contact-form-7-to-database-extension/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter morespinach

    (@morespinach)

    10 years, 8 months ago

    I looked into the PhyMyAdmin for this plugin. In the database, the query is being grouped by “submit time”.

    This is a horrible piece of code!

    The “submit time” is mostly the same for many concurrent submissions. As such the grouping (which therefore needs that each field is shown based on MAX(if.. statements) is flawed too.

    Any thoughts on how I can better query the data to show each unique submission?

    Thread Starter morespinach

    (@morespinach)

    10 years, 8 months ago

    Just to add. The idea to store the submit_time field as decimal(16,4) is not a smart one at all. Why not just rely on a timestamp, which already exists? That way the queries will work. Right now the decimals of time are basically the same across most records.

    The submit_time should be timestamp, and should default to now() or something. It’ll be much cleaner that way, and more importantly, it would at least work!

    Thread Starter morespinach

    (@morespinach)

    10 years, 8 months ago

    For anyone having the same issue, if it helps, this is what I did: I created a regular timestamp field in the table for this plugin.

    Important to have the default value as “CURRENT_TIMESTAMP“. This way we don’t need to muck around with the INSERT and UPDATE queries.

    Only in the view function, make sure the “GROUP BY” is by this new field, and not by the usual “submit_time“.

    How I wish the developer was not trying to be over-creative with that decimal rubbish. There’s a reason the TIMESTAMP type exists in the DB. Not many people need to store microseconds.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Email sent, but rows missing in Contact Form DB’ is closed to new replies.