Hello!
I have instaled dotProject 2.1.3, I keept getting this error
ERROR: /home4/ftpbkpco/public_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 = 2 GROUP BY p.project_id ORDER BY project_end_date asc) - error was: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Backtrace:
0 /home4/ftpbkpco/public_html/..../dotproject/classes/query.class.php:623 dprint('/home4/ftpbkpco/public_html/..../dotproject/classes/query.class.php',623,0,'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 = 2 GROUP BY p.project_id ORDER BY project_end_date asc) - error was: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay')
1 /home4/ftpbkpco/public_html/..../dotproject/classes/query.class.php:645 exec(2)
2 /home4/ftpbkpco/public_html/..../dotproject/modules/projects/projects.class.php:662 loadList()
3 /home4/ftpbkpco/public_html/..../dotproject/modules/projects/index.php:133 projects_list_data()
4 /home4/ftpbkpco/public_html/.../dotproject/index.php:298 require('/home4/ftpbkpco/public_html/.../dotproject/modules/projects/index.php')
<\pre>
Warning: Invalid argument supplied for foreach() in /home4/ftpbkpco/public_html/..../dotproject/modules/projects/vw_idx_proposed.php on line 17
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
It is realy weird couse some users don't have the error and some do.
Pls could anyone help!
Thank you!