WordPress.org

Ready to get started?Download WordPress

Forums

WP Db Abstraction
Not working well with WordPress Importer plugin (1 post)

  1. jbuedel
    Member
    Posted 1 year ago #

    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

    http://wordpress.org/plugins/wordpress-database-abstraction/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags