2nd February 2007
In my previous post on project management tools I stated that will try dotProject out. So I did, and here are my first impressions (mostly – what I dislike; the likes will come after some period of usage).
Read the rest of this entry »
Posted in Misc, Software, Web | 7 Comments »
22nd January 2007
Update: the same solution seems to still apply to dotProject 2.1.2; the post instructions have been modified for dP 2.1.2.
Update 2: fsmullin suggested a method to fix a similar error in index_table.php, the files_count_max cannot be found error when you click the FILES tab/menu item. His suggestion is now incorporated into the post.
Update 3: this post is still relevant for dotProject 2.1.3.
In one of my recent posts about project management software I stated the desire to extensively test dotProject 2.0.4. However, many shared hosting providers appear incompatible with dotProject: the right to CREATE TEMPORARY TABLES in MySQL is not granted, but is needed by dotProject.
Here’s sample error (2.0.4):
query failed(CREATE TEMPORARY TABLE tasks_sum SELECT task_project, COUNT(distinct task_id) AS total_tasks,
SUM(task_duration * task_percent_complete * IF(task_duration_type = 24, 8.0, task_duration_type))/
SUM(task_duration * IF(task_duration_type = 24, 8.0, task_duration_type)) AS project_percent_complete FROM `tasks` GROUP BY task_project)
For 2.1.2, sample error would be:
Table ‘tasks_total’ doesn’t exist
I tried looking for solutions, and here’s what I found…
Read the rest of this entry »
Posted in PHP, Programming, Software, Web | 10 Comments »
21st January 2007
I decided to streamline my project management procedures with some kind of software, as the number of concurrent projects is increasing, and more and more time is lost both for switching tasks and trying to grasp a-new the global view of the project each time I turn to it.
Read the rest of this entry »
Posted in Misc, Software, Web | 10 Comments »