|ERROR|[QUERY ERROR]: Error: Unknown column 'dhcp_r.fw_apply_to' in 'field list' after upgrade to 2.3

maxilee · Monday at 12:00 PM

hi.
I've tested update from 2.2 -> 2.3
I'm on EL9 , I've upgrade nodejs to ver 24 from appstream.
after update packagees fwcloud* , I've noticed errors on web interface : when you click on on one of my firewalls , then click on DHCP or HAproxy there is a red windows with error.
in logs I can find :
2026-02-02 11:53:36|ERROR|[QUERY ERROR]: Error: Unknown column 'dhcp_r.fw_apply_to' in 'field list'
2026-02-02 11:53:36|ERROR|QueryFailedError: Unknown column 'dhcp_r.fw_apply_to' in 'field list'
2026-02-02 11:53:36|ERROR| at Query.onResult (/opt/fwcloud/api/node_modules/typeorm/driver/mysql/MysqlQueryRunner.js:168:37)
2026-02-02 11:53:36|ERROR| at Query.execute (/opt/fwcloud/api/node_modules/mysql2/lib/commands/command.js:36:14)
2026-02-02 11:53:36|ERROR| at PoolConnection.handlePacket (/opt/fwcloud/api/node_modules/mysql2/lib/base/connection.js:508:34)
2026-02-02 11:53:36|ERROR| at PacketParser.onPacket (/opt/fwcloud/api/node_modules/mysql2/lib/base/connection.js:93:12)
2026-02-02 11:53:36|ERROR| at PacketParser.executeStart (/opt/fwcloud/api/node_modules/mysql2/lib/packet_parser.js:75:16)
2026-02-02 11:53:36|ERROR| at Socket.<anonymous> (/opt/fwcloud/api/node_modules/mysql2/lib/base/connection.js:100:25)
2026-02-02 11:53:36|ERROR| at Socket.emit (node:events:508:28)
2026-02-02 11:53:36|ERROR| at addChunk (node:internal/streams/readable:559:12)
2026-02-02 11:53:36|ERROR| at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
2026-02-02 11:53:36|ERROR| at Readable.push (node:internal/streams/readable:390:5)

2026-02-02 11:53:30|ERROR|[QUERY ERROR]: Error: Unknown column 'haproxy.fw_apply_to' in 'field list'
2026-02-02 11:53:30|ERROR|QueryFailedError: Unknown column 'haproxy.fw_apply_to' in 'field list'
2026-02-02 11:53:30|ERROR| at Query.onResult (/opt/fwcloud/api/node_modules/typeorm/driver/mysql/MysqlQueryRunner.js:168:37)
2026-02-02 11:53:30|ERROR| at Query.execute (/opt/fwcloud/api/node_modules/mysql2/lib/commands/command.js:36:14)
2026-02-02 11:53:30|ERROR| at PoolConnection.handlePacket (/opt/fwcloud/api/node_modules/mysql2/lib/base/connection.js:508:34)
2026-02-02 11:53:30|ERROR| at PacketParser.onPacket (/opt/fwcloud/api/node_modules/mysql2/lib/base/connection.js:93:12)
2026-02-02 11:53:30|ERROR| at PacketParser.executeStart (/opt/fwcloud/api/node_modules/mysql2/lib/packet_parser.js:75:16)
2026-02-02 11:53:30|ERROR| at Socket.<anonymous> (/opt/fwcloud/api/node_modules/mysql2/lib/base/connection.js:100:25)
2026-02-02 11:53:30|ERROR| at Socket.emit (node:events:508:28)
2026-02-02 11:53:30|ERROR| at addChunk (node:internal/streams/readable:559:12)
2026-02-02 11:53:30|ERROR| at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
2026-02-02 11:53:30|ERROR| at Readable.push (node:internal/streams/readable:390:5)

also there a very long SQL query.

Carles Munyoz · Monday at 1:39 PM

Hi,
It seems that you don't have all the database migrations applied in the FWCloud API.
Can you run the next command into the directory: /opt/fwcloud/api

Bash:

node fwcli migration:run

maxilee · Monday at 2:04 PM

Hi.
thx for quick response.
before your command I've to run "npm install strip-ansi" to install this module.

[root@fwcloud api]# node fwcli migration:run
✓ Pending migrations applied.

now no more errors

thx

Carles Munyoz · Monday at 2:11 PM

Great! Problem fixed.
But I would like to understand why the migrations where not applied to your installation, because the migrations run is part of the update procedure.
Did you had any problem with the update procedure?

maxilee · Monday at 3:52 PM

No. I haven't noticed any error on update.
My setup is rocky linux 9.
Nodejs is installed from appstream. Currently im using nodejs 24.

Carles Munyoz · Monday at 4:30 PM

I don't understand then why the migrations didn't get applied.
Okay, if you discover something about it, please, let us know.

maxilee · Monday at 8:21 PM

Tommorow I'll try to update main server.
first attempt was made on vm clone.
Let you know about status...

Carles Munyoz · 2026-02-03T08:25:20+0100

Great, thank you very much.

maxilee · 2026-02-03T08:34:55+0100

