In dotProject 2.1.9 errors occur after selecting the Project link. The errors stem from creating my user account being denied to create a temporary table. Included is the stack trace for the error.
ERROR: /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php(636): query failed(CREATE TEMPORARY TABLE dotp_tasks_sum SELECT t.task_project, SUM(t.task_duration * t.task_percent_complete * IF(t.task_duration_type = 24, 8.0, t.task_duration_type)) / SUM(t.task_duration * IF(t.task_duration_type = 24, 8.0, t.task_duration_type)) AS project_percent_complete, SUM(t.task_duration * IF(t.task_duration_type = 24, 8.0, t.task_duration_type)) AS project_duration FROM (dotp_tasks as t) WHERE t.task_id = t.task_parent GROUP BY t.task_project) - error was: Access denied for user ‘epiz_23450731’@‘192.168.%’ to database ‘epiz_23450731_dotproject’ Backtrace: 0 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php:636 dprint(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php’,636,0,‘query failed(CREATE TEMPORARY TABLE dotp_tasks_sum SELECT t.task_project, SUM(t.task_duration * t.task_percent_complete * IF(t.task_duration_type = 24, 8.0, t.task_duration_type)) / SUM(t.task_duration * IF(t.task_duration_type = 24, 8.0, t.task_duration_type)) AS project_percent_complete, SUM(t.task_duration * IF(t.task_duration_type = 24, 8.0, t.task_duration_type)) AS project_duration FROM (dotp_tasks as t) WHERE t.task_id = t.task_parent GROUP BY t.task_project) - error was: Access denied for user 'epiz_23450731'@'192.168.%' to database 'epiz_23450731_dotproject'’) 1 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/projects.class.php:509 exec() 2 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php:122 projects_list_data() 3 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/index.php:301 require(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php’)
ERROR: /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php(636): query failed(CREATE TEMPORARY TABLE dotp_tasks_total SELECT t.task_project, COUNT(distinct t.task_id) AS total_tasks FROM (dotp_tasks as t) GROUP BY t.task_project) - error was: Access denied for user ‘epiz_23450731’@‘192.168.%’ to database ‘epiz_23450731_dotproject’ Backtrace: 0 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php:636 dprint(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php’,636,0,‘query failed(CREATE TEMPORARY TABLE dotp_tasks_total SELECT t.task_project, COUNT(distinct t.task_id) AS total_tasks FROM (dotp_tasks as t) GROUP BY t.task_project) - error was: Access denied for user 'epiz_23450731'@'192.168.%' to database 'epiz_23450731_dotproject'’) 1 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/projects.class.php:524 exec() 2 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php:122 projects_list_data() 3 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/index.php:301 require(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php’)
ERROR: /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php(636): query failed(CREATE TEMPORARY TABLE dotp_tasks_summy SELECT t.task_project, COUNT(DISTINCT t.task_id) AS my_tasks FROM (dotp_tasks as t) WHERE t.task_owner = 2 GROUP BY t.task_project) - error was: Access denied for user ‘epiz_23450731’@‘192.168.%’ to database ‘epiz_23450731_dotproject’ Backtrace: 0 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php:636 dprint(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php’,636,0,‘query failed(CREATE TEMPORARY TABLE dotp_tasks_summy SELECT t.task_project, COUNT(DISTINCT t.task_id) AS my_tasks FROM (dotp_tasks as t) WHERE t.task_owner = 2 GROUP BY t.task_project) - error was: Access denied for user 'epiz_23450731'@'192.168.%' to database 'epiz_23450731_dotproject'’) 1 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/projects.class.php:537 exec() 2 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php:122 projects_list_data() 3 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/index.php:301 require(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php’)
ERROR: /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php(636): query failed(CREATE TEMPORARY TABLE dotp_tasks_critical SELECT t.task_project, t.task_id AS critical_task, MAX(t.task_end_date) AS project_actual_end_date FROM (dotp_tasks as t) GROUP BY t.task_project ORDER BY t.task_end_date DESC) - error was: Access denied for user ‘epiz_23450731’@‘192.168.%’ to database ‘epiz_23450731_dotproject’ Backtrace: 0 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php:636 dprint(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php’,636,0,‘query failed(CREATE TEMPORARY TABLE dotp_tasks_critical SELECT t.task_project, t.task_id AS critical_task, MAX(t.task_end_date) AS project_actual_end_date FROM (dotp_tasks as t) GROUP BY t.task_project ORDER BY t.task_end_date DESC) - error was: Access denied for user 'epiz_23450731'@'192.168.%' to database 'epiz_23450731_dotproject'’) 1 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/projects.class.php:551 exec() 2 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php:122 projects_list_data() 3 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/index.php:301 require(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php’)
ERROR: /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php(636): query failed(CREATE TEMPORARY TABLE dotp_tasks_problems SELECT t.task_project, tl.task_log_problem FROM (dotp_tasks as t) LEFT JOIN dotp_task_log AS tl ON tl.task_log_task = t.task_id WHERE tl.task_log_problem > 0 GROUP BY t.task_project) - error was: Access denied for user ‘epiz_23450731’@‘192.168.%’ to database ‘epiz_23450731_dotproject’ Backtrace: 0 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php:636 dprint(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php’,636,0,‘query failed(CREATE TEMPORARY TABLE dotp_tasks_problems SELECT t.task_project, tl.task_log_problem FROM (dotp_tasks as t) LEFT JOIN dotp_task_log AS tl ON tl.task_log_task = t.task_id WHERE tl.task_log_problem > 0 GROUP BY t.task_project) - error was: Access denied for user 'epiz_23450731'@'192.168.%' to database 'epiz_23450731_dotproject'’) 1 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/projects.class.php:563 exec() 2 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php:122 projects_list_data() 3 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/index.php:301 require(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php’)
ERROR: /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php(636): query failed(SELECT p.project_id, p.project_status, p.project_color_identifier, p.project_type, p.project_name, p.project_description, p.project_start_date, p.project_end_date, p.project_color_identifier, p.project_company, p.project_status, p.project_priority, com.company_name, com.company_description, tc.critical_task, tc.project_actual_end_date, if (tp.task_log_problem IS NULL, 0, tp.task_log_problem) AS task_log_problem, tt.total_tasks, tsy.my_tasks, ts.project_percent_complete, ts.project_duration, u.user_username FROM (dotp_projects as p) LEFT JOIN dotp_companies AS com ON p.project_company = com.company_id LEFT JOIN dotp_users AS u ON p.project_owner = u.user_id LEFT JOIN dotp_tasks_critical AS tc ON p.project_id = tc.task_project LEFT JOIN dotp_tasks_problems AS tp ON p.project_id = tp.task_project LEFT JOIN dotp_tasks_sum AS ts ON p.project_id = ts.task_project LEFT JOIN dotp_tasks_total AS tt ON p.project_id = tt.task_project LEFT JOIN dotp_tasks_summy AS tsy ON p.project_id = tsy.task_project LEFT JOIN dotp_companies AS co ON co.company_id = p.project_company WHERE p.project_status = 2 GROUP BY p.project_id ORDER BY project_end_date asc) - error was: Table ‘epiz_23450731_dotproject.dotp_tasks_critical’ doesn’t exist Backtrace: 0 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php:636 dprint(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php’,636,0,‘query failed(SELECT p.project_id, p.project_status, p.project_color_identifier, p.project_type, p.project_name, p.project_description, p.project_start_date, p.project_end_date, p.project_color_identifier, p.project_company, p.project_status, p.project_priority, com.company_name, com.company_description, tc.critical_task, tc.project_actual_end_date, if (tp.task_log_problem IS NULL, 0, tp.task_log_problem) AS task_log_problem, tt.total_tasks, tsy.my_tasks, ts.project_percent_complete, ts.project_duration, u.user_username FROM (dotp_projects as p) LEFT JOIN dotp_companies AS com ON p.project_company = com.company_id LEFT JOIN dotp_users AS u ON p.project_owner = u.user_id LEFT JOIN dotp_tasks_critical AS tc ON p.project_id = tc.task_project LEFT JOIN dotp_tasks_problems AS tp ON p.project_id = tp.task_project LEFT JOIN dotp_tasks_sum AS ts ON p.project_id = ts.task_project LEFT JOIN dotp_tasks_total AS tt ON p.project_id = tt.task_project LEFT JOIN dotp_tasks_summy AS tsy ON p.project_id = tsy.task_project LEFT JOIN dotp_companies AS co ON co.company_id = p.project_company WHERE p.project_status = 2 GROUP BY p.project_id ORDER BY project_end_date asc) - error was: Table 'epiz_23450731_dotproject.dotp_tasks_critical' doesn't exist’) 1 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/classes/query.class.php:658 exec(2) 2 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/projects.class.php:665 loadList() 3 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php:122 projects_list_data() 4 /home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/index.php:301 require(‘/home/vol1_6/epizy.com/epiz_23450731/projectmanagement.infinityfreeapp.com/htdocs/modules/projects/index.php’)
