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

[brainchild0]

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]

see https://github.com/nextcloud/ocsms/issues/329#issuecomment-1098971807 (and also https://github.com/nextcloud/ocsms/issues/347#issuecomment-1327179177 after) in essence, ocsms is not maintained anymore (last release 2020.12)

[brainchild0]

Perhaps it should be removed from the Store.