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

Table 'oc_ocsms_smsdatas' reported in error log as "doesn't exist" #348

Open
brainchild0 opened this issue Nov 23, 2022 · 2 comments
Open

Comments

@brainchild0
Copy link

Description

Needed database table not generated when application is installed.

Steps to reproduce

Install application version 2.2.2 on server version 25.0.1.

Results

Opening application displays error page for "Internal Server Error".

Log reports error as follows:

[index] Error: Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'abcd_next665.oc_ocsms_smsdatas' doesn't exist at <<closure>>

 0. /var/www/vhosts/abcd/nextcloud.abcd/3rdparty/doctrine/dbal/src/Connection.php line 1780
    Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
 1. /var/www/vhosts/abcd/nextcloud.abcd/3rdparty/doctrine/dbal/src/Connection.php line 1719
    Doctrine\DBAL\Connection->handleDriverException()
 2. /var/www/vhosts/abcd/nextcloud.abcd/3rdparty/doctrine/dbal/src/Connection.php line 1067
    Doctrine\DBAL\Connection->convertExceptionDuringQuery()
 3. /var/www/vhosts/abcd/nextcloud.abcd/lib/private/DB/Connection.php line 261
    Doctrine\DBAL\Connection->executeQuery()
 4. /var/www/vhosts/abcd/nextcloud.abcd/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php line 345
    OC\DB\Connection->executeQuery()
 5. /var/www/vhosts/abcd/nextcloud.abcd/lib/private/DB/QueryBuilder/QueryBuilder.php line 281
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /var/www/vhosts/abcd/nextcloud.abcd/apps/ocsms/db/smsmapper.php line 94
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /var/www/vhosts/abcd/nextcloud.abcd/apps/ocsms/controller/smscontroller.php line 70
    OCA\OcSms\Db\SmsMapper->getAllPhoneNumbers()
 8. /var/www/vhosts/abcd/nextcloud.abcd/lib/private/AppFramework/Http/Dispatcher.php line 225
    OCA\OcSms\Controller\SmsController->index()
 9. /var/www/vhosts/abcd/nextcloud.abcd/lib/private/AppFramework/Http/Dispatcher.php line 133
    OC\AppFramework\Http\Dispatcher->executeController()
10. /var/www/vhosts/abcd/nextcloud.abcd/lib/private/AppFramework/App.php line 172
    OC\AppFramework\Http\Dispatcher->dispatch()
11. /var/www/vhosts/abcd/nextcloud.abcd/lib/private/Route/Router.php line 298
    OC\AppFramework\App::main()
12. /var/www/vhosts/abcd/nextcloud.abcd/lib/base.php line 1047
    OC\Route\Router->match()
13. /var/www/vhosts/abcd/nextcloud.abcd/index.php line 36
    OC::handleRequest()

GET /index.php/apps/ocsms/
from 11.22.33.44 by admin at 2022-11-23T02:24:17+00:00
```
@Albirew
Copy link

Albirew commented Dec 21, 2022

see #329 (comment) (and also #347 (comment) after)
in essence, ocsms is not maintained anymore (last release 2020.12)

@brainchild0
Copy link
Author

Perhaps it should be removed from the Store.

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

No branches or pull requests

2 participants