{"id":794,"date":"2026-10-20T09:04:57","date_gmt":"2026-10-20T08:04:57","guid":{"rendered":"https:\/\/userswp.io\/documentation\/article\/form-builder-column-change-failed\/"},"modified":"2026-10-20T09:04:57","modified_gmt":"2026-10-20T08:04:57","slug":"form-builder-column-change-failed","status":"publish","type":"gd_place","link":"https:\/\/userswp.io\/documentation\/article\/troubleshooting\/form-builder-column-change-failed\/","title":{"rendered":"Form builder error: &#8220;Column change failed, you may have too many columns&#8221;"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">UsersWP keeps each custom account field in its own column of the <code>uwp_usermeta<\/code> database table. When you save a field in UsersWP &gt; Form Builder, UsersWP changes that column with an ALTER TABLE query. &#8220;Column change failed, you may have too many columns&#8221; means the database refused that change. Until it is fixed, the field settings do not save, and users&#8217; entries in that field may not save either.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Common causes<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The table is at the MySQL row size limit. Every text field adds a column, and MySQL caps how much a row can hold, so sites with many fields can hit it.<\/li>\n\n\n\n<li>The column for the field no longer exists, for example after a migration or a partial database restore, so there is nothing to change.<\/li>\n\n\n\n<li>The database user lacks permission to alter tables. Some hosts restrict this.<\/li>\n\n\n\n<li>The default value does not fit the field type, for example text in a number field.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Fix it<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Back up the database first.<\/li>\n\n\n\n<li>Export your users from UsersWP &gt; Import\/Export &gt; Users so you have a copy of the field data.<\/li>\n\n\n\n<li>Remove fields you no longer use from the account form. Each one you delete frees a column.<\/li>\n\n\n\n<li>For the field that fails, delete it and add it again with the same field key.<\/li>\n\n\n\n<li>Import the user data back from the export if you need to.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Deleting a field from the account form drops its database column, and with it every value users entered in that field. If a field is used by more than one registration form, the column is kept until it is removed from all of them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If new fields cannot be created either (&#8220;Column creation failed&#8221;), the table is most likely full. Fewer fields, or switching long text fields to fewer, combined fields, is the lasting fix. Your host can also tell you whether the database user has ALTER privileges.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>UsersWP keeps each custom account field in its own column of the uwp_usermeta database table. When you save a field in UsersWP &gt; Form Builder, UsersWP changes that column with an ALTER TABLE query. &#8220;Column change failed, you may have too many columns&#8221; means the database refused that change. Until it is fixed, the field [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"article\/tags":[],"article\/categories":[39,7],"class_list":["post-794","gd_place","type-gd_place","status-publish","hentry","gd_placecategory-troubleshooting","gd_placecategory-tips-tricks-more"],"_links":{"self":[{"href":"https:\/\/userswp.io\/documentation\/wp-json\/wp\/v2\/article\/794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/userswp.io\/documentation\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/userswp.io\/documentation\/wp-json\/wp\/v2\/types\/gd_place"}],"author":[{"embeddable":true,"href":"https:\/\/userswp.io\/documentation\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/userswp.io\/documentation\/wp-json\/wp\/v2\/comments?post=794"}],"version-history":[{"count":0,"href":"https:\/\/userswp.io\/documentation\/wp-json\/wp\/v2\/article\/794\/revisions"}],"wp:attachment":[{"href":"https:\/\/userswp.io\/documentation\/wp-json\/wp\/v2\/media?parent=794"}],"wp:term":[{"taxonomy":"gd_place_tags","embeddable":true,"href":"https:\/\/userswp.io\/documentation\/wp-json\/wp\/v2\/article\/tags?post=794"},{"taxonomy":"gd_placecategory","embeddable":true,"href":"https:\/\/userswp.io\/documentation\/wp-json\/wp\/v2\/article\/categories?post=794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}