[ZBX-2742] Can not delete item when using PostgreSQL for the Zabbix DB Created: 2010 Jul 23  Updated: 2017 May 30  Resolved: 2010 Jul 23

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

Type: Incident report Priority: Critical
Reporter: Igor Danoshaites (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Can not delete item when using PostgreSQL for the Zabbix DB
Appears error:

Can NOT delete item

  • pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: column "web.favorite.graphids" does not exist[/home/igor/public_html/1.8branch/include/db.inc.php:491]
  • Error in query [DELETE FROM profiles WHERE idx="web.favorite.graphids" AND source="itemid" AND (value_id IN (24703)) ] [ERROR: column "web.favorite.graphids" does not exist]
  • [ CItem::delete ] DBEXECUTE_ERROR


 Comments   
Comment by Alexey Fukalov [ 2010 Jul 23 ]

branches/1.8 13556

Comment by Igor Danoshaites (Inactive) [ 2010 Jul 23 ]

Confirm the fix in 1.8 branch, rev #13557.

Generated at Thu Mar 28 14:21:32 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.