I just have been notified that the webforms module isn't working proper anymore on one of our websites and I was able to reproduce the problem.
When a new webform-element is created and the configuration form of the new element is saved, it does not show up and doesn't exist in the overview/database.

Some steps I've taken to solve this problem/find out what actually IS the problem:
I have updated the installation of Webforms from 6.x-3.17 to 6.x-3.18 (the latest version), but this didn't solve the problem.
The error log of php/lighttpd does not show anything of interest.

Is there anybody else with the same problem?

Comments

quicksketch’s picture

quicksketch
he/him
commented

I have updated the installation of Webforms from 6.x-3.7 to 6.x-3.9 (the latest version), but this didn't solve the problem.

3.18 is actually the latest version. 3.9 is almost 2 years old. Could you clarify which version you're on? Be sure you run update.php after the upgrade, a lot has changed since the 3.7 version.

theemstra’s picture

theemstra commented

Im so sorry, the versions I stated before are incorrect.
We updated from 3.17 to 3.18.

Just went checking the log @ watchdog:
>> A Webform component could not be saved because a timeout occurred while trying to acquire a lock for the node.
Nothing strang is found anywhere else.

Abilnet’s picture

Abilnet commented

I'm having the same issue (webform 6.x-3.18)

Error log is showing:

Unknown column 'form_key' in 'field list' query: INSERT INTO webform_component (nid, cid, pid, form_key, name, type, value, extra, mandatory, weight) VALUES (69910, 1, 0, 'kerro_mielipiteesi_markkinapalstasta', 'Kerro mielipiteesi markkinapalstasta', 'grid', '', 'a:7:{s:7:\"options\";s:86:\"sm|Täysin samaa samaa mieltä\r\ns|Samaa mieltä\r\ne|Eri mieltä\r\nte|Täysin eri mieltä\";s:9:\"questions\";s:58:\"tarp|Markkinapalsta on tarpeellinen ja tervetullut palvelu\";s:13:\"title_display\";i:0;s:7:\"private\";i:0;s:7:\"optrand\";i:0;s:5:\"qrand\";i:0;s:20:\"conditional_operator\";s:1:\"=\";}', 0, 0) tiedostossa /home/xxxxxxx/public_html/sites/all/modules/webform/includes/webform.components.inc line 743.

theemstra’s picture

theemstra commented
Version: 6.x-3.9 » 6.x-3.18
Component: User interface » Code

Changing the version to the right one.

quicksketch’s picture

quicksketch
he/him
commented
Category: bug » support

A lack of a "form_key" column will have devastating effects on Webform (as you're seeing). Check if you need to run update.php. If not, I'm afraid the only "official" solution available to you would be to disable, uninstall (via the Uninstall tab), and then re-enable the module. This approach will start you with a clean Webform database table and erase all your existing data in the process, but it will certainly solve the problem you're having.

Abilnet’s picture

Abilnet commented

Reinstalling helped, works great again!

Thank you quicksketch for help, appreciated!

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Fixed

Super! Anyone else finding this issue and trying this solution, once again be careful with this approach because it will delete all the forms and values you have created thus far with Webform.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Anonymous’s picture

(not verified) commented
Issue summary: View changes

**EDIT: Changed incorrect version numbers)**