The message in the thread title appears when saving profile updates (in that case canvas picture and avatar)
The updates are applied, despite the error message. I can only guess which field is affected, as there is no "gender" field. We have a field "cb_geschlecht", which is text and shows values like männlich or weiblich (male or female). Users can set their cb_geschlecht from a drop-down, after registration - so this information is not available for everyone

Our joomla version is 4.3.1
CB is on version 2.8.0+build.2023.03.17.19.11.55.64386eb8d
PHP Version 8.0.24
mysql  Ver 14.14 Distrib 5.7.42, for Linux (x86_64) using  EditLine wrapper
 

thanks. I have checked some of these and here are my findings:

• the error message changes, when cb_geschlecht is updated, e.g. from männlich to weiblich or NULL --> in that case it would read "Incorrect integer value: 'weiblich' for column 'gender' at row 1
• cb_geschlecht was created using cb field management - back in 2005. The error message is fairly new, and must have to do something with recent changes
• we are not using any 3rd party installed CB plugins
• unpublishing  the field cb_geschlecht does not change the error message
• geschlecht is German for "gender" - there is no column "gender" in table comprofiler 
  
  
  (query: SELECT user_id, firstname, lastname, cb_geschlecht, gender FROM kle_comprofiler WHERE user_id = 12345678)

unfortunately, I am still clueless on how to fix this problem. Would it help to delete cb_geschlecht and restore it from a backup?

Thanks, I have checked _comprofiler_fields
I do not see what to change - seems like what you suggest to change is already there.



I wonder what the integer part of the message means - for some reason it seems to expect a number. right? but in the dropdown there is only text.