Here another one with the same problems. I’ve over and over reinstalled WP and tried and tried. But I still end up with this. A few months ago I’ve with a lot of fight imported anonther B2 log in WordPress and that is running now. Comparing the both databases i see a that WP tables have more items then the one I’m trying to get working now.
B2 was running okay – freshly installed WP, did the drop table rename query and then ran import-b2. Last step gave this:
WordPress database error: [Unknown column ‘post_name’ in ‘field list’]
SELECT ID, post_title, post_name FROM wp_posts WHERE post_name = ”
WordPress database error: [Unknown column ‘category_nicename’ in ‘field list’]
SELECT cat_ID, cat_name, category_nicename FROM wp_categories
Warning: Invalid argument supplied for foreach() in /home/sites/site173/web/weblog/wp-admin/upgrade-functions.php on line 30
WordPress database error: [Key column ‘post_name’ doesn’t exist in table]
ALTER TABLE wp_posts ADD INDEX ( post_name )
WordPress database error: [Key column ‘category_nicename’ doesn’t exist in table]
ALTER TABLE wp_categories ADD INDEX ( category_nicename )
WordPress database error: [Key column ‘comment_approved’ doesn’t exist in table]
ALTER TABLE wp_comments ADD INDEX ( comment_approved )
WordPress database error: [Unknown column ‘user_nicename’ in ‘field list’]
SELECT ID, user_nickname, user_nicename FROM wp_users
Warning: Invalid argument supplied for foreach() in /home/sites/site173/web/weblog/wp-admin/upgrade-functions.php on line 88
WordPress database error: [Unknown column ‘post_date_gmt’ in ‘field list’]
SELECT MAX(post_date_gmt) FROM wp_posts
WordPress database error: [Unknown column ‘guid’ in ‘field list’]
SELECT ID, post_title, post_content, post_excerpt, guid, post_date, post_name, post_status, post_author FROM wp_posts
WordPress database error: [Unknown column ‘comment_type’ in ‘field list’]
UPDATE wp_comments SET comment_type=’trackback’, comment_content = REPLACE(comment_content, ”, ”) WHERE comment_content LIKE ‘%’
WordPress database error: [Unknown column ‘comment_type’ in ‘field list’]
UPDATE wp_comments SET comment_type=’pingback’, comment_content = REPLACE(comment_content, ”, ”) WHERE comment_content LIKE ‘%’
Welcome to the family. Have fun!
I like this last line 🙁
