https://legacy.forums.gravityhelp.com/topic/sql-error-upon-plugin-activation Gravity Support Forums Topic: SQL Error Upon Plugin Activation en-US Mon, 06 Apr 2026 14:50:14 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/sql-error-upon-plugin-activation#post-102315 Thu, 13 Dec 2012 15:24:53 +0000 Chris Hajer 102315@https://legacy.forums.gravityhelp.com/ <p>You're welcome. Are you running WordPress on SQL Server now? </p> https://legacy.forums.gravityhelp.com/topic/sql-error-upon-plugin-activation#post-102311 Thu, 13 Dec 2012 15:21:46 +0000 tts 102311@https://legacy.forums.gravityhelp.com/ <p>Gotcha, makes sense. Thanks! </p> https://legacy.forums.gravityhelp.com/topic/sql-error-upon-plugin-activation#post-102304 Thu, 13 Dec 2012 15:06:05 +0000 Chris Hajer 102304@https://legacy.forums.gravityhelp.com/ <p>Gravity Forms requires MySQL 5+. It appears that this is a Microsoft SQL Server? </p> https://legacy.forums.gravityhelp.com/topic/sql-error-upon-plugin-activation#post-102299 Thu, 13 Dec 2012 14:53:34 +0000 tts 102299@https://legacy.forums.gravityhelp.com/ <p>Hi,</p> <p>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:</p> <pre><code>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 &#39;Awp_rg_form&#39;, 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 &#39;form_id&#39;.] 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 &#39;PRIMARY&#39; 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 = &#39;wp_rg_form_meta WHERE Key_name=&#39;form_id&#39;&#39; 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 &#39;&#39;, user_agent NVARCHAR(250) COLLATE database_default not null default &#39;&#39;, 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 &#39;active&#39;, 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 &#39;lead_detail_key&#39;.] 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 &#39;PRIMARY&#39; 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 = &#39;wp_rg_lead_detail_long WHERE Key_name=&#39;lead_detail_key&#39;&#39; 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 &#39;wp_rg_lead_detail&#39;.] select * from wp_rg_lead_detail where value LIKE &#39;!&#39;</code></pre> <p>Thoughts? </p>