[ZBX-3633] user history not saved with empty table Created: 2011 Mar 21  Updated: 2017 May 30  Resolved: 2011 Mar 24

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: 1.8.5

Type: Incident report Priority: Blocker
Reporter: richlv Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

1.8 branch rev 18595.



 Description   

with empty user_history table nothing is ever added to the user history. debug reveals only these queries :

SELECT title1, url1, title2, url2, title3, url3, title4, url4, title5, url5 FROM user_history WHERE userid=1
SELECT title5, url5 FROM user_history WHERE userid=1
UPDATE user_history SET title1=title2, url1=url2, title2=title3, url2=url3, title3=title4, url3=url4, title4=title5, url4=url5, title5='S_CONFIGURATION_OF_ACTIONS', url5='actionconf.php' WHERE userid=1

so it never attempts to add a new record and is not bothered that 'update' affects no records.

when fixing, selenium test that checks the db afterwards is highly recommended.



 Comments   
Comment by Alexey Fukalov [ 2011 Mar 23 ]

dev branch: ZBX-3633

Comment by Konstantin Buravcov (Inactive) [ 2011 Mar 24 ]

Reviewed and tested: works ok.

Comment by Alexey Fukalov [ 2011 Mar 24 ]

branches/1.8 18668

Generated at Thu Apr 03 07:46:09 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.