SQL query error on 'Memories' app after NC Update

ℹ️ Support
1

Nextcloud version : 25.0.5.1
Operating system and version : Debian 11 kernel 5.10.162-1
Apache or nginx version : Apache/2.4.56
PHP version : PHP 8.1.17

Since 2023-03-12, upgrade from version 25.0.3.2 to 25.0.4.1, Memories app don’t follow certain folders.
New medias are not indexed.
Errors when I try to re-index with Memories :

sudo -u www-data php /var/www/nextcloud/occ memories:index | grep SQLSTATE
Could not scan folder /****/files/****: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextclouddb.memories_planet_geometry' doesn't exist
Could not scan folder /****/files/Photos/InstantUpload: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextclouddb.memories_planet_geometry' doesn't exist

Same thing in nextcloud.log file (first occurences of this error) => ZeroBin

config.php file:

<?php
$CONFIG = array (
  'instanceid' => '*************',
  'passwordsalt' => '*******',
  'secret' => '**************************',
  'trusted_domains' => 
  array (
    0 => '*******************',
  ),
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'redis' => 
  array (
    'host' => '/run/redis/redis-server.sock',
    'port' => 0,
  ),
  'overwrite.cli.url' => '**********************',
  'htaccess.RewriteBase' => '/',
  'datadirectory' => '/var/www/nextcloud/data',
  'dbtype' => 'mysql',
  'version' => '25.0.5.1',
  'dbname' => '**************',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => '***********',
  'dbpassword' => '********************',
  'installed' => true,
  'default_language' => 'fr',
  'default_locale' => 'fr_FR',
  'default_phone_region' => 'FR',
  'enable_previews' => true,
  'preview_max_x' => 2048,
  'preview_max_y' => 2048,
  'enabledPreviewProviders' => 
  array (
    0 => 'OC\\Preview\\PNG',
    1 => 'OC\\Preview\\JPEG',
    2 => 'OC\\Preview\\GIF',
    3 => 'OC\\Preview\\BMP',
    4 => 'OC\\Preview\\XBitmap',
    5 => 'OC\\Preview\\MP3',
    6 => 'OC\\Preview\\TXT',
    7 => 'OC\\Preview\\MarkDown',
    8 => 'OC\\Preview\\OpenDocument',
    9 => 'OC\\Preview\\Krita',
    10 => 'OC\\Preview\\Movie',
  ),
  'maintenance' => false,
  'theme' => '',
  'jpeg_quality' => '60',
  'memories.exiftool' => '/var/www/nextcloud/apps/memories/exiftool-bin/exiftool-amd64-glibc',
  'memories.ffmpeg_path' => '/usr/bin/ffmpeg',
  'memories.ffprobe_path' => '/usr/bin/ffprobe',
  'memories.transcoder' => '/var/www/nextcloud/apps/memories/exiftool-bin/go-vod-amd64',
  'memories.no_transcode' => true,
  'memories.qsv' => false,
  'memories.gis_type' => 1,
  'memories.vod.ffmpeg' => '/usr/bin/ffmpeg',
  'memories.vod.ffprobe' => '/usr/bin/ffprobe',
  'memories.vod.disable' => true,
  'loglevel' => 2,
);

I am now on an up-to-date version and I have the same problem… It seems that the error comes from Nextcloud, not from the Memories app. How to further diagnose?
Thanks in advance

2

You need to run occ memories:places-setup

1 Like