Mark's Development Blog

迴響 ↓

• 回覆: dotProject 2.0.1 簡繁 UTF-8 中文版釋出
  littlecong  發表於 10/03/2006, 23:57

  在mysql4.1.4上，简体中文不能正常显示？

• dotProject在某些邏輯部份好像有問題!!
  minax  發表於 13/03/2006, 07:40

  請教一下大大!!
  dotProject是不是只能供個人使用!?
  因為在許多邏輯部份好像怪
  例如 :討論區部份如果把修改的權限拿掉
  新增的功能也會被同時拿掉

  行事曆跟日曆部份
  可以看到其他人的行事曆 ,連一般訪客也可以看到
  即使設定禁止

  沒辦法設定一般用戶初使介面(例如我希望一些用戶登入後是在討論區的位置而不是日曆)

  還是因為此套件還在開發中~所以並不是很完整
  以上問題^^謝謝囉!!

• 專案Gantt圖裡的「里程碑」項目中的中文是亂碼
  Alex  發表於 31/03/2006, 06:51

  您好，感謝您貢獻中文版的dotProject v2.0.1
  小弟我用得真很爽。但是有發現一個小問題，還請大大幫忙一下。
  就是在顯示專案干特圖的時候，如果項目被勾成「里程碑」的時候，如果項目名稱有中文的話，中文會變成亂碼。小弟我不知道要改哪裡。能否請大大指點。謝謝。

