nextcloud / ocsms

📱 Nextcloud/ownCloud PhoneSync server application
https://play.google.com/store/apps/details?id=fr.unix_experience.owncloud_sms
GNU Affero General Public License v3.0
189 stars 52 forks source link

Internal Error #339

Open Skythrew opened 3 years ago

Skythrew commented 3 years ago

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

bonswouar commented 3 years ago

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)

e-alfred commented 3 years ago

@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