tr_status.php Error
When open the triggers link, I got the following words:
Error in query [SELECT s.* FROM scripts s WHERE (s.scriptid div 100000000000000) in (0) AND (s.groupid IN (1,4,3,0)) AND (s.usrgrpid IN (7,0)) ORDER BY scriptid ASC] [Unknown column 's.groupid' in 'where clause']
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/apps/apache2/htdocs/include/db.inc.php:490]
I upgraded my zabbix from 1.4.5 to 1.5.2, use mysql database patch.sql file.
When open the triggers link, I got the following words:
Error in query [SELECT s.* FROM scripts s WHERE (s.scriptid div 100000000000000) in (0) AND (s.groupid IN (1,4,3,0)) AND (s.usrgrpid IN (7,0)) ORDER BY scriptid ASC] [Unknown column 's.groupid' in 'where clause']
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/usr/apps/apache2/htdocs/include/db.inc.php:490]
I upgraded my zabbix from 1.4.5 to 1.5.2, use mysql database patch.sql file.
Comment