hi.

maybe this will be helpful :
[root@fwcloud api]# yum module enable nodejs:24
[root@fwcloud api]# yum update --disablerepo=SOLTECSIS_FWCloud_rpm_any
[root@fwcloud api]# node --version
v24.11.1

from dir : /opt/fwcloud/api :

[root@fwcloud api]# npm outdated
Package Current Wanted Latest Location Depended by
@eslint/eslintrc 3.3.1 3.3.1 3.3.3 node_modules/@eslint/eslintrc api
@eslint/js 9.35.0 9.35.0 9.39.2 node_modules/@eslint/js api
@types/express 5.0.3 5.0.3 5.0.6 node_modules/@types/express api
@types/node 24.3.1 24.3.1 25.2.0 node_modules/@types/node api
@types/serve-static 1.15.8 1.15.8 2.2.0 node_modules/@types/serve-static api
@types/session-file-store 1.2.5 1.2.5 1.2.6 node_modules/@types/session-file-store api
@types/sinon 17.0.4 17.0.4 21.0.0 node_modules/@types/sinon api
@typescript-eslint/eslint-plugin 8.43.0 8.43.0 8.54.0 node_modules/@typescript-eslint/eslint-plugin api
@typescript-eslint/parser 8.43.0 8.43.0 8.54.0 node_modules/@typescript-eslint/parser api
axios 1.12.2 1.12.2 1.13.4 node_modules/axios api
bcryptjs 3.0.2 3.0.2 3.0.3 node_modules/bcryptjs api
body-parser 1.20.3 1.20.3 2.2.2 node_modules/body-parser api
chai 4.5.0 4.5.0 6.2.2 node_modules/chai api
chai-as-promised 7.1.2 7.1.2 8.0.2 node_modules/chai-as-promised api
class-validator 0.14.2 0.14.2 0.14.3 node_modules/class-validator api
cors 2.8.5 2.8.5 2.8.6 node_modules/cors api
cron 4.3.3 4.3.3 4.4.0 node_modules/cron api
dotenv 16.6.1 16.6.1 17.2.3 node_modules/dotenv api
eslint 9.35.0 9.35.0 9.39.2 node_modules/eslint api
eslint-plugin-prettier 5.5.4 5.5.4 5.5.5 node_modules/eslint-plugin-prettier api
express 4.21.2 4.21.2 5.2.1 node_modules/express api
express-session 1.18.2 1.18.2 1.19.0 node_modules/express-session api
form-data 4.0.4 4.0.4 4.0.5 node_modules/form-data api
fs-extra 11.3.1 11.3.1 11.3.3 node_modules/fs-extra api
glob 11.0.3 11.0.3 13.0.0 node_modules/glob api
globals 16.3.0 16.3.0 17.3.0 node_modules/globals api
ipaddr.js 2.2.0 2.2.0 2.3.0 node_modules/ipaddr.js api
joi 17.13.3 17.13.3 18.0.2 node_modules/joi api
libsodium-wrappers 0.7.15 0.7.15 0.8.2 node_modules/libsodium-wrappers api
lint-staged 16.1.6 16.1.6 16.2.7 node_modules/lint-staged api
mocha 11.7.2 11.7.2 11.7.5 node_modules/mocha api
mysql2 3.14.5 3.14.5 3.16.2 node_modules/mysql2 api
nodemon 3.1.10 3.1.10 3.1.11 node_modules/nodemon api
openai 5.20.0 5.20.0 6.17.0 node_modules/openai api
openpgp 6.2.2 6.2.2 6.3.0 node_modules/openpgp api
prettier 3.6.2 3.6.2 3.8.1 node_modules/prettier api
semver 7.7.2 7.7.2 7.7.3 node_modules/semver api
serve-static 2.2.0 2.2.0 2.2.1 node_modules/serve-static api
sinon 21.0.0 21.0.0 21.0.1 node_modules/sinon api
socket.io 4.8.1 4.8.1 4.8.3 node_modules/socket.io api
supertest 7.1.4 7.1.4 7.2.2 node_modules/supertest api
typeorm 0.3.26 0.3.26 0.3.28 node_modules/typeorm api
typescript 5.9.2 5.9.2 5.9.3 node_modules/typescript api
uuid 11.1.0 11.1.0 13.0.0 node_modules/uuid api
winston 3.17.0 3.17.0 3.19.0 node_modules/winston api
ws 8.18.3 8.18.3 8.19.0 node_modules/ws api
yargs 17.7.2 17.7.2 18.0.0 node_modules/yargs api

missing module : strip-ansi

maxilee · 2026-02-03T08:35:43+0100

when I was trying to update - there is error :

