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