• I am migrating a wordpress install to IIS/SqlServer. I’ve installed the WP DB Abstraction plugin. I also installed WordPress Importer.

    However when I go to the Tools->Import->Wordpress area I get errors.

    I am seeing some db specific errors like below. Perhaps mappings need to be added?

    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

    https://www.ads-software.com/plugins/wordpress-database-abstraction/

  • The topic ‘Not working well with WordPress Importer plugin’ is closed to new replies.