am3n portfolio

Okay, it’s started when my department need a Project Planner / Management software to handle their running and upcoming projects. The choices are Ms. Project + Sharepoint Portal or Free/OpenSource (Web) Application. Then I choose Free/OpenSource (Web) Application of course . There are only 2 Free/OpenSource Web-based Application for Project: phprojekt and dotProject after much comparation, testing, playing around, etc, etc I choosed dotProject for simplicity, elegant, complete documentation and live forum.

But after succesfull installation of version 2.1.2, I got error when I click the “Projects” tab


ERROR: /var/www/dotProject/classes/query.class.php(623): query failed(CREATE TEMPORARY TABLE tasks_sum SELECT task_project, COUNT(DISTINCT task_id) AS total_tasks,
SUM(task_duration * task_duration_type * task_percent_complete) / SUM(task_duration * task_duration_type) AS project_percent_complete FROM ( `tasks` ) GROUP BY task_project) - error was: Table 'tasks_sum' already exists
Backtrace:
0 /var/www/dotProject/classes/query.class.php:623 dprint('/var/www/dotProject/classes/query.class.php',623,0,'query failed(CREATE TEMPORARY TABLE tasks_sum SELECT task_project, COUNT(DISTINCT task_id) AS total_tasks,
SUM(task_duration * task_duration_type * task_percent_complete) / SUM(task_duration * task_duration_type) AS project_percent_complete FROM ( `tasks` ) GROUP BY task_project) - error was: Table \'tasks_sum\' already exists')
1 /var/www/dotProject/modules/projects/calendar_tab.projects.php:23 exec()
2 /var/www/dotProject/style/default/overrides.php:92 require('/var/www/dotProject/modules/projects/calendar_tab.projects.php')
3 /var/www/dotProject/modules/calendar/day_view.php:113 show()
4 /var/www/dotProject/index.php:299 require('/var/www/dotProject/modules/calendar/day_view.php')
<\pre>

ERROR: /var/www/dotProject/classes/query.class.php(623): query failed(CREATE TEMPORARY TABLE tasks_summy SELECT task_project, COUNT(DISTINCT task_id) AS my_tasks FROM ( `tasks` ) WHERE task_owner = 1 GROUP BY task_project) – error was: Table ‘tasks_summy’ already exists
Backtrace:
0 /var/www/dotProject/classes/query.class.php:623 dprint(‘/var/www/dotProject/classes/query.class.php’,623,0,’query failed(CREATE TEMPORARY TABLE tasks_summy SELECT task_project, COUNT(DISTINCT task_id) AS my_tasks FROM ( `tasks` ) WHERE task_owner = 1 GROUP BY task_project) – error was: Table \’tasks_summy\’ already exists’)
1 /var/www/dotProject/modules/projects/calendar_tab.projects.php:34 exec()
2 /var/www/dotProject/style/default/overrides.php:92 require(‘/var/www/dotProject/modules/projects/calendar_tab.projects.php’)
3 /var/www/dotProject/modules/calendar/day_view.php:113 show()
4 /var/www/dotProject/index.php:299 require(‘/var/www/dotProject/modules/calendar/day_view.php’)
<\pre>

ERROR: /var/www/dotProject/classes/query.class.php(623): query failed(SELECT project_id, project_name, project_status, project_color_identifier,
project_start_date, project_end_date, project_priority,
ts.total_tasks, tsm.my_tasks, ts.project_percent_complete,
contact_first_name, contact_last_name, user_username FROM ( `projects` as pr ) LEFT JOIN `users` AS u ON u.user_id = pr.project_owner LEFT JOIN `contacts` AS con ON u.user_contact = con.contact_id LEFT JOIN `tasks_sum` AS ts ON pr.project_id = ts.task_project LEFT JOIN `tasks_summy` AS tsm ON pr.project_id = tsm.task_project WHERE pr.project_status <> 7 AND pr.project_status <> 5 ORDER BY project_end_date) – error was: Unknown column ‘ts.total_tasks’ in ‘field list’
Backtrace:
0 /var/www/dotProject/classes/query.class.php:623 dprint(‘/var/www/dotProject/classes/query.class.php’,623,0,’query failed(SELECT project_id, project_name, project_status, project_color_identifier,
project_start_date, project_end_date, project_priority,
ts.total_tasks, tsm.my_tasks, ts.project_percent_complete,
contact_first_name, contact_last_name, user_username FROM ( `projects` as pr ) LEFT JOIN `users` AS u ON u.user_id = pr.project_owner LEFT JOIN `contacts` AS con ON u.user_contact = con.contact_id LEFT JOIN `tasks_sum` AS ts ON pr.project_id = ts.task_project LEFT JOIN `tasks_summy` AS tsm ON pr.project_id = tsm.task_project WHERE pr.project_status <> 7 AND pr.project_status <> 5 ORDER BY project_end_date) – error was: Unknown column \’ts.total_tasks\’ in \’field list\”)
1 /var/www/dotProject/classes/query.class.php:645 exec(2)
2 /var/www/dotProject/modules/projects/calendar_tab.projects.php:54 loadList()
3 /var/www/dotProject/style/default/overrides.php:92 require(‘/var/www/dotProject/modules/projects/calendar_tab.projects.php’)
4 /var/www/dotProject/modules/calendar/day_view.php:113 show()
5 /var/www/dotProject/index.php:299 require(‘/var/www/dotProject/modules/calendar/day_view.php’)
<\pre>

Warning: Invalid argument supplied for foreach() in /var/www/dotProject/modules/projects/calendar_tab.projects.php on line 81
Unknown column ‘ts.total_tasks’ in ‘field list’

Googling… found some infos:

• mysql user for dotProject already need permission for creating temporary tables => done
• try to download latest nightly builds just to make sure this bug already eliminated => download failed
• PHP database connection doesn’t need persistent connection => change my includes/config.php into

  $dPconfig['dbpersist'] = false;

  and try again => Okay!!

And if I choose to use Ms. Project here what needed

1. Brand New Server (as I dont have spare Windows server) = $4000
2. Ms. Windows SBS 2003 = $600
3. Ms. Office 2007 = $400 for each user. Times 10 = $4000

Total $8600!!! what a savings

Ref: Create temp tables in version 2.1.2

This entry was posted on Wednesday, February 11th, 2009 at 15:41 and is filed under Web and System Administrator. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.