PHPを7.4にアップグレードしたためにこれまでのNexrCloudのバージョン13.0.1.0では動作せずアップグレードとなりました。
でテーブルの問題でアップグレードすら途中で止まってしまいました。
ALTER Table oc_calendarobjects add column calendartype int(11) default 0 not null; commit;
ALTER Table oc_calendarchanges add column calendartype int(11) default 0 not null; commit;
この2箇所のテーブル補修でアップデートが進み完了しました。
NextCloudが動作し始めたので設定画面から残りの改善箇所の修正です。
There are some errors regarding your setup.
- Some files have not passed the integrity check. Further information on how to resolve this issue can be found in the documentation. (List of invalid files… / Rescan…)
- MySQL is used as database but does not support 4-byte characters. To be able to handle 4-byte characters (like emojis) without issues in filenames or comments for example it is recommended to enable the 4-byte support in MySQL. For further details read the documentation page about this.
- The “Strict-Transport-Security” HTTP header is not set to at least “15552000” seconds. For enhanced security, it is recommended to enable HSTS as described in the security tips ↗.
- No memory cache has been configured. To enhance performance, please configure a memcache, if available. Further information can be found in the documentation.
- The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running “occ db:add-missing-indices” those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.
-
- Missing index “cards_abid” in table “oc_cards”.
- Missing index “cards_prop_abid” in table “oc_cards_properties”.
- Missing index “calendarobject_calid_index” in table “oc_calendarobjects_props”.
- Missing index “schedulobj_principuri_index” in table “oc_schedulingobjects”.
- Missing index “properties_path_index” in table “oc_properties”.
- The database is missing some optional columns. Due to the fact that adding columns on big tables could take some time they were not added automatically when they can be optional. By running “occ db:add-missing-columns” those missing columns could be added manually while the instance keeps running. Once the columns are added some features might improve responsiveness or usability.
- Missing optional column “reference_id” in table “oc_comments”.
- This instance is missing some recommended PHP modules. For improved performance and better compatibility it is highly recommended to install them.
-
- imagick
- Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running ‘occ db:convert-filecache-bigint’ those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read the documentation page about this.
-
- activity.activity_id
- activity.object_id
- activity_mq.mail_id
Please double check the installation guides ↗, and check for any errors or warnings in the log.
Check the security of your Nextcloud over our security scan.
sudo -u apache php /home/vwww/4_cloud/occ db:add-missing-indices
#このコマンドを実行したら
#In SchemaException.php line 82:
# There is no column with name 'calendartype' on table 'oc_calendarobjects_props'.
#このエラーが返ってきたので次のSQLでコラムを追加しました。
ALTER Table oc_calendarobjects_props add column calendartype int(11) default 0 not null;
commit;
ALTER Table oc_comments add column reference_id int(11) default 0 not null;
commit;
#imagickが足らないと言われたので
yum install --enablerepo=remi,remi-php73 php-pear php-devel
pecl install imagick
#/etc/php.d/ 配下に 30-imagick.ini としてで ini ファイルを作って
#こちらを記述しておく
#extension=imagick
結局、imagickはいまだに起動せずphpモジュールとして読み込んでくれません。
しばらく復旧に時間がかかりそうです。
スポンサーリンク