Title: Duplicate Fields Last modified: August 31, 2016 --- # Duplicate Fields * Resolved [sharmavishal](https://wordpress.org/support/users/sharmavishal/) * (@sharmavishal) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/) * Hi Christian * Using latest WP+BP and your plugin on a multisite. I get duplicate xprofile fields at the wp backend * At the front end the “Name” field is displayed alongwith First Name and Last Name. * Activated your plugin network wide and site wide but the same issue. * Thanks * [https://wordpress.org/plugins/bp-xprofile-wp-user-sync/](https://wordpress.org/plugins/bp-xprofile-wp-user-sync/) Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/duplicate-fields/page/2/?output_format=md) [→](https://wordpress.org/support/topic/duplicate-fields/page/2/?output_format=md) * Plugin Author [Christian Wach](https://wordpress.org/support/users/needle/) * (@needle) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409621) * Have you upgraded the plugin via the WordPress auto-update process? Have you activated the plugin on both main site and network-wide? Any other plugins active that could be interfering? * Cheers, Christian * Thread Starter [sharmavishal](https://wordpress.org/support/users/sharmavishal/) * (@sharmavishal) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409622) * Thanks for your reply. Highly appreciated * Did auto update..did manual update…same issue..db is backedup… * no. it was activated either network wide or on individual sites. * deactivated all plugins which might be an issue..like w3tc, custom xprofile fields. * any other way you would like me to test/check? * Thread Starter [sharmavishal](https://wordpress.org/support/users/sharmavishal/) * (@sharmavishal) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409625) * i just tested one thing..i droped the db..removed the plugin via FTP…uploaded the db again…gave the plugin not there error and plugin got deactivated… * now when i try to activate the plugin site specific or network wide i get this error: * Plugin could not be activated because it triggered a fatal error. * string(143) “BP XProfile WordPress User Sync plugin: Could not update “ID” for xProfile field. SQL = UPDATE inbbp_xprofile_fields SET id = 0 WHERE id = 2059″ * Plugin Author [Christian Wach](https://wordpress.org/support/users/needle/) * (@needle) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409626) * Well the auto-update might be the cause – this plugin tries to make it as clear as possible that you shouldn’t update that way, but perhaps it needs to be even clearer than it is. * Anyway that aside, can you check the ‘wp_bp_xprofile_fields’ table and see if there are duplicate “First Name” and “Last Name” fields? If so, you’ll need to figure out which ones are the “real” ones (i.e. the ones that your actual xprofile data is attached to) and delete the ones that are unused. * Plugin Author [Christian Wach](https://wordpress.org/support/users/needle/) * (@needle) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409630) * > now when i try to activate the plugin site specific or network wide i get this > error: > Plugin could not be activated because it triggered a fatal error. * There are remnants of the plugin remaining in your DB – look for the “bp_xp_wp_sync_installed” option and remove it. * Plugin Author [Christian Wach](https://wordpress.org/support/users/needle/) * (@needle) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409632) * > There are remnants of the plugin remaining in your DB – look for the “bp_xp_wp_sync_installed” > option and remove it. * I should add – remove any and all options prefixed with “bp_xp_wp_sync_”. There are three IIRC: “bp_xp_wp_sync_options”, “bp_xp_wp_sync_options_store” and “bp_xp_wp_sync_installed”. You’re going to have to reconnect your fields and data manually and set the “ bp_xp_wp_sync_options” data yourself. The array is of the form `array( 'first_name_field_id' => $first_name_field_id, 'last_name_field_id' => $last_name_field_id )`. The instructions above should help you identify the IDs to be used. * Thread Starter [sharmavishal](https://wordpress.org/support/users/sharmavishal/) * (@sharmavishal) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409636) * yes..i might have updated the latest release automatically…any way to disable autoupdate for your plugin? * suprisingly the backend db is perfect. there are not duplicate First Name and Last Name fields in the “bp_xprofile_fields” * any other thing to be tried out? * Thread Starter [sharmavishal](https://wordpress.org/support/users/sharmavishal/) * (@sharmavishal) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409643) * i get the other 2 in db..not “bp_xp_wp_sync_options_store”…i deleted them both… * as the firstname and lastname data was already there in the database i deleted the plugin and uploaded the db.. * activated your plugin again and it did create 2 additional firstname and lastname filds which i deleted. this new additiaonl 2 fields were showing both in backend and db. * now on userprofile it does show the first name and last name but alongwith the name..thats still fine by me… * backend when i go to a users extended profile then i see again all the fields duplicated including the firstname and lastname and other xprofile field names * Plugin Author [Christian Wach](https://wordpress.org/support/users/needle/) * (@needle) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409647) * > any way to disable autoupdate for your plugin? * It’s something I should look into, but I’d prefer BuddyPress to allow the disabling and hiding of xProfile fields instead. * > backend when i go to a users extended profile then i see again all the fields > duplicated including the firstname and lastname and other xprofile field names * There must be data somewhere in your DB that the plugin is reading (or missing) such that it’s not picking up the correct fields. From your error above, I’d assume that the correct “First Name” has (or had) ID = 2059. My guess would be that “Last Name” originally had ID = 2060. I’d work from there to find out what the data table expects the ID to be and what the value in “bp_xp_wp_sync_options” is. These all need to match – for both “First Name” and “Last Name”. * Thread Starter [sharmavishal](https://wordpress.org/support/users/sharmavishal/) * (@sharmavishal) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409650) * Thanks a lot for ur time on this. its highly appreciated. Indeed an honor for me to be interacting with you. * front end is displaying fine so i scanned the whole db. i got this plugin installed * [https://wordpress.org/plugins/register-ip-multisite/](https://wordpress.org/plugins/register-ip-multisite/) * this creates a wp_signups row in the db. this row has a “meta” coloum which has the duplicate xprofile data. * should i delete this data or its related to your plugin? * Plugin Author [Christian Wach](https://wordpress.org/support/users/needle/) * (@needle) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409653) * > this creates a wp_signups row in the db. this row has a “meta” coloum which > has the duplicate xprofile data. > should i delete this data or its related to your plugin? * This plugin definitely doesn’t interact with the `wp_signups` table. BuddyPress itself does reach into that table, so it could be that this is the cause. You’ll have to play around with your database to establish whether or not that’s the case. Please let me know if it is! * Thread Starter [sharmavishal](https://wordpress.org/support/users/sharmavishal/) * (@sharmavishal) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409657) * Thanks a lot…will update this thread if i find something * Plugin Author [Christian Wach](https://wordpress.org/support/users/needle/) * (@needle) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409695) * Thank you! Let’s leave this thread open for the time-being. * Thread Starter [sharmavishal](https://wordpress.org/support/users/sharmavishal/) * (@sharmavishal) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409704) * Thanks a lot christian…just tested one more scenario..created 2 subsites with your plugin on…the main site already had First Name and Last Name fields in xprofile fields database. * as soon as those 2 sites are created i get additional 4 fields. 2 First Name and 2 Last Name fields. i had to delete this additional 4 fields from the DB. * Should this additional fields be created in the first place? * Thread Starter [sharmavishal](https://wordpress.org/support/users/sharmavishal/) * (@sharmavishal) * [10 years ago](https://wordpress.org/support/topic/duplicate-fields/#post-7409705) * bp_xp_wp_sync_options table: * main site * a:2:{s:19:”first_name_field_id”;i:2055;s:18:”last_name_field_id”;i:2056;} * 2nd site * a:2:{s:19:”first_name_field_id”;i:2058;s:18:”last_name_field_id”;i:2059;} * 3rd site * a:2:{s:19:”first_name_field_id”;i:2569;s:18:”last_name_field_id”;i:2570;} * sholdnt the values be the same? Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/duplicate-fields/page/2/?output_format=md) [→](https://wordpress.org/support/topic/duplicate-fields/page/2/?output_format=md) The topic ‘Duplicate Fields’ is closed to new replies. * ![](https://ps.w.org/bp-xprofile-wp-user-sync/assets/icon-256x256.jpg?rev=1078253) * [BP xProfile WordPress User Sync](https://wordpress.org/plugins/bp-xprofile-wp-user-sync/) * [Support Threads](https://wordpress.org/support/plugin/bp-xprofile-wp-user-sync/) * [Active Topics](https://wordpress.org/support/plugin/bp-xprofile-wp-user-sync/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/bp-xprofile-wp-user-sync/unresolved/) * [Reviews](https://wordpress.org/support/plugin/bp-xprofile-wp-user-sync/reviews/) * 23 replies * 2 participants * Last reply from: [Christian Wach](https://wordpress.org/support/users/needle/) * Last activity: [9 years, 8 months ago](https://wordpress.org/support/topic/duplicate-fields/page/2/#post-8225862) * Status: resolved