{"id":26,"date":"2007-01-27T15:51:50","date_gmt":"2007-01-27T14:51:50","guid":{"rendered":"http:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/"},"modified":"2007-02-19T10:01:34","modified_gmt":"2007-02-19T09:01:34","slug":"nightmare-on-elmhhhwordpress-upgrade","status":"publish","type":"post","link":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/","title":{"rendered":"Nightmare on Elm^H^H^HWordPress upgrade…"},"content":{"rendered":"

I just had a nightmarish experience when I upgraded Debian’s unstable WordPress package to version 2.1. When I invoked my site for the first time, WordPress prompted me to upgrade its database — which I did, of course, or rather “I tried to do.”<\/p>\n

After I started the upgrade, I saw a dozen or so error messages rushing over my screen. When I analyzed them, I quickly recognized that the database user didn’t have sufficient permissions to perform certain table alterations. I thought, “Hey, no prob, correct the permission problems, and re-run everything.”<\/p>\n

But “Not so!” WordPress was <\/em>able to write the new WP database version no. into the database in the last step of the upgrade procedure, so the upgrade refused to run again because it thought the database was already current.<\/p>\n

So what could I do?<\/p>\n

<\/p>\n

I searched thru the database to find the database version no., and manually changed it back from 4772 to 4351. When I visited my blog again, WordPress prompted me again to upgrade, and this time it worked!!! Hurray!!!<\/p>\n

So, what is the lesson of this? Guys, pleeeease, <\/em>for the sake of clean programming, be defensive in that you prefer too many<\/em> return code checks over too few.<\/em><\/p>\n

It is really bad practice to simply assume <\/em>an operation was successful, instead of making sure <\/em>it was successful. If an operation fails that is the prerequisite of another, you must <\/strong>stop in case the prerequisite operation could not successfully be performed.<\/p>\n

I wish that my words be heard by the WordPress guys, but I doubt that they are reading my lousy blog… \ud83d\ude09<\/p>\n

Anyway, if you are a programmer and read this, do yourself and the users of your software a favor and remember the advice of someone who has been developing computer software since about 25 years now.<\/p>\n","protected":false},"excerpt":{"rendered":"

I just had a nightmarish experience when I upgraded Debian’s unstable WordPress package to version 2.1. When I invoked my site for the first time, WordPress prompted me to upgrade its database — which I did, of course, or rather “I tried to do.” After I started the upgrade, I saw a dozen or so […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,7,11],"tags":[],"class_list":["post-26","post","type-post","status-publish","format-standard","hentry","category-computers","category-development","category-what-the-f"],"yoast_head":"\nNightmare on Elm^H^H^HWordPress upgrade... - Ralf's Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nightmare on Elm^H^H^HWordPress upgrade... - Ralf's Blog\" \/>\n<meta property=\"og:description\" content=\"I just had a nightmarish experience when I upgraded Debian’s unstable WordPress package to version 2.1. When I invoked my site for the first time, WordPress prompted me to upgrade its database — which I did, of course, or rather “I tried to do.” After I started the upgrade, I saw a dozen or so […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/\" \/>\n<meta property=\"og:site_name\" content=\"Ralf's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2007-01-27T14:51:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-02-19T09:01:34+00:00\" \/>\n<meta name=\"author\" content=\"Ralf Bergs\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ralfbergs\" \/>\n<meta name=\"twitter:site\" content=\"@ralfbergs\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ralf Bergs\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/2007\\\/01\\\/27\\\/nightmare-on-elmhhhwordpress-upgrade\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/2007\\\/01\\\/27\\\/nightmare-on-elmhhhwordpress-upgrade\\\/\"},\"author\":{\"name\":\"Ralf Bergs\",\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/#\\\/schema\\\/person\\\/354e37390b493c875f972bd313d29201\"},\"headline\":\"Nightmare on Elm^H^H^HWordPress upgrade…\",\"datePublished\":\"2007-01-27T14:51:50+00:00\",\"dateModified\":\"2007-02-19T09:01:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/2007\\\/01\\\/27\\\/nightmare-on-elmhhhwordpress-upgrade\\\/\"},\"wordCount\":310,\"publisher\":{\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/#\\\/schema\\\/person\\\/354e37390b493c875f972bd313d29201\"},\"articleSection\":[\"Computers\",\"Development\",\"WTF\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/2007\\\/01\\\/27\\\/nightmare-on-elmhhhwordpress-upgrade\\\/\",\"url\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/2007\\\/01\\\/27\\\/nightmare-on-elmhhhwordpress-upgrade\\\/\",\"name\":\"Nightmare on Elm^H^H^HWordPress upgrade... - Ralf's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/#website\"},\"datePublished\":\"2007-01-27T14:51:50+00:00\",\"dateModified\":\"2007-02-19T09:01:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/2007\\\/01\\\/27\\\/nightmare-on-elmhhhwordpress-upgrade\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bergs.biz\\\/blog\\\/2007\\\/01\\\/27\\\/nightmare-on-elmhhhwordpress-upgrade\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/2007\\\/01\\\/27\\\/nightmare-on-elmhhhwordpress-upgrade\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nightmare on Elm^H^H^HWordPress upgrade…\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/\",\"name\":\"Ralf's Blog\",\"description\":\"Just another WordPress weblog\",\"publisher\":{\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/#\\\/schema\\\/person\\\/354e37390b493c875f972bd313d29201\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/#\\\/schema\\\/person\\\/354e37390b493c875f972bd313d29201\",\"name\":\"Ralf Bergs\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Ralf-Tower-2026-1024x1024.jpg\",\"url\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Ralf-Tower-2026-1024x1024.jpg\",\"contentUrl\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Ralf-Tower-2026-1024x1024.jpg\",\"width\":1024,\"height\":1024,\"caption\":\"Ralf Bergs\"},\"logo\":{\"@id\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Ralf-Tower-2026-1024x1024.jpg\"},\"description\":\"Geek, computer guy, licensed and certified electrical and computer engineer, husband, best daddy.\",\"sameAs\":[\"https:\\\/\\\/bergs.biz\\\/\",\"https:\\\/\\\/linkedin.com\\\/in\\\/ralfbergs\\\/\",\"https:\\\/\\\/x.com\\\/ralfbergs\"],\"url\":\"https:\\\/\\\/bergs.biz\\\/blog\\\/author\\\/rabe\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Nightmare on Elm^H^H^HWordPress upgrade... - Ralf's Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/","og_locale":"en_US","og_type":"article","og_title":"Nightmare on Elm^H^H^HWordPress upgrade... - Ralf's Blog","og_description":"I just had a nightmarish experience when I upgraded Debian’s unstable WordPress package to version 2.1. When I invoked my site for the first time, WordPress prompted me to upgrade its database — which I did, of course, or rather “I tried to do.” After I started the upgrade, I saw a dozen or so […]","og_url":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/","og_site_name":"Ralf's Blog","article_published_time":"2007-01-27T14:51:50+00:00","article_modified_time":"2007-02-19T09:01:34+00:00","author":"Ralf Bergs","twitter_card":"summary_large_image","twitter_creator":"@ralfbergs","twitter_site":"@ralfbergs","twitter_misc":{"Written by":"Ralf Bergs","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/#article","isPartOf":{"@id":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/"},"author":{"name":"Ralf Bergs","@id":"https:\/\/bergs.biz\/blog\/#\/schema\/person\/354e37390b493c875f972bd313d29201"},"headline":"Nightmare on Elm^H^H^HWordPress upgrade…","datePublished":"2007-01-27T14:51:50+00:00","dateModified":"2007-02-19T09:01:34+00:00","mainEntityOfPage":{"@id":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/"},"wordCount":310,"publisher":{"@id":"https:\/\/bergs.biz\/blog\/#\/schema\/person\/354e37390b493c875f972bd313d29201"},"articleSection":["Computers","Development","WTF"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/","url":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/","name":"Nightmare on Elm^H^H^HWordPress upgrade... - Ralf's Blog","isPartOf":{"@id":"https:\/\/bergs.biz\/blog\/#website"},"datePublished":"2007-01-27T14:51:50+00:00","dateModified":"2007-02-19T09:01:34+00:00","breadcrumb":{"@id":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/bergs.biz\/blog\/2007\/01\/27\/nightmare-on-elmhhhwordpress-upgrade\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bergs.biz\/blog\/"},{"@type":"ListItem","position":2,"name":"Nightmare on Elm^H^H^HWordPress upgrade…"}]},{"@type":"WebSite","@id":"https:\/\/bergs.biz\/blog\/#website","url":"https:\/\/bergs.biz\/blog\/","name":"Ralf's Blog","description":"Just another WordPress weblog","publisher":{"@id":"https:\/\/bergs.biz\/blog\/#\/schema\/person\/354e37390b493c875f972bd313d29201"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bergs.biz\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/bergs.biz\/blog\/#\/schema\/person\/354e37390b493c875f972bd313d29201","name":"Ralf Bergs","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/bergs.biz\/blog\/wp-content\/uploads\/2026\/04\/Ralf-Tower-2026-1024x1024.jpg","url":"https:\/\/bergs.biz\/blog\/wp-content\/uploads\/2026\/04\/Ralf-Tower-2026-1024x1024.jpg","contentUrl":"https:\/\/bergs.biz\/blog\/wp-content\/uploads\/2026\/04\/Ralf-Tower-2026-1024x1024.jpg","width":1024,"height":1024,"caption":"Ralf Bergs"},"logo":{"@id":"https:\/\/bergs.biz\/blog\/wp-content\/uploads\/2026\/04\/Ralf-Tower-2026-1024x1024.jpg"},"description":"Geek, computer guy, licensed and certified electrical and computer engineer, husband, best daddy.","sameAs":["https:\/\/bergs.biz\/","https:\/\/linkedin.com\/in\/ralfbergs\/","https:\/\/x.com\/ralfbergs"],"url":"https:\/\/bergs.biz\/blog\/author\/rabe\/"}]}},"_links":{"self":[{"href":"https:\/\/bergs.biz\/blog\/wp-json\/wp\/v2\/posts\/26","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bergs.biz\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bergs.biz\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bergs.biz\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bergs.biz\/blog\/wp-json\/wp\/v2\/comments?post=26"}],"version-history":[{"count":0,"href":"https:\/\/bergs.biz\/blog\/wp-json\/wp\/v2\/posts\/26\/revisions"}],"wp:attachment":[{"href":"https:\/\/bergs.biz\/blog\/wp-json\/wp\/v2\/media?parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bergs.biz\/blog\/wp-json\/wp\/v2\/categories?post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bergs.biz\/blog\/wp-json\/wp\/v2\/tags?post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}