Having an issue when a user switches themes from the user drop down menu, that it throws an error:“operator does not exist: character varying = integer”
Which results in the user not being able to change themes.
Nocobase v2.1.23
Please provide the error message from your browser’s network request.
When I try to select a theme change:
It produces the following error:
I’m using a PostgreSQL 17 database.
Please open the browser’s developer tools, reproduce the theme change, and send the failed network request’s URL, status code, response body, and timestamp (with any tokens or cookies removed). This will let us determine whether the failure occurs in users:updateTheme and identify the field behind the PostgreSQL type mismatch.
Here is the output of the console:
POST https://my.example.net/api/users:updateTheme 500 (Internal Server Error)
(anonymous) @ vendor-misc-c30c528b.js:131
xhr @ vendor-misc-c30c528b.js:131
tt @ vendor-misc-c30c528b.js:131
Promise.then
_request @ vendor-misc-c30c528b.js:131
request @ vendor-misc-c30c528b.js:131
(anonymous) @ vendor-misc-c30c528b.js:131
request @ index-81af4d74.js:3575
(anonymous) @ index-81af4d74.js:3575
(anonymous) @ index.js?hash=2684ce62:10
(anonymous) @ index.js?hash=2684ce62:10
u @ index.js?hash=2684ce62:10
a @ index.js?hash=2684ce62:10
(anonymous) @ index.js?hash=2684ce62:10
(anonymous) @ index.js?hash=2684ce62:10
(anonymous) @ index.js?hash=2684ce62:10
onChange @ index.js?hash=2684ce62:10
eR @ vendor-antd-ecosystem-b9174353.js:2
(anonymous) @ vendor-antd-ecosystem-b9174353.js:2
(anonymous) @ vendor-antd-ecosystem-b9174353.js:2
Q @ vendor-antd-ecosystem-b9174353.js:2
onClick @ vendor-antd-ecosystem-b9174353.js:2
eA @ vendor-core-a233b529.js:2
eH @ vendor-core-a233b529.js:2
(anonymous) @ vendor-core-a233b529.js:2
re @ vendor-core-a233b529.js:2
rt @ vendor-core-a233b529.js:2
(anonymous) @ vendor-core-a233b529.js:2
uN @ vendor-core-a233b529.js:2
eO @ vendor-core-a233b529.js:2
ru @ vendor-core-a233b529.js:2
tA @ vendor-core-a233b529.js:2
tM @ vendor-core-a233b529.js:2
index.js?hash=2684ce62:10 ƒ (e){for(var t=arguments.length,l=Array(t>1?t-1:0),n=1;n<t;n++)l[n-1]=arguments[n];console.error(e,…l)}
index-81af4d74.js:3575 Z {message: ‘Request failed with status code 500’, name: ‘AxiosError’, code: ‘ERR_BAD_RESPONSE’, config: {…}, request: XMLHttpRequest, …}code: "ERR_BAD_RESPONSE"config: {transitional: {…}, adapter: Array(3), transformRequest: Array(1), transformResponse: Array(1), timeout: 0, …}message: "Request failed with status code 500"name: "AxiosError"request: XMLHttpRequest {onreadystatechange: null, readyState: 4, timeout: 0, withCredentials: false, upload: XMLHttpRequestUpload, …}response: {data: {…}, status: 500, statusText: ‘’, headers: eP, config: {…}, …}status: 500stack: “AxiosError: Request failed with status code 500\n at eM (https://my.example.net/assets/vendor-misc-c30c528b.js:131:396230)\n at XMLHttpRequest.v (https://my.example.net/assets/vendor-misc-c30c528b.js:131:401041)\n at to.request (https://my.example.net/assets/vendor-misc-c30c528b.js:131:408929)\n at async Proxy. (https://my.example.net/assets/index-81af4d74.js:3575:51759)”[[Prototype]]: Error
e_ @ index-81af4d74.js:3575
(anonymous) @ index.js?hash=2684ce62:10
(anonymous) @ index.js?hash=2684ce62:10
u @ index.js?hash=2684ce62:10
c @ index.js?hash=2684ce62:10
Promise.then
u @ index.js?hash=2684ce62:10
a @ index.js?hash=2684ce62:10
(anonymous) @ index.js?hash=2684ce62:10
(anonymous) @ index.js?hash=2684ce62:10
(anonymous) @ index.js?hash=2684ce62:10
onChange @ index.js?hash=2684ce62:10
eR @ vendor-antd-ecosystem-b9174353.js:2
(anonymous) @ vendor-antd-ecosystem-b9174353.js:2
(anonymous) @ vendor-antd-ecosystem-b9174353.js:2
Q @ vendor-antd-ecosystem-b9174353.js:2
onClick @ vendor-antd-ecosystem-b9174353.js:2
eA @ vendor-core-a233b529.js:2
eH @ vendor-core-a233b529.js:2
(anonymous) @ vendor-core-a233b529.js:2
re @ vendor-core-a233b529.js:2
rt @ vendor-core-a233b529.js:2
(anonymous) @ vendor-core-a233b529.js:2
uN @ vendor-core-a233b529.js:2
eO @ vendor-core-a233b529.js:2
ru @ vendor-core-a233b529.js:2
tA @ vendor-core-a233b529.js:2
tM @ vendor-core-a233b529.js:2
With this them switching issue, one thing that I have noticed is that with a brand new empty Main database installation, the themes switch just fine. It’s only after a restore of my existing Main database does the problem of switching themes appear. Not sure if that information is helpful. I’m not sure if the above developer tool console output is enough info for you. If you need something more specific, please let me know. Thanks for the help.
Please provide the log files for the operation or error that occurred, specifying the approximate time of the operation.
Log file location: storage\logs\main (request_xxx, system_xxx, system_error_xxx, sql_xxx)
Online log file management address: admin/settings/logger
The theme switching error occured 2026-07-20 at 13:00
The sql_xxxx-xx-xx.logs had no data in them. Here are the remaining logs you requested:
logs_2026-07-20.zip (77.0 KB)