WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Importer
Compatible with SQL Server? (1 post)

  1. jbuedel
    Member
    Posted 11 months ago #

    I am running wordpress on IIS w/ a SQL Server backend (via the WP DB Abstration plugin). Does this plugin support that scenario?

    When I go to Tools->Import->WordPress I get a blank page. That is, the menus on the top and side are present, but the main area is blank.

    I am seeing some db specific errors like:

    WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'wp_subscribe2'.]
    SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE ' N'wp_subscribe2''

    WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'SHOW'.]
    SHOW TABLES

    WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named 'wp_subscribe2' in the database.]
    CREATE TABLE wp_subscribe2 ( id int NOT NULL IDENTITY(1,1), email NVARCHAR(64) COLLATE database_default NOT NULL default '', active tinyint default 0, date DATE default '2013-08-07' NOT NULL, ip char(64) NOT NULL default 'admin', time TIME DEFAULT '00:00:00' NOT NULL, conf_date DATE, conf_time TIME, conf_ip char(64), CONSTRAINT [wp_subscribe2_id] PRIMARY KEY CLUSTERED (id) WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY];

    WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'SHOW'.]
    SHOW TABLES

    http://wordpress.org/plugins/wordpress-importer/

Reply

You must log in to post.

About this Plugin

About this Topic

Tags