Skip to Content Skip to Menu

updating user's field

  • piluche
  • piluche
  • OFFLINE
  • Posts: 78
  • Thanks: 13
  • Karma: 0
1 month 3 weeks ago #339799 by piluche
updating user's field was created by piluche
Hello,
When i try to update a user's CB field, i cant.
An error message : Field 'pluriel' doesn't have a default value
This field doesnt exist on CB field but on Acymailing fields
I set a default value in the Acymailing filed , no way !
I disabled Acymailing CB integration, no way !
What's going wrong ?
If creds needed, please ask
Thanks for help
Friendly
Philippe(Paris, France)
 
Attachments:

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48757
  • Thanks: 8327
  • Karma: 1448
1 month 3 weeks ago #339802 by krileon
Replied by krileon on topic updating user's field
That looks like an SQL error. Seams the table where that field is stored doesn't have a default value set and a value isn't being set during storage thus the error. As it doesn't begin with cb_ it's not coming from CB as a custom field in CB > Field Management and isn't a core CB field. So you've either a 3rd party field that wasn't created properly or you've an integration acting on Joomla or CB user storage not doing so correctly.

Since you've determined it's from AcyMailing and unpublishing it doesn't resolve the issue my guess is they added a database column to _comprofiler or _users incorrectly. Within your database review the _comprofiler table and see if there's a column named "pluriel". If there is try deleting it and re-installing your AcyMailing integration or contacting AcyMailing support regarding your issue.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • piluche
  • piluche
  • OFFLINE
  • Posts: 78
  • Thanks: 13
  • Karma: 0
1 month 3 weeks ago #339803 by piluche
Replied by piluche on topic updating user's field
Thanks Krleon
I'll check !
have a nice week-end
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum