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
Deleting a form throws tracking into chaos
January 4, 2008
1:59 am

Please replace the ??? with your data!

  • Your URL:
  • The browser used: Firefox (latest version)
  • cforms version: Latest version (6.41)
  • Your Wordpress version: Latest version (2.3.2)

[desc]:Hey cforms users,

I accidentally deleted a form (didn't mean to) and consequently pressed ESC to stop the server request. I found out the request did make it and the form was deleted…

But, my problem is now when I go to the Tracking page all my ID's are out. The "Feature request" messages are now headlining as "User Research" and they're all mixed up. I believe the ID's of the forms hasn't updated…

How can I fix this up? :D

Thanks! cforms II rules!

January 4, 2008
9:34 am
Munich, Germany
Forum Posts: 6400
Member Since:
March 6, 2005

Deleting forms doesn't touch the tracked data, nothing is lost, that's the good news.

However by deleting one form, all succeeding forms move one # to the left, ie. #3 becomes #2 etc. Hence the false association of form data and form ID/name.

Two options:

  1. You can use PHPmyadmin to run a SQL UPDATE command to move all form data with the old form_id to the new form ID. Probably the cleanest way (PLEASE MAKE DB BACKUP FIRST).
    off top of my head (no guarantee!):
    • UPDATE `wp_cformssubmissions` set `form_id`=XXX WHERE `form_id`=YYY;
      with XXX = new form id
      and YYY = old form id
  2. Or make a backup copy of the current form that replaced your old form, reconfigure this form to be your old form again, add a new form and make this your backed up form, example:
    • old form setup:  1 2 3 4
    • #3 gets deleted, leaving: 1 2 3(old4)
    • now backup #3 (old #4)
    • reconfigure #3 (old#4) to be old #3
    • add new form: 1 2 3(again old#3) 4(new form)
    • restore backed up form to slot #4

If you are not comfortable with MySQL option 2 may be 'easier', otherwise, I recommend option 1.



Forum Timezone: Europe/Berlin

Most Users Ever Online: 959

Currently Online:
29 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: 3761

Members: 1463

Moderators: 3

Admins: 2

Forum Stats:

Groups: 1

Forums: 4

Topics: 5358

Posts: 18739

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

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

Administrators: Oliver (6400), Nicky (3)