MariaDB: Add log message for versions < 10.5.10 with broken table name resolution MDEV-25362

[kalon33]

After updating to preview from stable version, I get these errors:

photoprism    | time="2021-09-23T08:51:12Z" level=warning msg="metadata: Error 1054: Unknown column 'subjects.subj_uid' in 'on clause' (update counts)"
photoprism    | time="2021-09-23T08:51:13Z" level=error msg="metadata: Error 1054: Unknown column 'albums.album_uid' in 'on clause' (update previews)"

How could I fix them?

Thanks for your help, and your very great project.

[lastzero]

Thanks for reporting this!

• Can you check how the subjects table looks?
• Do you use MariaDB, MySQL or SQLite?
• How old is the schema (what version did you start with)?
• Did you use other preview versions in between or only the stable version so far?

[kalon33]

I use MariaDB, the schema is from the stable version (current), and I used the stable version only so far.

[lastzero]

Ok, so when I install the stable version and then upgrade, I should see the same error?

[kalon33]

I hope so

[kalon33]

when I installed the stable, in Docker hub it seemed stable was from 4months ago.

[lastzero]

I'll try... can you test this too?

[kalon33]

Test a fresh reinstall? Basically my install is from last weekend when I wanted to test photoprism stable, and migration to preview was from this morning.

[lastzero]

Yes, just to be sure. Sounds like schema migrations didn't run (they should every time photoprism starts). The subjects table is new, so it's very strange the column doesn't exist at all.

[lastzero]

Does it work when you enable experimental features (advanced settings or in docker-compose.yml) and then restart?

[kalon33]

It was already enabled (I enabled it when on stable), and at start I only have this in the logs:

$ docker-compose up
Starting photoprism ... 
Starting photoprism ... done
Attaching to photoprism
photoprism    | running as uid 0
photoprism    | photoprism start
photoprism    | time="2021-09-23T14:14:47Z" level=info msg="http: enabling gzip compression"
photoprism    | time="2021-09-23T14:14:47Z" level=info msg="webdav: /originals/ enabled, waiting for requests"
photoprism    | time="2021-09-23T14:14:47Z" level=info msg="webdav: /import/ enabled, waiting for requests"
photoprism    | time="2021-09-23T14:14:47Z" level=info msg="http: starting web server at 0.0.0.0:2342"

[kalon33]

I still have the error when importing after a restart:

