- 
    
Problem report
 - 
    Resolution: Fixed
 - 
    
Blocker
 - 
    4.0.0beta1, 4.0.0beta2
 - 
    None
 - 
    MariaDB PostgreSQL
 
- 
        Sprint 43
 - 
        0.5
 
Steps to reproduce:
 Click "Sign out" of WebUI
Result:
 DB Log check
/var/lib/pgsql/data/pg_log/postgresql-Wed.log
ERROR: syntax error at or near "AND" at character 75 STATEMENT: SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid= AND idx='web.menu.login.last'
MariaDB general_log
180919  2:14:56    35 Query     BEGIN
                   35 Query     SELECT sessionid,userid FROM sessions WHERE sessionid='63d93ba80ff56014e599a5ec533e586a' AND status=0 LIMIT 1
                   35 Query     DELETE FROM sessions WHERE status='1' AND userid='1'
                   35 Query     UPDATE sessions SET status='1' WHERE sessionid='63d93ba80ff56014e599a5ec533e586a'
                   35 Query     SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
                   35 Query     UPDATE ids SET nextid=16 WHERE table_name='auditlog' AND field_name='auditid'
                   35 Query     INSERT INTO auditlog (userid,clock,ip,action,resourcetype,details,auditid) VALUES ('1','1537337696','192.168.10.122','4','0','','16')
                   35 Query     COMMIT
                   35 Query     SELECT c.* FROM config c
                   35 Query     SELECT userid FROM users WHERE alias='guest'
                   35 Query     SELECT MAX(g.gui_access) AS gui_access FROM usrgrp g,users_groups ug WHERE ug.userid='2' AND g.usrgrpid=ug.usrgrpid
                   35 Query     SELECT type,value_id,value_int,value_str,idx2 FROM profiles WHERE userid= AND idx='web.menu.login.last'
Found out that there was no problem version of 4.0.0 alpha9.