|
Hola,
Acabo de instalar dotproject (ultima version) en un servidor de arsys. Todo bien salvo al acceder a las pestañas de proyectos y archivos, que salen estos errores (parece haber un problema con la base de datos????):
Proyectos:
\Html\dotproject\classes\query.class.php(623): query failed(CREATE TEMPORARY TABLE 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 (`tasks` as t) WHERE t.task_id = t.task_parent GROUP BY t.task_project) - error was: Access denied for user 'qgd045'@'%' to database 'qgd045'
Html\dotproject\classes\query.class.php(623): query failed(CREATE TEMPORARY TABLE tasks_total SELECT t.task_project, COUNT(distinct t.task_id) AS total_tasks FROM (`tasks` as t) GROUP BY t.task_project) - error was: Access denied for user 'qgd045'@'%' to database 'qgd045'
\Html\dotproject\classes\query.class.php(623): query failed(CREATE TEMPORARY TABLE tasks_summy SELECT t.task_project, COUNT(DISTINCT t.task_id) AS my_tasks FROM (`tasks` as t) WHERE t.task_owner = 1 GROUP BY t.task_project) - error was: Access denied for user 'qgd045'@'%' to database 'qgd045'
\Html\dotproject\classes\query.class.php(623): query failed(CREATE TEMPORARY TABLE tasks_critical SELECT t.task_project, t.task_id AS critical_task, MAX(t.task_end_date) AS project_actual_end_date FROM (`tasks` as t) GROUP BY t.task_project ORDER BY t.task_end_date DESC) - error was: Access denied for user 'qgd045'@'%' to database 'qgd045'
\Html\dotproject\classes\query.class.php(623): query failed(CREATE TEMPORARY TABLE tasks_problems SELECT t.task_project, tl.task_log_problem FROM (`tasks` as t) LEFT JOIN `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 'qgd045'@'%' to database 'qgd045'
\Html\dotproject\classes\query.class.php(623): 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 (`projects` as p) LEFT JOIN `companies` AS com ON p.project_company = com.company_id LEFT JOIN `users` AS u ON p.project_owner = u.user_id LEFT JOIN `tasks_critical` AS tc ON p.project_id = tc.task_project LEFT JOIN `tasks_problems` AS tp ON p.project_id = tp.task_project LEFT JOIN `tasks_sum` AS ts ON p.project_id = ts.task_project LEFT JOIN `tasks_total` AS tt ON p.project_id = tt.task_project LEFT JOIN `tasks_summy` AS tsy ON p.project_id = tsy.task_project LEFT JOIN `companies` AS co ON co.company_id = p.project_company WHERE p.project_company = 1 GROUP BY p.project_id ORDER BY project_end_date asc) - error was: Table 'qgd045.tasks_critical' doesn't exist
PHP Warning: Invalid argument supplied for foreach() in \Html\dotproject\modules\projects\vw_idx_proposed.php on line 17
PHP Warning: Invalid argument supplied for foreach() in\Html\dotproject\modules\projects\vw_idx_proposed.php on line 115
Archivos:[u]
\dotproject\classes\query.class.php(623): query failed(CREATE TEMPORARY TABLE files_count_max SELECT DISTINCT count(f.file_id) as file_versions, max(f.file_version) as file_lastversion, f.file_version_id, f.file_project FROM (`files` as f) LEFT JOIN `projects` AS p ON p.project_id = f.file_project LEFT JOIN `tasks` AS t ON t.task_id = f.file_task LEFT JOIN `file_folders` AS ff ON ff.file_folder_id = f.file_folder GROUP BY f.file_project,f.file_version_id) - error was: Access denied for user 'qgd045'@'%' to database 'qgd045'
\dotproject\classes\query.class.php(623): query failed(SELECT SQL_CALC_FOUND_ROWS SQL_CALC_FOUND_ROWS f.*, f.file_id as latest_id, fmc.file_versions , round(fmc.file_lastversion, 2) as file_lastversion,ff.* FROM (`files` as f) INNER JOIN `files_count_max` AS fmc ON (fmc.file_lastversion = f.file_version AND fmc.file_version_id = f.file_version_id AND fmc.file_project = f.file_project) LEFT JOIN `file_folders` AS ff ON ff.file_folder_id = f.file_folder LEFT JOIN `projects` AS p ON p.project_id = f.file_project LEFT JOIN `tasks` AS t ON t.task_id = f.file_task GROUP BY p.project_id,f.file_version_id DESC) - error was: Table 'qgd045.files_count_max' doesn't exist
PHP Warning: Invalid argument supplied for foreach() in \Html\dotproject\modules\files\index_table.php on line 259
agradezco de antemano cualquier pista.
|