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.

Urgent - error when trying to create MailChimp form

  1. Andrew Munro
    Member

    I'm getting slammed with all sorts of errors, most likely something on my end, but I've done this many times before.

    When I try and create a MailChimp form I get:

    MailChimp list (?) Could not load MailChimp contact lists.
    Error:

    php error log shows:

    WordPress database error Table 'db_antidotecreative.wp_rg_form' doesn't exist for query SELECT s.id, s.is_active, s.form_id, s.meta, f.title as form_title
    FROM wp_rg_mailchimp s
    INNER JOIN wp_rg_form f ON s.form_id = f.id made by do_action, call_user_func_array, GFMailChimp->mailchimp_page, GFMailChimp->list_page, GFMailChimpData->get_feeds

    WordPress database error Table 'db_antidotecreative.wp_rg_form' doesn't exist for query SELECT f.id, f.title, f.date_created, f.is_active, 0 as lead_count, 0 view_count
    FROM wp_rg_form f

    ORDER BY title ASC made by do_action, call_user_func_array, GFMailChimp->mailchimp_page, GFMailChimp->edit_page, RGFormsModel->get_forms
    [28-Oct-2011 12:40:01] WordPress database error Table 'db_antidotecreative.wp_rg_lead' doesn't exist for query SELECT form_id, count(id) as lead_count FROM wp_rg_lead l WHERE status='active' GROUP BY form_id made by do_action, call_user_func_array, GFMailChimp->mailchimp_page, GFMailChimp->edit_page, RGFormsModel->get_forms
    [28-Oct-2011 12:40:01] WordPress database error Table 'db_antidotecreative.wp_rg_form_view' doesn't exist for query SELECT form_id, sum(count) as view_count FROM wp_rg_form_view GROUP BY form_id made by do_action, call_user_func_array, GFMailChimp->mailchimp_page, GFMailChimp->edit_page, RGFormsModel->get_forms

    I'm working locally, but I've had this working in the past. I've trying uninstalling GF and the mailchimp addon numerous times, double checked the MailChimp API key and all sorts.

    Any Ideas?

    Posted 13 years ago on Friday October 28, 2011 | Permalink
  2. It sounds like the plugin was not able to create the proper Gravity Forms database. Do you have access to the database to see if all the proper tables have been created? The WordPress database user needs to have CREATE and ALTER permissions to properly install Gravity Forms and the add-ons as new tables need to be created.

    Posted 13 years ago on Friday October 28, 2011 | Permalink
  3. Andrew Munro
    Member

    These are the tables I have, are there any missing?

    wp_rg_campaignmonitor
    wp_rg_form
    wp_rg_form_meta
    wp_rg_form_view
    wp_rg_lead
    wp_rg_lead_detail
    wp_rg_lead_detail_long
    wp_rg_lead_meta
    wp_rg_lead_notes
    wp_rg_mailchimp

    I've just tried with campaign monitor and it works fine, however I want to use mailchimp. I also created a new mysql user with all privileges and reinstalled gravity forms + mailchimp. That seemed to have cleared out the errors I was receiving in the php log but the mailchimp error is still appearing

    Something wrong at MC's side perhaps?

    Posted 13 years ago on Saturday October 29, 2011 | Permalink
  4. Andrew Munro
    Member

    Interesting, just tried with a completely different MailChimp account (which I can't really use) and it works fine! So something's up with the one I have now. I'll get in touch with them or just create a whole new account and see if that works :)

    Posted 13 years ago on Saturday October 29, 2011 | Permalink
  5. OK, please let us know if you need any more help.

    Posted 13 years ago on Saturday October 29, 2011 | Permalink