Unable to install: "Table 'nextcloud.oc_ocsms_user_datas' doesn't exist"

[csolisr]

Steps to reproduce

1. Install Nextcloud on a Raspberry Pi with a 64-bit OS
2. Install OCSMS (via the GUI or CLI)

Expected behaviour

The application should be installed and run successfully.

Actual behaviour

The installation fails, and the following error is output:

Error: An exception occurred while executing 'SELECT `user_id`, `datakey`, `datavalue` FROM `oc_ocsms_user_datas` WHERE `datakey` LIKE ?' with params ["lastReadDate-%"]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_ocsms_user_datas' doesn't exist

Server configuration

Nextcloud/ownCloud version: 20.0.7

PHP version: 7.3

HTTPd server: NGINX 1.14.2

Database engine & version: MariaDB 10.3

Client configuration

Android version: 10

Phone: Pocophone M3, stock ROM

Nextcloud SMS app version: 2.0.5

Logs

$ sudo  -u nextcloud php occ app:install ocsms -vvv
Error: An exception occurred while executing 'SELECT `user_id`, `datakey`, `datavalue` FROM `oc_ocsms_user_datas` WHERE `datakey` LIKE ?' with params ["lastReadDate-%"]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_ocsms_user_datas' doesn't exist

[fondemen]

Check #329 (comment)

[csolisr]

Thanks for the heads-up, that workaround made the app installable again. Although it should probably be integrated in a future update just in case.