WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Blogger to WordPress (3 posts)

  1. gashbaugh
    Member
    Posted 8 years ago #

    Hi:

    I've completed the import from Blogger to WordPress following the instructions at:

    http://catsutorials.catsudon.org/?p=1

    Everything seems to work, all the posts and comments get transfered over, however there was one error message I kept getting over and over during the process which is as follows:

    WordPress database error: [Unknown column 'user_nickname' in 'field list']
    INSERT INTO wp_users ( user_login, user_pass, user_nickname, user_email, user_url, user_ip, user_domain, user_browser, user_registered, user_level, user_idmode ) VALUES ( 'Greg', 'password', 'Greg', 'user@wordpress.org', '', '127.0.0.1', 'localhost', 'server', '1979-06-06 00:41:00', '1', 'nickname' )
    : Registered user Greg

    I would ignore it, but after doing the import, my WP runs extremely slow and am wondering if this error has caused part of the problem.

    Thanks!

  2. giles_t
    Member
    Posted 8 years ago #

    Greg, I ran into the same problem. However, there is a fix listed on Andy Skelton’s page by Elton Wilson in the comment section (about 5th from bottom). Anyway, you have to edit the import-blogger.php script at line 82 so that the INSERT command reads as follows:

    INSERT INTO $wpdb-->users (
    user_login,
    user_pass,
    user_nicename,
    user_email,
    user_url,
    user_registered
    ) VALUES (
    '$user_login',
    '$pass1',
    '$user_nickname',
    '$user_email',
    '$user_url',
    '$user_joindate'
    )");

    Here’s the link to Andy’s page: http://www.skeltoac.com/2005/03/12/from-blogger-to-wordpress-2/

    The above worked for me :) Good luck.

    http://www.gilestimms.com

  3. gashbaugh
    Member
    Posted 8 years ago #

    Hi, That worked great! Thanks for your reply!

    -Greg
    http://www.ashbaughonline.com

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags