These sound like errors that shouldn’t affect the operation. Does it work anyway?
Don’t forget, if you’re upgrading from b2 the table prefix needs to be the same as it was under b2, so if your table names are b2posts, b2users, etc you need to make “b2” your prefix in wp-config.php and not “wordpress_” which is what you currently have.
even with b2 as the prefix, it still comes up the same errors and doesnt convert over
I now have it converted over… but it wont let me log in
isnt this supposed to be easy?
Could you be more specific with regards to your login problems?
i goto login but it looks for the login page in my root folder, when I copy wordpress into the root, it displays but when I log in, nothing happens… I’ve even tried to get a new password emailed to me, but that doesnt work either
Are you trying to install into 2 directories ?
no, i installed it into my original b2 directory, that being wwwroot/journal/, but the install is looking ofr item in the root for some reason
after i ran import-b2.php at step 2 i got this :
Step 2
First we’re going to add excerpt, post, and password functionality…
Database error: [Duplicate column name ‘post_excerpt’]
ALTER TABLE wpposts ADD COLUMN post_excerpt text NOT NULL;
Database error: [Duplicate column name ‘post_status’]
ALTER TABLE wpposts 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 wpposts DROP INDEX ID
One down, two to go…
Database error: [Table ‘stg_elves1.wpsettings’ doesn’t exist]
ALTER TABLE wpsettings DROP INDEX ID
So far so good.
Database error: [Can’t DROP ‘post_karma’. Check that column/key exists]
ALTER TABLE wpposts DROP post_karma
Almost there…
Database error: [Can’t DROP ‘ID’. Check that column/key exists]
ALTER TABLE wpusers DROP INDEX ID
Welcome to the family. Have fun!
and it didnt do anything 🙁 didnt imported. i tried lots of times, different directories …i got bored of how many times i restored the db 😐
can anyone help ?
Anonymous
Hey Gregorsmith,
I got the same set of errors when I got to STEP2 .
How did you get yours to work?
Currently I installed WP and in the DB are a bunch of tables,
the old b2_ tables and a whole set of wp_ tables…
Wordrpress does work, but didn’t convert my old b2 data oveer…
Anonymous
I got:
Step 2
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 ‘medfools_com.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
Welcome to the family. Have fun!
ok, from what I gather, before you install WP, rename the table to be “b2” or whatever your b2 tables were… not “b2_” as the default b2 table has on _ in it
then run the import and it should work
Anonymous
actually, the exising b2 tables were “b2categories” etc…
I tried chaning them to “b2_categories”, then installing WP, but no go.
Should I have chanaged them to “wp_categories” etc… THEN tried to install WP
