Lost user info – \"Too many columns\" – Form Builder

This topic contains 4 replies, has 2 voices, and was last updated by  Foster 1 week, 1 day ago.

  • Author
    Posts
  • #5003

    Foster
    Buyer
    Post count: 79

    Hello,

    I am unfortunately running into the same issue I had a few months ago.

    Yesterday while trying to format the Profile page, I tried to update a field to show in the “profile side” location and ran into the “Column change failed, you may have too many columns” error again. So, as before I re-added the fields for Facebook Page, phone number, website, Active State(s), and User Role.

    Any user info entered into those fields prior to re-adding them appears to have been lost, again (I think the info had been lost before I attempted to re-add the fields not in the process).

    This wasn’t much of an issue before but now I’m having new users sign up more regularly and don’t want to be losing their data.

    I only have 12 fields so I’m not sure how there are “too many columns”.

    
    ### WordPress Environment ###
    
    Home URL: https://venuemaps.net
    Site URL: https://venuemaps.net
    UWP Version: 1.1.3
    WP Version: 5.2.2
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    UWP Mode: UsersWP is Activate for Single Site
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.10 (Debian)
    PHP Version: 7.3.6-1+0~20190531112546.39+jessie~1.gbp6131b7
    PHP Post Max Size: 12 MB
    PHP Time Limit: 60
    PHP Max Input Vars: 2500
    cURL Version: 7.38.0
    OpenSSL/1.0.1t
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.44
    Max Upload Size: 12 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    GD Library: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    UWP Database Version: 1.1.3
    UWP Database Prefix: wpzq_
    Total Database Size: 75.49MB
    Database Data Size: 52.13MB
    Database Index Size: 23.36MB
    wpzq_uwp_usermeta: Data: 0.05MB + Index: 0.00MB
    wpzq_uwp_form_fields: Data: 0.02MB + Index: 0.00MB
    wpzq_uwp_form_extras: Data: 0.02MB + Index: 0.00MB
    wpzq_uwp_activity: ❌ Table does not exist
    wpzq_uwp_followers: ❌ Table does not exist
    wpzq_uwp_friends: ❌ Table does not exist
    wpzq_bp_activity: Data: 0.00MB + Index: 0.01MB
    wpzq_bp_activity_meta: Data: 0.00MB + Index: 0.00MB
    wpzq_bp_friends: Data: 0.00MB + Index: 0.00MB
    wpzq_bp_messages_messages: Data: 0.00MB + Index: 0.00MB
    wpzq_bp_messages_meta: Data: 0.00MB + Index: 0.00MB
    wpzq_bp_messages_notices: Data: 0.00MB + Index: 0.00MB
    wpzq_bp_messages_recipients: Data: 0.00MB + Index: 0.01MB
    wpzq_bp_notifications: Data: 0.00MB + Index: 0.01MB
    wpzq_bp_notifications_meta: Data: 0.00MB + Index: 0.00MB
    wpzq_bp_user_blogs: Data: 0.00MB + Index: 0.00MB
    wpzq_bp_user_blogs_blogmeta: Data: 0.00MB + Index: 0.01MB
    wpzq_bp_xprofile_data: Data: 0.00MB + Index: 0.00MB
    wpzq_bp_xprofile_fields: Data: 0.00MB + Index: 0.01MB
    wpzq_bp_xprofile_groups: Data: 0.00MB + Index: 0.00MB
    wpzq_bp_xprofile_meta: Data: 0.00MB + Index: 0.01MB
    wpzq_commentmeta: Data: 0.00MB + Index: 0.00MB
    wpzq_comments: Data: 0.09MB + Index: 0.04MB
    wpzq_countries: Data: 0.08MB + Index: 0.00MB
    wpzq_email_log: Data: 0.06MB + Index: 0.00MB
    wpzq_ewwwio_images: Data: 1.52MB + Index: 1.61MB
    wpzq_geodir_api_keys: Data: 0.02MB + Index: 0.03MB
    wpzq_geodir_attachments: Data: 1.40MB + Index: 0.09MB
    wpzq_geodir_business_hours: Data: 0.02MB + Index: 0.00MB
    wpzq_geodir_claim: Data: 0.02MB + Index: 0.00MB
    wpzq_geodir_comments_reviews: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_countries: Data: 0.03MB + Index: 0.00MB
    wpzq_geodir_coupons: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_cp_link_posts: Data: 0.02MB + Index: 0.02MB
    wpzq_geodir_custom_advance_search_fields: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_custom_fields: Data: 0.05MB + Index: 0.00MB
    wpzq_geodir_custom_sort_fields: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_event_schedule: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_gd_agency_detail: Data: 0.02MB + Index: 0.05MB
    wpzq_geodir_gd_band_detail: Data: 0.02MB + Index: 0.05MB
    wpzq_geodir_gd_booking_detail: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_gd_diy_detail: Data: 0.02MB + Index: 0.03MB
    wpzq_geodir_gd_event_detail: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_gd_festival_detail: Data: 0.02MB + Index: 0.03MB
    wpzq_geodir_gd_place_detail: Data: 2.94MB + Index: 0.23MB
    wpzq_geodir_gd_promoter_detail: Data: 0.02MB + Index: 0.03MB
    wpzq_geodir_gd_venue_detail: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_invoice: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_location_seo: Data: 0.01MB + Index: 0.00MB
    wpzq_geodir_post_icon: Data: 1.34MB + Index: 0.08MB
    wpzq_geodir_post_locations: Data: 0.21MB + Index: 0.03MB
    wpzq_geodir_post_neighbourhood: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_post_packages: Data: 0.05MB + Index: 0.00MB
    wpzq_geodir_post_review: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_price: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_pricemeta: Data: 0.02MB + Index: 0.03MB
    wpzq_geodir_rating_category: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_rating_style: Data: 0.00MB + Index: 0.00MB
    wpzq_geodir_tabs_layout: Data: 0.02MB + Index: 0.00MB
    wpzq_geodir_term_meta: Data: 0.76MB + Index: 0.05MB
    wpzq_geodir_unassign_comment_images: Data: 0.00MB + Index: 0.00MB
    wpzq_grp_google_place: Data: 0.02MB + Index: 0.02MB
    wpzq_grp_google_review: Data: 0.02MB + Index: 0.03MB
    wpzq_ip_geo_block_cache: Data: 0.02MB + Index: 0.02MB
    wpzq_ip_geo_block_logs: Data: 0.31MB + Index: 0.03MB
    wpzq_ip_geo_block_stat: Data: 0.02MB + Index: 0.00MB
    wpzq_links: Data: 0.00MB + Index: 0.00MB
    wpzq_ms_snippets: Data: 0.02MB + Index: 0.00MB
    wpzq_nf3_actions: Data: 0.02MB + Index: 0.00MB
    wpzq_nf3_action_meta: Data: 0.13MB + Index: 0.00MB
    wpzq_nf3_chunks: Data: 0.02MB + Index: 0.00MB
    wpzq_nf3_fields: Data: 0.02MB + Index: 0.00MB
    wpzq_nf3_field_meta: Data: 1.52MB + Index: 0.00MB
    wpzq_nf3_forms: Data: 0.02MB + Index: 0.00MB
    wpzq_nf3_form_meta: Data: 0.11MB + Index: 0.00MB
    wpzq_nf3_objects: Data: 0.02MB + Index: 0.00MB
    wpzq_nf3_object_meta: Data: 0.02MB + Index: 0.00MB
    wpzq_nf3_relationships: Data: 0.02MB + Index: 0.00MB
    wpzq_nf3_upgrades: Data: 0.47MB + Index: 0.00MB
    wpzq_options: Data: 12.89MB + Index: 0.12MB
    wpzq_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB
    wpzq_postmeta: Data: 15.85MB + Index: 2.20MB
    wpzq_posts: Data: 4.52MB + Index: 3.52MB
    wpzq_searchlog: Data: 0.27MB + Index: 0.00MB
    wpzq_signups: Data: 0.00MB + Index: 0.01MB
    wpzq_snippets: Data: 0.02MB + Index: 0.00MB
    wpzq_statistics_exclusions: Data: 0.02MB + Index: 0.03MB
    wpzq_statistics_historical: Data: 0.02MB + Index: 0.05MB
    wpzq_statistics_pages: Data: 0.39MB + Index: 1.33MB
    wpzq_statistics_search: Data: 0.02MB + Index: 0.05MB
    wpzq_statistics_useronline: Data: 0.02MB + Index: 0.00MB
    wpzq_statistics_visit: Data: 0.06MB + Index: 0.02MB
    wpzq_statistics_visitor: Data: 4.52MB + Index: 10.58MB
    wpzq_termmeta: Data: 0.01MB + Index: 0.01MB
    wpzq_terms: Data: 0.02MB + Index: 0.04MB
    wpzq_term_relationships: Data: 0.51MB + Index: 1.09MB
    wpzq_term_taxonomy: Data: 0.02MB + Index: 0.03MB
    wpzq_tm_taskmeta: Data: 0.02MB + Index: 0.03MB
    wpzq_tm_tasks: Data: 0.02MB + Index: 0.02MB
    wpzq_usermeta: Data: 0.41MB + Index: 0.17MB
    wpzq_users: Data: 0.03MB + Index: 0.04MB
    wpzq_uwp_social_profiles: Data: 0.02MB + Index: 0.03MB
    wpzq_wpinv_subscriptions: Data: 0.02MB + Index: 0.06MB
    wpzq_wplc_chat_msgs: Data: 0.02MB + Index: 0.00MB
    wpzq_wplc_chat_ratings: Data: 0.02MB + Index: 0.00MB
    wpzq_wplc_chat_sessions: Data: 0.02MB + Index: 0.00MB
    wpzq_wplc_chat_triggers: Data: 0.02MB + Index: 0.00MB
    wpzq_wplc_custom_fields: Data: 0.02MB + Index: 0.00MB
    wpzq_wplc_departments: Data: 0.02MB + Index: 0.00MB
    wpzq_wplc_offline_messages: Data: 0.02MB + Index: 0.00MB
    wpzq_wplc_roi_conversions: Data: 0.02MB + Index: 0.00MB
    wpzq_wplc_roi_goals: Data: 0.02MB + Index: 0.00MB
    wpzq_wplc_webhooks: Data: 0.02MB + Index: 0.00MB
    wpzq_wplnst_scans: Data: 0.13MB + Index: 0.08MB
    wpzq_wplnst_scans_objects: Data: 0.02MB + Index: 0.05MB
    wpzq_wplnst_urls: Data: 0.08MB + Index: 0.19MB
    wpzq_wplnst_urls_locations: Data: 0.02MB + Index: 0.28MB
    wpzq_wplnst_urls_locations_att: Data: 0.02MB + Index: 0.06MB
    wpzq_wplnst_urls_status: Data: 0.02MB + Index: 0.23MB
    wpzq_wsluserscontacts: Data: 0.00MB + Index: 0.00MB
    wpzq_wslusersprofiles: Data: 0.00MB + Index: 0.00MB
    wpzq_yoast_seo_links: Data: 0.02MB + Index: 0.02MB
    wpzq_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB
    wp_comments: Data: 0.02MB + Index: 0.08MB
    wp_links: Data: 0.02MB + Index: 0.02MB
    wp_options: Data: 0.05MB + Index: 0.02MB
    wp_postmeta: Data: 0.02MB + Index: 0.03MB
    wp_posts: Data: 0.02MB + Index: 0.06MB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB
    wp_terms: Data: 0.02MB + Index: 0.03MB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB
    wp_users: Data: 0.02MB + Index: 0.05MB
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (31) ###
    
    WP Easy Updates: by AyeCode Ltd – 1.1.10
    Adaptive Images for WordPress: by Nevma – 0.6.67
    AddToAny Share Buttons: by AddToAny – 1.7.36
    Beaver Builder Plugin (Lite Version): by The Beaver Builder Team – 2.2.4.3
    Breeze: by Cloudways – 1.0.11
    Code Snippets: by Shea Bunge – 2.13.3
    Email Log: by Sudar – 2.3.1
    GeoDirectory Google Analytics: by GeoDirectory – 2.0.0.4
    GeoDirectory Advanced Search Filters: by AyeCode Ltd – 2.0.0.12
    GeoDirectory Ajax Duplicate Alert: by GeoDirectory – 2.0.0.2
    GeoDirectory Claim Listings: by AyeCode Ltd – 2.0.0.8
    GeoDirectory Map Styles: by GeoDirectory – 2.0.0.2
    GeoDirectory Custom Post Types: by AyeCode Ltd – 2.0.0.13
    GeoDirectory Location Manager: by AyeCode Ltd – 2.0.0.20
    GeoDirectory Pricing Manager: by AyeCode Ltd – 2.5.0.12
    GeoDirectory Re-Captcha: by AyeCode Ltd – 2.0.0.2
    GeoDirectory Social Importer: by AyeCode Ltd – 2.0.1.3
    GeoDirectory: by AyeCode Ltd – 2.0.0.65
    Google XML Sitemaps: by Arne Brachhold – 4.1.0
    Anti-Malware Security and Brute-Force Firewall: by Eli Scheetz – 4.18.76
    Invoicing: by AyeCode Ltd – 1.0.10
    IP Geo Block: by tokkonopapa – 3.0.17.4
    Ninja Forms: by The WP Ninjas – 3.4.17
    Really Simple SSL: by Rogier Lankhorst
    Mark Wolters – 3.2.3
    
    ShortPixel Image Optimizer: by ShortPixel – 4.14.3
    SiteOrigin Widgets Bundle: by SiteOrigin – 1.15.7
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.16.16
    
    UsersWP: by AyeCode Ltd – 1.1.3
    Widget Importer & Exporter: by ChurchThemes.com – 1.5.5
    Widget Logic: by WPChef – 5.10.4
    WP Statistics: by VeronaLabs – 12.6.7
    
    ### UWP Pages ###
    
    Profile Page: ❌ Page does not contains the shortcode.
    Register Page: #18864 - /account/register/
    Login Page: #18865 - /account/login/
    Account Page: #18866 - /account/
    Change Password Page: #18862 - /account/change/
    Forgot Password Page: #18860 - /account/forgot/
    Reset Password Page: #18861 - /account/reset/
    Users List Page: #18867 - /account/users/
    
    ### Theme ###
    
    Name: Lisitmia - Child Theme
    Version: 1
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Listimia
    Parent Theme Version: 1.0.9.3
    Parent Theme Author URL: https://addictedtoweb.com
    
    ### Templates ###
    
    Overrides: listimia/userswp/profile.php
    
    #5005

    Foster
    Buyer
    Post count: 79
    This reply has been marked as private.
    #5013

    patrik
    Moderator
    Post count: 1268

    Hi,

    This error generally coming from the database table update failed. Whenever you create a new field, it will add a new column for that field in the Database. So I would suggest you discuss with your hosting provider about why adding columns to the database fails and if there are any limits of adding columns then ask them to increase.

    Please make sure you keep the same key while recreating the fields otherwise the data can be not displayed properly but as the table has the column with the same key, you can create field anytime and the data will be displayed properly.

    Regards,
    Patrik

    #5030

    Foster
    Buyer
    Post count: 79

    I did not get the error when creating NEW fields. Only when trying to SAVE settings for fields that are already there.

    Has anyone else reported losing data in connection with the “too many columns” error?

    I have opened a ticket with Cloudways.

    #5031

    Foster
    Buyer
    Post count: 79

    Cloudways support says

    Could you please check with the plugin devs if the current Mysql version ( 5.6 ) is supported by them?
    If not, then please try to upgrade it to 5.7 or higher

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.