SkyPHP/cms — Issue #9: Login AQL Error
Author: john3571
Created: 2012-03-09 21:11:41+00:00
State: open

Recently this error started happening when attempting to login.

AQL:

person {
where (
lower(email_address) like 'johnb' or lower(username) like 'johnb'
and password_hash is not null
)
order by id desc
}

Genereated SQL:

SELECT FROM person as person
WHERE person.active = 1 AND ( lower(person.email_address) like 'johnb' or lower(person.username) like 'johnb' and person.password_hash is not null )
GROUP BY person.id
ORDER BY person.id desc

Fatal error:

AQL Error. Select Failed. Error on line 93 of file /home/wbreak/codebases/cms/lib/class/class.Login.php
ERROR: syntax error at or near "FROM" at character 10
in /home/wbreak/codebases/skyphp/lib/core/class.aql.php on line 604