After a fresh install of Ubuntu - i did the same installation as above: creating a folder, git clone, then:
python3 -m pip install .
python3 -m pip install SQLAlchemy==1.4.42
OpenLP is running, but when I try add a song to the service - OpenLP crash:
Traceback (most recent call last):
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such column: media_files.file_hash
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/ralfrupf/.local/lib/python3.10/site-packages/openlp/core/lib/mediamanageritem.py", line 602, in on_add_click
self.add_to_service(item, position=drop_position)
File "/home/ralfrupf/.local/lib/python3.10/site-packages/openlp/core/lib/mediamanageritem.py", line 623, in add_to_service
service_item = self.build_service_item(item, remote=remote, context=ServiceItemContext.Service)
File "/home/ralfrupf/.local/lib/python3.10/site-packages/openlp/core/lib/mediamanageritem.py", line 663, in build_service_item
if self.generate_slide_data(service_item, item=item, remote=remote, context=context):
File "/home/ralfrupf/.local/lib/python3.10/site-packages/openlp/plugins/songs/lib/mediaitem.py", line 627, in generate_slide_data
if song.media_files:
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 482, in __get__
return self.impl.get(state, dict_)
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 942, in get
value = self._fire_loader_callables(state, key, passive)
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/orm/attributes.py", line 978, in _fire_loader_callables
return self.callable_(state, passive)
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 912, in _load_for_state
return self._emit_lazyload(
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/orm/strategies.py", line 1046, in _emit_lazyload
result = session.execute(
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1714, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 333, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
ret = self._execute_context(
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
self._handle_dbapi_exception(
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception
util.raise_(
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 208, in raise_
raise exception
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/home/ralfrupf/.local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: media_files.file_hash
[SQL: SELECT media_files.id AS media_files_id, media_files.song_id AS media_files_song_id, media_files.file_path AS media_files_file_path, media_files.file_hash AS media_files_file_hash, media_files.type AS media_files_type, media_files.weight AS media_files_weight
FROM media_files
WHERE ? = media_files.song_id ORDER BY media_files.weight]
[parameters: (14,)]
(Background on this error at: https://sqlalche.me/e/14/e3q8)