Posted 5 years ago #
I have made a clean installation of the new version (2.1).
Then i imported a v2.0.7 dump file of the following 3 tables only (it replaced the default ones):
wp_categories
wp_post2cat
wp_posts
It doesn't work (tho it shows it on the sidebar).
Is there some kind of SQL command lines i can run that will fix those 3 tables to fit v2.1 ??
Thanks
I think you would be better taking a complete 2.0.7 blog, upgrade that to 2.1 then in the Admin panels, delete what you don't want.
Addtional Resources:
Upgrading WordPress
Moving WordPress
Posted 5 years ago #
Ye, I know there are better ways to upgrade, but i need this solution for a good reason. Don't even ask :)
What actually needed is to know what changes has been made in these tables and update it accordingly..
I don't know SQL well unfortunately...
Posted 5 years ago #
Okay, I don't ask.
There may be a way to accomplish your task but it's not easy and involves in depth knowledge of WordPress and SQL. So based on your skills I would recommend: Don't even ask :)
Posted 5 years ago #
Well.. That's why i'm looking for someone with indepth knowledge of WordPress and SQL to help me figure it out....
Posted 5 years ago #
I do not guarantee any of these will work, so don't cry if your dog dies from this...
UPDATE wp_posts SET post_status = 'published', post_type = 'page' WHERE post_status = 'static'
UPDATE wp_posts SET post_status = 'inherit', post_type = 'attachment' WHERE post_status = 'attachment'
ALTER TABLE wp_categories ADD link_count BIGINT , ADD posts_private TINYINT , ADD links_private TINYINT
Manually change the status to 'future' for any future posts.
Posted 5 years ago #
#1064 - 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 'UPDATE wp_posts SET post_status = 'inherit', post_type = 'attach
Any idea ?
This topic has been closed to new replies.