$ docker-compose up
Starting photoprism ... 
Starting photoprism ... done
Attaching to photoprism
photoprism    | running as uid 0
photoprism    | photoprism start
photoprism    | time="2021-09-23T14:14:47Z" level=info msg="http: enabling gzip compression"
photoprism    | time="2021-09-23T14:14:47Z" level=info msg="webdav: /originals/ enabled, waiting for requests"
photoprism    | time="2021-09-23T14:14:47Z" level=info msg="webdav: /import/ enabled, waiting for requests"
photoprism    | time="2021-09-23T14:14:47Z" level=info msg="http: starting web server at 0.0.0.0:2342"
photoprism    | time="2021-09-23T14:23:41Z" level=info msg="1 fichiers chargés en 30 s"
photoprism    | time="2021-09-23T14:24:22Z" level=info msg="1 fichiers chargés en 40 s"
photoprism    | time="2021-09-23T14:25:00Z" level=info msg="1 fichiers chargés en 37 s"
photoprism    | time="2021-09-23T14:25:22Z" level=info msg="1 fichiers chargés en 22 s"
photoprism    | time="2021-09-23T14:25:56Z" level=info msg="1 fichiers chargés en 33 s"
photoprism    | time="2021-09-23T14:27:35Z" level=info msg="1 fichiers chargés en 99 s"
photoprism    | time="2021-09-23T14:28:02Z" level=info msg="1 fichiers chargés en 26 s"
photoprism    | time="2021-09-23T14:28:02Z" level=error msg="failed updating folder previews: Error 1054: Unknown column 'albums.album_path' in 'on clause'"
photoprism    | time="2021-09-23T14:28:02Z" level=info msg="Déplacement de fichiers depuis 1632406990404"
photoprism    | time="2021-09-23T14:28:02Z" level=info msg="classify: loading nasnet"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="classify: loading labels from labels.txt"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: no .ppignore file found"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: added folder /upload/1632406990404"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="media: IMG_20200823_190519.jpg was taken at 2020-08-23 17:05:20 +0000 UTC (meta)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: IMG_20200823_190519.jpg is identical to 2020/08/20200823_170520_2EC4A4C7.jpg (sha1 f5bc4ab4cd00900fa7c7030073ea546b5e79040e)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="media: IMG_20200823_190454.jpg was taken at 2020-08-23 17:04:56 +0000 UTC (meta)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: deleted IMG_20200823_190519.jpg (already exists)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: IMG_20200823_190454.jpg is identical to 2020/08/20200823_170456_B94430ED.jpg (sha1 5142d3bf8af2001c10e8ede19f6557f515abbb94)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: deleted IMG_20200823_190454.jpg (already exists)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="media: IMG_20200823_190522.jpg was taken at 2020-08-23 17:05:23 +0000 UTC (meta)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: IMG_20200823_190522.jpg is identical to 2020/08/20200823_170523_4E8F4500.jpg (sha1 334c51711a0a685b92d86e681c7199f1bc9dce22)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: deleted IMG_20200823_190522.jpg (already exists)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="media: IMG_20200823_190527.jpg was taken at 2020-08-23 17:05:28 +0000 UTC (meta)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: IMG_20200823_190527.jpg is identical to 2020/08/20200823_170528_4862A8E1.jpg (sha1 d422415633205f619509f2b0bd5e9a69b5050aa9)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: deleted IMG_20200823_190527.jpg (already exists)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="media: IMG_20200823_190530.jpg was taken at 2020-08-23 17:05:32 +0000 UTC (meta)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: IMG_20200823_190530.jpg is identical to 2020/08/20200823_170532_D2FF6C38.jpg (sha1 86e2dff85555d70ef509f11c006519bbe7b46325)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: deleted IMG_20200823_190530.jpg (already exists)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="media: IMG_20200823_190536.jpg was taken at 2020-08-23 17:05:38 +0000 UTC (meta)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: IMG_20200823_190536.jpg is identical to 2020/08/20200823_170538_F0251DAC.jpg (sha1 8f154ced2358ac87d257804ead347dfe4548415f)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: deleted IMG_20200823_190536.jpg (already exists)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="media: IMG_20200823_190539_1.jpg was taken at 2020-08-23 17:05:41 +0000 UTC (meta)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: IMG_20200823_190539_1.jpg is identical to 2020/08/20200823_170541_8A046280.jpg (sha1 b72de1b1560eae09dc829123071ba9ea98bc9805)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: deleted IMG_20200823_190539_1.jpg (already exists)"
photoprism    | time="2021-09-23T14:28:05Z" level=error msg="import: Error 1054: Unknown column 'subjects.subj_uid' in 'on clause' (update counts)"
photoprism    | time="2021-09-23T14:28:05Z" level=info msg="import: deleted empty folder /photoprism/import/upload/1632406990404"
photoprism    | time="2021-09-23T14:28:06Z" level=info msg="Importation terminée en 3 s"
photoprism    | time="2021-09-23T14:28:06Z" level=error msg="import: Error 1054: Unknown column 'albums.album_uid' in 'on clause' (update previews)"
photoprism    | time="2021-09-23T14:29:47Z" level=info msg="metadata: optimized 5 photos"
photoprism    | time="2021-09-23T14:29:47Z" level=warning msg="metadata: Error 1054: Unknown column 'subjects.subj_uid' in 'on clause' (update counts)"
photoprism    | time="2021-09-23T14:29:47Z" level=error msg="metadata: Error 1054: Unknown column 'albums.album_uid' in 'on clause' (update previews)"

[lastzero]

I assume you're using version 10.5 of MariaDB with the same settings as shown in our docker-compose.yml example?