Title: Imported Wrongly
Last modified: August 18, 2016

---

# Imported Wrongly

 *  ChrisGwynne
 * [21 years, 9 months ago](https://wordpress.org/support/topic/imported-wrongly/)
 * Okay so I’d set up WordPress and attempted to import my MT posts into the system.
   Everything seemed fine and ok when it came upon a snag. It’d taken one of my 
   posters usernames and inserted him, not only as a site admin but the poster of
   every single one of my posts. I was also in the list so I defined myself as the
   site admin, and clicked proceed.
    Good job that did. I had one post, which was
   the default WordPress one whilst a non-registered average joe poster on my site
   was deemed the author of the blog. Why? I “thought” it’d be okay to delete this
   user and all posts under him would be reverted to my control, bad mistake, it
   deleted all the posts and comments. Why? Isn’t WordPress supposed to be good,
   puh-lease.

Viewing 11 replies - 1 through 11 (of 11 total)

 *  [carthik](https://wordpress.org/support/users/carthik/)
 * (@carthik)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84146)
 * Not changing any options during the import will import all posts with the same
   usernames as on the MT weblog, if that is what you want.
 *  Thread Starter Anonymous
 * [21 years, 9 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84147)
 * I’ll give that a try. But does a non author, an average joe, become author to
   all?
 *  [Ruby Sinreich](https://wordpress.org/support/users/rubyji/)
 * (@rubyji)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84159)
 * I had similar problems, my export from MT was mangled with “——–” that screwed
   everything up. The good thing is that your erroneous import can be easily undone
   by deleting your “average joe” user, thereby deleting all posts assigned to him.
   
   I’d suggest breaking your import into smaller chunks so you can isolate the problem.
   OR… assuming you are the only author, just change the user created for “average
   joe” in the import process and modify the profile to make it your own account.
   Done.
 *  [carthik](https://wordpress.org/support/users/carthik/)
 * (@carthik)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84162)
 * I think I found a potential problem, find
    `echo '<option value="'.$user->user_nickname.'"
   >'.$user->user_nickname.'</option>';` around line 79 of import-mt.php and replace
   that line with `echo '<option value="'.$user->user_login.'">'.$user->user_login.'
   </option>';` That should fix the authors problem. After importing the posts, 
   if everything is imported right, run wp-admin/upgrade.php to fix loose ends (
   like gmt dates, and some other odd things) Both these problem should be fixed
   in the next release. Thank you.
 *  [carthik](https://wordpress.org/support/users/carthik/)
 * (@carthik)
 * [21 years, 9 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84164)
 * [The bug fix](http://mosquito.wordpress.org/bug_view_page.php?bug_id=0000227).
 *  Thread Starter Anonymous
 * [21 years, 9 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84196)
 * More errors when trying to import. It generates this error;
    Database error: [
   You have an error in your SQL syntax. Check the manual that corresponds to your
   MySQL server version for the right syntax to use near ‘ORDER BY ID’ at line 1]
   SELECT * FROM ORDER BY ID And this is from a fresh install and import…
 *  Thread Starter Anonymous
 * [21 years, 9 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84251)
 * Any help on this?
 *  [carthik](https://wordpress.org/support/users/carthik/)
 * (@carthik)
 * [21 years, 8 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84258)
 * Did you use the bug fix posted above (ie, did you edit import-mt.php) ?
    The 
   error statement in itself does not give me much to go by. Any other details will
   be helpful.
 *  Thread Starter Anonymous
 * [21 years, 8 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84274)
 * Yep I used the updated file. I went to run import-mt.php clicked the let’s go
   and got that error. Tried to click okay anyway and got a whole bunch of errors
   with each post being imported.
 *  Thread Starter Anonymous
 * [21 years, 8 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84281)
 * Still getting this problem. I’ve used the bug fix file yet it’s still the same…
 *  [carthik](https://wordpress.org/support/users/carthik/)
 * (@carthik)
 * [21 years, 8 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84290)
 * ChrisGwynne,
    My bad. I should have told you that the bug fix file is for version
   1.3 alpha 2. to make it work for 1.2, please follow the instructions in [my earlier reply](http://wordpress.org/support/index.php?action=vthread&forum=3&topic=11214&page=-1#post-5)

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Imported Wrongly’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 11 replies
 * 3 participants
 * Last reply from: [carthik](https://wordpress.org/support/users/carthik/)
 * Last activity: [21 years, 8 months ago](https://wordpress.org/support/topic/imported-wrongly/#post-84290)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics