ocsms icon indicating copy to clipboard operation
ocsms copied to clipboard

Internal Error

Open Skythrew opened this issue 4 years ago • 2 comments

Steps to reproduce

1.Install ocsms

Expected behaviour

Access to ocsms

Actual behaviour

It shows server internal error

Server configuration

Nextcloud/ownCloud version: 22.0.0 PHP version: PHP-7.4 HTTPd server: Apache 2 Database engine & version:

Client configuration

Android version: Android 9 (Pie) Phone: Samsung J3 2017 Nextcloud SMS app version: Version 2.0.3

Logs

[index] Error: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_ocsms_smsdatas' doesn't exist

GET /nextcloud/index.php/apps/ocsms/
from .............. by admin at 2021-07-26T07:08:21+00:00

An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_ocsms_user_datas' doesn't exist

I think I could create the tables but I don't know what are the values in this tables.

Please help me.

Thanks

Skythrew avatar Jul 26 '21 07:07 Skythrew

Latest official build is old and apparently deprecated (why not updating it ? @nerzhul ). This should work using the sources, migration has been added since (it worked for me)

bonswouar avatar Aug 09 '21 13:08 bonswouar

@bonswouar The problem is that the table and index names had to be shortened, so we need a way to migrate the data from the old tables: https://github.com/nextcloud/ocsms/issues/334#issuecomment-898909319

e-alfred avatar Aug 14 '21 15:08 e-alfred