starred/tacticalrmm

Fork 0

mirror of https://github.com/amidaware/tacticalrmm.git synced 2026-04-26 06:55:52 +03:00

[GH-ISSUE #1532] New db error after update (tested with or without --force) #2903

New issue

Closed

opened 2026-03-14 05:54:40 +03:00 by kerem · 9 comments

kerem commented

2026-03-14 05:54:40 +03:00

Owner

Originally created by @MAJINFORMATIQUE on GitHub (Jun 7, 2023).
Original GitHub issue: https://github.com/amidaware/tacticalrmm/issues/1532

Server Info

OS: Ubuntu 20.04.6
Browser: [e.g. chrome, safari]
RMM Version 0.15.12:

Installation Method:
Standard

Bug : error 500 after update

In django.log error missing column accounts.user.dash_info_color
Doesn't know value type (text, var....)

Originally created by @MAJINFORMATIQUE on GitHub (Jun 7, 2023). Original GitHub issue: https://github.com/amidaware/tacticalrmm/issues/1532 Server Info - OS: Ubuntu 20.04.6 - Browser: [e.g. chrome, safari] - RMM Version 0.15.12: Installation Method: Standard Bug : error 500 after update In django.log error missing column accounts.user.dash_info_color Doesn't know value type (text, var....) ![erreur-rmm-ap1512](https://github.com/amidaware/tacticalrmm/assets/114332678/495d90ff-fee7-49d5-acc4-9ae8ed314fa7)

kerem

2026-03-14 05:54:40 +03:00

closed this issue
added the
duplicate
label

kerem commented

2026-03-14 05:54:56 +03:00

Author

Owner

@MAJINFORMATIQUE commented on GitHub (Jun 7, 2023):

Could it be possible to obtain database schema with all values types?

@MAJINFORMATIQUE commented on GitHub (Jun 7, 2023): Could it be possible to obtain database schema with all values types?

kerem commented

2026-03-14 05:55:01 +03:00

Author

Owner

@silversword411 commented on GitHub (Jun 7, 2023):

Duplicate of https://github.com/amidaware/tacticalrmm/issues/1517 please keep to one issue.

The other was closed because you didn't reply for a while and figured it was fixed. I've reopened it.

@silversword411 commented on GitHub (Jun 7, 2023): Duplicate of https://github.com/amidaware/tacticalrmm/issues/1517 please keep to one issue. The other was closed because you didn't reply for a while and figured it was fixed. I've reopened it.

kerem commented

2026-03-14 05:55:06 +03:00

Author

Owner

@wh1te909 commented on GitHub (Jun 7, 2023):

your migrations didn't run. the update script will pull latest changes from github and run migrations, so not sure what's going on. please paste the output of the following command:

ls -ltr /rmm/api/tacticalrmm/accounts/migrations/

@wh1te909 commented on GitHub (Jun 7, 2023): your migrations didn't run. the update script will pull latest changes from github and run migrations, so not sure what's going on. please paste the output of the following command: ``` ls -ltr /rmm/api/tacticalrmm/accounts/migrations/ ```

kerem commented

2026-03-14 05:55:11 +03:00

Author

Owner

@Nzrvynnyk commented on GitHub (Jun 12, 2023):

Hi. Have the same issue, also have an issue with API getting 500 for some POST requests.
https://prnt.sc/zeQrZsTMQuaH

ls -ltr /rmm/api/tacticalrmm/accounts/migrations/
total 156
-rw-rw-r-- 1 tactical tactical  934 Jun 12 19:09 0005_auto_20201002_1303.py
-rw-rw-r-- 1 tactical tactical  652 Jun 12 19:09 0004_auto_20201002_1257.py
-rw-rw-r-- 1 tactical tactical  934 Jun 12 19:09 0003_auto_20200922_1344.py
-rw-rw-r-- 1 tactical tactical  446 Jun 12 19:09 0002_auto_20200810_0544.py
-rw-rw-r-- 1 tactical tactical 4606 Jun 12 19:09 0001_initial.py
-rw-rw-r-- 1 tactical tactical    0 Jun 12 19:09 __init__.py
-rw-rw-r-- 1 tactical tactical  427 Jun 12 19:09 0034_role_can_send_wol.py
-rw-rw-r-- 1 tactical tactical  969 Jun 12 19:09 0033_user_dash_info_color_user_dash_negative_color_and_more.py
-rw-rw-r-- 1 tactical tactical  642 Jun 12 19:09 0032_alter_user_default_agent_tbl_tab.py
-rw-rw-r-- 1 tactical tactical  412 Jun 12 19:09 0031_user_date_format.py
-rw-rw-r-- 1 tactical tactical  570 Jun 12 19:09 0030_auto_20211104_0221.py
-rw-rw-r-- 1 tactical tactical  738 Jun 12 19:09 0029_auto_20211022_2245.py
-rw-rw-r-- 1 tactical tactical 5002 Jun 12 19:09 0028_auto_20211010_0249.py
-rw-rw-r-- 1 tactical tactical  705 Jun 12 19:09 0027_auto_20210903_0054.py
-rw-rw-r-- 1 tactical tactical 1286 Jun 12 19:09 0026_auto_20210901_1247.py
-rw-rw-r-- 1 tactical tactical  934 Jun 12 19:09 0025_auto_20210721_0424.py
-rw-rw-r-- 1 tactical tactical  428 Jun 12 19:09 0024_user_last_login_ip.py
-rw-rw-r-- 1 tactical tactical  411 Jun 12 19:09 0023_user_is_installer_user.py
-rw-rw-r-- 1 tactical tactical  415 Jun 12 19:09 0022_user_clear_search_when_switching.py
-rw-rw-r-- 1 tactical tactical  405 Jun 12 19:09 0021_role_can_view_core_settings.py
-rw-rw-r-- 1 tactical tactical  387 Jun 12 19:09 0020_role_can_manage_roles.py
-rw-rw-r-- 1 tactical tactical  606 Jun 12 19:09 0019_user_role.py
-rw-rw-r-- 1 tactical tactical 6628 Jun 12 19:09 0018_auto_20210511_0233.py
-rw-rw-r-- 1 tactical tactical 5474 Jun 12 19:09 0017_auto_20210508_1716.py
-rw-rw-r-- 1 tactical tactical  880 Jun 12 19:09 0016_auto_20210507_1526.py
-rw-rw-r-- 1 tactical tactical  415 Jun 12 19:09 0015_user_loading_bar_color.py
-rw-rw-r-- 1 tactical tactical  406 Jun 12 19:09 0014_user_client_tree_splitter.py
-rw-rw-r-- 1 tactical tactical  510 Jun 12 19:09 0013_user_client_tree_sort.py
-rw-rw-r-- 1 tactical tactical  408 Jun 12 19:09 0012_user_agents_per_page.py
-rw-rw-r-- 1 tactical tactical  652 Jun 12 19:09 0011_user_default_agent_tbl_tab.py
-rw-rw-r-- 1 tactical tactical  677 Jun 12 19:09 0010_user_agent_dblclick_action.py
-rw-rw-r-- 1 tactical tactical  397 Jun 12 19:09 0009_user_show_community_scripts.py
-rw-rw-r-- 1 tactical tactical  394 Jun 12 19:09 0008_user_dark_mode.py
-rw-rw-r-- 1 tactical tactical  617 Jun 12 19:09 0007_update_agent_primary_key.py
-rw-rw-r-- 1 tactical tactical  654 Jun 12 19:09 0006_user_agent.py
drwxrwxr-x 2 tactical tactical 4096 Jun 12 19:11 __pycache__

@Nzrvynnyk commented on GitHub (Jun 12, 2023): Hi. Have the same issue, also have an issue with API getting 500 for some POST requests. https://prnt.sc/zeQrZsTMQuaH ``` ls -ltr /rmm/api/tacticalrmm/accounts/migrations/ total 156 -rw-rw-r-- 1 tactical tactical 934 Jun 12 19:09 0005_auto_20201002_1303.py -rw-rw-r-- 1 tactical tactical 652 Jun 12 19:09 0004_auto_20201002_1257.py -rw-rw-r-- 1 tactical tactical 934 Jun 12 19:09 0003_auto_20200922_1344.py -rw-rw-r-- 1 tactical tactical 446 Jun 12 19:09 0002_auto_20200810_0544.py -rw-rw-r-- 1 tactical tactical 4606 Jun 12 19:09 0001_initial.py -rw-rw-r-- 1 tactical tactical 0 Jun 12 19:09 __init__.py -rw-rw-r-- 1 tactical tactical 427 Jun 12 19:09 0034_role_can_send_wol.py -rw-rw-r-- 1 tactical tactical 969 Jun 12 19:09 0033_user_dash_info_color_user_dash_negative_color_and_more.py -rw-rw-r-- 1 tactical tactical 642 Jun 12 19:09 0032_alter_user_default_agent_tbl_tab.py -rw-rw-r-- 1 tactical tactical 412 Jun 12 19:09 0031_user_date_format.py -rw-rw-r-- 1 tactical tactical 570 Jun 12 19:09 0030_auto_20211104_0221.py -rw-rw-r-- 1 tactical tactical 738 Jun 12 19:09 0029_auto_20211022_2245.py -rw-rw-r-- 1 tactical tactical 5002 Jun 12 19:09 0028_auto_20211010_0249.py -rw-rw-r-- 1 tactical tactical 705 Jun 12 19:09 0027_auto_20210903_0054.py -rw-rw-r-- 1 tactical tactical 1286 Jun 12 19:09 0026_auto_20210901_1247.py -rw-rw-r-- 1 tactical tactical 934 Jun 12 19:09 0025_auto_20210721_0424.py -rw-rw-r-- 1 tactical tactical 428 Jun 12 19:09 0024_user_last_login_ip.py -rw-rw-r-- 1 tactical tactical 411 Jun 12 19:09 0023_user_is_installer_user.py -rw-rw-r-- 1 tactical tactical 415 Jun 12 19:09 0022_user_clear_search_when_switching.py -rw-rw-r-- 1 tactical tactical 405 Jun 12 19:09 0021_role_can_view_core_settings.py -rw-rw-r-- 1 tactical tactical 387 Jun 12 19:09 0020_role_can_manage_roles.py -rw-rw-r-- 1 tactical tactical 606 Jun 12 19:09 0019_user_role.py -rw-rw-r-- 1 tactical tactical 6628 Jun 12 19:09 0018_auto_20210511_0233.py -rw-rw-r-- 1 tactical tactical 5474 Jun 12 19:09 0017_auto_20210508_1716.py -rw-rw-r-- 1 tactical tactical 880 Jun 12 19:09 0016_auto_20210507_1526.py -rw-rw-r-- 1 tactical tactical 415 Jun 12 19:09 0015_user_loading_bar_color.py -rw-rw-r-- 1 tactical tactical 406 Jun 12 19:09 0014_user_client_tree_splitter.py -rw-rw-r-- 1 tactical tactical 510 Jun 12 19:09 0013_user_client_tree_sort.py -rw-rw-r-- 1 tactical tactical 408 Jun 12 19:09 0012_user_agents_per_page.py -rw-rw-r-- 1 tactical tactical 652 Jun 12 19:09 0011_user_default_agent_tbl_tab.py -rw-rw-r-- 1 tactical tactical 677 Jun 12 19:09 0010_user_agent_dblclick_action.py -rw-rw-r-- 1 tactical tactical 397 Jun 12 19:09 0009_user_show_community_scripts.py -rw-rw-r-- 1 tactical tactical 394 Jun 12 19:09 0008_user_dark_mode.py -rw-rw-r-- 1 tactical tactical 617 Jun 12 19:09 0007_update_agent_primary_key.py -rw-rw-r-- 1 tactical tactical 654 Jun 12 19:09 0006_user_agent.py drwxrwxr-x 2 tactical tactical 4096 Jun 12 19:11 __pycache__ ```

kerem commented

2026-03-14 05:55:16 +03:00

Author

Owner

@NiceGuyIT commented on GitHub (Jun 12, 2023):

@Nzrvynnyk Can you edit your post and put the content in triple backticks to format it as a block?

```
Your content here
```

@NiceGuyIT commented on GitHub (Jun 12, 2023): @Nzrvynnyk Can you edit your post and put the content in triple backticks to format it as a block? \`\`\` Your content here \`\`\`

kerem commented

2026-03-14 05:55:21 +03:00

Author

Owner

@wh1te909 commented on GitHub (Jun 12, 2023):

@Nzrvynnyk API error is unrelated. you need to update your post requests and add run_as_user to the payload (it's a boolean)

@wh1te909 commented on GitHub (Jun 12, 2023): @Nzrvynnyk API error is unrelated. you need to update your post requests and add `run_as_user` to the payload (it's a boolean)

kerem commented

2026-03-14 05:55:26 +03:00

Author

Owner

@wh1te909 commented on GitHub (Jun 12, 2023):

@Nzrvynnyk and @MAJINFORMATIQUE please export your DB and send it to us, you can open a ticket here and upload it and will take a look to see what's going on. you can use the following script to export db then upload the db-issue1532.psql.gz file in ticket.

#!/usr/bin/env bash

POSTGRES_USER=$(/rmm/api/env/bin/python /rmm/api/tacticalrmm/manage.py get_config dbuser)
POSTGRES_PW=$(/rmm/api/env/bin/python /rmm/api/tacticalrmm/manage.py get_config dbpw)

pg_dump --dbname=postgresql://"${POSTGRES_USER}":"${POSTGRES_PW}"@127.0.0.1:5432/tacticalrmm | gzip -9 >db-issue1532.psql.gz

@wh1te909 commented on GitHub (Jun 12, 2023): @Nzrvynnyk and @MAJINFORMATIQUE please export your DB and send it to us, you can open a ticket [here](https://support.amidaware.com/) and upload it and will take a look to see what's going on. you can use the following script to export db then upload the `db-issue1532.psql.gz` file in ticket. ```bash #!/usr/bin/env bash POSTGRES_USER=$(/rmm/api/env/bin/python /rmm/api/tacticalrmm/manage.py get_config dbuser) POSTGRES_PW=$(/rmm/api/env/bin/python /rmm/api/tacticalrmm/manage.py get_config dbpw) pg_dump --dbname=postgresql://"${POSTGRES_USER}":"${POSTGRES_PW}"@127.0.0.1:5432/tacticalrmm | gzip -9 >db-issue1532.psql.gz ```

kerem commented

2026-03-14 05:55:31 +03:00

Author

Owner

@Nzrvynnyk commented on GitHub (Jun 12, 2023):

run_as_user

Could you pls share some examples?

@Nzrvynnyk commented on GitHub (Jun 12, 2023): > run_as_user Could you pls share some examples?

kerem commented

2026-03-14 05:55:36 +03:00

Author

Owner

@wh1te909 commented on GitHub (Jun 12, 2023):

run_as_user

Could you pls share some examples?

{
    "shell": "cmd",
    "cmd": "ping 8.8.8.8",
    "timeout": 30,
    "custom_shell": null,
    "run_as_user": false
}

@wh1te909 commented on GitHub (Jun 12, 2023): > > run_as_user > > Could you pls share some examples? ```json { "shell": "cmd", "cmd": "ping 8.8.8.8", "timeout": 30, "custom_shell": null, "run_as_user": false } ```