queries not compatible with mysql5
Added by AP Clarke 805 days ago
I've just been debugging JQuarks because I couldn't assign sets of questions to quizzes.
The problems are caused by certain aggregate SQL queries that don't have the necessary 'GROUP BY' clause required by MySQL5. Examples of the problem include Administrator > Component > JQuarks > models > quiz.php line 720 - function assignSet - also Administrator > Component > JQuarks > models > quizzes.php line 720 in function publish(). I haven't tracked them all down yet. I'm running J1.5.15, PHP5.2, MySQL5.0.27. I installed the JQuarks component v 0.2.2 and the 2 plugins (user/editor).
If you add the GROUP BY clause (eg GROUP BY soq.id), the component is then able to assign sets.
Replies
RE: queries not compatible with mysql5 - Added by Mohamed Tougorti 804 days ago
Hello AP Clarke,
Thank you for reporting this, a bug report #16 has been filled and this issue will be corrected on the next release.
RE: queries not compatible with mysql5 - Added by Mahmoud M'HIRI 803 days ago
For anyone having this issue, just apply the patch file uploaded in #16.