• Resolved Andrew

    (@andrew)


    Hello there,

    Recently, I moved my blog (MySQL database and all) over to a new spot on the internet. Okay, so I didn’t literally move the blog. Basically, I installed a clean version of WordPress, and (after getting a backup of my old SQL database) I then preceded to replace the fields and tables of the newly installed database, with content from my old database. Basically, I opened up the .sql file from the backup, and then pasted portions of it into phpMyAdmin. The things I replaced were:

    • Posts
    • Categories
    • Links
    • Users
    • Link Categories
    • Post2cat table

    I didn’t replace any options tables.

    Everything seemed to import pretty well, excepting a few things:
    Anything with an apostrophe in the title showed up with a ‘\’ next to the apostraphe.
    I can’t edit previous posts.
    I can’t post anything new.

    If I try to edit anything, I get this error:
    WordPress database error: [Unknown column ‘menu_order’ in ‘field list’]
    UPDATE wp_posts SET post_content = ‘This is the content of my post, right here’, post_status = ‘publish’, comment_status = ‘open’, ping_status = ‘closed’, post_author = ‘1’, post_password = ”, post_name = ‘its-july-already’, to_ping = ”, post_modified = ‘2005-07-01 21:47:56’, post_modified_gmt = ‘2005-07-02 02:47:56’, menu_order = ‘0’, post_parent = ‘0’ WHERE ID = 181

    If I try to post anything new, I get this error:

    WordPress database error: [Unknown column ‘menu_order’ in ‘field list’]
    INSERT INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, post_modified, post_modified_gmt, post_parent, menu_order) VALUES (‘182’, ‘1’, ‘2005-07-01 21:49:34’, ‘2005-07-02 02:49:34’, ‘This is a test!’, ‘Test’, ”, ‘publish’, ‘open’, ‘open’, ”, ‘test’, ”, ‘2005-07-01 21:49:34’, ‘2005-07-02 02:49:34’, ‘0’, ‘0’)

    WordPress database error: [Unknown column ‘guid’ in ‘field list’]
    UPDATE wp_posts SET guid = ‘http://andrew.dragonflytemplates.com/?p=’ WHERE ID = ‘182’

    Is anyone experience with MySQL databases? If so, your help would be much appreciated.

    EDIT: By the way, my old installation of WordPress was 1.2.1. My recent installation is 1.5.1.3

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

The topic ‘MySQL issues…’ is closed to new replies.