We’re running into an issue with GF on a multisite setup with multiple languages. GF works fine on English sites, but on our German and French blogs we’re having database issues.
Process:
Activate GF on English site. Works fine. All tables created like wp_gf_xx
Activate GF on French/German site, database tables are created like wp_gf_xx, but GF looks for some tables to have wp_rg prefix
German/French sites show DB Upgrade in progress with missing tables, forms can’t be created:
Database Version The database is currently being upgraded to version 2.4.4. Current Status: Queued for upgrade. NAN% complete. Force the upgrade
wp_5_rg_form_view Table does not exist
wp_5_rg_form_meta Table does not exist
wp_5_rg_form Table does not exist
wp_5_gf_form_revisions
wp_5_gf_entry
wp_5_gf_entry_meta
wp_5_gf_entry_notes
wp_5_gf_draft_submissions
This leaves us in a state where GF works fine on English sites, but doesn’t work at all on the German/French sites. Forms fail to be created or imported.
So far I’ve tried:
- Renaming tables to match - there are still some tables like wp_rg_lead what were never created and throw and error
- Disabling Plugin on DE/FR sites and reenabling
- Network activating plugin
WP Config Collate/Character Settings:
define('DB_CHARSET', 'utf8');
/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');