Errores en proyectos y archivos šŸ„‡ Foro GestiĆ³n Proyectos Dotproject

Foros de discusiĆ³n > GestiĆ³n Proyectos Dotproject
#1:  Errores en proyectos y archivos  Autor: Akrapovich,  Enlaces Publicado: Sab May 01, 2010 7:01 pm
    ----
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.

Foros de discusiĆ³n > GestiĆ³n Proyectos Dotproject

Todas las horas son GMT + 1 Hora

PƔgina 1 de 1 - Tema con 1 Mensajes y 14703 Lecturas

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
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