{"id":16600060,"date":"2023-03-27T20:18:18","date_gmt":"2023-03-27T20:18:18","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-problems-37\/"},"modified":"2023-03-27T20:20:29","modified_gmt":"2023-03-27T20:20:29","slug":"database-problems-37","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-problems-37\/","title":{"rendered":"Database problems"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hello again Antoine,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I wanted to make matches for the upcoming games and when I went to teams menu it was empty. Did not think much of it as there are not a lot of teams, so I wanted to create them from a scrach. When I tried, I could not as after saving nothing showed in the table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I turned on de-bugging and got this error:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>WordPress database error:<\/strong>&nbsp;[Unknown column &#8216;t.is_favorite&#8217; in &#8216;field list&#8217;]<br \/><code>SELECT t.id, t.name, t.photo, t.flag, t.link, g.id AS group_id, g.name as group_name, t.is_real, t.is_active, t.is_favorite, t.group_order, t.comments FROM pool_wp_teams t LEFT OUTER JOIN pool_wp_groups g ON t.group_id = g.id ORDER BY t.name ASC<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I suspect there might be some problem that after upgrading to newest version plugin did not create the necessary field. As my current table in DB looks like this:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">https:\/\/ibb.co\/z8M58QN<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Is it possible to just add the necessary field without braking the DB or it has to be made from scratch?<br \/><br \/>EDIT#1 DB table indeed have all the team data, it just cannot display in site because of this error.<\/p>\n","protected":false},"template":"","class_list":["post-16600060","topic","type-topic","status-publish","hentry","topic-tag-database"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16600060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":3,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16600060\/revisions"}],"predecessor-version":[{"id":16600076,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16600060\/revisions\/16600076"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=16600060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}