cforms II User Forum

Registration is currently disabled.


Login form protected by Login LockDown.

Lost password?
Advanced Search

— Forum Scope —


— Match —


— Forum Options —


Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
Only some submissions not saved into Database
Bug report
November 1, 2013
1:44 am

Hi Oliver.

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);
return $ip_addr;

Thank you

November 5, 2013
1:00 am

An update:

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.

November 6, 2013
1:24 am

Another Update:

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.


Forum Timezone: Europe/Berlin

Most Users Ever Online: 959

Currently Online:
27 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

tracedef: 43

mores: 21

Gyrus: 20

frozenwaste: 18

asuffredini: 15

photoworks: 14

Member Stats:

Guest Posters: 3763

Members: 1463

Moderators: 3

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 5359

Posts: 18742

Newest Members: juredujmovic, dreamkeeper, rajattyagi, wrokaa, lukass

Moderators: Paul (421), cnymike (8), sonika (95)

Administrators: Oliver (6400), Nicky (3)