Not working well with WordPress Importer plugin
-
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 TABLESWordPress 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 TABLEShttps://www.ads-software.com/plugins/wordpress-database-abstraction/
- The topic ‘Not working well with WordPress Importer plugin’ is closed to new replies.