Hi,
I tried to install and activate the latest version of Gravity Forms on my WP site. Here is the error that I receive (upon clicking Activate) in my WP-Admin Dashboard:
CREATE TABLE wp_rg_form ( id mediumint not null IDENTITY(1,1), title NVARCHAR(150) COLLATE database_default not null, date_created datetime not null, is_active tinyint not null default 1, CONSTRAINT [wp_rg_form_id] PRIMARY KEY CLUSTERED (id) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY];
WordPress database error: [[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the table 'Awp_rg_form', because it does not exist or you do not have permission.]
DROP TABLE Awp_rg_form
WordPress database error: [[Microsoft][SQL Server Native Client 10.0][SQL Server]Column, parameter, or variable #1: Cannot find data type mediumint.]
CREATE TABLE wp_rg_form_meta ( form_id mediumint not null, display_meta NVARCHAR(MAX) COLLATE database_default, entries_grid_meta NVARCHAR(MAX) COLLATE database_default, CONSTRAINT [wp_rg_form_meta_form_id] PRIMARY KEY CLUSTERED (form_id) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY];
WordPress database error: [[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'form_id'.]
select t.name AS [Table], CASE WHEN ind.is_unique = 1 THEN 0 ELSE 1 END AS Non_unique, CASE WHEN ind.is_primary_key = 1 THEN 'PRIMARY' ELSE ind.name END AS Key_name, col.name AS Column_name, NULL as Sub_part from sys.indexes ind inner join sys.index_columns ic on ind.object_id = ic.object_id and ind.index_id = ic.index_id inner join sys.columns col on ic.object_id = col.object_id and ic.column_id = col.column_id inner join sys.tables t on ind.object_id = t.object_id where t.name = 'wp_rg_form_meta WHERE Key_name='form_id'' order by t.name, ind.name, ind.index_id, ic.index_column_id
WordPress database error: [[Microsoft][SQL Server Native Client 10.0][SQL Server]Column, parameter, or variable #2: Cannot find data type mediumint.]
CREATE TABLE wp_rg_form_view ( id bigint not null IDENTITY(1,1), form_id mediumint not null, date_created datetime not null, ip char(15), count mediumint not null default 1, CONSTRAINT [wp_rg_form_view_id] PRIMARY KEY CLUSTERED (id) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY], ) ON [PRIMARY];
WordPress database error: [[Microsoft][SQL Server Native Client 10.0][SQL Server]Column, parameter, or variable #2: Cannot find data type mediumint.]
CREATE TABLE wp_rg_lead ( id int not null IDENTITY(1,1), form_id mediumint not null, post_id bigint , date_created datetime not null, is_starred tinyint not null default 0, is_read tinyint not null default 0, ip NVARCHAR(39) COLLATE database_default not null, source_url NVARCHAR(200) COLLATE database_default not null default '', user_agent NVARCHAR(250) COLLATE database_default not null default '', currency NVARCHAR(5) COLLATE database_default, payment_status NVARCHAR(15) COLLATE database_default, payment_date datetime, payment_amount decimal(19,2), transaction_id NVARCHAR(50) COLLATE database_default, is_fulfilled tinyint, created_by bigint , transaction_type tinyint, status NVARCHAR(20) COLLATE database_default not null default 'active', CONSTRAINT [wp_rg_lead_id] PRIMARY KEY CLUSTERED (id) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY], ) ON [PRIMARY];
WordPress database error: [[Microsoft][SQL Server Native Client 10.0][SQL Server]Column, parameter, or variable #3: Cannot find data type mediumint.]
CREATE TABLE wp_rg_lead_detail ( id bigint not null IDENTITY(1,1), lead_id int not null, form_id mediumint not null, field_number float not null, value NVARCHAR(200) COLLATE database_default, CONSTRAINT [wp_rg_lead_detail_id] PRIMARY KEY CLUSTERED (id) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY], ) ON [PRIMARY];
WordPress database error: [[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'lead_detail_key'.]
select t.name AS [Table], CASE WHEN ind.is_unique = 1 THEN 0 ELSE 1 END AS Non_unique, CASE WHEN ind.is_primary_key = 1 THEN 'PRIMARY' ELSE ind.name END AS Key_name, col.name AS Column_name, NULL as Sub_part from sys.indexes ind inner join sys.index_columns ic on ind.object_id = ic.object_id and ind.index_id = ic.index_id inner join sys.columns col on ic.object_id = col.object_id and ic.column_id = col.column_id inner join sys.tables t on ind.object_id = t.object_id where t.name = 'wp_rg_lead_detail_long WHERE Key_name='lead_detail_key'' order by t.name, ind.name, ind.index_id, ic.index_column_id
WordPress database error: [[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'wp_rg_lead_detail'.]
select * from wp_rg_lead_detail where value LIKE '!'Thoughts?
