[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: |
|
||||
Team: | Team B | ||||
Sprint: | Sprint 43 | ||||
Story Points: | 0.5 |
Description |
Steps to reproduce: Result: /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 |