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

This topic contains 5 replies, has 2 voices, and was last updated by  Patrik 5 years, 4 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: , ,

  • Author
    Posts
  • August 14, 2019 at 2:07 am #5003

    Foster
    Buyer
    Post count: 164

    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

    

		
	
    


    

			
				

    

	
    

		August 14, 2019 at 2:19 am

		
		#5005

		
		
		
	
    


    


    

	
    

		
		
    Foster
    Buyer
    
		
		
     Post count: 164
    
	
    

	
    

		
		This reply has been marked as private.
		
	
    


    

			
				

    

	
    

		August 14, 2019 at 7:07 am

		
		#5013

		
		
		
	
    


    


    

	
    

		
		
    Patrik
    Moderator
    
		
		
     Post count: 1971
    
	
    

	
    

		
		
    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
    

		
	
    


    

			
				

    

	
    

		August 14, 2019 at 1:40 pm

		
		#5030

		
		
		
	
    


    


    

	
    

		
		
    Foster
    Buyer
    
		
		
     Post count: 164
    
	
    

	
    

		
		
    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.
    

		
	
    


    

			
				

    

	
    

		August 14, 2019 at 5:43 pm

		
		#5031

		
		
		
	
    


    


    

	
    

		
		
    Foster
    Buyer
    
		
		
     Post count: 164
    
	
    

	
    

		
		
    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
    

		
	
    


    

			
				

    

	
    

		August 26, 2019 at 6:51 am

		
		#5084

		
		
		
	
    


    


    

	
    

		
		
    Patrik
    Moderator
    
		
		
     Post count: 1971
    
	
    

	
    

		
		
    We highly recommend using PHP version 7 or latest. Let me know if it resolves your problem or not.
    

    Regards,
    
Patrik
    

		
	
    


    

			
		
	
    • 

	
  • 

		
    Author
    

		
    

			
				Posts
			
		
    

	
    • 





			



	


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


	


		
	





		
				

			

				

					
We have moved to a support ticketing system and our forums are now closed.

					Open Support Ticket