Projects Tab does not work

[rwclark]

I just ran the installer for dotProject 2.0.1 in a hosted linux environment that meets the minimum specs. Everything seemed to go smoothly, but for some reason the projects tab does not work properly. All the other areas seem to be working.

Here are the errors I'm getting:

[ABOVE THE BLUE TAB]:

ERROR: /home/content/t/3/2/t324project/html/projects/classes/query.class.php(590): 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) - error was: Access denied for user: 't324project@64.202.163.%' to database 't324project'
Backtrace:
0 /home/content/t/3/2/t324project/html/projects/classes/query.class.php:590 dprint(

Warning: Invalid argument supplied for foreach() in /home/content/t/3/2/t324project/html/projects/includes/main_functions.php on line 538

)
1 /home/content/t/3/2/t324project/html/projects/modules/projects/index.php:82 exec('/home/content/t/3/2/t324project/html/projects/classes/query.class.php',590,0,'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) - error was: Access denied for user: \'t324project@64.202.163.%\' to database \'t324project\'')
2 /home/content/t/3/2/t324project/html/projects/index.php:324 require('/home/content/t/3/2/t324project/html/projects/modules/projects/index.php')

ERROR: /home/content/t/3/2/t324project/html/projects/classes/query.class.php(590): 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: Access denied for user: 't324project@64.202.163.%' to database 't324project'
Backtrace:
0 /home/content/t/3/2/t324project/html/projects/classes/query.class.php:590 dprint(

Warning: Invalid argument supplied for foreach() in /home/content/t/3/2/t324project/html/projects/includes/main_functions.php on line 538

)
1 /home/content/t/3/2/t324project/html/projects/modules/projects/index.php:93 exec('/home/content/t/3/2/t324project/html/projects/classes/query.class.php',590,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: Access denied for user: \'t324project@64.202.163.%\' to database \'t324project\'')
2 /home/content/t/3/2/t324project/html/projects/index.php:324 require('/home/content/t/3/2/t324project/html/projects/modules/projects/index.php')

ERROR: /home/content/t/3/2/t324project/html/projects/classes/query.class.php(590): query failed(CREATE TEMPORARY TABLE tasks_critical SELECT task_project, task_id AS critical_task, task_end_date AS project_actual_end_date FROM `tasks` LEFT JOIN `projects` AS p ON p.project_id = task_project GROUP BY task_project ORDER BY task_end_date DESC) - error was: Access denied for user: 't324project@64.202.163.%' to database 't324project'
Backtrace:
0 /home/content/t/3/2/t324project/html/projects/classes/query.class.php:590 dprint(

Warning: Invalid argument supplied for foreach() in /home/content/t/3/2/t324project/html/projects/includes/main_functions.php on line 538

)
1 /home/content/t/3/2/t324project/html/projects/modules/projects/index.php:103 exec('/home/content/t/3/2/t324project/html/projects/classes/query.class.php',590,0,'query failed(CREATE TEMPORARY TABLE tasks_critical SELECT task_project, task_id AS critical_task, task_end_date AS project_actual_end_date FROM `tasks` LEFT JOIN `projects` AS p ON p.project_id = task_project GROUP BY task_project ORDER BY task_end_date DESC) - error was: Access denied for user: \'t324project@64.202.163.%\' to database \'t324project\'')
2 /home/content/t/3/2/t324project/html/projects/index.php:324 require('/home/content/t/3/2/t324project/html/projects/modules/projects/index.php')

ERROR: /home/content/t/3/2/t324project/html/projects/classes/query.class.php(590): query failed(CREATE TEMPORARY TABLE tasks_problems SELECT task_project, task_log_problem FROM `tasks` LEFT JOIN `task_log` AS tl ON tl.task_log_task = task_id WHERE task_log_problem > '0' GROUP BY task_project) - error was: Access denied for user: 't324project@64.202.163.%' to database 't324project'
Backtrace:
0 /home/content/t/3/2/t324project/html/projects/classes/query.class.php:590 dprint(

Warning: Invalid argument supplied for foreach() in /home/content/t/3/2/t324project/html/projects/includes/main_functions.php on line 538

)
1 /home/content/t/3/2/t324project/html/projects/modules/projects/index.php:113 exec('/home/content/t/3/2/t324project/html/projects/classes/query.class.php',590,0,'query failed(CREATE TEMPORARY TABLE tasks_problems SELECT task_project, task_log_problem FROM `tasks` LEFT JOIN `task_log` AS tl ON tl.task_log_task = task_id WHERE task_log_problem > \'0\' GROUP BY task_project) - error was: Access denied for user: \'t324project@64.202.163.%\' to database \'t324project\'')
2 /home/content/t/3/2/t324project/html/projects/index.php:324 require('/home/content/t/3/2/t324project/html/projects/modules/projects/index.php')

