sql全文檢索的使用說明

--移除全文檢索
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'drop';
GO

--建立全文檢索資訊
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'create', 'tmp', 'PK_100and10';

--Add some columns
EXEC sp_fulltext_column 'tmp','MsgText','add';
-- Activate the full-text index
EXEC sp_fulltext_table 'tmp','activate';
GO
--重建索引資料匣
USE ServerLog;
GO
EXEC sp_fulltext_catalog 'full28', 'rebuild';
GO

--索引狀態確認
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'Start_change_tracking';
EXEC sp_fulltext_table 'tmp', 'Start_background_updateindex';
GO

confluence proxy setting for server url

refer to the document of https://confluence.atlassian.com/doc/configuring-the-server-base-url-148592.html

gradebook setting of quiz

Step1:

Step2:

Step3:設定分數顯示方式

Step4:

Step5:

Step6:

Step7:

Step8: hidden assignment

centos with 80 port confluence setting

refer document : https://confluence.atlassian.com/doc/using-apache-with-mod_proxy-173669.html

apache conf setting

moodle - feedback預覽功能停用

Step1: vi /var/www/html/moodle/mod/feedback/view.php
Step2: 把preview拿掉

moodle-backup and restore

透過下列的工具來備份MOODLE 資料庫

把原本的mooddata資料匣複製到新的電腦，並執行下列指令

ubuntu confluence port change

refer to the document of https://confluence.atlassian.com/doc/using-apache-with-mod_proxy-173669.html
Attached is my example file setting of confluence and apache, please refer to it.
example file

server.xml