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

An exception occurred while executing 'SELECT * FROM "oc_spreedme_rooms"' during migration #10948

Closed
svenerbe opened this issue Aug 31, 2018 · 2 comments
Labels

Comments

@svenerbe
Copy link

I try to migrate my nextcloud db from sqllite to mysql. Nextcloud 13.0.6

php70 /volume1/web/nextcloud/occ db:convert-type --all-apps --port="3307" mysql $USER 127.0.0.1 nextclouddb

What is the database password?
Creating schema in new database

[Doctrine\DBAL\Exception\TableNotFoundException]
An exception occurred while executing 'SELECT * FROM "oc_spreedme_rooms"':
SQLSTATE[HY000]: General error: 1 no such table: oc_spreedme_rooms

[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000]: General error: 1 no such table: oc_spreedme_rooms

[PDOException]
SQLSTATE[HY000]: General error: 1 no such table: oc_spreedme_rooms

but when i use mysql, all is working fine.

./mysql -u $USER -p nextclouddb
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6036
Server version: 10.0.34-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [nextclouddb]>
MariaDB [nextclouddb]> SELECT * FROM oc_spreedme_rooms;
Empty set (0.01 sec)

MariaDB [nextclouddb]> quit

@nextcloud-bot
Copy link
Member

GitMate.io thinks possibly related issues are #5155 (Migrations), #7191 (Crash on start with An exception occurred while executing 'CREATE table oc_locks_w2g), #2661 ([11] Specific user creation failed: An exception occurred while executing 'SELECT user FROM mysql.user ), #7528 (An exception occurred while executing 'INSERT INTO migrations (app,version)), and #8826 (Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO oc_file_locks).

@MorrisJobke
Copy link
Member

This is an issue within the spreedme app. Thus please report it to the maintainer of that app in its repository: https://github.com/strukturag/nextcloud-spreedme

Keep in mind that this app is discontinued in order to provide a better working solution with the talk app: https://github.com/nextcloud/spreed

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

No branches or pull requests

3 participants