Db:convert-filecache-bigint * file_metadata.id

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:


Or for longer, use three backticks above and below the code snippet:


Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version 25.0.4
Operating system and version unknown - shared hosting`
Apache or nginx version unknown
PHP version 7.4

The issue you are facing:
In admin - overview I have the following message:

Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running “occ db:convert-filecache-bigint” those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this :arrow_upper_right:.

  • file_metadata.id

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Upgrade to 25.0.5
  2. Run the command: db:convert-filecache-bigint -in the occ app while NOT in maintenance mode.
  3. Receive print: [object Object]
  4. Refresh the admin page and the same error is still present.

The output of your Nextcloud log in Admin > Logging:


[index] Error: Exception: Undefined constant ‘STDIN’ in file ‘/home/barkingb/nextcloud.barkingbandicoot.com/3rdparty/symfony/console/Helper/QuestionHelper.php’ line 108 at <>

  1. /home/barkingb/nextcloud.barkingbandicoot.com/lib/private/AppFramework/App.php line 172
    OC\AppFramework\Http\Dispatcher->dispatch(["OCA\OCCWeb\C … "], “cmd”)
  2. /home/barkingb/nextcloud.barkingbandicoot.com/lib/private/Route/Router.php line 298
    OC\AppFramework\App::main(“OCA\OCCWeb\Controller\OccController”, “cmd”, ["OC\AppFramewo … "], [“occweb.occ.cmd”])
  3. /home/barkingb/nextcloud.barkingbandicoot.com/lib/base.php line 1047
  4. /home/barkingb/nextcloud.barkingbandicoot.com/index.php line 36

POST /index.php/apps/occweb/cmd
from by taoist at 2023-03-07T12:42:33+00:00