Project

General

Profile

"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>