BoxError: ER_BAD_FIELD_ERROR: Unknown column 'language' in 'field list'

[rmdes]

Apparently auto-upgrade to the latest cloudron version didn't went well, at least for the cloudron box.service that is,
even tho systemctl status box would appear to be fine, running, started, enabled
and journalctl -u box -f wouldn't show much, beside restarting in loop
the log here : /home/yellowtent/platformdata/logs/box.log were speaking a bit more and show the errors below

root@my ~# cloudron-support --troubleshoot
[OK]    node version is correct
[OK]    docker is running
[OK]    MySQL is running
[OK]    nginx is running
[OK]    box is running
[OK]    unbound is running
[OK]    Dashboard is reachable via domain name
[OK]    Domain is valid and has not expired

Apparently fine but not really, no dashboard:

root@my ~# grc tail -f /home/yellowtent/platformdata/logs/box.log

2024-03-25T18:35:43.736Z box:server ==========================================
2024-03-25T18:35:43.738Z box:server            Cloudron 7.7.1  
2024-03-25T18:35:43.738Z box:server ==========================================
2024-03-25T18:35:43.739Z box:platform initialize: start platform
2024-03-25T18:35:43.791Z box:tasks stopAllTasks: stopping all tasks
2024-03-25T18:35:43.792Z box:shell stopTask /usr/bin/sudo -S /home/yellowtent/box/src/scripts/stoptask.sh all
2024-03-25T18:35:43.852Z box:reverseproxy writeDashboardConfig: writing dashboard config for osintukraine.com
2024-03-25T18:35:43.860Z box:shell isOscpEnabled execArgs: openssl ["x509","-in","/home/yellowtent/platformdata/nginx/cert/_.osintukraine.com.cert","-noout","-ocsp_uri"]
2024-03-25T18:35:43.880Z box:shell reload /usr/bin/sudo -S /home/yellowtent/box/src/scripts/restartservice.sh nginx
2024-03-25T18:35:44.291Z box:platform onActivated: starting post activation services
2024-03-25T18:35:44.291Z box:platform startInfra: checking infrastructure
2024-03-25T18:35:44.292Z box:platform startInfra: infra is uptodate at version 49.5.0
2024-03-25T18:35:44.292Z box:platform onInfraReady: platform is ready. infra changed: false
2024-03-25T18:35:44.292Z box:apps schedulePendingTasks: scheduling app tasks
2024-03-25T18:35:44.337Z box:cron startJobs: starting cron jobs with hour 4 and minute 48
2024-03-25T18:35:44.376Z box:cron backupPolicyChanged: schedule 00 00 23 * * 0 (Europe/Berlin)
2024-03-25T18:35:44.390Z box:cron autoupdatePatternChanged: pattern - 00 00 0,1,2,3,4,5,6,7,8,23 * * 1,2,3,4,5,6 (Europe/Berlin)
2024-03-25T18:35:44.392Z box:cron Dynamic DNS setting changed to false
2024-03-25T18:35:44.394Z box:dockerproxy start: listening on 172.18.0.1:3003
2024-03-25T18:35:44.924Z box:oidc Using existing OIDC EdDSA key
2024-03-25T18:35:44.925Z box:oidc Using existing OIDC RS256 key
2024-03-25T18:35:44.928Z box:oidc start: create provider for my.osintukraine.com at /openid
2024-03-25T18:35:40.681Z box:apphealthmonitor app health: 43 running / 15 stopped / 0 unresponsive
**BoxError: ER_BAD_FIELD_ERROR: Unknown column 'language' in 'field list'
    at Query.queryCallback (/home/yellowtent/box/src/database.js:91:38)
    at Query.<anonymous> (/home/yellowtent/box/node_modules/mysql/lib/Connection.js:526:10)
    at Query._callback (/home/yellowtent/box/node_modules/mysql/lib/Connection.js:488:16)
    at Sequence.end (/home/yellowtent/box/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
    at Query.ErrorPacket (/home/yellowtent/box/node_modules/mysql/lib/protocol/sequences/Query.js:92:8)
    at Protocol._parsePacket (/home/yellowtent/box/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/home/yellowtent/box/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/home/yellowtent/box/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/home/yellowtent/box/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/home/yellowtent/box/node_modules/mysql/lib/Connection.js:88:28)**
2024-03-25T18:35:43.736Z box:server ==========================================
2024-03-25T18:35:43.738Z box:server            Cloudron 7.7.1  
2024-03-25T18:35:43.738Z box:server ==========================================
2024-03-25T18:35:43.739Z box:platform initialize: start platform

and it loops like that over and over again.

[rmdes]

Solution is to run the start script, it will apply some migration and do necessary steps that may have been missed for some reason :

root@my ~# /home/yellowtent/box/setup/start.sh

once I run this, the box service started normally and the dashboard was accessible again @benborges

[girish]

@rmdes said in BoxError: ER_BAD_FIELD_ERROR: Unknown column 'language' in 'field list':

BoxError: ER_BAD_FIELD_ERROR: Unknown column 'language' in 'field list'

this happens when the database migration did not run completely for some reason. The solution to run start.sh is the correct one.

[rmdes]

@girish Yup I posted it here, really for search results in case other people come up with the same issue !
it can be marked as solved !