with custom profile fields: we can't create a new user view (page not working)

[jkleen]

We have not tested this before our latest 1.8.38 upgrade and before we added our custom profile fields. And we can't test it by removing it either as it might delete existing entry's from our users (900+):

We added the following custom profile fields (attached picture).
I'm now using the users & groups > Users (left) Views (box on the right) > "Manage Views"> 'Create New View'.
URL: https://www.xx.xx/admin/index.php?module...ews&do=add

We create a new title (1word) add in a Enabled function like Avatar and when hitting save we get the error1.png as attached:
'This page isn't working'.
www.xxx is currently unable to handle this request
HTTP ERROR 5000.

In the error log I found this at that exact time stamp:
[Tue Oct 22 12:44:30.040584 2024] [lsapi:error] [pid 187846:tid 139716074559232] [client 147.161.133.31:40191] [host xxx.x.xx] Backend fatal error: PHP Fatal error:  Uncaught mysqli_sql_exception: Unknown column 'custom_profile_fields' in 'field list' in /home/u151436p143097/domains/x.xx/public_html/inc/db_mysqli.php:335\nStack trace:\n#0 /home/u151436p143097/domains/x.xx/public_html/inc/db_mysqli.php(335): mysqli_query()\n#1 /home/u151436p143097/domains/x.xx/public_html/inc/db_mysqli.php(378): DB_MySQLi->query()\n#2 /home/u151436p143097/domains/x.xx/public_html/inc/db_mysqli.php(839): DB_MySQLi->write_query()\n#3 /home/u151436p143097/domains/x.xx/public_html/admin/inc/functions_view_manager.php(109): DB_MySQLi->insert_query()\n#4 /home/u151436p143097/domains/x.xx/public_html/admin/modules/user/users.php(149): view_manager()\n#5 /home/u151436p143097/domains/x.xx/public_html/admin/index.php(834): require('/home/u151436p1...')\n#6 {main}\n  thrown in /home/u151436p143097/domains/x.xx/public_html/inc/db_mysqli.php on line 335\n

mybb 1.8.38
PHP 8.2.18
SQL 10.6.18

What is it what I could change to make it work or is this a bug in the code?

[jkleen]

Is there an update from somebody on this?

[HLFadmin]

If you have created custom fields for user profile and populated at least one, do they display properly?
Do you have a field in mybb_adminviews named custom_profile_views?
And what is the typical content of that field?
Can you create a new view without specifying a match based on custom_profile_fields?
Try to create a view that does not enable the avatar as a visible element in the view.

I'm running 1.8.37 with added custom fields and detecting none of the problems you describe.
The fields display properly and I can create a view of users based on content of one of the fields.
None of the code differences between 1.8.37 and 1.8.38 seem to be significant factors that could explain why your experience varies with mine.

Probably now's the time to ask what plugins you're using, what theme, and what are results of File Verification.