aredubya
Forum Replies Created
-
Forum: Installing WordPress
In reply to: Importing from b2?I’m getting a similar issue trying to import files from b2 to WordPress. I’ve got things set up properly after running install.php, such that I’ve got a usable, albeit separate, instance of WordPress from my b2 data and document root. Running the import-b2.php script, step 1 seems to work, but step 2 has numerous errors. My existing site is available at http://blog.netho.net/ for anyone who wishes to give it a look. Thanks.
[output from step 2 below]
First we’re going to add excerpt, post, and password functionality…
Database error: [Duplicate column name ‘post_excerpt’]
ALTER TABLE wp_posts ADD COLUMN post_excerpt text NOT NULL;
Database error: [Duplicate column name ‘post_status’]
ALTER TABLE wp_posts ADD post_status ENUM(‘publish’,’draft’,’private’) NOT NULL, ADD comment_status ENUM(‘open’,’closed’) NOT NULL, ADD ping_status ENUM(‘open’,’closed’) NOT NULL, ADD post_password varchar(20) NOT NULL;
That went well! Now let’s clean up the b2 database structure a bit…
Database error: [Can’t DROP ‘ID’. Check that column/key exists]
ALTER TABLE wp_posts DROP INDEX ID
One down, two to go…
Database error: [Table ‘b2.wp_settings’ doesn’t exist]
ALTER TABLE wp_settings DROP INDEX ID
So far so good.
Database error: [Can’t DROP ‘post_karma’. Check that column/key exists]
ALTER TABLE wp_posts DROP post_karma
Almost there…
Database error: [Can’t DROP ‘ID’. Check that column/key exists]
ALTER TABLE wp_users DROP INDEX ID