PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

SQL Error Upon Plugin Activation

  1. tts
    Member

    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?

    Posted 7 years ago on Thursday December 13, 2012 | Permalink
  2. Gravity Forms requires MySQL 5+. It appears that this is a Microsoft SQL Server?

    Posted 7 years ago on Thursday December 13, 2012 | Permalink
  3. tts
    Member

    Gotcha, makes sense. Thanks!

    Posted 7 years ago on Thursday December 13, 2012 | Permalink
  4. You're welcome. Are you running WordPress on SQL Server now?

    Posted 7 years ago on Thursday December 13, 2012 | Permalink