PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Forms not saving entries and sending blank notifications e-mails

Gravity Support Forums » Plugin Support » Gravity Forms

  1. post@smart-media.no
    Member

    Hi!
    I have some problems with my Gravity Forms not saving the submitted entries. I've searched the Supportforum for similar issues but none of the suggested fixes seems to help. I've tried to reinstall the plugin, but the problem persist. With wp_debug activated I get the following errors:

    WordPress database error: [Column count doesn't match value count at row 1]
    INSERT INTO wp_rg_lead_detail (lead_id,form_id,field_number,value) VALUES (1,1,1,000000,'testining')

    WordPress database error: [Column count doesn't match value count at row 1]
    INSERT INTO wp_rg_lead_detail (lead_id,form_id,field_number,value) VALUES (1,1,2,000000,'testing')

    Anyone have an idea how to fix this?

    Thanks,
    Erlend

    Posted 12 years ago on Friday August 3, 2012 | Permalink

  2. Chris Hajer
    Key Master

    Somehow, four values are trying to be inserted into a table with five columns. That won't work. The lead_detail table (in the most current Gravity Forms any way) has five columns. Are you using another plugin related to Gravity Forms that is modifying the data that is being inserted, or are you inserting leads into the database directly with some custom code?

    What version of Gravity Forms are you using?

    This is not a common error, and may be something specific to your installation. We're going to need more information to help you out. Thank you.

    Posted 12 years ago on Monday August 6, 2012 | Permalink

  3. post@smart-media.no
    Member

    I use the following versions:
    PHP Versjon 5.3.13
    MySQL Versjon 5.0.95
    WordPress Versjon 3.4.1
    Gravity Forms Versjon 1.6.5.1

    I'm not using another plugin related to Gravity Forms.

    I've tried the following:
    Reinstalled the Gravity Forms plugin and deleted all entries in the database. Same errors still occurs.
    I've cloned the installation to another site and the Gravity Forms works great with all plugins enabeled.

    Do you need som more information from me regarding the site?

    Thanks,
    Erlend

    Posted 12 years ago on Monday August 6, 2012 | Permalink

  4. Chris Hajer
    Key Master

    Is the cloned site using the same database and database user? I can't imagine where the insert with the wrong number of parameters is coming from. The id is missing. Maybe it's related to a security function on the server, something like mod_security or suhosin patch for PHP?

    Does this happen for all forms on the server where the problem exists?

    Can you create a new form with just a field or two and see if it inserts properly? Maybe it's a problem with just the one form?

    This is certainly a strange issue that I have not seen before.

    Posted 12 years ago on Monday August 6, 2012 | Permalink

  5. post@smart-media.no
    Member

    I've now tried the following:

    1. Deleted the Gravity Forms plugin
    2. Made sure that all the tables regarding the plugin got deleted in the database.
    3. Installed the latest version of Gravityform
    4. Created a new test form
    5. The same errors occours:

    WordPress database error: [Column count doesn't match value count at row 1]
    II-N-S-E-R-T I-N-T-O wp_rg_lead_detail (lead_id,form_id,field_number,value) VALUES (2,1,1,000000,'test')

    WordPress database error: [Column count doesn't match value count at row 1]
    I-N-S-E-R-T I-N-T-O wp_rg_lead_detail (lead_id,form_id,field_number,value) VALUES (2,1,2,000000,'test')

    WordPress database error: [Column count doesn't match value count at row 1]
    I-N-S-E-R-T I-N-T-O wp_rg_lead_detail (lead_id,form_id,field_number,value) VALUES (2,1,3,000000,'Tredje valg')

    The wp_rg_led_detail only got only 4 columns and the form is trying to insert 5 fields.

    id
    lead_id
    meta_key
    meta_value

    I used manageWP to clone the site to a new server, but the database user is the same, and the database migrated to the new url.

    Thanks,

    Posted 12 years ago on Wednesday August 8, 2012 | Permalink

  6. Chris Hajer
    Key Master

    Can I have a WordPress administrator login for the cloned site where this occurs? Hopefully somewhere I can break things and not worry about this being a production site. I will also need access to a control panel or something like phpMyAdmin. Please email those details to chris@rocketgenius.com - thank you.

    It's a strange issue and I am curious what is causing it.

    Posted 12 years ago on Wednesday August 8, 2012 | Permalink

  7. post@smart-media.no
    Member

    - I have checked and deactivate the plugin one by one in a local setup. I found the issue in WP-Event plugin. (http://wordpress.org/extend/plugins/wp-events/)
    - After deactivating the wp-event plugin the Gravity Gorm is working fine.
    - I also changed the language into English in the wp-config.php(WPLANG) and activated the wp-event plugin. The Gravity Form plugin is then working fine.
    - I checked the wp-event plugin and there is no Norwegian language po and mo files. I think this cause the issue in the wp-event plugin.

    I removed the WP-Event plugin from the site, so consider this case as closed.

    Posted 12 years ago on Friday August 10, 2012 | Permalink

  8. Chris Hajer
    Key Master

    Thank you for the update.

    Posted 12 years ago on Friday August 10, 2012 | Permalink

This topic has been resolved and has been closed to new replies.