Running transaction
Preparing : 1/1
Running scriptlet: fwcloud-ui-2.3.1-1.noarch 1/4
Upgrading : fwcloud-ui-2.3.1-1.noarch 1/4
Running scriptlet: fwcloud-ui-2.3.1-1.noarch 1/4
Running scriptlet: fwcloud-api-2.3.1-1.noarch 2/4
Upgrading : fwcloud-api-2.3.1-1.noarch 2/4
Running scriptlet: fwcloud-api-2.3.1-1.noarch 2/4
TypeError: stringWidth is not a function
at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:66
at Array.map (<anonymous>)
at wordLengths (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:49)
at exec (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:112:18)
at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:16
at Array.map (<anonymous>)
at module.exports [as wrap] (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:4)
at file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:168:33
at Array.forEach (<anonymous>)
at UI.rasterize (file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:164:13)
TypeError: stringWidth is not a function
at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:66
at Array.map (<anonymous>)
at wordLengths (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:49)
at exec (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:112:18)
at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:16
at Array.map (<anonymous>)
at module.exports [as wrap] (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:4)
at file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:168:33
at Array.forEach (<anonymous>)
at UI.rasterize (file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:164:13)
TypeError: stringWidth is not a function
at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:66
at Array.map (<anonymous>)
at wordLengths (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:49)
at exec (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:112:18)
at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:16
at Array.map (<anonymous>)
at module.exports [as wrap] (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:4)
at file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:168:33
at Array.forEach (<anonymous>)
at UI.rasterize (file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:164:13)

Cleanup : fwcloud-ui-2.2.0-1.noarch 3/4
Running scriptlet: fwcloud-ui-2.2.0-1.noarch 3/4
Cleanup : fwcloud-api-2.2.0-1.noarch 4/4
Running scriptlet: fwcloud-api-2.2.0-1.noarch 4/4
Verifying : fwcloud-api-2.3.1-1.noarch 1/4
Verifying : fwcloud-api-2.2.0-1.noarch 2/4
Verifying : fwcloud-ui-2.3.1-1.noarch 3/4
Verifying : fwcloud-ui-2.2.0-1.noarch 4/4

Upgraded:
fwcloud-api-2.3.1-1.noarch fwcloud-ui-2.3.1-1.noarch

Complete!

So I've reverted to snapshot.
installed nmp install strip-ansi
and once more update , the error is the same.

maxilee · 2026-02-03T08:36:13+0100

Total 64 MB/s | 130 MB 00:02

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Running scriptlet: fwcloud-ui-2.3.1-1.noarch 1/4

Upgrading : fwcloud-ui-2.3.1-1.noarch 1/4

Running scriptlet: fwcloud-ui-2.3.1-1.noarch 1/4

Running scriptlet: fwcloud-api-2.3.1-1.noarch 2/4

Upgrading : fwcloud-api-2.3.1-1.noarch 2/4

Running scriptlet: fwcloud-api-2.3.1-1.noarch 2/4

TypeError: stringWidth is not a function

at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:66

at Array.map (<anonymous>)

at wordLengths (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:49)

at exec (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:112:18)

at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:16

at Array.map (<anonymous>)

at module.exports [as wrap] (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:4)

at file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:168:33

at Array.forEach (<anonymous>)

at UI.rasterize (file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:164:13)

TypeError: stringWidth is not a function

at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:66

at Array.map (<anonymous>)

at wordLengths (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:49)

at exec (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:112:18)

at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:16

at Array.map (<anonymous>)

at module.exports [as wrap] (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:4)

at file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:168:33

at Array.forEach (<anonymous>)

at UI.rasterize (file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:164:13)

TypeError: stringWidth is not a function

at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:66

at Array.map (<anonymous>)

at wordLengths (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:24:49)

at exec (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:112:18)

at /opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:16

at Array.map (<anonymous>)

at module.exports [as wrap] (/opt/fwcloud/api/node_modules/cliui/node_modules/wrap-ansi/index.js:214:4)

at file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:168:33

at Array.forEach (<anonymous>)

at UI.rasterize (file:///opt/fwcloud/api/node_modules/cliui/build/lib/index.js:164:13)

Cleanup : fwcloud-ui-2.2.0-1.noarch 3/4

Running scriptlet: fwcloud-ui-2.2.0-1.noarch 3/4

Cleanup : fwcloud-api-2.2.0-1.noarch 4/4

Running scriptlet: fwcloud-api-2.2.0-1.noarch 4/4

Verifying : fwcloud-api-2.3.1-1.noarch 1/4

Verifying : fwcloud-api-2.2.0-1.noarch 2/4

Verifying : fwcloud-ui-2.3.1-1.noarch 3/4

Verifying : fwcloud-ui-2.2.0-1.noarch 4/4

Upgraded:

fwcloud-api-2.3.1-1.noarch fwcloud-ui-2.3.1-1.noarch

and after update - there was error in SQL.

and it is gone after manual run "node fwcli migration:run"

Carles Munyoz · 2026-02-03T11:16:14+0100

Thank you for the detailed report.
We will analyze it.

|ERROR|[QUERY ERROR]: Error: Unknown column 'dhcp_r.fw_apply_to' in 'field list' after upgrade to 2.3

maxilee

New member

Carles Munyoz

Administrator

maxilee

New member

Carles Munyoz

Administrator

maxilee

New member

Carles Munyoz

Administrator

maxilee

New member

Carles Munyoz

Administrator

maxilee

New member

maxilee

New member

maxilee

New member

Carles Munyoz

Administrator