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

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 4.0.0beta1, 4.0.0beta2
    • Fix Version/s: 4.0.0rc2, 4.0 (plan)
    • Component/s: Frontend (F)
    • Labels:
      None
    • Environment:
      MariaDB PostgreSQL
    • 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.

        Attachments

          Activity

            People

            • Assignee:
              iivs Ivo Kurzemnieks
              Reporter:
              hayato.watanabe Hayato Watanabe
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: