"Database Column Conversion to Big Integers in Nextcloud" » History » Version 2
Gareth Eaton, 05/19/2024 01:46 PM
1 | 2 | Gareth Eaton | h3. Database Column Conversion to Big Integers in Nextcloud |
---|---|---|---|
2 | 1 | Gareth Eaton | |
3 | 2 | Gareth Eaton | If Nextcloud has identified some database columns that need to be converted to big integers. |
4 | This change wasn't made automatically due to the time it can take for large tables. |
||
5 | 1 | Gareth Eaton | |
6 | 2 | Gareth Eaton | We will enable maintenance mode to prevent user access during the conversion process: |
7 | 1 | Gareth Eaton | |
8 | 2 | Gareth Eaton | Enable maintenance mode; |
9 | |||
10 | 1 | Gareth Eaton | <pre> |
11 | sudo -u www-data php occ maintenance:mode --on |
||
12 | </pre> |
||
13 | |||
14 | 2 | Gareth Eaton | Run the conversion command: |
15 | 1 | Gareth Eaton | |
16 | <pre> |
||
17 | 2 | Gareth Eaton | sudo -u www-data php occ db:convert-filecache-bigint |
18 | 1 | Gareth Eaton | </pre> |
19 | |||
20 | 2 | Gareth Eaton | Once the conversion is complete, disable maintenance mode; |
21 | 1 | Gareth Eaton | |
22 | |||
23 | <pre> |
||
24 | 2 | Gareth Eaton | sudo -u www-data php occ maintenance:mode --off |
25 | 1 | Gareth Eaton | </pre> |