ocsms icon indicating copy to clipboard operation
ocsms copied to clipboard

Error at installing

Open theemutvcode opened this issue 4 years ago • 12 comments

I get this error when I try to install it An exception occurred while executing 'SELECT user_id, datakey, datavalueFROMoc_ocsms_user_datasWHEREdatakey LIKE ?' with params ["lastReadDate-%"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud_f1a7d9f0.oc_ocsms_user_datas' doesn't exist

theemutvcode avatar Jan 05 '21 10:01 theemutvcode

same for me.

bytersproblem avatar Jan 13 '21 00:01 bytersproblem

same for me.

ilikecola avatar Jan 17 '21 15:01 ilikecola

Same here

bradgranath2 avatar Jan 18 '21 07:01 bradgranath2

Got the same error today, Nextcloud 20.0.4, PhoneSync server app 2.2.0 =). Exact error for me:

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

Xia0ben avatar Jan 21 '21 16:01 Xia0ben

Still happening with NextCloud 20.0.5:

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````

politas avatar Jan 25 '21 00:01 politas

Same here Nextcloud 20.0.5.

An error occured during the request. Unable to proceed. 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`

scotteelp avatar Jan 26 '21 21:01 scotteelp

I've found the same issue with a workaround and some explanations #329

having the same issue

Amanuense-del-diavolo avatar Feb 02 '21 14:02 Amanuense-del-diavolo

This works, thanks!

bytersproblem avatar Feb 02 '21 15:02 bytersproblem

Can anyone expand on #329's workaround? I don't see how simply cloning this repository is going to install the app on my NextCloud system.

Surely, putting out a new release would be better?

politas avatar Feb 03 '21 20:02 politas

Same here Nextcloud 20.0.7. 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

MitusM avatar Feb 04 '21 06:02 MitusM

Try my new quick and dirty workaround on #329 this worked for me

drdetergent avatar Feb 10 '21 01:02 drdetergent

Found a similar problem with #335 - should I mark it as a duplicate of this one?

csolisr avatar Apr 23 '21 18:04 csolisr