Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

no such table: scene_exceptions #7983

Closed
reemplazable opened this issue Apr 17, 2020 · 7 comments
Closed

no such table: scene_exceptions #7983

reemplazable opened this issue Apr 17, 2020 · 7 comments
Labels
triage Untriaged issue

Comments

@reemplazable
Copy link

Describe the bug
It will not download anything

To Reproduce
Steps to reproduce the behavior:

  1. Stop docker
  2. Pull new version
  3. Start docker
  4. See error

Medusa (please complete the following information):

  • Branch: master
  • Commit: 8f6b666
  • Version: 0.3.15
  • Database: 44.15
  • Python Version: | 3.7.6 (default, Dec 21 2019, 02:28:04) [GCC 8.3.0]
  • SSL Version: | OpenSSL 1.1.1d 10 Sep 2019
  • OS: | Linux-5.6.3-arch1-1-x86_64-with
  • Locale: | en_US.UTF-8

Debug logs (at least 50 lines):

2020-04-17 07:10:54 ERROR    FORCEDSEARCHQUEUE-MANUAL-364149 :: [8f6b666] DB error: OperationalError('no such table: scene_exceptions')
Traceback (most recent call last):
sqlite3.OperationalError: no such table: scene_exceptions
2020-04-17 07:10:54 ERROR    FORCEDSEARCHQUEUE-MANUAL-364149 :: [8f6b666] DB error: no such table: scene_exceptions
Traceback (most recent call last):
sqlite3.OperationalError: no such table: scene_exceptions
@triage-new-issues triage-new-issues bot added the triage Untriaged issue label Apr 17, 2020
@medariox
Copy link
Contributor

Read this: #7976

@reemplazable
Copy link
Author

@medariox but this is not a fix, How do I fix it? Send you the database file?

@p0psicles
Copy link
Contributor

I'll give you instructions how to fix when I get home

@reemplazable
Copy link
Author

@p0psicles thanks!

@p0psicles
Copy link
Contributor

p0psicles commented Apr 17, 2020

If you follow these instructions you can fix the issue your self.

  1. Shutdown medusa
  2. Make sure the process has completed stopped
  3. Open a cmd prompt or bash, and navigate to the location where the main.db file resides
  4. Run the following command:
    python -c "exec(\"import sqlite3\ncurs=sqlite3.connect('main.db')\ncurs.execute('UPDATE db_version set db_minor_version = 14;')\ncurs.commit()\ncurs.close()\")"
  5. Start medusa (wait until it has fully started)

The scene_exceptions table should have been recreated now

@reemplazable
Copy link
Author

If you follow these instructions you can fix the issue your self.

1. Shutdown medusa

2. Make sure the process has completed stopped

3. Open a cmd prompt or bash, and navigate to the location where the `main.db` file resides

4. Run the following command:
   `python -c "exec(\"import sqlite3\ncurs=sqlite3.connect('main.db')\ncurs.execute('UPDATE db_version set db_minor_version = 14;')\ncurs.commit()\ncurs.close()\")"`

5. Start medusa (wait until it has fully started)

The scene_exceptions table should have been recreated now

IT is working!
THANKYOUUUU

@Jahislove
Copy link

same problem for me , fixing by Popsicles instructions work :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
triage Untriaged issue
Projects
None yet
Development

No branches or pull requests

4 participants