Issue: Gravity Forms Update and deprecated tables.

Last Updated on September 21, 2023 EDT by Jordan

I ran into an issue with a site when installing Gravity Forms, it resulted in an error with trying to upgrade. Looking further under system tools, it was trying to migrate a table named wp_rg_lead_meta which didn’t exist.

I searched everywhere to try and find the table to create a statement in some sort of MySQL schema file. Lucky I found this article on the Gravity Forms site

https://legacy.forums.gravityhelp.com/topic/error-saving-form

WordPress database error: [Unknown character set: 'utf']
CREATE TABLE wp_rg_form ( id mediumint(8) unsigned not null auto_increment, title varchar(150) not null, date_created datetime not null, is_active tinyint(1) not null default 1, PRIMARY KEY (id) ) DEFAULT CHARACTER SET utf-8

WordPress database error: [Unknown character set: 'utf']
CREATE TABLE wp_rg_form_meta ( form_id mediumint(8) unsigned not null, display_meta longtext, entries_grid_meta longtext, PRIMARY KEY (form_id) ) DEFAULT CHARACTER SET utf-8

WordPress database error: [Table 'lidija_wrdp1.wp_rg_form_meta' doesn't exist]
SHOW INDEX FROM wp_rg_form_meta WHERE Key_name='form_id'

WordPress database error: [Unknown character set: 'utf']
CREATE TABLE wp_rg_form_view ( id bigint(20) unsigned not null auto_increment, form_id mediumint(8) unsigned not null, date_created datetime not null, ip char(15), count mediumint(8) unsigned not null default 1, PRIMARY KEY (id), KEY form_id (form_id) ) DEFAULT CHARACTER SET utf-8

WordPress database error: [Unknown character set: 'utf']
CREATE TABLE wp_rg_lead ( id int(10) unsigned not null auto_increment, form_id mediumint(8) unsigned not null, post_id bigint(20) unsigned, date_created datetime not null, is_starred tinyint(1) not null default 0, is_read tinyint(1) not null default 0, ip varchar(39) not null, source_url varchar(200) not null default '', user_agent varchar(250) not null default '', currency varchar(5), payment_status varchar(15), payment_date datetime, payment_amount decimal(19,2), transaction_id varchar(50), is_fulfilled tinyint(1), created_by bigint(20) unsigned, transaction_type tinyint(1), status varchar(20) not null default 'active', PRIMARY KEY (id), KEY form_id (form_id), KEY status (status) ) DEFAULT CHARACTER SET utf-8

WordPress database error: [Unknown character set: 'utf']
CREATE TABLE wp_rg_lead_notes ( id int(10) unsigned not null auto_increment, lead_id int(10) unsigned not null, user_name varchar(250), user_id bigint(20), date_created datetime not null, value longtext, PRIMARY KEY (id), KEY lead_id (lead_id), KEY lead_user_key (lead_id,user_id) ) DEFAULT CHARACTER SET utf-8

WordPress database error: [Unknown character set: 'utf']
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 utf-8

WordPress database error: [Unknown character set: 'utf']
CREATE TABLE wp_rg_lead_detail_long ( lead_detail_id bigint(20) unsigned not null, value longtext, PRIMARY KEY (lead_detail_id) ) DEFAULT CHARACTER SET utf-8

WordPress database error: [Table 'lidija_wrdp1.wp_rg_lead_detail_long' doesn't exist]
SHOW INDEX FROM wp_rg_lead_detail_long WHERE Key_name='lead_detail_key'

WordPress database error: [Unknown character set: 'utf']
CREATE TABLE wp_rg_lead_meta ( id bigint(20) unsigned not null auto_increment, lead_id bigint(20) unsigned not null, meta_key varchar(255), meta_value longtext, PRIMARY KEY (id), KEY meta_key (meta_key), KEY lead_id (lead_id) ) DEFAULT CHARACTER SET utf-8

WordPress database error: [Table 'lidija_wrdp1.wp_rg_lead_detail' doesn't exist]
select * from wp_rg_lead_detail where value= '!'

I ran the one I needed an viola, Gravity Forms upgraded. So strange 🙁