Answers.Body: <p>I have had this issue recently and the issue was with the plugin 'WPBakery Visual Composer' that caused the issue. We deactivate the plugin, add the profile and reactivate it. We suspect it is a setting within the plugin but haven't identified it yet. I will update when we do. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-05-03T21:33:58.727Z
Answers.LastActivityDate: 2017-05-03T21:33:58.727Z
Answers.UserDisplayName: KilakwaBT
Answers.Body: <p>The problem came with the theme I had activated (Nimva by Rockythemes). I haven't been able to troubleshoot exactly what caused it (and likely won't have time anytime soon) but switching to a default theme and even leaving all the plugins activated allowed the dropdown menus to work as intended.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-05T18:30:47.700Z
Answers.LastActivityDate: 2016-10-05T18:30:47.700Z
Answers.UserDisplayName: matthewlehew
Body: <p>I am getting the same problem that is described <a href="https://civicrm.stackexchange.com/questions/2990/db-error-constraint-violation-when-i-try-to-add-profiles-to-contribution-page">here</a> and <a href="https://civicrm.stackexchange.com/questions/10895/cant-add-profile-to-contribution-page">here</a>, but I can't find a clear resolution on either of these pages.</p>
  
  <p>I am working with a fresh install of CiviCRM 4.7.11 on Wordpress 4.6.1. This is running on an AWS EC2 running Ubuntu 14.04. When attempting to create a membership signup page, the profiles tab contains a text box instead of drop-down menus. I created a custom profile after I observed this behavior, and am unable to access a selection mechanism to select the profile I created or any of the stock profiles. </p>
  
  <p><a href="https://i.sstatic.net/1NuMF.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/1NuMF.png" alt="This is what I see."></a></p>
  
  <p>When I look at the console log for errors, these two errors appear consistently:</p>
  
  <p><a href="https://i.sstatic.net/9A98H.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/9A98H.png" alt="Console error output"></a></p>
  
  <p>Any advice would be much appreciated!</p>
  
Tags: <wordpress><profile>
Title: Can't add profiles to contribution page (DB Error: constraint violation)
ThreadText: # Can't add profiles to contribution page (DB Error: constraint violation)
  
  (Asked by: username_0 on 2016-10-05)
  
  I am getting the same problem that is described [here](https://civicrm.stackexchange.com/questions/2990/db-error-constraint-violation-when-i-try-to-add-profiles-to-contribution-page) and [here](https://civicrm.stackexchange.com/questions/10895/cant-add-profile-to-contribution-page), but I can't find a clear resolution on either of these pages.
  
  I am working with a fresh install of CiviCRM 4.7.11 on Wordpress 4.6.1. This is running on an AWS EC2 running Ubuntu 14.04. When attempting to create a membership signup page, the profiles tab contains a text box instead of drop-down menus. I created a custom profile after I observed this behavior, and am unable to access a selection mechanism to select the profile I created or any of the stock profiles.
  
  [![This is what I see.](https://i.sstatic.net/1NuMF.png)](https://i.sstatic.net/1NuMF.png)
  
  When I look at the console log for errors, these two errors appear consistently:
  
  [![Console error output](https://i.sstatic.net/9A98H.png)](https://i.sstatic.net/9A98H.png)
  
  Any advice would be much appreciated!
  
  **Tags:** wordpress, profile
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2017-05-03. Score: 1
  
  I have had this issue recently and the issue was with the plugin 'WPBakery Visual Composer' that caused the issue. We deactivate the plugin, add the profile and reactivate it. We suspect it is a setting within the plugin but haven't identified it yet. I will update when we do.
  
  
  ---
  
  ### Answer by username_0 on 2016-10-05. Score: 1
  
  The problem came with the theme I had activated (Nimva by Rockythemes). I haven't been able to troubleshoot exactly what caused it (and likely won't have time anytime soon) but switching to a default theme and even leaving all the plugins activated allowed the dropdown menus to work as intended.
  
  
  ---
  
  