Internal Server Error #1877
Description
Describe the bug
Internal Server Error
To Reproduce
Steps to reproduce the behavior:
- visit $host/apps/social/ or $host/index.php/.well-known/webfinger
- 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