#244 – SQL Error when searching projects

Posted in ‘TrackTime’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Sunday, 27 April 2014 03:59 CEST
 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
Custom Fields
Joomla! Version  
Extension version (x.y.z) 3.0.1
jaredshih
Monday, 28 April 2014 09:20 CEST
Hello Jared,

thank you very much for your report!
A new version will be released today, containing this fix.

Thank you very much again
signature.png
tampe125
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.

SUPPORT IS PROVIDED IN ENGLISH OR ITALIAN ONLY.
Please make sure that your question is not answered in the documentation before submitting a ticket.
It will save you time!

SUPPORT IS PROVIDED TO SUBSCRIBERS ONLY.
You can review all public tickets, but if you want to open a new ticket you must have a valid subscription.
You can purchase it here