Firstly I would like to say that you've got a fantastic plugin. Nice work.
We've recently noticed that some of our form submissions are not appearing in the Database. Even though the submissions arrive through via email without fuss. We figure that it may have to do with the following:
The function cf_getip() can sometimes return a comma separated list of IP addresses, because of its use of HTTP_X_FORWARDED_FOR.
This returned value then cannot INSERT INTO $wpdb->cformssubmissions. Because the IP address row in this table has been restricted to 15 varchars.
May I plase suggest a tiny modification to the above mentioned function, so that it only returns one IP address:
if (($pos= strrpos($ip_addr, \",\")) !== false) $ip_addr = substr($ip_addr, $pos+1);
Unfortunately, the above has not completely solved our problem. We still occasionally (approx 1 in 20) receive a submission via email that is not tracked in the database. And I am at a loss as to why this could be happening.
It is difficult to replicate. When we do receive an email submission that is not tracked, we resubmit those same details into the form ourselves, and find that it does successfully save into the DB.
Has anyone else experienced anything similar to this? I am starting to think that it may even be due to our website hosting.
We worked out that those above mentioned submissions weren't being saved because the submitters had very long email addresses.
More than 40 characters long. As was defined in the CREATE TABLE email varchar(40)
We fixed it by modifying that column to have varchar(250).
May I please suggest that the default length of this column be increased for a future release of your plugin.
Most Users Ever Online: 959
Currently Browsing this Page:
Guest Posters: 3748
Newest Members: juredujmovic, dreamkeeper, rajattyagi, wrokaa, lukass
Moderators: Paul (421), cnymike (8), sonika (95)
Administrators: Oliver (6400), Nicky (3)