sudo -i
sqlite3 /var/lib/casaos/files.db ‘ALTER TABLE trash_files ADD COLUMN user_id INTEGER NOT NULL DEFAULT 0;’
systemctl restart icewhale-files
Yes — these are three separate commands.
First run:
sudo -i
Then enter your password to switch to the root user.
Next run:
sqlite3 /var/lib/casaos/files.db 'ALTER TABLE trash_files ADD COLUMN user_id INTEGER NOT NULL DEFAULT 0;'
Finally run:
systemctl restart icewhale-files
After executing these three commands, the issue should be resolved.
If you encounter any problems, please take a screenshot of the command output and share it here so I can take a closer look.