[ZBX-14874] Frontend syntax error of zabbix 4.0.0 beta Created: 2018 Sep 19  Updated: 2024 Apr 10  Resolved: 2018 Sep 21

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 4.0.0beta1, 4.0.0beta2
Fix Version/s: 4.0.0rc2, 4.0 (plan)

Type: Problem report Priority: Blocker
Reporter: Hayato Watanabe Assignee: Ivo Kurzemnieks
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

MariaDB PostgreSQL


Issue Links:
Causes
Team: Team B
Sprint: Sprint 43
Story Points: 0.5

 Description   

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.



 Comments   
Comment by Ivo Kurzemnieks [ 2018 Sep 21 ]

RESOLVED in svn://svn.zabbix.com/branches/dev/ZBX-14727

Comment by Ivo Kurzemnieks [ 2018 Sep 21 ]

Fixed in 4.0.0rc2 (trunk) r85122

Generated at Tue Apr 23 22:04:52 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.