• I just installed and activated this plugin. When I go to Forms in the dashboard and attempt to add a new Form I receive

    Field ‘title’ doesn’t have a default value

    Did I miss a step in the setup?

    Thanks!!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author hoffcamp

    (@hoffcamp)

    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.

    Plugin Author hoffcamp

    (@hoffcamp)

    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 …. ?

    Plugin Author hoffcamp

    (@hoffcamp)

    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_*.

    Plugin Author hoffcamp

    (@hoffcamp)

    I found a bug and just posted an update that should fix the problem you were having, 1.6.14.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Field 'title' doesn't have a default value’ is closed to new replies.