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.

Form has entries but do not show

Gravity Support Forums » Plugin Support » Gravity Forms

  1. ndepth
    Member

    I recently updated to the latest version of GForms. When installing i saw that i had a DB error (I since then, can not recreate that page or see what the errors were). My issue is that Gforms is working correctly in every aspect except when you go into a form that says it has submissions. Once in the forms entries it displays that it has 64 Entries but there are no entries in the list view.

    I have tried the Meta Recovery plugin and it did not work. I also tried exporting my contact submissions and the CSV is empty. Can anyone help me with this issue. Also can someone guide me to where I can see the errors GForms created.

    Posted 11 years ago on Monday December 3, 2012 | Permalink

  2. ndepth
    Member

    Error Lays in the "wp_rg_lead_detail" table.

    SHOW FULL FIELDS FROM wp_rg_lead_detail ;
    MySQL said:
    #145 - Table './DBNAME/wp_rg_lead_detail' is marked as crashed and should be repaired

    Posted 11 years ago on Monday December 3, 2012 | Permalink

  3. Chris Hajer
    Key Master

    Do you need tips on repairing that table, or do you have access to something like phpMyAdmin to repair the table? Maybe your host's support can help?

    Posted 11 years ago on Monday December 3, 2012 | Permalink

  4. ndepth
    Member

    I am working on this. I updated today and got this error:

    WordPress database error: [Table 'wp_rg_lead_detail' already exists]
    CREATE TABLE wp_rg_lead_detail ( id bigint(20) unsigned not null auto_increment, lead_id int(10) unsigned not null, form_id mediumint(8) unsigned not null, field_number float not null, value varchar(200), PRIMARY KEY (id), KEY form_id (form_id), KEY lead_id (lead_id) ) DEFAULT CHARACTER SET utf8

    WordPress database error: [Table './champion_roper_live/wp_rg_lead_detail' is marked as crashed and should be repaired]
    select * from wp_rg_lead_detail where value= '!'

    Posted 11 years ago on Wednesday December 5, 2012 | Permalink

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