but get error:
_SQLSTATE[42000]: Syntax error or access violation: 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 'all FROM courses WHERE (status=1) AND (teacher_id IS NOT NULL) GROUP BY teac' at line 1
The SQL being executed was: SELECT teacher_id as _id, COUNT(*) as all FROM courses WHERE (status=1) AND (teacher_id IS NOT NULL) GROUP BY teacherid
The problem is from Mysql with: 'as all', you need to change it to 'as all'
I integrated this extension to my project as following code: `public function init() { $parentRet = parent::init();
in other action: `$query = FECourse::find()->where(['status' => FECourse::STATUS_ACTIVE]);
but get error: _SQLSTATE[42000]: Syntax error or access violation: 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 'all FROM
courses
WHERE (status
=1) AND (teacher_id IS NOT NULL) GROUP BY teac' at line 1 The SQL being executed was: SELECT teacher_id as _id, COUNT(*) as all FROMcourses
WHERE (status
=1) AND (teacher_id IS NOT NULL) GROUP BY teacheridThe problem is from Mysql with: 'as all', you need to change it to 'as
all
'Can you update the lib for this?