[ZBX-3045] can't delete mediatype: Table 'opmediatypes' doesn't exist Created: 2010 Sep 27  Updated: 2017 May 30  Resolved: 2010 Sep 29

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

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:

trunk rev 14588.


 Description   

deleting a mediatype fails :

Error in query [SELECT a.actionid FROM actions a,opmediatypes opm,operations o WHERE ((a.actionid BETWEEN 000000000000000 AND 099999999999999)) AND (opm.mediatypeid IN (11)) AND opm.operationid=o.operationid AND a.actionid=o.actionid] [Table 'zabbix_1_9.opmediatypes' doesn't exist]
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:544]
mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/local/apache2/htdocs/trunk/include/db.inc.php:546]

opmediatypes table has been dropped by db patch

 Comments   
Comment by Alexey Fukalov [ 2010 Sep 29 ]

dev branch: ZBX-3045

Comment by richlv [ 2010 Sep 29 ]

confirming the fix in dev branch rev 14619.

Comment by Alexey Fukalov [ 2010 Sep 29 ]

trunk 14621

Generated at Mon Apr 07 12:48:10 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.