MySQL issues…
-
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 = 181If 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
The topic ‘MySQL issues…’ is closed to new replies.