1. What is not working as documented?
photoprism migrations ls error
20221015-100000 failed with Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF EXISTS `accounts` TO `services`' at line 1 [631.138µs]
Im using standalone mariadb instance:
mysql Ver 15.1 Distrib 10.3.28-MariaDB, for Linux (x86_64) using readline 5.1
2. How can we reproduce it?
Steps to reproduce the behavior:
Stop photopirsm docker, remove old images, start photoprism docker.
After successfully executing photoprism users reset and recreating second user account (Admin account was not created automatically - password change forced migration).
Inside docker image:
Trying to upgrade photoprism to Release 46, after checking photoprism migrations ls error is displayed:
20221015-100000 failed with Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF EXISTS `accounts` TO `services`' at line 1 [631.138µs]
Tryig to retry migration with photoprism migrations run -f but same error apears.
When reporting an import, indexing, or performance issue, please include the number and type of pictures in your library, as well as any configuration options you have changed, such as for thumbnail quality.
3. What behavior do you expect?
'Ok' in migration process
4. What could be the cause of your problem?
Upgrade ?
5. Can you provide us with example files for testing, error logs, or screenshots?
No idea what example is needed but will provide what needed.
6. Which software versions do you use?
(a) PhotoPrism Release 46
(b) Database Type & Version: MariaDB, MySQL, SQLite,...
(c) Centos 8 Stream
(d) Firefox
(e) relevant
7. On what kind of device is PhotoPrism installed?
Skip
8. Do you use a Reverse Proxy, Firewall, VPN, or CDN?
No
1. What is not working as documented?
photoprism migrations lserror20221015-100000 failed with Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF EXISTS `accounts` TO `services`' at line 1 [631.138µs]Im using standalone mariadb instance:
mysql Ver 15.1 Distrib 10.3.28-MariaDB, for Linux (x86_64) using readline 5.1
2. How can we reproduce it?
Steps to reproduce the behavior:
Stop photopirsm docker, remove old images, start photoprism docker.
After successfully executing
photoprism users resetand recreating second user account (Admin account was not created automatically - password change forced migration).Inside docker image:
Trying to upgrade photoprism to Release 46, after checking
photoprism migrations lserror is displayed:20221015-100000 failed with Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF EXISTS `accounts` TO `services`' at line 1 [631.138µs]Tryig to retry migration with
photoprism migrations run -fbut same error apears.When reporting an import, indexing, or performance issue, please include the number and type of pictures in your library, as well as any configuration options you have changed, such as for thumbnail quality.
3. What behavior do you expect?
'Ok' in migration process
4. What could be the cause of your problem?
Upgrade ?
5. Can you provide us with example files for testing, error logs, or screenshots?
No idea what example is needed but will provide what needed.
6. Which software versions do you use?
(a) PhotoPrism Release 46
(b) Database Type & Version: MariaDB, MySQL, SQLite,...
(c) Centos 8 Stream
(d) Firefox
(e) relevant
7. On what kind of device is PhotoPrism installed?
Skip
8. Do you use a Reverse Proxy, Firewall, VPN, or CDN?
No