{"id":937,"date":"2006-02-09T21:39:01","date_gmt":"2006-02-10T01:39:01","guid":{"rendered":"http:\/\/www.hoogervorst.ca\/arthur\/?p=937"},"modified":"2006-02-11T11:09:54","modified_gmt":"2006-02-11T15:09:54","slug":"burnt-wordpress","status":"publish","type":"post","link":"http:\/\/www.hoogervorst.ca\/arthur\/?p=937","title":{"rendered":"Burnt WordPress"},"content":{"rendered":"<p><span class=\"dropcap\">T<\/span>alking about burnt: it looks like WordPress is pretty much acting up with a couple of &#8216;SQL-errors&#8217; on my side. They happen to appear around the time I press the &#8216;Save&#8217; button. WordPress returns the following error:\n<\/p>\n<p><code>UPDATE IGNORE wp_posts SET .... (and posting information follows).<br \/>\n<\/code><\/p>\n<p>I have the impression something goes wrong with escaping single quotes. I&#8217;m testing this right now.\n<\/p>\n<p><small>Update 1: WordPress has problems with escaping of single quotes. A quick test of the previous entry seems to illustrate this.<br \/>\n<\/small>\n<\/p>\n<p><small>Update 2: It&#8217;s a combination of sorts and version differences make it harder to see where it goes wrong. On my test server <em>escaping<\/em> or not escaping doesn&#8217;t throw an error at all (version: 4.0.24_Debian-10-log vs. Dreamhost 4.1.14-Debian_3-log) . Different versions PHP too: home runs 4.3.10-16, and Dreamhost 4.4.2. (if you&#8217;re not familiar with how to extract PHP info, you can run <em>php -i > test.html<\/em> for 4.4.x versions: php will generate an html file). I still think it&#8217;s a magic quotes issue (and probably a bug introduced in WP 2.0.1)<br \/>\n<\/small>\n<\/p>\n<p><small>Update 3: <a href=\"http:\/\/www.webmasterstop.com\/63.html\">Priceless comment about &#8220;magic quotes&#8221;<\/a>. Developers, please escape your quotes (or convert those quotes to html entities).<br \/>\n<\/small>\n<\/p>\n<p><small>Update 4: <a href=\"http:\/\/wordpress.org\/support\/topic\/59258\">Thread to watch at WordPress.org<\/a><br \/>\n<\/small><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Talking about burnt: it looks like WordPress is pretty much acting up with a couple of &#8216;SQL-errors&#8217; on my side. They happen to appear around the time I press the &#8216;Save&#8217; button. WordPress returns the following error: UPDATE IGNORE wp_posts &hellip; <a href=\"http:\/\/www.hoogervorst.ca\/arthur\/?p=937\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[16],"tags":[],"_links":{"self":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/937"}],"collection":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=937"}],"version-history":[{"count":0,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/937\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=937"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=937"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}