osxphotos: macOS 15 timewarp --pull-exif: no such table: Z_31ASSETS
On the latest beta 3 of macOS 15 the following error appears when trying to execute
osxphotos timewarp --pull-exif
Created: 2024-07-13 19:20:04.127053
osxphotos version: 0.68.2
Platform: macOS-15.0-arm64-arm-64bit
Python version: 3.12.4 (main, Jun 6 2024, 18:26:44) [Clang 15.0.0 (clang-1500.3.9.4)]
sys.argv: ['/Users//.local/bin/osxphotos', 'timewarp', '--pull-exif']
CRASH_DATA:
locals: {'date': None, 'date_delta': None, 'time': None, 'time_delta': None, 'timezone': None, 'date_added': None, 'date_added_from_photo': False, 'inspect': False, 'compare_exif': False, 'push_exif': False, 'pull_exif': True, 'function': None, 'match_time': False, 'use_file_time': False, 'add_to_album': None, 'exiftool_path': None, 'verbose_flag': 0, 'library': None, 'theme': None, 'parse_date': None, 'plain': False, 'timestamp': False, 'force': False}
osxphotos version: 0.68.2
Error: no such table: Z_31ASSETS
Traceback (most recent call last):
File "/Users//.local/pipx/venvs/osxphotos/lib/python3.12/site-packages/osxphotos/crash_reporter.py", line 79, in wrapped
return func(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^
File "/Users//.local/pipx/venvs/osxphotos/lib/python3.12/site-packages/osxphotos/cli/timewarp.py", line 648, in timewarp
exif_updater = ExifDateTimeUpdater(
^^^^^^^^^^^^^^^^^^^^
File "/Users//.local/pipx/venvs/osxphotos/lib/python3.12/site-packages/osxphotos/exif_datetime_updater.py", line 39, in __init__
self.db = PhotosDB(self.library_path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users//.local/pipx/venvs/osxphotos/lib/python3.12/site-packages/osxphotos/photosdb/photosdb.py", line 419, in __init__
self._process_database5()
File "/Users//.local/pipx/venvs/osxphotos/lib/python3.12/site-packages/osxphotos/photosdb/photosdb.py", line 1832, in _process_database5
c.execute(
sqlite3.OperationalError: no such table: Z_31ASSETS
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Reactions: 1
- Comments: 18 (12 by maintainers)
@mybizgeek yeah, Apple changed the schema again. Working on a fix that will address both 14.6 and 15.0
@RhetTbull I’m getting a similar error on MacOS 14.6. Was working fine on 14.5.
Thanks @RhetTbull all good on macOS 15.1!
macOS 15 is not officially supported yet. The first beta worked but Apple keeps changing things.
@RhetTbull I’ve sent library opened in 15.1 (already updated from 15.0 to 15.1) to osxphotos.py@gmail.com, hope that helps. Thanks.
Dropped you a link to a zip file, via email. Hope it works!