Hello,
When I search for projects in the backend I get the following error:
An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id_projects ORDER BY cu_name DESC LIMIT 0, 20' at line 7 SQL=SELECT project.*, cu_name, SUM(tr_hours) as tot_hours, cat_name FROM gajdv_tracktime_projects project INNER JOIN gajdv_tracktime_customers customer ON pr_id_customers = id_customers INNER JOIN gajdv_tracktime_categories ON pr_id_categories = id_categories LEFT JOIN gajdv_tracktime_trackers ON tr_id_projects = id_projects WHERE (cu_name LIKE '%lumax%' OR pr_name LIKE '%lumax%' OR pr_domain LIKE '%lumax%' AND project.enabled = 1 GROUP BY id_projects ORDER BY cu_name DESC LIMIT 0, 20
Please advise.
Thanks!
Jared
When I search for projects in the backend I get the following error:
An error has occurred.
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY id_projects ORDER BY cu_name DESC LIMIT 0, 20' at line 7 SQL=SELECT project.*, cu_name, SUM(tr_hours) as tot_hours, cat_name FROM gajdv_tracktime_projects project INNER JOIN gajdv_tracktime_customers customer ON pr_id_customers = id_customers INNER JOIN gajdv_tracktime_categories ON pr_id_categories = id_categories LEFT JOIN gajdv_tracktime_trackers ON tr_id_projects = id_projects WHERE (cu_name LIKE '%lumax%' OR pr_name LIKE '%lumax%' OR pr_domain LIKE '%lumax%' AND project.enabled = 1 GROUP BY id_projects ORDER BY cu_name DESC LIMIT 0, 20
Please advise.
Thanks!
Jared
Custom Fields
| Joomla! Version | |
| Extension version (x.y.z) | 3.0.1 |
