bazarr / wiki

Wiki for Bazarr, Bazarr is a companion application to Sonarr and Radarr that manages and downloads subtitles based on your requirements.
https://www.bazarr.media/
MIT License
26 stars 13 forks source link

Bazarr doesn't start anymore #264

Closed vctrbm closed 12 months ago

vctrbm commented 12 months ago

Hi, I'm new here. Can I ask a question? I have a dedicated server running ubuntu 16.04. I had already installed sonarr, radarr and bazarr. Everything was working fine, but all of a sudden, bazarr doesn't start anymore.


Ubuntu-1604-xenial-64-minimal-no-hwe:~# /home/weedmade/.pyenv/versions/3.8-dev/bin/python3.8 /opt/bazarr/bazarr.py Bazarr starting... Traceback (most recent call last): File "/opt/bazarr/bazarr/../libs/sqlalchemy/engine/base.py", line 1964, in _exec_single_context self.dialect.do_execute( File "/opt/bazarr/bazarr/../libs/sqlalchemy/engine/default.py", line 748, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: near "ON": syntax error

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/opt/bazarr/bazarr/main.py", line 70, in load_language_in_db() File "/opt/bazarr/bazarr/languages/get_languages.py", line 18, in load_language_in_db database.execute( File "/opt/bazarr/bazarr/../libs/sqlalchemy/orm/scoping.py", line 724, in execute return self._proxied.execute( File "/opt/bazarr/bazarr/../libs/sqlalchemy/orm/session.py", line 2229, in execute return self._execute_internal( File "/opt/bazarr/bazarr/../libs/sqlalchemy/orm/session.py", line 2124, in _execute_internal result: Result[Any] = compile_state_cls.orm_execute_statement( File "/opt/bazarr/bazarr/../libs/sqlalchemy/orm/bulk_persistence.py", line 1225, in orm_execute_statement result = conn.execute( File "/opt/bazarr/bazarr/../libs/sqlalchemy/engine/base.py", line 1414, in execute return meth( File "/opt/bazarr/bazarr/../libs/sqlalchemy/sql/elements.py", line 486, in _execute_on_connection return connection._execute_clauseelement( File "/opt/bazarr/bazarr/../libs/sqlalchemy/engine/base.py", line 1638, in _execute_clauseelement ret = self._execute_context( File "/opt/bazarr/bazarr/../libs/sqlalchemy/engine/base.py", line 1842, in _execute_context return self._exec_single_context( File "/opt/bazarr/bazarr/../libs/sqlalchemy/engine/base.py", line 1983, in _exec_single_context self._handle_dbapi_exception( File "/opt/bazarr/bazarr/../libs/sqlalchemy/engine/base.py", line 2326, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/opt/bazarr/bazarr/../libs/sqlalchemy/engine/base.py", line 1964, in _exec_single_context self.dialect.do_execute( File "/opt/bazarr/bazarr/../libs/sqlalchemy/engine/default.py", line 748, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "ON": syntax error [SQL: INSERT INTO table_settings_languages (code3, code2, enabled, name) VALUES (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?), (?, ?, ?, ?) ON CONFLICT DO NOTHING] [parameters: ('aar', 'aa', 0, 'Afar', 'abk', 'ab', 0, 'Abkhazian', 'afr', 'af', 0, 'Afrikaans', 'aka', 'ak', 0, 'Akan', 'amh', 'am', 0, 'Amharic', 'ara', 'ar', 0, 'Arabic', 'arg', 'an', 0, 'Aragonese', 'asm', 'as', 0, 'Assamese', 'ava', 'av', 0, 'Avaric', 'ave', 'ae', 0, 'Avestan', 'aym', 'ay', 0, 'Aymara', 'aze', 'az', 0, 'Azerbaijani', 'bak', 'ba' ... 636 parameters truncated ... 0, 'Urdu', 'uzb', 'uz', 0, 'Uzbek', 'ven', 've', 0, 'Venda', 'vie', 'vi', 0, 'Vietnamese', 'vol', 'vo', 0, 'Volapük', 'wln', 'wa', 0, 'Walloon', 'wol', 'wo', 0, 'Wolof', 'xho', 'xh', 0, 'Xhosa', 'yid', 'yi', 0, 'Yiddish', 'yor', 'yo', 0, 'Yoruba', 'zha', 'za', 0, 'Zhuang', 'zho', 'zh', 0, 'Chinese', 'zul', 'zu', 0, 'Zulu')] (Background on this error at: https://sqlalche.me/e/20/e3q8)


Does anyone know howto solve this?

morpheus65535 commented 12 months ago

This repository is for the wiki, please use this existing issue: https://github.com/morpheus65535/bazarr/issues/2247