Translation issue (Gravity Forms)

[joegasper]

Gravity Forms installed fine and works, but upgrade is failing on this code:

$sql = "CREATE TABLE IF NOT EXISTS {$wpdb->prefix}rg_test ( col1 int PRIMARY KEY )"; $wpdb->query( $sql );

From the translate.log:

2017-06-26 19:19:33 Error Code: 156 -- Begin Query translation attempt: CREATE TABLE IF NOT EXISTS wp_rg_test ( col1 int PRIMARY KEY ) 2017-06-26 19:19:33 -- Translation result: CREATE TABLE wp_rg_test ( col1 int CONSTRAINT [wp_rg_test_REATE TABLE wp_rg_test ] PRIMARY KEY CLUSTERED (REATE TABLE wp_rg_test ) WITH (IGNORE_DUP_KEY = OFF) );

Thank you.

[patrickebates]

Seen something similar to this with the REATE and a different plugin, but so far I've been unsuccessful at figuring out where it's coming from. Unfortunately, table creation is our primary compatibility issue with plugins.

Time permitting, I'll try to take a fresh look at this.

[russellmann]

Is it a typeo in "CREATE" :)

[russellmann]

FYI, every GF install I have fails the test "SELECT COUNT(1) FROM wp_rg_test" because the table doesn't exist. I'm looking for a model that I can manually add to clear up that issue.