{"id":409,"date":"2008-03-31T20:03:23","date_gmt":"2008-03-31T19:03:23","guid":{"rendered":"https:\/\/www.networknet.nl\/apps\/wp\/archives\/409"},"modified":"2008-03-31T20:36:26","modified_gmt":"2008-03-31T19:36:26","slug":"wordpress-version-25-upgrade","status":"publish","type":"post","link":"https:\/\/www.networknet.nl\/apps\/wp\/archives\/409","title":{"rendered":"WordPress version 2.5 upgrade"},"content":{"rendered":"<p><a href=\"https:\/\/www.networknet.nl\/apps\/wp\/wp-content\/uploads\/Wordpressversion2.5upgrade_12810\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" height=\"68\" alt=\"image\" src=\"https:\/\/www.networknet.nl\/apps\/wp\/wp-content\/uploads\/Wordpressversion2.5upgrade_12810\/image_thumb.png\" width=\"250\" align=\"left\" border=\"0\"><\/a> Two hours ago I upgraded Networknet.nl with WordPress version 2.5 and immediately after the php binaries and database were upgraded I hit my first problem. Within my Widgets Design Sidebar I have the Pages widget which shows all pages on the right side of my blog starting with &#8220;About me&#8221;.. VMware. For some topics I created pages instead of WordPress posts and linked those pages to a parent page; these two pages were excluded from &#8220;Pages Widget&#8221;. After the upgrade my pages widget become really huge showing 30+ pages. I did a search on WordPress support site and someone else already reported this problem; no response yet except me on this post.&nbsp; <\/p>\n<p>I didn&#8217;t want to downgrade my new WordPress version and therefore I used this method to query the parent pages and exclude them manually without doing the PHP code research how to exclude them.<\/p>\n<ul>\n<li>Open phpmyadmin\n<li>Select your wordpress database\n<li>Open wp_posts and click SQL<\/li>\n<\/ul>\n<blockquote>\n<p><a href=\"https:\/\/www.networknet.nl\/apps\/wp\/wp-content\/uploads\/Wordpressversion2.5upgrade_12810\/image_3.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px\" height=\"313\" alt=\"image\" src=\"https:\/\/www.networknet.nl\/apps\/wp\/wp-content\/uploads\/Wordpressversion2.5upgrade_12810\/image_thumb_3.png\" width=\"596\" border=\"0\"><\/a>&nbsp;&nbsp;&nbsp; <\/p>\n<\/blockquote>\n<ul>\n<li>Paste this sql query<\/li>\n<\/ul>\n<blockquote>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">  &lt;p&gt;SELECT id&lt;br&gt;FROM 'wp_posts'&lt;br&gt;WHERE 'post_type' = 'page'&lt;br&gt;AND 'post_parent' NOT LIKE '0' &lt;\/p&gt;<\/pre>\n<\/blockquote>\n<ul>\n<li>Click GO button and click Export; I export to CSV to excel and copied all cells into Notepad.<\/li>\n<\/ul>\n<blockquote>\n<p><a href=\"https:\/\/www.networknet.nl\/apps\/wp\/wp-content\/uploads\/Wordpressversion2.5upgrade_12810\/image_4.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px\" height=\"117\" alt=\"image\" src=\"https:\/\/www.networknet.nl\/apps\/wp\/wp-content\/uploads\/Wordpressversion2.5upgrade_12810\/image_thumb_4.png\" width=\"544\" border=\"0\"><\/a> <\/p>\n<\/blockquote>\n<ul>\n<li>Paste these pages into the exclude for your pages widget.<\/li>\n<\/ul>\n<p>Dirty solution but I solved my problem in less than 5 minutes for now&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Two hours ago I upgraded Networknet.nl with WordPress version 2.5 and immediately after the php binaries and database were upgraded I hit my first problem. Within my Widgets Design Sidebar I have the Pages widget which shows all pages on the right side of my blog starting with &#8220;About me&#8221;.. VMware. For some topics I created pages instead of WordPress posts and linked those pages to a parent page; these two pages were excluded from &#8220;Pages Widget&#8221;. After the upgrade my pages widget become really huge showing 30+ pages. I did a search on WordPress support site and someone else already reported this problem; no response yet except me on this post.&nbsp; I didn&#8217;t want to downgrade my new WordPress version and therefore I used this method to query the parent pages and exclude them manually without doing the PHP code research how to exclude them. Open phpmyadmin Select your wordpress database Open wp_posts and click SQL &nbsp;&nbsp;&nbsp; Paste this sql query &lt;p&gt;SELECT id&lt;br&gt;FROM &#8216;wp_posts'&lt;br&gt;WHERE &#8216;post_type&#8217; = &#8216;page'&lt;br&gt;AND &#8216;post_parent&#8217; NOT LIKE &#8216;0&#8217; &lt;\/p&gt; Click GO button and click Export; I export to CSV to excel and copied all cells into Notepad. Paste these pages into the exclude for your pages widget. Dirty solution but I solved my problem in less than 5 minutes for now&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[285],"tags":[303,306,307,305,304,302],"class_list":["post-409","post","type-post","status-publish","format-standard","hentry","category-opensource","tag-303","tag-exclude","tag-fix","tag-pages","tag-widget","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/www.networknet.nl\/apps\/wp\/wp-json\/wp\/v2\/posts\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.networknet.nl\/apps\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.networknet.nl\/apps\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.networknet.nl\/apps\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.networknet.nl\/apps\/wp\/wp-json\/wp\/v2\/comments?post=409"}],"version-history":[{"count":0,"href":"https:\/\/www.networknet.nl\/apps\/wp\/wp-json\/wp\/v2\/posts\/409\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.networknet.nl\/apps\/wp\/wp-json\/wp\/v2\/media?parent=409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.networknet.nl\/apps\/wp\/wp-json\/wp\/v2\/categories?post=409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.networknet.nl\/apps\/wp\/wp-json\/wp\/v2\/tags?post=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}