User blog: admin 系統管理
我在 10月1 日 把這個 bug 反應到 Moodle Tracker
http://tracker.moodle.org/browse/MDL-6757
10月8日 Moodle.org 回信如下, 且在 Moodle 1.6.3 fixed
==============================================
[ http://tracker.moodle.org/browse/MDL-6757?page=all ]
Petr Škoda resolved MDL-6757.
-----------------------------
Fix Version/s: 1.6.3
1.7
Resolution: Fixed
fixed in 1.6.2+ and 17dev.
We are not using mb functions directly, because it would break lots of sites that do not have it installed
Thanks for the report and proposed patch!
> Insert a Chinese charachter string to label resource result error.
> ------------------------------------------------------------------
>
> Key: MDL-6757
> URL: http://tracker.moodle.org/browse/MDL-6757
> Project: Moodle
> Issue Type: Bug
> Components: Resource
> Affects Versions: 1.6.2
> Environment: Windows 2003 Server CHT version, php 5.X, MySQL 5.X
> Reporter: Chien Wen-Chang
> Assigned To: Petr Škoda
> Priority: Critical
> Fix For: 1.6.3, 1.7
>
>
> Insert a Chinese charachter string to label resource result error.
> For example. Insert a label, Content as [標籤範例]: 同學請注意! 本週停課一天, 補課時間另外公告本課程網頁.
> Error report as follow:
> ---------------------------------------------------------------
> Data too long for column \'name\' at row 1
> INSERT INTO mdl_label ( COURSE, NAME, CONTENT, TIMEMODIFIED ) VALUES ( 1, \'[標籤範例]: 同學請注意! 本週停課一央..\', \'[標籤範例]: 同學請注意! 本週停課一天, 補課時間另外公告本課程網頁. \', 1159673300 )
> Could not add a new instance of label
> ----------------------------------------------------------------------------------------------------------------
> This bug is in /moodle/mod/label/lib.php line 16:
> $label->name = substr($label->name, 0, LABEL_MAX_NAME_LENGTH).\"...\";
> Suggest correct source as follow:
> mb_internal_encoding(\"UTF-8\");
> $label->name = mb_substr($label->name, 0, LABEL_MAX_NAME_LENGTH).\"...\";
>
==============================================
Moodle 1.6.3
10th October, 2006
Full details of these issues can be found in the tracker
Security Bugfix
- A vulnerability was discovered that could allow SQL injections if a parameter was improperly used. Full details of this particular issue are on the Moodle Security site. All registered Moodle admins were notified by direct email on Saturday September 30th.
General Bugs Fixed
- [ MDL-3048 ] - Release note should note not to use some PHP versions
- [ MDL-3805 ] - mod.html in NEWMODULE.zip is not XHTML1.0 Transitional compliant
- [ MDL-5378 ] - shorten_text doesn\'t work for oriental languages
- [ MDL-5601 ] - cloze question restore error problem
- [ MDL-5884 ] - Turn Student View On
- [ MDL-5893 ] - Blackboard export/backup course does not restore to Moodle correctly
- [ MDL-6084 ] - Restore to new course failure notice if logged in as course creator
- [ MDL-6128 ] - 1.6, special chars and messaging system.
- [ MDL-6193 ] - problem with login/index.php file
- [ MDL-6205 ] - slashes not stripped when re-editing profile
- [ MDL-6224 ] - Syntax error creating tables on install
- [ MDL-6247 ] - Error checking for missing themes
- [ MDL-6271 ] - breadcrumb problem
- [ MDL-6272 ] - DB Enrolment not recording enrolment end date
- [ MDL-6334 ] - Unnecessary group menu in Feedback popup window
- [ MDL-6336 ] - After utf8-migration unserializing of old essay fails
- [ MDL-6341 ] - \"Student view\" locks out designers/administrators from courses not available to students
- [ MDL-6342 ] - cannot move forum post to other forum when the subject includes an apostrophe
- [ MDL-6363 ] - typo in mod/forum/restorelib.php prevents grouped discussions from being accessible to group after a restore.
- [ MDL-6375 ] - Uploaded assignments are not available from the student submission page once graded
- [ MDL-6480 ] - Import of multichoice questions in Moodle XML format doesn\'t use shuffle option. Fix included
- [ MDL-6517 ] - Adding or editing post produces \"ERROR: invalid input syntax for integer: \"Object id #XXX\"
- [ MDL-6518 ] - How to make new themes link no longer required
- [ MDL-6521 ] - Single discussion forums can be splitted and it hasn\'t too much sense....
- [ MDL-6537 ] - past students receive email from forum
- [ MDL-6538 ] - Bug in hotpot upgrade script 1.6.1 -> 1.6.2 with MetaColumns() method
- [ MDL-6615 ] - Highlighting search terms in forum search text posts fails
- [ MDL-6632 ] - scorm_grade_user function in locallib.php file has errors
- [ MDL-6649 ] - HTML Editor in Quiz Essay Question unreliable
- [ MDL-6686 ] - Streamed Chat Locks Send Message Field
- [ MDL-6750 ] - change_password.php produces JS error.
- [ MDL-6754 ] - moodle.php in de_utf8 langpack has wrong locale
- [ MDL-6757 ] - Insert a Chinese charachter string to label resource result error.
- [ MDL-6770 ] - Student cannot see handed-in assignment
- [ MDL-6791 ] - Streamed Chat JS bug Prevents Use
- [ MDL-6824 ] - redundant style declaration in theme
- [ MDL-6837 ] - Make a language file entry for the wording of popup blocker checker
- [ MDL-6841 ] - Student View button fails when course is hidden to students
- [ MDL-6842 ] - Resource frameset error in IE6
- [ MDL-6866 ] - A required parameter (backup_unique_code) was missing\" error
- [ MDL-6876 ] - Grades computed incorrectly if assignment name appears more than twice in a course
Improvement
- [ MDL-6280 ] - Backup files should not be included in new backups
- [ MDL-6572 ] - Allow students to access their uploaded documents after grading.
- [ MDL-6662 ] - why footer with margin-top: 100px
- [ MDL-6878 ] - Scalable Vector Graphics (SVG) files in Moodle are not correctly displayed in many Browsers
New Feature
- [ MDL-5653 ] - add blacklisted level into environment XML
因為在製作 NCNU Moodle 線上教學教材, 發現使用 [標籤] 時, 經常會
發生錯誤, 寫入資料庫失敗.
花了二個小時, 終於找到 Moodle 原始程式的錯誤, 程式碼已更正 OK,
有空再 Post http://moodle.org
非常感謝王院長的鼓勵 !
系統開發工作是寂寞, 使用者往往不知道開發者在幕後的辛苦,
但使用者如果能給開發者適時的鼓勵, 開發者就會感覺繼續為使
用者做這些工作是值得的. 因此有很多 Freeware 的設計者,
會跟 user 說: 如果您覺得我設計的程式好用, 就寫一張明信片
給我吧 ! 這就是 Cardware.
系統開發的工作是很辛苦的, 有時連睡覺的時侯, 還在想如何
解決程式的問題, 更神奇連作夢也夢到, 真是日有所思, 夜有
所夢, 有時有些問題還是作夢時想到解決方法.
最近還在忙 Moodle 在 Windows 2003 Server 上傳檔不支
援中文檔名的問題, 暑假改了一半, 因為要改的 Moodle 原始程
式大約有 7 支, 而且太複雜了. 本來準備放棄, 接受 [不支援
中文檔名] 這個事實, 但想到 user 因為這個因素, 就不用這個
系統. 因此狠下心來一鼓作氣, 利用前兩天例假日, 把程式看
了一下(因為過了兩個多星期, 一些細節都忘光了), 一面改一
面測試, 總算有點成果, 但仍有些中文字因 Big5 與 Utf-8 轉換
時會有問題, 仍在克服中.
NCNU 課程資訊網功能簡介
95 學年第一學期開始 , 本校的教師及同學 , 不用作任何設定 , 只要登入
正式系統網址 : http://moodle.ncnu.edu.tw
供教職員工測試之用系統網址 : http://moodletest.ncnu.edu.tw
就能享用最便利的網路輔教學系統 , 本系統在教學方面提供 :
- 與本校校務行政電腦化系統密切整合,教師開課及學生選課資料於每日 23 時自動與教務系統資料庫同步更新。教職員工登入帳號密碼 : 身分證號及校務行政系統密碼;學生登入帳號密碼 : 學號及校務行政系統密碼
- 預設是以週 曆 方式呈現課程架構 , 教師可以自行修改為章節主題或其他格式
- 每一門課程都有專屬的課程討論區 , 供教師與同學們討論課程議題之用
- 每一門課程都有專屬的行事曆 , 供教師公佈課程活動時程之用
- 本系統提供多國語言介面,且支援萬國字元 (Unicode) ,可支援各種語言文字線上教學用途
- 教師可以很容易製作網路教材 , 方式有線上製作 , 或上傳現有的 Word, Power Point, PDF 等電子檔講義
- 教師可以事先將網路教材製作好,但暫不開放 , 等授課時程屆時再開放
- 提供簡訊及線上聊天功能 , 供教師與同學連絡之用
- 提供學員分組功能
- 提供網路繳交作業及批改作業功能 , 教師可以即時掌握同學繳交作業情形 , 同學也可以即時看到批改結果
- 提供題庫功能
- 提供網路測驗及批改考卷功能 , 同學也可以即時看到考試批考結果
- 教師可以檢視每一位學生參與這門課程的活動記錄
- 提供網路問卷調查功能,供教師教學意見調查之用
- 提供互動式課程教材製作功能
- 提供符合 SCORM ( Sharable Content Object Reference Model )(例如: MIT OpenCourseWare)標準教材匯入功能
- 教師可以指定研究生或助理擔任教學助理 , 協助回答討論區議題、製作網路教材、批改作業考試等工作
- 教師可以自行決定是否開放訪客進入該課程區,,目前系統預設是開放的
- 教師可以備份全部課程內容 , 來年開設同樣課程 , 可自行還原課程內容 , 不用重新製作
經過了一個暑假, 利用了個人許多晚上、暑休及例假日, 犧牲了應該與小孩老婆相處時間, 不眠不休日夜加班, 終於完成了暨大課程資訊網 (名稱暫定, 可能未來會改名稱) !
這個系統整合本校校務行政 e 化系統及一個 Course Management System - Moodle ( Open Source Freeware ), 提供一個全新的教與學(Teaching and Learning)的系統平台. 希望可以提昇本校老師教學及同學學習品質.