Ok, so I’m writing this down in English, just to avoid everybody the trip to Google Translate. (English translated to Italian sounds funny, but Italian to English is really weird – at least to me)<\/p>\n
While upgrading from 2.0.7 to 2.1, the upgrade procedure failed horribly on me with quite a lot of SQL errors. Let me make it clear right now: it is not WordPress guys fault, it’s mine.
\nThe user accessing the database did not have all the permissions needed to upgrade the structure and the content of the tables — so I was left with a half-dead blog.
\nThe live half consisted of the public pages, good.
\nThe dead half was the administrative interface, bad. While the error messages were different (I could distinguish between a successful authentication and a bad password), all I got was the dreaded<\/p>\n
\n“You do not have sufficient permissions to access this page.”\n<\/p><\/blockquote>\n
To make a long debug story short: being too lazy to dig inside the WP internals and understand which parts of code were running the authentication, I just choose to guess the tables which may have been screwed up by the limited upgrade. They could not be posts, categories, links, or the like, right?<\/p>\n
Did I mention I didn’t make a backup before? (living on the edge :P) All I had was a backup a couple of days old, and I didn’t want to loose the last couple of comments and posts.<\/p>\n
Anyway, I decided to bet on<\/p>\n
\n
- options\n<\/li>\n
- users\n<\/li>\n
- usermeta\n<\/li>\n<\/ul>\n
Got them out of the two-days-old SQL dump, and restored them on the half-new database — then run again the upgrade procedure after fixing user privileges on the db.
\nThat’s all, now I have a shiny new admin section working.<\/p>\nMAKE BACKUPS! :)<\/p>\n","protected":false},"excerpt":{"rendered":"
Ok, so I’m writing this down in English, just to avoid everybody the trip to Google Translate. (English translated to Italian sounds funny, but Italian to English is really weird – at least to me) While upgrading from 2.0.7 to 2.1, the upgrade procedure failed horribly on me with quite a lot of SQL errors. … Continue reading “WordPress 2.0.7 to 2.1 Upgrade – screwed up (almost)”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,3],"tags":[],"class_list":["post-158","post","type-post","status-publish","format-standard","hentry","category-english","category-geek"],"_links":{"self":[{"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/posts\/158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=158"}],"version-history":[{"count":0,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/posts\/158\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kill-9.it\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}