• 求教？ 如何新加任务栏
  jhucn  發表於 26/04/2006, 22:12

  我的dotproject V2.0.1 安装无报错，但运行时，任务项及论坛项都报错：分别如下，请问如何解决？
  ERROR: D:Myphpxampphtdocsdotproincludesdb_adodb.php(61): Error executing:

  SELECT
  distinct tasks.task_id, task_parent, task_name, task_start_date, task_end_date, task_dynamic, task_pinned, pin.user_id as pin_user,
  task_priority, task_percent_complete, task_duration, task_duration_type, task_project,
  task_description, task_owner, task_status, usernames.user_username, usernames.user_id, task_milestone,
  assignees.user_username as assignee_username, count(distinct assignees.user_id) as assignee_count, co.contact_first_name, co.contact_last_name,
  count(distinct files.file_task) as file_count, tlog.task_log_problem, MAX(history_date) as last_update FROM tasks, user_tasks LEFT JOIN history ON history_item = tasks.task_id AND history_table='tasks' LEFT JOIN projects ON project_id = task_project LEFT JOIN users as usernames ON task_owner = usernames.user_id LEFT JOIN user_tasks as ut ON ut.task_id = tasks.task_id LEFT JOIN users as assignees ON assignees.user_id = ut.user_id LEFT JOIN contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN task_log AS tlog ON tlog.task_log_task = tasks.task_id AND tlog.task_log_problem > '0' LEFT JOIN files on tasks.task_id = files.file_task LEFT JOIN user_task_pin as pin ON tasks.task_id = pin.task_id AND pin.user_id = 2 WHERE project_active 0 AND user_tasks.user_id = 2
  AND task_project = projects.project_id
  AND user_tasks.task_id = tasks.task_id
  AND task_percent_complete = '100'
  AND task_end_date >= '2006-04-19 00:00:00'
  AND task_status = '0'
  GROUP BY task_id
  ORDER BY project_id, task_start_date

  Backtrace:
  0 D:Myphpxampphtdocsdotproincludesdb_adodb.php:61 dprint('D:Myphpxampphtdocsdotproincludesdb_adodb.php',61,0,'Error executing:

  SELECT
  distinct tasks.task_id, task_parent, task_name, task_start_date, task_end_date, task_dynamic, task_pinned, pin.user_id as pin_user,
  task_priority, task_percent_complete, task_duration, task_duration_type, task_project,
  task_description, task_owner, task_status, usernames.user_username, usernames.user_id, task_milestone,
  assignees.user_username as assignee_username, count(distinct assignees.user_id) as assignee_count, co.contact_first_name, co.contact_last_name,
  count(distinct files.file_task) as file_count, tlog.task_log_problem, MAX(history_date) as last_update FROM tasks, user_tasks LEFT JOIN history ON history_item = tasks.task_id AND history_table='tasks' LEFT JOIN projects ON project_id = task_project LEFT JOIN users as usernames ON task_owner = usernames.user_id LEFT JOIN user_tasks as ut ON ut.task_id = tasks.task_id LEFT JOIN users as assignees ON assignees.user_id = ut.user_id LEFT JOIN contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN task_log AS tlog ON tlog.task_log_task = tasks.task_id AND tlog.task_log_problem > '0' LEFT JOIN files on tasks.task_id = files.file_task LEFT JOIN user_task_pin as pin ON tasks.task_id = pin.task_id AND pin.user_id = 2 WHERE project_active 0 AND user_tasks.user_id = 2
  AND task_project = projects.project_id
  AND user_tasks.task_id = tasks.task_id
  AND task_percent_complete = '100'
  AND task_end_date >= '2006-04-19 00:00:00'
  AND task_status = '0'
  GROUP BY task_id
  ORDER BY project_id, task_start_date

  ')
  1 D:Myphpxampphtdocsdotpromodulestaskstasks.php:289 db_exec('SELECT
  distinct tasks.task_id, task_parent, task_name, task_start_date, task_end_date, task_dynamic, task_pinned, pin.user_id as pin_user,
  task_priority, task_percent_complete, task_duration, task_duration_type, task_project,
  task_description, task_owner, task_status, usernames.user_username, usernames.user_id, task_milestone,
  assignees.user_username as assignee_username, count(distinct assignees.user_id) as assignee_count, co.contact_first_name, co.contact_last_name,
  count(distinct files.file_task) as file_count, tlog.task_log_problem, MAX(history_date) as last_update FROM tasks, user_tasks LEFT JOIN history ON history_item = tasks.task_id AND history_table='tasks' LEFT JOIN projects ON project_id = task_project LEFT JOIN users as usernames ON task_owner = usernames.user_id LEFT JOIN user_tasks as ut ON ut.task_id = tasks.task_id LEFT JOIN users as assignees ON assignees.user_id = ut.user_id LEFT JOIN contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN task_log AS tlog ON tlog.task_log_task = tasks.task_id AND tlog.task_log_problem > '0' LEFT JOIN files on tasks.task_id = files.file_task LEFT JOIN user_task_pin as pin ON tasks.task_id = pin.task_id AND pin.user_id = 2 WHERE project_active 0 AND user_tasks.user_id = 2
  AND task_project = projects.project_id
  AND user_tasks.task_id = tasks.task_id
  AND task_percent_complete = '100'
  AND task_end_date >= '2006-04-19 00:00:00'
  AND task_status = '0'
  GROUP BY task_id
  ORDER BY project_id, task_start_date')
  2 D:Myphpxampphtdocsdotpromodulestasksindex.php:115 include('D:Myphpxampphtdocsdotpromodulestaskstasks.php')
  3 D:Myphpxampphtdocsdotproindex.php:311 require('D:Myphpxampphtdocsdotpromodulestasksindex.php')
  Unknown column 'tasks.task_id' in 'on clause'
  论坛栏的报错：
  ERROR: D:Myphpxampphtdocsdotproclassesquery.class.php(590): query failed(SELECT forum_id, forum_project, forum_description, forum_owner, forum_name,forum_moderated, forum_create_date, forum_last_date,sum(if(c.message_parent=-1,1,0)) as forum_topics, sum(if(c.message_parent>0,1,0)) as forum_replies,user_username, project_name, project_color_identifier,SUBSTRING(l.message_body,1,30) message_body,LENGTH(l.message_body) message_length, watch_user, l.message_parent, l.message_id,count(distinct v.visit_message) as visit_count, count(distinct c.message_id) as message_count FROM `forums`,`projects` as p,`users` as u LEFT JOIN `forum_messages` AS l ON l.message_id = forum_last_id LEFT JOIN `forum_messages` AS c ON c.message_forum = forum_id LEFT JOIN `forum_watch` AS w ON watch_user = 2 AND watch_forum = forum_id LEFT JOIN `forum_visits` AS v ON visit_user = 2 AND visit_forum = forum_id and visit_message = c.message_id LEFT JOIN `companies` AS co ON co.company_id = project_company WHERE user_id = forum_owner AND project_id = forum_project AND project_active=1 GROUP BY forum_id ORDER BY forum_name asc) - error was: Unknown column 'forum_last_id' in 'on clause'
  Backtrace:
  0 D:Myphpxampphtdocsdotproclassesquery.class.php:590 dprint('D:Myphpxampphtdocsdotproclassesquery.class.php',590,0,'query failed(SELECT forum_id, forum_project, forum_description, forum_owner, forum_name,forum_moderated, forum_create_date, forum_last_date,sum(if(c.message_parent=-1,1,0)) as forum_topics, sum(if(c.message_parent>0,1,0)) as forum_replies,user_username, project_name, project_color_identifier,SUBSTRING(l.message_body,1,30) message_body,LENGTH(l.message_body) message_length, watch_user, l.message_parent, l.message_id,count(distinct v.visit_message) as visit_count, count(distinct c.message_id) as message_count FROM `forums`,`projects` as p,`users` as u LEFT JOIN `forum_messages` AS l ON l.message_id = forum_last_id LEFT JOIN `forum_messages` AS c ON c.message_forum = forum_id LEFT JOIN `forum_watch` AS w ON watch_user = 2 AND watch_forum = forum_id LEFT JOIN `forum_visits` AS v ON visit_user = 2 AND visit_forum = forum_id and visit_message = c.message_id LEFT JOIN `companies` AS co ON co.company_id = project_company WHERE user_id = forum_owner AND project_id = forum_project AND project_active=1 GROUP BY forum_id ORDER BY forum_name asc) - error was: Unknown column 'forum_last_id' in 'on clause'')
  1 D:Myphpxampphtdocsdotproclassesquery.class.php:615 exec(2)
  2 D:Myphpxampphtdocsdotpromodulesforumsindex.php:74 loadList()
  3 D:Myphpxampphtdocsdotproindex.php:311 require('D:Myphpxampphtdocsdotpromodulesforumsindex.php')

• 回覆: dotProject 2.0.1 簡繁 UTF-8 中文版釋出
  ATang  發表於 01/07/2006, 00:02

  In modules/tasks/tasks.php replace lines in the switch statement (lines 171-236) where it is

  $from .= ", user_tasks";

  to

  $from = "user_tasks,tasks"; //$from .= ", user_tasks";

• 執行任務時出現的錯誤訊息
  DC  發表於 15/07/2006, 06:03

  ERROR: E:xampphtdocsdotprojectincludesdb_adodb.php(61): Error executing: SELECT
  distinct tasks.task_id, task_parent, task_name, task_start_date, task_end_date, task_dynamic, task_pinned, pin.user_id as pin_user,
  task_priority, task_percent_complete, task_duration, task_duration_type, task_project,
  task_description, task_owner, task_status, usernames.user_username, usernames.user_id, task_milestone,
  assignees.user_username as assignee_username, count(distinct assignees.user_id) as assignee_count, co.contact_first_name, co.contact_last_name,
  count(distinct files.file_task) as file_count, tlog.task_log_problem FROM tasks, user_tasks LEFT JOIN projects ON project_id = task_project LEFT JOIN users as usernames ON task_owner = usernames.user_id LEFT JOIN user_tasks as ut ON ut.task_id = tasks.task_id LEFT JOIN users as assignees ON assignees.user_id = ut.user_id LEFT JOIN contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN task_log AS tlog ON tlog.task_log_task = tasks.task_id AND tlog.task_log_problem > '0' LEFT JOIN files on tasks.task_id = files.file_task LEFT JOIN user_task_pin as pin ON tasks.task_id = pin.task_id AND pin.user_id = 1 WHERE project_active 0
  AND task_project = projects.project_id
  AND user_tasks.user_id = 1
  AND user_tasks.task_id = tasks.task_id
  AND (task_percent_complete '0' LEFT JOIN files on tasks.task_id = files.file_task LEFT JOIN user_task_pin as pin ON tasks.task_id = pin.task_id AND pin.user_id = 1 WHERE project_active 0
  AND task_project = projects.project_id
  AND user_tasks.user_id = 1
  AND user_tasks.task_id = tasks.task_id
  AND (task_percent_complete '0' LEFT JOIN files on tasks.task_id = files.file_task LEFT JOIN user_task_pin as pin ON tasks.task_id = pin.task_id AND pin.user_id = 1 WHERE project_active 0
  AND task_project = projects.project_id
  AND user_tasks.user_id = 1
  AND user_tasks.task_id = tasks.task_id
  AND (task_percent_complete

• dotproject无法安装
  rew  發表於 28/01/2007, 02:35

  Warning: mysql_connect(): Access denied for user 'dp_user'@'localhost' (using password: YES) in c:appservwwwdotprojectlibadodbdriversadodb-mysql.inc.php on line 327

  install过程中出现此消息，我重复试过几次也是这样，不知道什么原因，请各位大哥帮帮忙，小弟先谢过了。
  上面11楼的"airmarmot"大哥也出现过这个问题,请问"airmarmot"大哥是怎么解决此问题的呀？
  QQ:312331392

• 回覆: dotProject 2.0.1 簡繁 UTF-8 中文版釋出
  dd  發表於 10/02/2007, 19:45

  passwd

• 如何刪除上傳檔案
  matt  發表於 03/08/2007, 01:54

  mark大哥,您好
  1.今天在測試利用DOTPROJECT上傳JPG檔或XLS檔後,發現無法選擇刪除已上傳之檔 案(沒有這個選項),但如果是DOC檔就有刪除檔案的選項可選,這是哪邊出了問題??
  2.在上傳檔案時是不是一定要用英文做為檔名,使用中文的檔名上傳後就無法開啟??

  感謝

• dotproject安装
  michelle  發表於 23/08/2007, 00:04

  我的问题跟rew的一样,也是在安装的过程中出现了Warning: mysql_connect(): Access denied for user 'dp_user'@'localhost' (using password: YES) in c:\program files\easyphp1-8\www\dotproject\lib\adodb\drivers\adodb-mysql.inc.php on line 327
  试了好多次,还是这样,之前我已经在另一台机子上成功安装过一回了,但是没有出现这种情况,所以不知道是什么原因,请各位大哥帮帮小妹吧,非常紧急,小妹在这先谢过啦!

• dotproject安装
  michelle  發表於 23/08/2007, 00:18

  我的QQ是:408737912

• 請問任務的顯示順序
  potter  發表於 23/01/2008, 00:32

  專案中的任務在顯示時，似乎不是依照我建立的順序而排
  而是依該任務的天數而排
  如果我要改成依我建立的順序而排列的話
  應該要如何改呢？？

  謝謝

• 中文檔名問題修正
  beter  發表於 07/05/2008, 00:36

  我用的是 dotproject 2.1.1英文版/under windows xp pro 也是遇到一樣的問題
  後來把 fileviewer.php 這個檔案的第168行程式的地方做以下的修改，下載中文檔名就正常了。

  //header( 'Content-disposition: attachment; filename="'.$file['file_name'].'"' );
  //jhaowei modified for chinese filename 2008-5-6
  header( 'Content-disposition: attachment; filename="'.iconv('UTF-8','BIG5',$file['file_name']).'"' );

  by the way 我是beter, email怕招來一堆spam mail就不便留下了

• 请教关于父任务与子任务进度的问题
  e我行  發表於 14/10/2008, 04:31

  在使用dotProject的时候，在“新建日志”中更新了子任务的进度%后，但父任务的进度为什么不会跟着改变呢？父任务和子任务的关系是什么呢？