{"id":4081,"date":"2021-06-15T12:02:07","date_gmt":"2021-06-15T17:02:07","guid":{"rendered":"https:\/\/www.incredigeek.com\/home\/?p=4081"},"modified":"2021-06-15T12:02:08","modified_gmt":"2021-06-15T17:02:08","slug":"librenms-error-port_groups-base-table-or-view-already-exists","status":"publish","type":"post","link":"https:\/\/www.incredigeek.com\/home\/librenms-error-port_groups-base-table-or-view-already-exists\/","title":{"rendered":"LibreNMS Error &#8211; port_groups Base table or view already exists"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.incredigeek.com\/home\/wp-content\/uploads\/2021\/06\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"387\" src=\"https:\/\/www.incredigeek.com\/home\/wp-content\/uploads\/2021\/06\/image-1024x387.png\" alt=\"\" class=\"wp-image-4082\" srcset=\"https:\/\/www.incredigeek.com\/home\/wp-content\/uploads\/2021\/06\/image-1024x387.png 1024w, https:\/\/www.incredigeek.com\/home\/wp-content\/uploads\/2021\/06\/image-300x113.png 300w, https:\/\/www.incredigeek.com\/home\/wp-content\/uploads\/2021\/06\/image-768x290.png 768w, https:\/\/www.incredigeek.com\/home\/wp-content\/uploads\/2021\/06\/image-1536x580.png 1536w, https:\/\/www.incredigeek.com\/home\/wp-content\/uploads\/2021\/06\/image-500x189.png 500w, https:\/\/www.incredigeek.com\/home\/wp-content\/uploads\/2021\/06\/image.png 1787w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>port_groups issue upgrading LibreNMS<\/figcaption><\/figure>\n\n\n\n<p>The above error can be resolved by dropping the port_groups table in mysql.  You may double check that there is no information in the table.  I checked this instance and it didn&#8217;t have any data in the table so I dropped it with<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">drop table port_groups;<\/pre>\n\n\n\n<p>I then ran the lnms command again and it created the table and started migrating.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The above error can be resolved by dropping the port_groups table in mysql. You may double check that there is no information in the table. I checked this instance and it didn&#8217;t have any data in the table so I &hellip; <a href=\"https:\/\/www.incredigeek.com\/home\/librenms-error-port_groups-base-table-or-view-already-exists\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[352],"tags":[1233,353,1232,389,1234],"class_list":["post-4081","post","type-post","status-publish","format-standard","hentry","category-librenms","tag-base-table","tag-librenms","tag-network-monitoring","tag-nms","tag-port_groups"],"_links":{"self":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts\/4081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/comments?post=4081"}],"version-history":[{"count":1,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts\/4081\/revisions"}],"predecessor-version":[{"id":4083,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts\/4081\/revisions\/4083"}],"wp:attachment":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/media?parent=4081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/categories?post=4081"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/tags?post=4081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}