WordPress.org

Ready to get started?Download WordPress

Forums

Installation & switching from b2... (11 posts)

  1. LoKat
    Member
    Posted 9 years ago #

    I switched from b2 to WP... and I've got a TON of errors. I finally got all of my b2 archives to convert over... and WP shows that they are there... but, you can't view them. There are errors if I log into the admin panel... and errors when I view my site: http://www.passionate-desire.org/wp/

    Also, from what I can tell... even though my categories table converted over... all of my entries are not uncategorized. I feel a little overwhelmed right now, to say the least.

    Any help would be greatly appreciated. I'm finally giving in and converting, but it's frustrating when you start out with nothing but problems.

  2. When you imported from b2, did you use either the script or tutorial found at the following link?

    http://codex.wordpress.org/Importing_Content#b2

  3. LoKat
    Member
    Posted 9 years ago #

    I used the tutorial.

  4. LoKat
    Member
    Posted 9 years ago #

    This is what I get on the right-hand side (column) when I log into my admin:

    Latest Activity
    WordPress database error: [Unknown column 'post_date_gmt' in 'where clause']
    SELECT ID, post_title FROM wp_posts WHERE post_status = 'publish' AND post_date_gmt < '2005-06-16 18:19:13' ORDER BY post_date DESC LIMIT 5

    WordPress database error: [Unknown column 'post_date_gmt' in 'field list']
    SELECT ID, post_title, post_date_gmt FROM wp_posts WHERE post_status = 'publish' AND post_date_gmt > '2005-06-16 18:19:13'

    WordPress database error: [Unknown column 'comment_approved' in 'where clause']
    SELECT comment_author, comment_author_url, comment_ID, comment_post_ID FROM wp_comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 5

    Blog Stats
    WordPress database error: [Unknown column 'comment_approved' in 'where clause']
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = '1'

    There are currently 761 posts and comments, contained within 8 categories.

    So, the posts and categories are there... but, they're also errors if you view my page. Ugh... this is beyond aggrevating.

  5. If you just install WordPress (without importing), do you still see the errors? If not, I suggest starting fresh repeating the install/import procedure.

  6. LoKat
    Member
    Posted 9 years ago #

    Yeah, but then I completely lose all of my b2 posts. I'm trying to run my back-up SQL now to see if I can get them back into my database and just delete WP. I'll try this again sometime when I'm not so frustrated. LOL

  7. twotwentysix
    Member
    Posted 8 years ago #

    I am having the same problem.
    I used the upgrade script provided in the admin folder.
    Help anyone?

    this is the error I am getting and no posts are showing up.
    thanks

    WordPress database error: [Unknown column 'post_date_gmt' in 'where clause']
    SELECT DISTINCT * FROM b2posts WHERE 1=1 AND YEAR(post_date)=2004 AND MONTH(post_date)=10 AND post_date_gmt <= '2005-12-05 14:28:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') GROUP BY b2posts.ID ORDER BY post_date DESC LIMIT 0, 10

    here is the link: http://twotwentysix.com/blog/

  8. katootje
    Member
    Posted 8 years ago #

    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 :(

  9. katootje
    Member
    Posted 8 years ago #

    Luckely I had a good working wp log (also with imported B2 logfiles) I've compared all the tables and just added the missing lines in PHPmyadmin, looking good at the attributes and settings and it helped. I think I've tackled all the problems now.

  10. kappaluppa
    Member
    Posted 8 years ago #

    Katootje...
    I am not clear what you are saying about the log files.
    Are you saying you just added the "missing fields" to the tables?

    I am getting all these same errors. I've installed, reinstalled, and get to the point where I see the archives listed but the WordPress database error: [Unknown column 'post_date_gmt' in 'where clause'] error and all the ones you list that are on the side, keep the posts from displaying.

    Thanks for any help! Anyone!

    Kathy

  11. kappaluppa
    Member
    Posted 8 years ago #

    What a pain! I'm not sure if I took the best route, but i could NOT get my mysql statements right and had to add all the missing field names one by one. I am NOT one for tedium, so it was a headache.

    but my b2's are now WP's. THANK GOD I don't have anymore B2's!!!

Topic Closed

This topic has been closed to new replies.

About this Topic