-
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.