Errores en proyectos y archivos 🥇 Foro Gestión Proyectos Dotproject 🗺️

Foro de Gestión Proyectos Dotproject Foro de Gestión Proyectos Dotproject: Todo los temas relacionados con las gestión de proyectos web con Dotproject
Responder al tema Versión Imprimible
Página 1 de 1 - Tema con 1 Mensajes y 15548 Lecturas
Último Mensaje:
Autor Mensaje

Imagen: Akrapovich
Nuevo
Nuevo
Registrado:
01-05-2010
Mensajes: 1

Votos: 0 👍
Responder citando

EnlacesAsunto: Errores en proyectos y archivos

Publicado:
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.
Ir arriba Akrapovich
Compartir:
Mostrar mensajes de anteriores:
Responder al tema Versión Imprimible
Página 1 de 1 - Tema con 1 Mensajes y 15548 Lecturas - Última modificación: 01/05/2010


RSS: Foro Gestión Proyectos Dotproject RSS - Últimos Mensajes
Cambiar a:  


Puede publicar nuevos temas en este foro
No puede responder a temas en este foro
No puede editar sus mensajes en este foro
No puede borrar sus mensajes en este foro
No puede votar en encuestas en este foro
No Puedes adjuntar archivos en este foro
Tu puedes descargar archivos en este foro