Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-14874

Frontend syntax error of zabbix 4.0.0 beta

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 4.0.0rc2, 4.0 (plan)
    • 4.0.0beta1, 4.0.0beta2
    • Frontend (F)
    • None
    • MariaDB PostgreSQL
    • Team B
    • 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.

            iivs Ivo Kurzemnieks
            hayato.watanabe Hayato Watanabe
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: