#若安裝出問題,請移除app後,再刪除以下資料庫資料,之後就可以正常安裝了 drop table oc_fulltextsearch_indexes; drop table oc_fulltextsearch_ticks; delete from oc_appconfig where appid='fulltextsearch'; delete from oc_appconfig where appid='fulltextsearch_elasticsearch'; delete from oc_appconfig where appid='files_fulltextsearch'; delete from oc_appconfig where appid='files_fulltextsearch_tesseract'; DELETE FROM oc_migrations WHERE app='fulltextsearch'; DELETE FROM oc_preferences WHERE appid='fulltextsearch';
# 例如某個連結失效了 https://cloud.test.com/s/T8wnofnnZjHk93e # 我們可以透過以下語法,找到哪個帳號停用了 select * from ( select uid_owner uid,ldap_dn name,token from oc_share,oc_ldap_user_mapping where uid_owner=owncloud_name union select uid_owner uid,displayname name,token from oc_share,oc_users where uid_owner=uid ) as NewUnionTable where token='T8wnofnnZjHk93e'