ERROR: /home/content/t/3/2/t324project/html/projects/classes/query.class.php(590): query failed(SELECT projects.project_id, project_active, project_status, project_color_identifier, project_name, project_description,
project_start_date, project_end_date, project_color_identifier, project_company, company_name, project_status,
project_priority, tc.critical_task, tc.project_actual_end_date, tp.task_log_problem, ts.total_tasks, tsy.my_tasks,
ts.project_percent_complete, user_username FROM `projects` LEFT JOIN `companies` AS com ON projects.project_company = company_id LEFT JOIN `users` AS u ON projects.project_owner = u.user_id LEFT JOIN `tasks_critical` AS tc ON projects.project_id = tc.task_project LEFT JOIN `tasks_problems` AS tp ON projects.project_id = tp.task_project LEFT JOIN `tasks_sum` AS ts ON projects.project_id = ts.task_project LEFT JOIN `tasks_summy` AS tsy ON projects.project_id = tsy.task_project GROUP BY projects.project_id ORDER BY project_end_date asc) - error was: Table 't324project.tasks_critical' doesn't exist
Backtrace:
0 /home/content/t/3/2/t324project/html/projects/classes/query.class.php:590 dprint(

Warning: Invalid argument supplied for foreach() in /home/content/t/3/2/t324project/html/projects/includes/main_functions.php on line 538

)
1 /home/content/t/3/2/t324project/html/projects/classes/query.class.php:615 exec('/home/content/t/3/2/t324project/html/projects/classes/query.class.php',590,0,'query failed(SELECT projects.project_id, project_active, project_status, project_color_identifier, project_name, project_description,
project_start_date, project_end_date, project_color_identifier, project_company, company_name, project_status,
project_priority, tc.critical_task, tc.project_actual_end_date, tp.task_log_problem, ts.total_tasks, tsy.my_tasks,
ts.project_percent_complete, user_username FROM `projects` LEFT JOIN `companies` AS com ON projects.project_company = company_id LEFT JOIN `users` AS u ON projects.project_owner = u.user_id LEFT JOIN `tasks_critical` AS tc ON projects.project_id = tc.task_project LEFT JOIN `tasks_problems` AS tp ON projects.project_id = tp.task_project LEFT JOIN `tasks_sum` AS ts ON projects.project_id = ts.task_project LEFT JOIN `tasks_summy` AS tsy ON projects.project_id = tsy.task_project GROUP BY projects.project_id ORDER BY project_end_date asc) - error was: Table \'t324project.tasks_critical\' doesn\'t exist')
2 /home/content/t/3/2/t324project/html/projects/modules/projects/index.php:192 loadlist(2)
3 /home/content/t/3/2/t324project/html/projects/index.php:324 require('/home/content/t/3/2/t324project/html/projects/modules/projects/index.php')




[IN THE BLUE AREA UNDER 'ALL PROJECTS']:
Warning: Invalid argument supplied for foreach() in /home/content/t/3/2/t324project/html/projects/modules/projects/vw_idx_proposed.php on line 73





[AT THE BOTTOM OF THE PAGE IN RED TEXT]:
Table 't324project.tasks_critical' doesn't exist


Can anyone help with this?

Ryan

[rwclark]

I did some more searching and it looks like this is related to the known issue about needing to be able to create temporary tables. Sorry to clutter up the forums unnecessarily...still, I'd appreciate any "new" insights anyone has.

[rwclark]

I found a fix at: http://www.dotproject.net/index.php?name=PNphpBB2&file=viewtopic&t=2164&highlight=taskssum

This was said to work with v2.0 snapshot. Has anyone tried it with v2.0.1?

[ssddgreg]

link does not work!


http://www.dotproject.net/index.php?name=PNphpBB2&file=viewtopic&t=2164&highlight=taskssum


:(

[ajdonnison]

What is this supposed to mean? What link doesn't work? What are the error messages? What version of dp? What are you doing to generate the error? How about some quality reporting of problems so others can help?

[Karen]

I think he means that the link to the forum post referred to in the reply directly above doesn't work - which we know. It's from the old forum's software and to be utterly and absolutely honest - I've got an appointment with a manicurist and some bamboo splinters that I'd rather keep than chase down every link from the old board, find the new reference here in the new software and edit the links. After all, there's always the search function.......... :wink: