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.

Sign up for GitHub

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

Jump to bottom

Internal Server Error #1877

Open
john-clark opened this issue Jan 13, 2024 · 0 comments
Open

Internal Server Error #1877

john-clark opened this issue Jan 13, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@john-clark
Copy link

Describe the bug
Internal Server Error

To Reproduce
Steps to reproduce the behavior:

  1. visit $host/apps/social/ or $host/index.php/.well-known/webfinger
  2. See error

Expected behavior
See valid response, social app

Client details:

  • OS: Windows
  • Browser Firefox
  • Version current
  • Device: desktop
Server details

Social app version: 0.7.0

  • git clone
  • make dev-setup
  • make build-js
  • occ app:update social

Operating system: Linux

Web server: Nginx

Database: mariadb

PHP version: 8.1

Nextcloud version: 28.0.1

Logs

Nextcloud log (data/nextcloud.log)

 Error    index              OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[42S02]: Base      2024-01-13T03:26:58+00:00
                              table or view not found: 1146 Table 'nextcloud.oc_social_actor' doesn't exist at
                              lib/private/DB/Exceptions/DbalException.php line 71

                              0. lib/private/DB/QueryBuilder/QueryBuilder.php line 295
                                 OC\DB\Exceptions\DbalException::wrap(

                                 )
                              1. apps/social/lib/Db/ActorsRequest.php line 106
                                 OC\DB\QueryBuilder\QueryBuilder->executeQuery(

                                 )
                              2. apps/social/lib/Service/AccountService.php line 209
                                 OCA\Social\Db\ActorsRequest->getFromUsername(

                                 )
                              3. .../lib/Controller/NavigationController.php line 160
                                 OCA\Social\Service\AccountService->createActor("*** sensitive parameters replaced ***")
                              4. .../AppFramework/Http/Dispatcher.php line 230
                                 OCA\Social\Controller\NavigationController->navigate(

                                 )
                              5. .../AppFramework/Http/Dispatcher.php line 137
                                 OC\AppFramework\Http\Dispatcher->executeController(

                                 )
                              6. lib/private/AppFramework/App.php line 184
                                 OC\AppFramework\Http\Dispatcher->dispatch(

                                 )
                              7. lib/private/Route/Router.php line 315
                                 OC\AppFramework\App::main(

                                 )
                              8. lib/base.php line 1069
                                 OC\Route\Router->match(

                                 )
                              9. index.php line 39
                                 OC::handleRequest(

                                 )

                              Caused by Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query:
                              SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_social_actor' doesn't exist at
                              .../dbal/src/Driver/API/MySQL/ExceptionConverter.php line 49

                               0. .../dbal/src/Connection.php line 1938
                                  Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(

                                  )
                               1. .../doctrine/dbal/src/Connection.php line 1880
                                  Doctrine\DBAL\Connection->handleDriverException(

                                  )
                               2. .../dbal/src/Connection.php line 1105
                                  Doctrine\DBAL\Connection->convertExceptionDuringQuery(

                                  )
                               3. lib/private/DB/Connection.php line 261
                                  Doctrine\DBAL\Connection->executeQuery(

                                  )
                               4. 3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 341
                                  OC\DB\Connection->executeQuery(

                                  )
                               5. .../dbal/src/Query/QueryBuilder.php line 377
                                  Doctrine\DBAL\Query\QueryBuilder->executeQuery(

                                  )
                               6. lib/private/DB/QueryBuilder/QueryBuilder.php line 280
                                  Doctrine\DBAL\Query\QueryBuilder->execute(

                                  )
                               7. lib/private/DB/QueryBuilder/QueryBuilder.php line 293
                                  OC\DB\QueryBuilder\QueryBuilder->execute(

                                  )
                               8. apps/social/lib/Db/ActorsRequest.php line 106
                                  OC\DB\QueryBuilder\QueryBuilder->executeQuery(

                                  )
                               9. .../social/lib/Service/AccountService.php line 209
                                  OCA\Social\Db\ActorsRequest->getFromUsername(

                                  )
                              10. .../lib/Controller/NavigationController.php line 160
                                  OCA\Social\Service\AccountService->createActor("*** sensitive parameters replaced ***")
                              11. .../AppFramework/Http/Dispatcher.php line 230
                                  OCA\Social\Controller\NavigationController->navigate(

                                  )
                              12. .../AppFramework/Http/Dispatcher.php line 137
                                  OC\AppFramework\Http\Dispatcher->executeController(

                                  )
                              13. lib/private/AppFramework/App.php line 184
                                  OC\AppFramework\Http\Dispatcher->dispatch(

                                  )
                              14. lib/private/Route/Router.php line 315
                                  OC\AppFramework\App::main(

                                  )
                              15. lib/base.php line 1069
                                  OC\Route\Router->match(

                                  )
                              16. index.php line 39
                                  OC::handleRequest(

                                  )

                              Caused by Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table
                              'nextcloud.oc_social_actor' doesn't exist at 3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php line 28

                               0. .../doctrine/dbal/src/Driver/PDO/Statement.php line 132
                                  Doctrine\DBAL\Driver\PDO\Exception::new(

                                  )
                               1. 3rdparty/doctrine/dbal/src/Connection.php line 1098
                                  Doctrine\DBAL\Driver\PDO\Statement->execute(

                                  )
                               2. lib/private/DB/Connection.php line 261
                                  Doctrine\DBAL\Connection->executeQuery(

                                  )
                               3. 3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 341
                                  OC\DB\Connection->executeQuery(

                                  )
                               4. .../dbal/src/Query/QueryBuilder.php line 377
                                  Doctrine\DBAL\Query\QueryBuilder->executeQuery(

                                  )
                               5. lib/private/DB/QueryBuilder/QueryBuilder.php line 280
                                  Doctrine\DBAL\Query\QueryBuilder->execute(

                                  )
                               6. lib/private/DB/QueryBuilder/QueryBuilder.php line 293
                                  OC\DB\QueryBuilder\QueryBuilder->execute(

                                  )
                               7. apps/social/lib/Db/ActorsRequest.php line 106
                                  OC\DB\QueryBuilder\QueryBuilder->executeQuery(

                                  )
                               8. .../social/lib/Service/AccountService.php line 209
                                  OCA\Social\Db\ActorsRequest->getFromUsername(

                                  )
                               9. .../lib/Controller/NavigationController.php line 160
                                  OCA\Social\Service\AccountService->createActor("*** sensitive parameters replaced ***")
                              10. .../AppFramework/Http/Dispatcher.php line 230
                                  OCA\Social\Controller\NavigationController->navigate(

                                  )
                              11. .../AppFramework/Http/Dispatcher.php line 137
                                  OC\AppFramework\Http\Dispatcher->executeController(

                                  )
                              12. lib/private/AppFramework/App.php line 184
                                  OC\AppFramework\Http\Dispatcher->dispatch(

                                  )
                              13. lib/private/Route/Router.php line 315
                                  OC\AppFramework\App::main(

                                  )
                              14. lib/base.php line 1069
                                  OC\Route\Router->match(

                                  )
                              15. index.php line 39
                                  OC::handleRequest(

                                  )

                              Caused by PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_social_actor'

                              doesn't exist at 3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 130

                               0. 3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php line 130
                                  PDOStatement->execute(

                                  )
                               1. 3rdparty/doctrine/dbal/src/Connection.php line 1098
                                  Doctrine\DBAL\Driver\PDO\Statement->execute(

                                  )
                               2. lib/private/DB/Connection.php line 261
                                  Doctrine\DBAL\Connection->executeQuery(

                                  )
                               3. 3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 341
                                  OC\DB\Connection->executeQuery(

                                  )
                               4. .../dbal/src/Query/QueryBuilder.php line 377
                                  Doctrine\DBAL\Query\QueryBuilder->executeQuery(

                                  )
                               5. lib/private/DB/QueryBuilder/QueryBuilder.php line 280
                                  Doctrine\DBAL\Query\QueryBuilder->execute(

                                  )
                               6. lib/private/DB/QueryBuilder/QueryBuilder.php line 293
                                  OC\DB\QueryBuilder\QueryBuilder->execute(

                                  )
                               7. apps/social/lib/Db/ActorsRequest.php line 106
                                  OC\DB\QueryBuilder\QueryBuilder->executeQuery(

                                  )
                               8. .../social/lib/Service/AccountService.php line 209
                                  OCA\Social\Db\ActorsRequest->getFromUsername(

                                  )
                               9. .../lib/Controller/NavigationController.php line 160
                                  OCA\Social\Service\AccountService->createActor("*** sensitive parameters replaced ***")
                              10. .../AppFramework/Http/Dispatcher.php line 230
                                  OCA\Social\Controller\NavigationController->navigate(

                                  )
                              11. .../AppFramework/Http/Dispatcher.php line 137
                                  OC\AppFramework\Http\Dispatcher->executeController(

                                  )
                              12. lib/private/AppFramework/App.php line 184
                                  OC\AppFramework\Http\Dispatcher->dispatch(

                                  )
                              13. lib/private/Route/Router.php line 315
                                  OC\AppFramework\App::main(

                                  )
                              14. lib/base.php line 1069
                                  OC\Route\Router->match(

                                  )
                              15. index.php line 39
                                  OC::handleRequest(

                                  )

Browser log

GET
https://nextcloud.s.d/apps/social/
[HTTP/2 500  597ms]

Uncaught ReferenceError: OCA is not defined
    <anonymous> https://nextcloud.s.d/apps/extract/js/extraction.js?v=4dcda0ee-31:3
    EventListener.handleEvent* https://nextcloud.s.d/apps/extract/js/extraction.js?v=4dcda0ee-31:1
extraction.js:3:6
    <anonymous> https://nextcloud.s.d/apps/extract/js/extraction.js?v=4dcda0ee-31:3
    (Async: EventListener.handleEvent)
    <anonymous> https://nextcloud.s.pwdapps/extract/js/extraction.js?v=4dcda0ee-31:1
@john-clark john-clark added the bug Something isn't working label Jan 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@john-clark