No you didn’t mess anything up, this is a conflict with MySQL. What version do you have? Also who is your host?
Thread Starter
nyscaa
(@nyscaa)
MySQL 5.5.12
I am the host
Win Server 2008 / IIS 7
Output of the DB Check under Forms / Advanced setting
NYSCAA Members Site Access Restricted
Howdy, AdminUser | Log Out
New Post
Help
Forms table (wp_fm_forms)… OK
Items table (wp_fm_items)… OK
Templates table (wp_fm_templates)… OK
Settings table (wp_fm_settings)… OK
Forms table…
For duplicate IDs and slugs…
OK
Items table…
Checking form IDs exists…
OK
Checking unique names…
SLUGS OK
Templates entries:
Title: Filename: fm-form-default.php Modified: 1309185059
Title: Filename: fm-summary-default.php Modified: 1309185059
Title: Filename: fm-summary-multi.php Modified: 1309185059
Settings entries:
Name: email_admin Value: YES
Name: email_reg_users Value: YES
Name: recaptcha_private Value:
Name: recaptcha_public Value:
Name: recaptcha_theme Value: red
Name: required_msg Value: ‘%s’ is required.
Name: submitted_msg Value: Thank you! Your data has been submitted.
Name: template_form Value:
Name: text_validator_0 Value: a:4:{s:4:”name”;s:6:”number”;s:5:”label”;s:12:”Numbers Only”;s:7:”message”;s:27:”‘%s’ must be a valid number”;s:6:”regexp”;s:27:”/^\s*[0-9]*[\.]?[0-9]+\s*$/”;}
Name: text_validator_1 Value: a:4:{s:4:”name”;s:5:”phone”;s:5:”label”;s:12:”Phone Number”;s:7:”message”;s:33:”‘%s’ must be a valid phone number”;s:6:”regexp”;s:36:”/^.*[0-9]{3}.*[0-9]{3}.*[0-9]{4}.*$/”;}
Name: text_validator_2 Value: a:4:{s:4:”name”;s:5:”email”;s:5:”label”;s:6:”E-Mail”;s:7:”message”;s:35:”‘%s’ must be a valid e-mail address”;s:6:”regexp”;s:51:”/^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/”;}
Name: text_validator_3 Value: a:4:{s:4:”name”;s:4:”date”;s:5:”label”;s:15:”Date (MM/DD/YY)”;s:7:”message”;s:30:”‘%s’ must be a date (MM/DD/YY)”;s:6:”regexp”;s:35:”/^[0-9]{1,2}.[0-9]{1,2}.[0-9]{2}.$/”;}
Name: text_validator_count Value: 4
Name: title Value: New Form
Done.
The problem is that the ‘title’ field is a text type, and MySQL should not be expecting a default value for text fields according to the manual, yet some configurations do. Beyond that, I don’t know anything about configuring MySQL.
Thread Starter
nyscaa
(@nyscaa)
IS the table invovled wp_fm_forms? or …. ?
All of the tables, including the data table for each form, will have ‘text’ fields. So this is wp_fm_forms, wp_fm_items, and wp_fm_data_*.
I found a bug and just posted an update that should fix the problem you were having, 1.6.14.
