Webnaranja
 
Mostrar/Ocultar
Mostrar/Ocultar Menú principal

Errores En Proyectos Y Archivos - Foro: Gestión de Proyectos con Dotproject
Errores en proyectos y archivos
Gestión de Proyectos con Dotproject Gestión de Proyectos con Dotproject: Todo los temas relacionados con las gestión de proyectos web con Dotproject
Responder al tema   Versión Imprimible    Foros de discusión - Proyectos Web - Gestión de Proyectos con Dotproject
Ver tema anterior :: Ver tema siguiente  
Autor Mensaje
akrapovich
Nuevo
Nuevo


Registrado: May 01, 2010
Mensajes: 1

EnvioPublicado: Sab May 01, 2010 7:01 pm    Asunto: Errores en proyectos y archivos Responder citando

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.


Volver arriba
Ver perfil de usuario
Mostrar mensajes de anteriores:   
 Responder al tema   Versión Imprimible     Foros de discusión - Proyectos Web - Gestión de Proyectos con Dotproject Todas las horas son GMT + 1 Hora
Página 1 de 1




RSS: Gestión de Proyectos con Dotproject RSS
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

Diseño web, bases de datos, lenguajes de programación, comunidades... todo lo necesario para construir tu sitio web.
The logos and trademarks used on this site are the property of their respective owners. We are not responsible for comments posted by our users, as they are the property of the poster.
Aviso Legal - Privacidad
Construyendo la web 2.0
Interactive software released under GNU GPL, Code Credits, Privacy Policy

Orange Theme by WebNaranja.com more Info.